R12: IBY: Cannot Complete PPR Due to Rejected Documents, PPR Processing Log Shows Error ORA-01403 and Message 'Document payable was failed because its parent payment was failed'
(Doc ID 1582983.1)
Last updated on JULY 25, 2023
Applies to:
Oracle Payables - Version 12.0.6 and laterInformation in this document applies to any platform.
Symptoms
Cannot Complete PPR due to Rejected Documents.
When creating a Payment Batch "PPR", several documents have been rejected.
Online FND log show the following:
IBY_VALIDATIONSETS_PUB.checkProfileFormatCompat: Getting the data from Cache For Payee Id: &id
IBY_VALIDATIONSETS_PUB.checkProfileFormatCompat: Format: linked to payee &id
IBY_VALIDATIONSETS_PUB.checkProfileFormatCompat: No format was found linked to payee &id
IBY_VALIDATIONSETS_PUB.checkProfileFormatCompat: Format cd not available. Cannot validate. Returning success.
IBY_VALIDATIONSETS_PUB.checkProfileFormatCompat: EXIT
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Payment profile is compatible with payment format for document id: &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Ext Bank Acct Id field is: &id for the assignments
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Ext Payee Id field is: &id for the assignments
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Bank Acct is not present at supplier site level
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: No Address OU level Payee Exists
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: No Address level Payee Exists
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: End Date field is: for the assignments
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Supplier / External Bankaccount is attached is valid for document id: &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Fetching the value from Cache Structure l_int_bank_accts_tbl &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Internal bank acct is valid for document id: &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: External payee id is valid for document id: &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Getting Data from Cache For Profile Id: &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert to the cursor
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert doc_id is &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert pmt_grp_num is &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert payee_id is &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert pmt_method_cd is EFT
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert int_bank_acct_id is &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert l_payment_format_cd is &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert l_bepid is
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert l_transmit_protocol_cd is
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert l_country is
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: The data for the index already exists
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: After doing a bulk insert to the cursor
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: The cursor return count is0
------------------------
No Reporting Code defined for Process result id fo&id : ORA-01403: No se ha encontrado ningْn dato
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfPmtsInModifiedStatus: SQLERRM: ORA-01403: no data found
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfPmtsInModifiedStatus: SQLERRM: ORA-01403: no data found
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfPmtsInModBankAccStatus: SQLERRM: ORA-01403: no data found
------------------------
IBY_PAYINSTR_PUB.flagSeparateRemitAdvcPayments: SQLERRM: ORA-01403: no data found
IBY_PAYINSTR_PUB.flagSeparateRemitAdvcPayments: SQLERRM: ORA-01403: no data found
"Enter Build :: Concurrent Request ID::25220851
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: ENTER
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: Calling app id: 200
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: Calling app pay req cd: &id
+-----------------------------------------------------------------------------------------------------+
|STEP 1: Insert Payment Service Request:: Timestamp:31-JUL-13 05.49.12.417074000 PM -05:00|
+-----------------------------------------------------------------------------------------------------+
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfDuplicate: ENTER
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfDuplicate: Calling app payment request MERCAD1 31.07 PEN is a duplicate for calling app 200. Previously generated payment request id: &id
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfDuplicate: EXIT
Payment service request &id is a duplicate. Skipping insert of request
IBY_VALIDATIONSETS_PUB.checkProfileFormatCompat: Format: linked to payee &id
IBY_VALIDATIONSETS_PUB.checkProfileFormatCompat: No format was found linked to payee &id
IBY_VALIDATIONSETS_PUB.checkProfileFormatCompat: Format cd not available. Cannot validate. Returning success.
IBY_VALIDATIONSETS_PUB.checkProfileFormatCompat: EXIT
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Payment profile is compatible with payment format for document id: &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Ext Bank Acct Id field is: &id for the assignments
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Ext Payee Id field is: &id for the assignments
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Bank Acct is not present at supplier site level
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: No Address OU level Payee Exists
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: No Address level Payee Exists
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: End Date field is: for the assignments
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Supplier / External Bankaccount is attached is valid for document id: &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Fetching the value from Cache Structure l_int_bank_accts_tbl &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Internal bank acct is valid for document id: &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: External payee id is valid for document id: &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Getting Data from Cache For Profile Id: &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert to the cursor
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert doc_id is &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert pmt_grp_num is &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert payee_id is &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert pmt_method_cd is EFT
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert int_bank_acct_id is &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert l_payment_format_cd is &id
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert l_bepid is
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert l_transmit_protocol_cd is
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Before doing a bulk insert l_country is
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: The data for the index already exists
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: After doing a bulk insert to the cursor
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: The cursor return count is0
------------------------
No Reporting Code defined for Process result id fo&id : ORA-01403: No se ha encontrado ningْn dato
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfPmtsInModifiedStatus: SQLERRM: ORA-01403: no data found
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfPmtsInModifiedStatus: SQLERRM: ORA-01403: no data found
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfPmtsInModBankAccStatus: SQLERRM: ORA-01403: no data found
------------------------
IBY_PAYINSTR_PUB.flagSeparateRemitAdvcPayments: SQLERRM: ORA-01403: no data found
IBY_PAYINSTR_PUB.flagSeparateRemitAdvcPayments: SQLERRM: ORA-01403: no data found
"Enter Build :: Concurrent Request ID::25220851
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: ENTER
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: Calling app id: 200
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: Calling app pay req cd: &id
+-----------------------------------------------------------------------------------------------------+
|STEP 1: Insert Payment Service Request:: Timestamp:31-JUL-13 05.49.12.417074000 PM -05:00|
+-----------------------------------------------------------------------------------------------------+
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfDuplicate: ENTER
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfDuplicate: Calling app payment request MERCAD1 31.07 PEN is a duplicate for calling app 200. Previously generated payment request id: &id
IBY_DISBURSE_SUBMIT_PUB_PKG.checkIfDuplicate: EXIT
Payment service request &id is a duplicate. Skipping insert of request
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit PPR.
2. Rejected Scheduled Payments = xx (number of rejected payable documents)
The following select statement will show the validation failures, or use the Funds Disbursement Analyzer (Doc ID 1587455.1) which will show the same in the 'PPR Data Collection' section.
Changes
Applied the Patches 11699958 and 15867522.
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 |