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 laterOracle 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:
- Go to Payments -> Entry -> Payments Manager -> Submit Single Payment Process Request
- Submit a new Payment Process Request (PPR) and under processing options check the checkbox to stop for selected invoice review
- Once the PPR finishes selecting invoices click on Go To Task to review the invoices selected
- Click to process the PPR and submit the build
- 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 |