1. Integrate Oracle MICROS Reporting and Analytics Sales Data from ATP with Oracle Financials Accounting Hub
  2. Install and Configure the Recipe

3 Install and Configure the Recipe

On your Oracle Integration instance, install the recipe package to deploy and configure the integration and associated resources.

  1. On the Oracle Integration Home page, scroll to the Accelerators & Recipes section.
  2. Click Search All.
    The list of available recipes is displayed.
  3. Find and select the recipe package that you want to install, then click Install Install icon..
    A message confirms that the recipe was successfully installed, and the recipe card shows INSTALLED.
  4. After the package is installed, click Configure Configure icon on the recipe card.

    The Configuration Editor opens, displaying all the resources of the recipe package. Configure the following resources before you activate and run the recipe.

Configure the Oracle ERP Cloud Connection MICROS

  1. In the Configuration Editor, select the connection, then click Edit Edit icon.
  2. In the Connection Properties section, enter the Oracle Fusion Cloud ERP host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    User Name Enter the user name of the account created for Oracle Integration on Oracle Fusion Cloud SCM. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle Fusion Cloud SCM.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  6. To return to the Configuration Editor, click Back Back icon . Click Save again if prompted.

Configure the Oracle ATP Connection MICROS Connection

Note:

This connection configuration is not required if the prerequisite recipe Oracle MICROS R&A — Oracle ATP | Export Sales Data is already installed and configured.
  1. In the Configuration Editor, select the connection, then click Edit Edit icon.
  2. In the Connection Properties section, enter the Service Name.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Leave JDBC Over SSL selected.
    Wallet Delete the existing wallet, then click Upload and browse for the cloud wallet zip file for your ATP connection. Click Upload.
    Wallet Password Specify the cloud wallet for your ATP instance.
    Database Service Username Enter the Database Service user name for your ATP instance.
    Database Service Password Enter the Database Service password for your ATP instance.

    Note:

    These configurations indicate a wallet-based connectivity to ATP. This may vary depending on the type of ATP and its authentication in your instance.

  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  6. To return to the Configuration Editor, click Back Back icon . Click Save again if prompted.

Configure the Lookup Tables

Edit the lookup tables and enter the necessary values.

This recipe package contains the following lookup tables:

  • ORACLE-BRT-ATP_AH_SalesConfiguration

    This lookup table contains the information needed to import sales data from Micros to Fusion Accounting Hub.

    Parameter Name Description
    ESSJobPackageName

    The Oracle Enterprise Scheduler Job Package name of the job Import Accounting Transactions (XLATXNIMPORT) as configured on the Oracle Fusion Accounting Hub instance.

    Example value: /oracle/apps/ess/financials/subledgerAccounting/shared/

    Note: Do not modify this value unless the Oracle Fusion Accounting Hub configuration has changed.

    ESSJobName

    The Oracle Enterprise Scheduler Job Package name of the job Import Accounting Transactions (XLATXNIMPORT) as configured on the Oracle Fusion Accounting Hub instance.

    Example value: XLATXNIMPORT

    Note: Do not modify this value unless the Oracle Fusion Accounting Hub configuration has changed.

    LedgerName

    The value of the Ledger Name where the sales transaction data is to be imported, as configured on Oracle Fusion Accounting Hub.

    Example value: US Primary Ledger
    TransactionsOutputDirectory

    The Oracle Integration Stage Folder path where the Transaction template files are written and compressed before being uploaded to UCM.

    Example value: /FNB_ICS/TransactionFiles
    TransactionsHeaderFileName

    The name of the header file of the AH Transaction Upload Template.

    Example value: XlaTrxH.csv

    Note: Do not modify this value unless the Oracle Fusion Accounting Hub configuration has changed.

    TransactionsLineFileName

    The name of the line file of the AH Transaction Upload Template.

    Example value: XlaTrxL.csv

    Note: Do not modify this value unless the Oracle Fusion Accounting Hub configuration has changed.

    TransactionsPropertiesFileName

    The name of the metadata file of the AH Transaction Upload Template.

    Example value: XlaTrxL.csv

    Note: Do not modify this value unless the Oracle Fusion Accounting Hub configuration has changed.

  • ORACLE-BRT-Micros_ErrorNotification_Config

    This lookup table contains the information needed to trigger the error handlers.

    Parameter Name Description
    OIC

    The Oracle Integration Admin email address that must be notified on failures.
    ERP

    The ERP Admin email address that must be notified on failures.
    Micros

    The MICROS Admin email address that must be notified on failures.
  1. In the Configuration Editor, select a lookup table, then click Edit Edit icon.
  2. Update parameter values as required.
  3. Click Save. If prompted, click Save again.
  4. To return to the Configuration Editor, click Back Back icon . Click Save again if prompted.