My Oracle Support Banner

Error "This foreign key value cannot be resolved for the field ExpenseCategoryObjectId of the object ExpenseCategory" When Exporting Expense data to File from P6 EPPM using Primavera Gateway (Doc ID 2452662.1)

Last updated on SEPTEMBER 27, 2018

Applies to:

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

Symptoms

On : 17.12.0.0 version, General

When attempting to export P6 EPPM expense data to File using Primavera Gateway, the following error occurs:

"Unresolved foreign key in ActivityExpense. 123 - This foreign key value cannot be resolved for the field ExpenseCategoryObjectId of the object ExpenseCategory."

When attempting to import that same expense data into P6 EPPM using Primavera Gateway, the following error occurs:

"Field not set:ActivityObjectId when creating ActivityExpense"


BUSINESS IMPACT
-----------------------
The issue has the following business impact: Due to this issue, users cannot export or import P6 EPPM expense data consistently.

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!


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