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. (Doc ID 2235079.1)

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.

Symptoms

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 2 AP_MATCHING_UTILS_PKG.Validate_Po_Match_Exp_Item_Date
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:

PA_AP_INTEGRATION 1 Default Exp item date profile:INVGLDT

.

Cause

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