My Oracle Support Banner

R12: Error Occurs when Creating or Updating Supplier Banking Details: JBO-27122: SQL Error During Statement Preparation (Doc ID 1130023.1)

Last updated on MARCH 29, 2021

Applies to:

Oracle Payables - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Creating/updating the Supplier Banking Details errors with the following:

You have encountered an unexpected error.  Please contact the System Administrator for assistance.

Exception Details:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM
(SELECT ExtBanksEO.BANK_PARTY_ID,
ExtBanksEO.BANK_NAME, ExtBanksEO.BANK_NUMBER, ExtBanksEO.BANK_INSTITUTION_TYPE,
ExtBanksEO.BANK_NAME_ALT, ExtBanksEO.SHORT_BANK_NAME, ExtBanksEO.DESCRIPTION,
..........



Steps to reproduce the issue:
  From a Payables Manager responsibility
  Navigation path:  Supplier > Supplier
  Query for an existing Supplier
  Click on UPDATE
  Click Banking Details on left
  Click Update on one of the existing rows
  Error is thrown

 or

  From a Payables Manager responsibility
  Navigation path: Supplier > Supplier
  Click on create supplier button.
  Error occurs.

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


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