P2: User Defined Validation Rejecting An Entire Batch With Same Error Where The Details Are Present (Doc ID 2152240.1)

Last updated on AUGUST 22, 2016

Applies to:

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

Symptoms

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.

Changes

 Customer already tried to set the status of the end-dated row in CE_Bank_Branches_V to 'I'

Cause

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