My Oracle Support Banner

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

Last updated on APRIL 12, 2021

Applies to:

Oracle Application Object Library - Version 12.2.9 and later
Oracle Project Billing - Version 12.2.9 and later
Oracle Grants Accounting - Version 12.2.9 and later
Oracle Receivables - Version 12.2.9 and later
Information in this document applies to any platform.

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

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


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