Matched Po Distribution Missing From the Purchase Order Hence the Invoice Cannot Be Validated
Last updated on MAY 23, 2018
Applies to:Oracle Purchasing - Version 12.2.5 and later
Information in this document applies to any platform.
When Attempting to validate an Invoice User encounter the following Error:
APP-SQLAP-10000: ORA-01403: no data found occurred in AP_ETAX_UTILITY_PKG.Get_PO_Info<-AP_ETAX_SERVICES_PKG.Populate_Distributions_GT<-AP_ETAX_SERVICES_PKG.APPROVAL
with parameters ( P_PO_Line_Location_Id =P_Error_Code = P_Calling_Sequence =AP_ETAX_SERVICES_PKG.Populate_Distributions_GT<-AP_ETAX_SERVICES_PKG.APPROVAL)
while performing the following operation:
Step 1.1: PO additional info & & & & &
Steps to replicate the issue :
1) login using CLM Purchasing Responsibility -> User Created Award with Distribution #1 and linked it to Requisition
2) Login to Payables -> Enter Invoice and Validate it matched to Distribution #1
3) Instead of cancelling this invoice User entered Credit memo and validate it
4) User unlinked Req from Distribution 1 - this deleted the Distribution.
5) User created Distribution #2 and linked it to Requisition and Entered an Invoice
and Validated it for Distribution #2
6) User cancelled Invoice that was matched to Correct Distribution #2 and
they needed to cancel the credit memo for Distribution #1
the error above shows and they are not able to validate cancel of the credit memo
because credit memo is matched to Distribution #1 which is deleted .
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