Query to get functional currency of Bussiness Unit

SELECT
  gs.currency_code,
  ho.name
FROM
  gl_sets_of_books gs,
  ar_system_parameters_all os,
  hr_operating_units ho
WHERE
  OS.SET_OF_BOOKS_ID = GS.SET_OF_BOOKS_ID
  and HO.name = '<BUSSINESS UNIT NAME>'
  AND ho.organization_id = os.org_id;

Importing Banks, Branches and Accounts in Oracle Cloud ERP

Login to application

Click on “Setup and Maintenance”  from  navigator  

Search for “Create Banks, Branches, and Accounts in Spreadsheet” as shown below.

 

Click on the link

 

It will download a file

 

Fill the Spreadsheet as per our requirement and click on “Generate Banks, Branches and Accounts File”

 

An xml file will be generated with name” CE_RAPID_IMPLEMENTATION.xlm”

Navigate to “Setup and Maintenance” and Search for Task “Search for “Upload Banks, Branches, and Accounts” as shown below.

 

Browse the xml file and click on Submit.

A schedule process is submitted.

 

Navigate to schedule Process and check for the status.