My Oracle Support Banner

After Applying GTAS Projects GDF Patch 13614161, Receive Error Message On AR Invoice Flexfield - APP-FND-00874 APP-FND-00730 (Doc ID 1903762.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle U.S. Federal Financials - Version 12.1.3 and later
Information in this document applies to any platform.


You recently applied <Patch 13614161> so that the Project Agreement Global Flexfields are displayed (for Customer TAS, BETC).

After populating these fields, and running the process to transfer an Invoice to Receivables, there is an issue with the Transactions form in AR.

Below is the behavior:

1. After querying the AR Transaction:
If you click Line Items then Distributions, you only see the REV Distribution Line (as expected).
If you click the GDF field, everything was populated correctly.
However, if you switch the field at the top to "Account For All Lines," so that you can see the REC Distribution Line, you receive the following error:

APP-FND-00874: Routine FDFBDF found no rows in table FND_DESCRIPTIVE_FLEXS. Please contact your system administrator or support representative.

Click details on the error received:

APP-FND-00730: This flexfield has an invalid value set. It may use a special value set that uses an Edit event user exit, and the user exit has failed.
If you are using a form on a graphical user interface (GUI) you may have an invalid value set of a different type, possibly a table validated value set where the table or view does not exist or where there is an invalid WHERE clause.
Contact your system administrator or support representative to check and correct the value sets this flexfield uses.

2. If you go straight from the AR Transaction screen, to the Distributions screen, using the Distributions button on the header form, both the REC and REV Distribution Lines are displayed and you get the same error described in 1.


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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