Configuring Oracle Cloud ERP Integration

Creating a Source System

1. Log in to Oracle Fusion Accounts Receivables Cloud with a valid username and password. 

2. Select Others and then select Setup and Maintenance.

3. Select the Financials offering from the Setup drop down list.

4. Select Customers from the Functional Areas list.

5. Click Manage Trading Community Source Systems.

6. Click the ‘+’ icon to create a new Source System and enter the required details.

7. Select the Enable check box for Trading Community Members.

8. Click Save, click Close, and then click Done.

9. In Search Tasks, search for Manage Source System Entities.

10. In the Search Task Results, select the Manage Source System Entities that correspond to the Functional Area ‘Customers.’ Click Manage Source System Entities.

11. Search for the source system name created and select all check boxes.

12. Click Save and then click Close.

Creating a Customer Class

1. Log in to Oracle Fusion Accounts Receivables Cloud with a valid username and password. 

2. Select Others and then select Setup and Maintenance.

3. Select the Financials offering from the Setup drop down list.

4. Select Customers from the Functional Area list.

5. In Search Tasks, search for Manage Customer Account Lookups.

6. In the search results, select the Manage Customer Account Lookups corresponding to the Functional Area ‘Customers.’ Click Manage Customer Account Lookups.

7. Click CUSTOMER CLASS and click the ‘+’ icon to create a new Lookup Code.

8. Enter values for Lookup Code, Start date, and Meaning and Description.

9. Use the following value for Lookup Code: OPERA.

10. Select the Enabled check box

11. Click Save, click Close, and then click Done.

Creating Transaction Sources

Note:

There should be one transaction source created for each property defined in OPERA and each one must be added to the relevant Oracle Integration Cloud lookups listed below.

1. Log in to Oracle Fusion Accounts Receivables Cloud with a valid username and password.

2. Select Others and then select Setup and Maintenance.

3. Select the Financials offering from the Setup drop down list.

4. Select Customer Billing in the Functional Area list.

5. In Search Tasks, search for Manage Transaction Sources and select it in the search results.

6. Click the Add icon.

7. In the Transaction Source Set field, select the required reference data set.

   Note:

   The reference data set must be the same reference data set mapped to the Object - Receivables Transaction Source in the 'Manage Business Unit Set Assignment' setup.

8. In the Name field, enter a name for this transaction source.

9. In the Description field, enter a description for this transaction source.

10. In the Type field, select Imported.

11. Enter the dates during which this transaction source is active.

12. Deselect Automatic Transaction Numbering.

13. Select Allow duplicate transaction numbers.

14. In the Standard Transaction Type field, select the transaction type defined for invoices.

15. In Reference Field Default Value, select interface_header_attribute1.

16. In the Grouping Rule field, select a value for importing Credit Memo.

17. Click Save, click Close, and then click Done.

Note:

You should create one transaction source for each property defined in OPERA and each one must be added to the relevant Oracle Integration Cloud lookup.

Creating Value Sets for Invoice Context and Flex Fields

1. Log in to Oracle Fusion Accounts Receivables Cloud with a valid username and password.

2. Select Others and then select Setup and Maintenance.

3. Select the Financials offering from the Setup drop down list.

4. Select the Financial Reporting Structures in the Functional Area list.

5. In Search Tasks, search for “Manage Chart of Accounts Value Sets.”

6. In Manage Chart of Accounts Value Sets, click (+) create.

7. Enter the values for the following fields:Value Set Code, Module, Validation Type, Value Data Type, Value Subtype, and Maximum Length.

8. Click Save and then click Close. 

9. Repeat steps 4 through 6 for all entries mentioned in the below table.

Table 4-2 Fields

VALUE SET CODE	DESCRIPTION	MODULE	VALIDATION TYPE	VALUE DATA TYPE	VALUE SUBTYPE	MAXIMUM LENGTH
Hotel Code Value Set	Hotel Code Value Set	General Ledger	Format Only	Character	Text	20
Invoice Number Value Set	Invoice Number Value Set	General Ledger	Format Only	Character	Text	20
Confirmation Number Value Set	Confirmation Number Value Set	General Ledger	Format Only	Character	Text	20
Guest Name Value Set	Guest Name Value Set	General Ledger	Format Only	Character	Text	20
Arrival Date Value Set	Arrival Date Value Set	General Ledger	Format Only	Character	Text	20
Departure Date Value Set	Departure Date Value Set	General Ledger	Format Only	Character	Text	20
Reservation ID Value Set	Reservation ID Value Set	General Ledger	Format Only	Character	Text	20
Folio Window Number Value Set	Folio Window Number Value Set	General Ledger	Format Only	Character	Text	20
Check Status Value Set	Check Status Value Set	General Ledger	Format Only	Character	Text	20

Creating Invoice Context and Flex Fields

1. Log in to Oracle Fusion Accounts Receivables Cloud with a valid username and password.

2. Select Others and then select Setup and Maintenance.

3. Select the Financials offering from the Setup drop down list.

4. Select Receivables in the Functional Area list.

5. In Search Tasks, search for Manage Receivables Descriptive Flex Fields.

6. Select Manage Receivables Descriptive Flex Fields in the search results and click Manage Receivables Descriptive Flex Fields.

7. Navigate to Search and Line Transactions. Select Line Transactions and click Edit.

8. On the Edit Descriptive Flex Field page, click Manage Contexts.

9. On the Manage Contexts page, click the Create (+) icon.

10. On the Create Context page, enter the values for Display Name as OPERA_INVOICE_CONTEXT. The Context Code API name will auto populate.

11. Select the Enabled check box.

12. Click Save and then click Close.

13. In the Context Sensitive Segments section, select the context created OPERA_INVOICE_CONTEXT from the Context list.

14. Click the Create icon.

15. On the Create Segment page, enter the values for the segment.

16. Click Save and then click Close.

17. Repeat steps 13 through 16 for all the context flex fields mentioned in the table below.

Table 4-3 Context Flex Fields

NAME	ENABLED	DATA TYPE	TABLE COLUMN	VALUE SET	PROMPT	DISPLAY TYPE	READ-ONLY
Hotel Code	Yes	Character	INTERFACE_LINE_ATTRIBUTE1	Hotel Code Value Set	Hotel Code	Text Box	Yes
Invoice Number	Yes	Character	INTERFACE_LINE_ATTRIBUTE2	Invoice Number Value Set	Invoice Number	Text Box	Yes
Confirmation Number	Yes	Character	INTERFACE_LINE_ATTRIBUTE3	Confirmation Number Value Set	Confirmation Number	Text Box	Yes
Guest Name	Yes	Character	INTERFACE_LINE_ATTRIBUTE4	Guest Name Value Set	Guest Name	Text Box	Yes
Arrival Date	Yes	Character	INTERFACE_LINE_ATTRIBUTE5	Arrival Date Value Set	Arrival Date	Text Box	Yes
Departure Date	Yes	Character	INTERFACE_LINE_ATTRIBUTE6	Departure Date Value Set	Departure Date	Text Box	Yes
Reservation ID	Yes	Character	INTERFACE_LINE_ATTRIBUTE7	Reservation ID Value Set	Reservation ID	Text Box	Yes
Folio Window Number	Yes	Character	INTERFACE_LINE_ATTRIBUTE8	Folio Window Number Value Set	Folio Window Number	Text Box	Yes
Check Status	Yes	Character	INTERFACE_LINE_ATTRIBUTE9	Check Status Value Set	Check Status	Text Box	Yes

Enabling Flex Fields

To enable flex fields, you must validate and deploy them.

1. Log in to Oracle Fusion Accounts Receivables Cloud using a valid username and password.

2. Select Others and then select Setup and Maintenance.

   1. Select the Financials offering from the Setup drop-down list.

   2. Select Receivables in the Functional Area list.

3. In Search Tasks, search for ‘Manage Receivables Descriptive Flexfields.’

4. Click Manage Receivables Descriptive Flexfields in the search results.

5. Click Manage Receivables Descriptive Flexfields.

6. Search for ‘Line Transactions.’

7. With Line Transactions selected, click Actions and then clickValidate Flexfield.

8. With Line Transactions selected, click Actions and then clickDeploy Flexfield.

Creating Attachment Categories

1. Log in to the Oracle Fusion Accounts Receivables Cloud using a valid username and password.

2. Select Others and then select Setup and Maintenance.

   1. Click the Setup drop-down list and select the Financials offering.

3. Click the Tasks button.

4. Click the Search link.

5. In the Search Tasks, search for Manage Attachment Categories.

6. Click (L) Manage Attachment Categories.

7. On the Manage Attachment Categories page, click Create (+).

8. Enter the following values:

   1. Category Name: OPERA_TRX

   2. User Name: OPERA Transaction

   3. Module: Transactions (FinArTransactionsMain)

   4. Description: OPERA Transaction

9. In the Attachment Entities section, click Create (+).

10. Search for and add the following Entities.

    1. Entity Name: RA_CUSTOMER_TRX_ALL

    2. Entity Name: RA_CUSTOMER_TRX_LINES_ALL

11. Click Save and Close.

Importing BIP Reports

1. Log in to the Oracle BI Analytics (OTBI) Cloud with a valid username and password.

2. Navigate to the Catalog menu item.

3. In the Folders pane, select Shared Folders.

4. Click Expand under the Custom folder.

5. In the Tasks pane, click Unarchive.

6. Click Browse in the Unarchive window and select the downloaded Catalog file.

7. Set the following values:

   • Replace: None

   • ACL: Inherit

8. Click OK.

Note:

To access and download the Catalog file, refer to the ERP Reports Catalog (Doc ID 2923690.1) MOS article and download the attached OFAR_OPERA_PMS_BA.catalog file.

Creating ESS jobs

1. Log in to Oracle Fusion Accounts Receivables Cloud with a valid username and password.

2. Select Others and then select Setup and Maintenance.

3. Select the Financials offering from the Setup drop down list.

4. In Search Tasks, search for Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications.

5. Click Manage Enterprise Scheduler Job Definitions Job Sets for Financial, Supply Chain Management, and Related Applications.

6. Under Manage Job Definitions, click the + plus icon to create a new job.

7. Create a Job Definition using the table below as reference.

   Table 4-4 Job Definition

   DISPLAY NAME	NAME	PATH	JOB APPLICATION NAME	JOB TYPE	DEFAULT OUTPUT FORMAT	REPORT ID
   BIP Report to Create Customer Profile	Cust_Sync_CreateCustomerProfile	/Cust_Sync_Accelerator/Create_Customer_Profile/	FscmEss	BIPJobType	XML	Custom/OFAR_OPERA_PMS_BA/CREATE_COMPANY_PROFILE_REPORT.xdo

8. Under Parameters, click the + plus icon to create a new parameter.

   Table 4-5 Parameters

   SEQUENCE	PARAMETER PROMPT	DATA TYPE	PAGE ELEMENT	REQUIRED
   1	P_BATCH_ID	String	Text Box	Yes
   2	P_ORIG_SYSTEM	String	Text Box	Yes
   3	P_LAST_RUN_DATE	String	Text Box	Yes

9. Use the up arrow button and down arrow button to ensure the sequence is maintained.

10. Click Save and then click Close.

11. Repeat step 4 for the following jobs:

Note:

Ensure the Display Name, Path, and the sequence of parameters is maintained per the document.

Table 4-6 Job Definition

DISPLAY NAME	NAME	PATH	JOB APPLICATION NAME	JOB TYPE	DEFAULT OUTPUT FORMAT	REPORT ID
BIP Report to Create AR Address	Cust_Sync_CreateARAddress	/Cust_Sync_Accelerator/Create_Customer_AR_Address/	FscmEss	BIPJobType	XML	Custom/OFAR_OPERA_PMS_BA/CREATE_AR_ADDRESS_REPORT.xdo
BIP Report to Extract Customer Balance and Credit Status	OPERA_Invoice_Processing_Credit_UPD_AccountBalance	/OPERA_Invoice_Processing_Accelerator/Credit_Update_Processing_Accelerator/Credit_Update/	FscmEss	BIPJobType	XML	Custom/OFAR_OPERA_PMS_BA /CUSTOMER_CREDIT_STATUS_REPORT.xdo

Table 4-7 Parameters

SEQUENCE	PARAMETER PROMPT	DATA TYPE	PAGE ELEMENT	REQUIRED
1	P_BATCH_ID	String	Text Box	Yes
2	P_ORIG_SYSTEM	String	Text Box	Yes

Table 4-8 Job Definition

DISPLAY NAME	NAME	PATH	JOB APPLICATION NAME	JOB TYPE	DEFAULT OUTPUT FORMAT	REPORT ID	ALLOW MULTIPLE PENDING SUBMISSIONS
BIP Report to Create Invoice Attachment	Inv_Attchmnt_CreateAttchmnt	/OPERA_Invoice_Attachment_Accelerator/Invoice_Attachment/	FscmEss	BIPJobType	XML	Custom/OFAR_OPERA_PMS_BA/	False

Table 4-9 Parameters

SEQUENCE	PARAMETER PROMPT	DATA TYPE	PAGE ELEMENT	REQUIRED
1	P_BATCH_ID	String	Text Box	Yes
2	P_TRX_SRC	String	Text Box	Yes
3	P_LAST_RUN_DATE	String	Text Box	Yes

Table 4-10 Job Definition

DISPLAY NAME	NAME	PATH	JOB APPLICATION NAME	JOB TYPE	DEFAULT OUTPUT FORMAT	REPORT ID
BIP Report to Create Customer Account	Cust_Sync_CreateCustomerAccount	/Cust_Sync_Accelerator/Create_Customer_Account/	FscmEss	BIPJobType	XML	Custom/OFAR_OPERA_PMS_BA/CREATE_ACCOUNT_REPORT.xdo

Table 4-11 Parameters

SEQUENCE	PARAMETER PROMPT	DATA TYPE	PAGE ELEMENT	REQUIRED
1	P_BATCH_ID	String	Text Box	Yes
2	P_ORIG_SYSTEM	String	Text Box	No
3	P_LAST_RUN_DATE	String	Text Box	Yes

Table 4-12 Job Definition

DISPLAY NAME	NAME	PATH	JOB APPLICATION NAME	JOB TYPE	DEFAULT OUTPUT FORMAT	REPORT ID
BIP Report to Update AR Address	Cust_Sync_UpdateARAddress	/Cust_Sync_Accelerator/Update_Customer_AR_Address/	FscmEss	BIPJobType	XML	Custom/OFAR_OPERA_PMS_BA/UPDATE_AR_ADDRESS_REPORT.xdo

Table 4-13 Parameters

SEQUENCE	PARAMETER PROMPT	DATA TYPE	PAGE ELEMENT	REQUIRED
1	P_BATCH_ID	String	Text Box	Yes
2	P_ORIG_SYSTEM	String	Text Box	No
3	P_LAST_RUN_DATE	String	Text Box	Yes

Table 4-14 Job Definition

DISPLAY NAME	NAME	PATH	JOB APPLICATION NAME	JOB TYPE	DEFAULT OUTPUT FORMAT	REPORT ID
BIP Report to Update Customer Account	Cust_Sync_UpdateCustomerAccount	/Cust_Sync_Accelerator/Update_Customer_Account/	FscmEss	BIPJobType	XML	Custom/OFAR_OPERA_PMS_BA/UPDATE_ACCOUNT_REPORT.xdo

Table 4-15 Parameters

SEQUENCE	PARAMETER PROMPT	DATA TYPE	PAGE ELEMENT	REQUIRED
1	P_BATCH_ID	String	Text Box	Yes
2	P_ORIG_SYSTEM	String	Text Box	No
3	P_LAST_RUN_DATE	String	Text Box	Yes

Table 4-16 Job Definition

DISPLAY NAME	NAME	PATH	JOB APPLICATION NAME	JOB TYPE	DEFAULT OUTPUT FORMAT	REPORT ID
BIP Report to Sync Customer Contact	Cust_Sync_CustomerContactSync	/Cust_Sync_Accelerator/Customer_Contact_Sync/	FscmEss	BIPJobType	XML	Custom/OFAR_OPERA_PMS_BA/COMMUNICATION_CONTACT_DATA_REPORT.xdo

Table 4-17 Parameters

SEQUENCE	PARAMETER PROMPT	DATA TYPE	PAGE ELEMENT	REQUIRED
1	P_BATCH_ID	String	Text Box	Yes
2	P_ORIG_SYSTEM	String	Text Box	No
3	P_LAST_RUN_DATE	String	Text Box	Yes

Table 4-18 Job Definition

DISPLAY NAME	NAME	PATH	JOB APPLICATION NAME	JOB TYPE	DEFAULT OUTPUT FORMAT	REPORT ID
BIP Report to Extract Customer Balance and Credit Status	OPERA_Invoice_Processing_Credit_UPD_AccountBalance	/OPERA_Invoice_Processing_Accelerator/Credit_Update/	FscmEss	BIPJobType	XML	Custom/OFAR_OPERA_PMS_BA /CUSTOMER_CREDIT_STATUS_REPORT.xdo

Table 4-19 Parameters

SEQUENCE	PARAMETER PROMPT	DATA TYPE	PAGE ELEMENT	REQUIRED
1	P_BATCH_ID	String	Text Box	Yes
2	P_ORIG_SYSTEM	String	Text Box	Yes

Table 4-20 Job Definition

DISPLAY NAME	NAME	PATH	JOB APPLICATION NAME	JOB TYPE	DEFAULT OUTPUT FORMAT	REPORT ID	ALLOW MULTIPLE PENDING SUBMISSIONS
BIP Report to Create Invoice Attachment	INV_ATTCHMNT_CREATEATTCHMNT	/OPERA_INVOICE_ATTACHMENT_ACCELERATOR/INVOICE_ATTACHMENT/	FSCMESS	BIPJOBTYPE	XML	CUSTOM/OFAR_OPERA_PMS_BA /	True

Table 4-21 Job Definition

DISPLAY NAME	NAME	PATH	JOB APPLICATION NAME	JOB TYPE	DEFAULT OUTPUT FORMAT	REPORT ID	ALLOW MULTIPLE PENDING SUBMISSIONS
BIP Report to Create Invoice Checks	Inv_Chk_CreateCheck	/OPERA_Invoice_Check_Accelerator/Invoice_Checks/	FscmEss	BIPJobType	XML	CUSTOM/OFAR_OPERA_PMS_BA /INVOICE_WITHOUT_CHECKS_REPORT.xdo	False

Table 4-22 Parameters

SEQUENCE	PARAMETER PROMPT	DATA TYPE	PAGE ELEMENT	REQUIRED
1	P_BATCH_ID	String	Text Box	Yes
2	P_TRX_SRC	String	Text Box	Yes
3	P_CAT_NAME	String	Text Box	Yes
4	P_INVOICE_CONTEXT	String	Text Box	No

Note:

The following additional ESS jobs, which are predefined in Fusion, are used as part of this Accelerator:

• Process Receivables Transactions for Customer Account Summaries

• Refresh Receivables Transactions for Customer Account Summaries