R12: IBY: PPR Build Finished In Error IBY_DOC_INV_CROSSBORDER_PMT
(Doc ID 2758830.1)
Last updated on DECEMBER 23, 2022
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
PPR Finished in error at the Build stage with below error:
SQLERRM: User-Defined Exception
Build program error: Exception occured when attempting to validate the documents payable of the provided payment service request.
Build program error: Exception occured when attempting to validate the documents payable of the provided payment service request.
Build concurrent Log shows the following Errors.
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:Getting the data from DB For Ext Bank Account Id: [##EBA##]
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:Getting the data from Cache For Int Bank Account Id: [##IBA##]
...
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Failing document id: 3554635. The payee bank account is set up to allow domestic payments only. The internal bank account used to pay this document will result in an international payment to this payee bank account.
IBY_VALIDATIONSETS_PUB.checkIfDocFailed:
...
IBY_BUILD_UTILS_PKG.createErrorRecord:
Transaction type: DOCUMENT_PAYABLE
Transaction status: REJECTED
Error code based on input param: IBY_DOC_INV_CROSSBORDER_PMT
Error message derived from error code: The payee bank account is set up to allow domestic payments only. The internal bank account used to pay this document will result in an international payment to this payee bank account.
...
Payment profile is compatible with payment format for document id: 3554635
Ext Bank Acct Id field is: 47800 for the assignments
Payee Party Id field is: 5939765 for the assignments
Supplier Site Id field is: 2279523 for the assignments
Party Site Id field is: 4654014 for the assignments
Org Id field is: 1869 for the assignments
Org Type field is: OPERATING_UNIT for the assignments
Supplier / External Bankaccount is attached is valid for document id: 3554635
Fetching the value from Cache Structure l_int_bank_accts_tbl EUR$OPERATING_UNIT$1869$05-06-20$30003
Internal bank acct is valid for document id: 3554635
External payee id is valid for document id: 3554635
Failing document id: 3554635. The payee bank account is set up to allow domestic payments only. The internal bank account used to pay this document will result in an international payment to this payee bank account.
...
iby.scheduler.BuildPayments.runProgram()
BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
Error Message:BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
An error occurred. Roll back any changes.
...
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets:Getting the data from Cache For Int Bank Account Id: [##IBA##]
...
IBY_VALIDATIONSETS_PUB.applyDocumentValidationSets: Failing document id: 3554635. The payee bank account is set up to allow domestic payments only. The internal bank account used to pay this document will result in an international payment to this payee bank account.
IBY_VALIDATIONSETS_PUB.checkIfDocFailed:
...
IBY_BUILD_UTILS_PKG.createErrorRecord:
Transaction type: DOCUMENT_PAYABLE
Transaction status: REJECTED
Error code based on input param: IBY_DOC_INV_CROSSBORDER_PMT
Error message derived from error code: The payee bank account is set up to allow domestic payments only. The internal bank account used to pay this document will result in an international payment to this payee bank account.
...
Payment profile is compatible with payment format for document id: 3554635
Ext Bank Acct Id field is: 47800 for the assignments
Payee Party Id field is: 5939765 for the assignments
Supplier Site Id field is: 2279523 for the assignments
Party Site Id field is: 4654014 for the assignments
Org Id field is: 1869 for the assignments
Org Type field is: OPERATING_UNIT for the assignments
Supplier / External Bankaccount is attached is valid for document id: 3554635
Fetching the value from Cache Structure l_int_bank_accts_tbl EUR$OPERATING_UNIT$1869$05-06-20$30003
Internal bank acct is valid for document id: 3554635
External payee id is valid for document id: 3554635
Failing document id: 3554635. The payee bank account is set up to allow domestic payments only. The internal bank account used to pay this document will result in an international payment to this payee bank account.
...
iby.scheduler.BuildPayments.runProgram()
BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
Error Message:BUILD PROGRAM ERROR - CANNOT VALIDATE DOCUMENTS
An error occurred. Roll back any changes.
...
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 |
| References |