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

Last updated on NOVEMBER 09, 2016

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

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