My Oracle Support Banner

Projects Descriptive Flexfield Errors With Descriptive Flexfield Failed Validation When Running PRC: Interface Supplier Cost, Querying Projects Descriptive Flexfields or Running afffcdff.sql To Do a Descriptive Flex Field (DFF) Consistency Check (Doc ID 3008617.1)

Last updated on APRIL 26, 2024

Applies to:

Oracle Project Costing - Version 12.2.9 and later
Oracle Project Foundation - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

When running PAAPIMP_SI:PRC: Interface Supplier Cost the following error appears in the Supplier Cost Interface Audit report:

Descriptive Flexfield failed validation

If the user tries to query any Descriptive Flex Field (DFF) for Projects in the Descriptive Flexfield Segments form the following error is encountered:

INCONSISTENT DATA EXCEPTION:

DFF NAME:PA_EXPENDITURES _ITEMS_DESC_FLEX

ERROR:PA_EXPENDITURES_ALL IS NOT IN FND_TABLES, OR NO GLOBAL CONTEXT

If the user runs $FND_TOP/sql/afffcdff.sql to do a DFF consistency check the following error was returned:

Rule A.05: DFF base table must exist in FND_TABLES.

 

Steps:
-------
1. Using a Projects responsibility navigate to Other-->Requests--.run
2. Select Name = PRC: Interface Supplier Cost and submit.

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
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.