Prerequisites
The prerequisites are:
• All lookups and DVMs are setup in the Oracle Integration Cloud.
• Oracle Utilities Work and Asset Cloud Service configurations related to this integration are setup correctly.
• Oracle ERP Financial Cloud configurations related to this integration are setup correctly.
Refer to Configuring Oracle ERP Financial Cloud for more information.
• Setup the schedule details of all the scheduled processes needed for this integration. Make sure to coordinate the timing of the WACS Batch Process (W1-ERPGL) and ERP Financial Cloud BIP Report (FIN_COA_WACS) by run them first before the OIC Integration Processes.
• Chart of Account integration is a prerequisite to General Ledger. Oracle Utilities Work and Asset Cloud has a limit for 10 segments, similarly Oracle ERP Financial Cloud should also send 10 segments in the integration flow.
For instructions to set up Chart of Accounts, refer to the Chart of Accounts section in Configuring Oracle Utilities Work and Asset Cloud Service.
Note: Oracle Work and Asset Cloud has a limit of 10 segments. ERP should only send up to 10 segments in the Chart of Account Sync process.
• In the integration, the extract report generates data for Code Combination table within Oracle ERP Financial Cloud. In case the valid code combination are not available in the table, users' needs to manually add the details to the task “Manage Account Combination”. Consultant in the integration team implementing the integration needs to list all the valid combination and add to the above-mentioned task in Financial Cloud. (The above action also required to add the segment values in “Manage Value” if not available in Oracle ERP Financial Cloud).
• If the business wants to create a new Chart of Account, follow the usual practice of creating Value sets/Segment and values and defining the configuration for new Chart of accounts.