My Oracle Support Banner

JBO-27122 Error When Updating Bank Account Information in Manage Payment Methods Link (Doc ID 2202292.1)

Last updated on FEBRUARY 12, 2019

Applies to:

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

Symptoms

Receiving the following error when updating any bank information under Manage Payment Methods option in the Advanced Payment page of iReceivables:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT
ExtPayersEO.EXT_PAYER_ID,
ExtPayersEO.PAYMENT_FUNCTION,
ExtPayersEO.PARTY_ID,
ExtPayersEO.ORG_TYPE,
ExtPayersEO.ORG_ID,
ExtPayersEO.CUST_ACCOUNT_ID,
ExtPayersEO.ACCT_SITE_USE_ID,
ExtPayersEO.BANK_CHARGE_BEARER_CODE,
ExtPayersEO.DIRDEB_INSTRUCTION_CODE,
hzp.party_name,
hzct.ACCOUNT_NUMBER,
hzps.party_site_name,
hr.NAME Organization,
1 HideShow


Steps to Reproduce:

Responsibility: iReceivables 2.0 Internal
Navigation
: Customer Search

  1. Select an invoice to pay, click on Advanced Payment, click on Manage Payment Methods
  2. Click on the Update icon for any bank account.

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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.