P2: User Defined Validation Rejecting An Entire Batch With Same Error Where The Details Are Present
Last updated on AUGUST 22, 2016
Applies to:Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Pmt PayReports PBatch & Prepay
Certain Scheduled Payments in Electronic PPRs are failing in
STEP 4: Document Validation, even though the attached supplier bank account is attached and valid.
And that is causing all the Documents in the batch to be rejected.
Due to this issue, users cannot complete Payment Process Request.
The FND Log shows the following [[
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable:Old Method - Validation Failed: Document Payee Bank Account Number is required.
IBY_VALIDATIONSETS_PUB.insertIntoErrorTable:Finished populating the error table.
... ... ...
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Request status after document validation: VALIDATION_FAILED
The data of CE_Bank_Branches_V returns 2 rows with BRANCH_PARTY_ID = 2194074 and 2 different BANK_BRANCH_TYPE: ABA, SWIFT
According to screen shots provided, both rows have primary_flag set to 'Y' and status A. But one is end-dated and the other is not.
Customer already tried to set the status of the end-dated row in CE_Bank_Branches_V to 'I'
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