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:

1. 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.
2. In the Oracle Financials Accounting Hub/Accounting Transformation application:
   1. 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

   2. 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.
3. 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:

   1. Create a user account for Oracle Integration, which will be required to connect to SCM from Oracle Integration using the Oracle ERP Adapter.
   2. Assign roles to the user account. See Assign Required Roles to an Integration User.
   3. 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:

1. Obtain the Cloud Wallet and the Credentials of the ATP instance to be used in the Oracle Integration connections
2. Create a view with name FNB_AHCS_REPORT_FOR_CSV_V in your ATP database using FNB_AHCS_REPORT_FOR_CSV_V.sql and FNB_AHCS_LINES_V.sql attached to Support note Supplemental Code for Oracle MICROS – ATP – Accounting Hub Oracle Integration Cloud Recipes.