Troubleshooting Tips for ERP Integration

When an ERP data integration process is executed, Oracle Enterprise Performance Management Cloud submits an Enterprise Service Scheduler (ESS) job in EPM Cloud. When this job is completed, the data is transferred and integrated into EPM Cloud.

If failures occur during the Extract phase of the integration, review the Data Management process log. Identify the ESS Process ID from the log. The log for the ESS job is appended to the process log. Identify and fix the errors as follows:

• Error: Invalid member specified in the query

  Solution: Typically, this error is caused by an invalid member or a partially qualified member. Edit the source filters to specify fully qualified member names.

• Error: Query fails due to number of cells exceeding the governor limit

  Solution: Adjust the source filters to query smaller data slices. Alternatively, create multiple integrations and include them in a batch to automate the execution.

• Error: Query did not produce any data

  Solution: Review the source filter and correct the condition that caused the data retrieval to fail.

• Error: System timed out due to batch timeout settings

  Solution: Increase the batch time out. If ERP Cloud has many jobs in the queue, reschedule the integration for a time when the ERP Cloud job queue is empty or has only a few jobs.