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 to deploy and configure the integration and associated resources.

  1. On the Oracle Integration Home page, in the Get started section, click Browse store.
  2. Find the recipe you want to install, then click Get.

    A message confirms that the recipe was successfully installed, and the recipe card shows In use.

  3. Click Configure Configure icon on the recipe to configure its resources.

    The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Configure the Oracle ERP Cloud Connection MICROS Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Oracle ERP Cloud 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.
    Username Enter the username of the account created for Oracle Integration on Oracle SCM Cloud. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle SCM Cloud.
  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 project workspace, click Go back Back icon.

Configure the Oracle ATP Connection MICROS Connection

  1. In the Connections section, click the connection name.
  2. In the 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 project workspace, click Go back Back icon.

Configure the Lookup Table

Edit the lookup tables and enter necessary values.

This recipe contains the following lookup tables:

  • ORACLE-BRT-ATP_AH_SalesConfiguration

    This lookup table contains the information needed to import sales data from Oracle MICROS to Oracle Financials 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 Financials Accounting Hub instance.

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

    Note:

    Do not modify this value unless the Oracle Financials 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 Financials Accounting Hub instance.

    Example value: XLATXNIMPORT

    Note:

    Do not modify this value unless the Oracle Financials 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 Financials 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 Financials 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 Financials 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 Financials 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 Lookups section, click the lookup name.
  2. Update parameter values as required.
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.