iAssets: JBO-27122: SQL error during statement preparation Error During Transfer process (Doc ID 2258707.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle iAssets - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On R12

iAsset Transfer Request Error at Select Of Approver.

 

ERROR

SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT ppf.PERSON_ID as ReceivingApproverId FROM per_people_f ppf, hr_organization_information cc, per_business_groups bg oracle.sql.CLOB@2022b332 and cc.org_information5 = '10202'
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAExcep
tion.java:1009)

Changes

 

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