R12: AP Match of Invoice to PO Gives Error 'The validations for Project or Award or Transaction GL Date have failed because of the following reasons(s):' but the Error is NULL.
Last updated on FEBRUARY 17, 2017
Applies to:Oracle Project Costing - Version 12.2.5 and later
Information in this document applies to any platform.
Matching Invoice to PO in AP result in a decision popup:
The validations for Project or Award or Transaction GL Date have failed because of the following reasons(s):
Do you want to use the Source Document Expenditure Item Date to continue with the Purchase Order match action?
Answer "Yes" takes the user to the expenditure item date on the PO which is 12-Nov-2014
Answer "No" takes you no where
The fnd_log_messages shows:
AP.PLSQL.AP_MATCHING_UTILS_PKG.Is_Proj_Exp_Item_Date_Valid 1 Open Cursor po_dists_cursor
AP.PLSQL.AP_MATCHING_UTILS_PKG.Is_Proj_Exp_Item_Date_Valid 1 Validating EI date on PO distribution : 618615
PA_AP_INTEGRATION 1 Default Exp item date profile:INVGLDT
PA_AP_INTEGRATION 1 Date returned :12-NOV-2014
AP.PLSQL.AP_MATCHING_UTILS_PKG.Is_Proj_Exp_Item_Date_Valid 1 l_is_date_valid : N
AP.PLSQL.AP_MATCHING_UTILS_PKG.Is_Proj_Exp_Item_Date_Valid 1 EI date NOT valid for the PO dist. Returning N.
The item is listed in the transaction controls as chargeable. This date is inside the project and task effective dates. The value returned by PA_AP_INTEGRATION is correct, in this case PO distribution GL date:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms