Primavera Gateway Error When Synchronizing Data from EBS " Identifier 'XPA_EBS_P6_EXTRACT_PKG.GET_PROJECT_EXTRACT' Must Be Declared" (Doc ID 2146136.1)

Last updated on JUNE 09, 2016

Applies to:

Primavera Gateway - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to synchronize data from P6 to EBS,
the following error occurs.

ERROR
-----------------------
Failure: ORA-06550: line1, column 7: PLS-00201: identifier 'XPA_EBS_P6_EXTRACT_PKG.GET_PROJECT_EXTRACT' must be declared. ORA-06550: line 1, column 7: PL/SQL: Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Define business flow to transfer data from P6 to EBS.
2. The EBS provider connection is tested successfully in the EBS deployment.
3. Run sync job then fails with above error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot transfer data from P6 to EBS.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms