Topic:
The ERP Settings Window is used to establish the connection between AFCS and other applications. In case, you wish to do changes post-deployment, it can be done in ERP Settings.
NOTE: For Service Instances Upgraded from 22B to 22C
ERP Settings should be re-saved via the UI for automatic creation of BI Cloud Connector extract jobs to be available.
To configure ERP Settings, follow these steps:
1. Navigate to Subledger Application Summary Page.
2. Click from
Top-right corner and select Administration.
3. Select ERP Settings from the Left Menu.
The ERP Settings Window is displayed.
4. Enter the following details:
§ URL for Accounting Hub Cloud Service:
Enter the URL assigned to you as part of your Oracle ERP Cloud AHCS subscription here. This information is specific to your tenancy on Oracle Cloud and subscription to ERP Cloud AHCS Instance.
For example:
https://abc.de.fg.oraclecloud.com
§ Version:
Enter the version of the AHCS Instance.
§ User ID:
Enter the User Identification assigned to you for the AHCS Instance here.
§ Password:
Enter the password for your AHCS Instance here.
§ Event Type Column Name:
This is pre-populated with the Transaction Type value, the auto-generated value for the Transaction Type Column Name in the Register Transaction Source System step.
If you modify the auto-generated value for Transaction Type Column Name in the Register Transaction Source System step, edit the pre-populated text and capture the assigned column name here.
§ Line Number Column Name:
This is pre-populated with the LINE NUMBER value, the auto-generated value for Line Number Column Name in the Register Transaction Source System step.
If you modify the auto-generated value for the Line Number Column Name in the Register Transaction Source System step, edit the pre-populated text and capture the assigned column name here.
§ Date Format:
Enter the date format in which your instance of AHCS accepts the date columns. If you do not enter a value here, the date field uses the default format.
5. Click Save or Test Connection.
For more information, see the Verification of ERP Setting Section.
After you save, the entered settings are used while producing the Transaction Template. This is a one-time setup activity. Do not change these settings unless required by changes to your instance of AHCS.
After you save, the Application creates the following jobs in the BI Cloud Console for General Ledger and Journal Extraction:
§ GL_SR_EXTRACT_JOB
§ JOURNAL_INGESTION_EXTRACT_JOB
NOTE:
The above jobs will extract records with PRIMARY ledger type.