AP: R12: ORA-02014 Invoice Validation Error When Organization Parameter is NULL
(Doc ID 2771136.1)
Last updated on APRIL 23, 2021
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
AP Invoice Validation concurrent Request is ending in error when Organization parameter is not provided
MSG-00101: Error occured in BATCH_APPROVAL()
MSG-00102: Error Code : -20001
MSG-00103: Error Message : ORA-20001: APP-SQLAP-10000: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc. occurred in
with parameters (Run Option = All, Batch Id = , Begin Date = , End Date = DD-MON-YY, Vendor Id = , Pay Group = , Invoice Id = , Entered By = , Concurrent Request Id = <request_id>, Org Id = )
while performing the following operation:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_APPROVAL_PKG", line 11265
MSG-00000: When Others:User-Defined Exception
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
In FND Log can see:
( SELECT /*+ push_subq no_unnest */ 'Cancelled distributions'
FROM AP_INVOICE_DISTRIBUTIONS_ALL D3
WHERE D3.INVOICE_ID = AI.INVOICE_ID
AND D3.CANCELLATION_FLAG = 'Y'
) AND AI.invoice_date <= :b_end_date FOR UPDATE SKIP LOCKED"
ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
AP.PLSQL.AP_APPROVAL_PKG.Batch_Approval Others: Exception: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "APP-SQLAP-10000: ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc. occurred in
The issue can be reproduced at will with the following steps:
1. Run Invoice Validation concurrent program with Organization parameter NULL
2. Error appears
Parallel Processing is available in 12.2.4 and was made available for R12.1.x customers via the application of Patch 8547912:R12.AP.B
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