RAXMTR: Autoinvoice Master Program Fails With APP-FND-00798: Invalid Reference After Upgrading To 12.2.10 (Doc ID 2767588.1)

Last updated on NOVEMBER 08, 2022

Applies to:

Symptoms

STEPS TO REPRODUCE:
------------------------

Log into the Accounts Receivables responsibility
Navigate to Interfaces > Autoinvoice
Select Single Request
Click OK
Enter Autoinvoice Master Program
Required Parameters:
     Number of Instances: 1
     Organization: All
     Invoice Source: PROJECTS INVOICES
     Default Date: <Current Date>
     All other parameters to remain as default.

ACTUAL BEHAVIOR:
----------------------
When running the Autoinvoice Master Program it fails with the following error message in the log when importing invoices from Projects;

ERROR MESSAGE:
----------------------
APP-FND-00798: Invalid reference GMS_AW_PROJECT_NUMBER_AR in value set attached to segment Award Manager
Please check the WHERE clauses of your table validated value sets.

EXPECTED BEHAVIOR:
----------------------
Autoinvoice Master Program should complete without error and import invoices that have been interfaced from Projects.


BUSINESS IMPACT:
----------------------
Cannot import any invoices from Projects to Receivables when the program errors.

Changes

Testing the setup of the the Descriptive Flexfield (DFF) Segments for the PA INVOICES Transaction Type while upgrading from 12.1.3 to 12.2.10

The Line Transaction Flexfield for the Receivables DFF is different between 12.1.3 and the upgrade test instance (12.2.10).

When the segment number 5 in the Receivables Line Transaction Flexfield for PA INVOICES has the 'Enabled' box for the Award Manager, the Autoinvoice Program completes successfully. 

Cause

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