- Integrate Oracle MICROS Reporting and Analytics Sales Data from ATP with Oracle Financials Accounting Hub
- Before You Install the Recipe
2 Before You Install the Recipe
Perform the following configuration tasks to successfully install and run the
recipe.
Configure Oracle ERP Cloud
To capture the sales data that must be accounted in Financials Cloud using
Oracle Financials Accounting Hub:
- In the Oracle General Ledger application:
- Make sure you have the basic Enterprise Structure setup, which includes your Legal Entity, Primary Ledger, and Ledger options setup.
- In the Oracle Financials Accounting Hub/Accounting Transformation
application:
- Create a subledger source system with short name
FB_REV_ACCT
with the following details.Note:
These objects must be created exactly as shown. Any changes made here must be incorporated in the integration configuration accordingly.Object Column Name Name Level Data Type APPLICATION_ID
Application Identifier Header Number BUS_DATE
Business Date Accounting Event Header Date EVENT_ID
Identifier Header Number LOCATION
Location Header Alphanumeric LOC_CODE
Location Code Header Alphanumeric REV_CENTER
Revenue Center Header Alphanumeric REV_CENTER_CODE
Revenue Center Code Header Number TRANSACTION_DATE
Transaction Date Header Date TRANSACTION_NUMBER
Transaction Number Header Alphanumeric CODE
Code Line Number COUNT
Count Line Number DEFAULT_AMOUNT
Default Amount Line Number DEFAULT_CURRENCY
Default Currency Line Alphanumeric DESCRIPTION
Code Description Line Alphanumeric LINE_NUMBER
Line Number Line Number MAJOR_GROUP
Major Group Line Alphanumeric MAJOR_GROUP_CODE
Major Group Code Line Number ORDER_TYPE
Order Type Line Alphanumeric ORDER_TYPE_CODE
Order Type Code Line Number PREP_COST
Preparation Cost Line Number - Create mapping sets, account rules, description rules, supporting
references, journal line rules, and journal line rule sets to create a
subledger accounting method.
Note:
Based on the Oracle Financials Accounting Hub configurations, the Accounting Hub File Based Data Import (FBDI) file configurations may have to be changed. Review the FBDI file configurations in Oracle Integration once the configurations are complete.
- Create a subledger source system with short name
- Create an integration user account on Oracle Financials Accounting Hub. To
access Oracle SCM Cloud from Oracle Integration, you’ll require a separate
user account on Oracle SCM Cloud.
Log in to the Oracle SCM Cloud instance as an Administrator and perform the following tasks:
- Create a user account for Oracle Integration, which will be required to connect to SCM from Oracle Integration using the Oracle ERP Adapter.
- Assign roles to the user account. See Assign Required Roles to an Integration User.
- In addition to the above roles, also assign the roles needed for Oracle Integration to perform the following operations in Oracle
Financials Accounting Hub:
- Upload file content to the UCM server
- Run the Import Accounting Transactions job
Configure ATP
To access ATP from Oracle Integration, perform the following configuration
tasks on your ATP database:
- Obtain the Cloud Wallet and the Credentials of the ATP instance to be used in the Oracle Integration connections.
- Create a view with name
FNB_AHCS_REPORT_FOR_CSV_V
in your ATP database usingFNB_AHCS_REPORT_FOR_CSV_V.sql
andFNB_AHCS_LINES_V.sql
attached to Support note Supplemental Code for Oracle MICROS – ATP – Accounting Hub Oracle Integration Cloud Recipes.