My Oracle Support Banner

FRM-40735 When Attempting To Compile A DFF (Doc ID 2961351.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Oracle Purchasing - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Using Purchasing,

Actual:
Querying the purchase orders, are resulting in errors with regards to the flexfields, both key and descriptive.


Expected:
There should not be a flexfield error on the purchase order lines.


Errors:
Enter PO Error:
APP-00690 The data which defines the flexfield may be inconsistent.
application id = 401
code = MCAT
structure number = 101



Replication Steps:
The issue can be reproduced at will with the following steps:
1. Enter PO form - lines - error occurs. APP-690
2. Define Flexfield Form - Requisition Lines - compile - errors - FRM-40735


Other:

When using the adadmin utility to compile the item category flexfield - and all flexfields - multiple failures on various flexfields are noted. 

 

Application Id: 401
Short Name: INV
Name: Inventory
Flexfield Code: MCAT
Name: Item Categories
Structure Num: 3
Code: STATISTICAL_CODE
Name: Statistical Code

Compilation aborted for current key flexfield...

APP-FND-00684: Flexfield routine FDFRKS cannot find flexfield definition for application 401, and code MCAT.
APP-FND-00858: Flexfield compiler cannot find enabled key flexfield columns. (ROUTINE=FDFBKF)
APP-FND-01564: ORACLE error 1403 in FDFBCO

Cause: FDFBCO failed due to ORA-01403: no data found.

The SQL statement being executed at the time of the error was: and was executed from the file &ERRFILE.

 

Name: Lease and Finance Management
Flexfield Code: BG#
Name: Leasing Key CCID
Structure Num: 50419
Code: Leasing Key CCID
Name: Leasing Key CCID

Compilation aborted for current key flexfield...

APP-FND-00684: Flexfield routine FDFRKS cannot find flexfield definition for application 540, and code BG#.
APP-FND-00858: Flexfield compiler cannot find enabled key flexfield columns. (ROUTINE=FDFBKF)
APP-FND-01564: ORACLE error 1403 in FDFBCO

Cause: FDFBCO failed due to ORA-01403: no data found.
_______________________________________________________________________

Application Id: 800
Short Name: PER
Name: Human Resources
Flexfield Code: SCL
Name: Soft Coded KeyFlexfield
Structure Num: 2
Code: DE_STATUTORY_INFO.
Name: DE Statutory Info.

Compilation aborted for current key flexfield...

APP-FND-00684: Flexfield routine FDFRKS cannot find flexfield definition for application 800, and code SCL.
APP-FND-00858: Flexfield compiler cannot find enabled key flexfield columns. (ROUTINE=FDFBKF)
APP-FND-01564: ORACLE error 1403 in FDFBCO

Cause: FDFBCO failed due to ORA-01403: no data found.
_______________________________________________________________________

Application Id: 800
Short Name: PER
Name: Human Resources
Flexfield Code: SCL
Name: Soft Coded KeyFlexfield
Structure Num: 3
Code: DK_STATUTORY_INFO.
Name: DK Statutory Info.

Compilation aborted for current key flexfield...

APP-FND-00684: Flexfield routine FDFRKS cannot find flexfield definition for application 800, and code SCL.
APP-FND-00858: Flexfield compiler cannot find enabled key flexfield columns. (ROUTINE=FDFBKF)
APP-FND-01564: ORACLE error 1403 in FDFBCO

_______________________________________________________________________

Flex compilation process complete ...
=====================================
Number of successful key flex compilations : 75
Number of failed key flex compilations : 67

 

Changes

Patch 35173846 was applied, however this can happen regardless of the specific patch.
There is a defect in the adop utility.
Bug 34372447 : RECREATE TABLE STRUCTURE FOR FND_COMMON_LOOKUPS FROM TRANSLATION PATCH 34040340
Bug 34496050 - RECREATE TABLE STRUCTURE FOR FND_COLUMNS FROM PO_HEADERS_ALL PATCH 33899861
Bug 34585551- FND_COLUMNS MISSING DATA AFTER 3 GERMAN NLS PATCHES 31856789, 34423621, 31856799
Bug 34672050 - FND_COLUMNS MISSING DATA AFTER APPLYING PATCH 33527653 R12.HR_PF.C.DELTA.16

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.