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 MAY 06, 2021

Applies to:

Symptoms

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.

Cause

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