My Oracle Support Banner

Synchromization Between EBS And P6 Failed With Error "ORA-20001: Conversion rate date is invalid. ORA-06512: at APPS.XPA_EBS_P6_EXTRACT_PKG, line 7298 ORA-06512: at line 1" (Doc ID 2521372.1)

Last updated on SEPTEMBER 30, 2019

Applies to:

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

Symptoms

When attempting to synchronize EBS projects to P6, the following error occurs:

ERROR
-----------------------
com.oracle.pgbu.pdi.provider.ProviderException: ORA-20001: Conversion rate date is invalid.
ORA-06512: at "APPS.XPA_EBS_P6_EXTRACT_PKG", line 7298
ORA-06512: at line 1
at com.oracle.pgbu.pdi.ebsprovider.project.ProjectLoadStep.getOneProject(ProjectLoadStep.java:266)
at com.oracle.pgbu.pdi.ebsprovider.project.ProjectLoadStep.load(ProjectLoadStep.java:54)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeLoadStep(JobSimulator.java:775)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.executeLoadSideSteps(JobSimulator.java:630)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator.access$000(JobSimulator.java:101)
at com.oracle.pgbu.pdi.service.jobs.JobSimulator$LoadSideStepsExecutor.run(JobSimulator.java:1229)
at org.springframework.scheduling.commonj.DelegatingWork.run(DelegatingWork.java:62)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:209)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:640)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:406)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)

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

1. Run the Create Project Header From EBS business flow
2. Specify the Project Number in the ERP Project Filer parameter (value: 13050)
3. Specify Project Plan (value: Work Plan)
4. Specify Plan Versions (value: Current Working)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot synchronize EBS to P6

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.