My Oracle Support Banner

R12: AP/IBY: The Build Process for a Payment Process Request Fails with "ORA-01403: no data found" (Doc ID 2884784.1)

Last updated on JULY 28, 2023

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Payments - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When processing a Payment Process Request (PPR) the build process fails with

Enter: iby.scheduler.BuildPayments.runBuildPayments()
Sql to be executed: BEGIN IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31); END;
BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
Error Message:BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
An error occurred. Roll back any changes.
Done roll back changes.
Request completed in error.
...
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+----------------------------------------------------------------------------------------------------+
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:|STEP 4: Document Validation :Timestamp:01-JAN-50 24.00.00.0000000 AM 00:00|
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:+----------------------------------------------------------------------------------------------------+
ERROR Code : 100
ERROR Msg : ORA-01403: no data found
AP.PLSQL.AP_PMT_CALLOUT_PKG..documents_payable_rejected - Fetch CURSOR for all PPRs in a payment Instruction - 01-JAN-50 24.00.00.0000000 AM 00:00
IBY_DISBURSE_UI_API_PUB_PKG.remove_documents_payable:Fatal: External app callout 'AP_PMT_CALLOUT_PKG.documents_payable_rejected', generated exception.
IBY_DISBURSE_UI_API_PUB_PKG.remove_documents_payable:SQL code: -20001
IBY_DISBURSE_UI_API_PUB_PKG.remove_documents_payable:SQL err msg: ORA-20001: 
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when validating documents. Document validation will be aborted and no document statuses will be committed for payment request 999999
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: 1
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: User-Defined Exception
Build program error: Exception occured when attempting to validate the documents payable of the provided payment service request.

 

From the Payables Responsibility:

  1. Go to Payments -> Entry -> Payments Manager -> Submit Single Payment Process Request
  2. Submit a new Payment Process Request (PPR) and under processing options check the checkbox to stop for selected invoice review
  3. Once the PPR finishes selecting invoices click on Go To Task to review the invoices selected
  4. Click to process the PPR and submit the build
  5. Review the log file to see the error

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


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