Troubleshooting Issues Resulting from Invalid or Missing EXPENDITURE_ITEM_DATE on Supplier Invoices
(Doc ID 1486372.1)
Last updated on JANUARY 31, 2019
Oracle Payables - Version 12.1.1 to 12.1.3 [Release 12.1] Oracle Project Costing - Version 12.1.1 to 12.1.3 [Release 12.1] Oracle Grants Accounting - Version 12.1.1 to 12.1.3 [Release 12.1] Oracle Project Planning and Control - Version 12.1.1 to 12.1.3 [Release 12.1] Information in this document applies to any platform.
In Release 12 new functionality was added to allow users various options in terms of how the expenditure item date is derived when matching an invoice to a project-related purchase order.
This feature is controlled by the profile option "PA: Default expenditure Item date for supplier cost" (PA_AP_EI_DATE_DEFAULT). The possible settings are:
Source Document Exp Item Date
Transaction GL Date
Transaction System Date
Two primary issues with the implementation of the feature have been:
When the profile option is not set, or is set to an invalid value, supplier invoices created in Payables by matching to a project-related PO are created with a NULL expenditure item date (EXPENDITURE_ITEM_DATE).
The original profile option definition created from pa120pc.ldt incorrectly defined the List of Values (LOV) for the profile option. As a result, when the profile option was set by the user, the value being saved on the back end was the lookup meaning rather than the actual lookup code (e.g., the profile option value was stored as 'Transaction Date' rather than 'INVTRNSDT'). This naturally has resulted in many cases where the profile has been set to an invalid value, even though the correct user-visible value (e.g., 'Transaction Date') is displayed in the profile options form.
When the value of the profile option is something other than "Source Document Exp Item Date", this can result in a change to the expenditure item date that was entered and validated on the PO. These validations were not being carried out on the new expenditure item date at the point of matching the invoice to the PO, which could result in invalid expenditure item dates being assigned on the invoice.
These two issues result in missing or invalid expenditure item dates on project-related supplier invoices, and this condition can produce a wide array of symptoms, issues, and problems in both Payables and Projects. The purpose of this document is to identify the various symptoms that can result from the two conditions above, and to provide a complete solution which will resolve them.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!