My Oracle Support Banner

R12: AP: ORA-01403 Error When Matching to PO (Doc ID 1076364.1)

Last updated on OCTOBER 11, 2021

Applies to:

Oracle Payables - Version 12.0.6 and later
Information in this document applies to any platform.
Form:APXPMTCH.FMB - Match to Purchase Order


Symptoms

While matching PO with invoice receiving the following error:
ORA-01403: no data found
APP-SQLAP-10108: An error has occurred while trying to commit

Fnd Debug Log shows:

Beginning of Function
ZX_API_PUB: SET_TAX_SECURITY_CONTEXT()+
ZX_API_PUB: DETERMINE_EFFECTIVE_DATE()+
ZX_SECURITY: SET_SECURITY_CONTEXT()+, OU: ## and LE: <your LE>
".GET_TAX_SUBSCRIBER(+)
Parameters:
p_le_id: <your LE>p_org_id: ##"
Party Tax Profile Id info for party_id: ## and party_type_code OU found in cache at index: XXXX
Getting PTP from LE_ID: <your LE> l_chk_le_flg = Y
.GET_TAX_SUBSCRIBER(-)
ZX_SECURITY: SET_SECURITY_CONTEXT()-, G_EFFECTIVE_DATE: 24-FEB-10, G_FIRST_PARTY_ORG_ID: 808720
ZX_API_PUB: SET_TAX_SECURITY_CONTEXT()-
begin
#event_name#WHEN-NEW-ITEM-INSTANCE*formname*APXINWKB
end
"APP-SQLAP-10024: This value already exists.
Re-enter."
"APP-SQLAP-10024: This value already exists.
Re-enter."
"APP-SQLAP-10024: This value already exists.
Re-enter."
begin
#event_name#WHEN-NEW-ITEM-INSTANCE*formname*APXINWKB

Changes

 

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
References


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