My Oracle Support Banner

VWP Error: GETTING JBO-27122 When Opening Visits From Visit Work Package. (Doc ID 1952157.1)

Last updated on APRIL 09, 2018

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.1.3 and later
Information in this document applies to any platform.
CreateUpdateVisitVO.xml

Symptoms

When trying to Open Visits, the below mentioned error is displayed. (Note: This is not replicable continously.)

ERROR
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT VisitEO.ACTUAL_PRICE, VisitEO.ANY_TASK_CHG_FLAG, VisitEO.ASSO_PRIMARY_VISIT_ID, VisitEO.ATTRIBUTE1, VisitEO.ATTRIBUTE10, VisitEO.ATTRIBUTE11, VisitEO.ATTRIBUTE12, VisitEO.ATTRIBUTE13, VisitEO.ATTRIBUTE14, VisitEO.ATTRIBUTE15, VisitEO.ATTRIBUTE2, VisitEO.ATTRIBUTE3, VisitEO.ATTRIBUTE4, VisitEO.ATTRIBUTE5, VisitEO.ATTRIBUTE6, VisitEO.ATTRIBUTE7, VisitEO.ATTRIBUTE8, VisitEO.ATTRIBUTE9, VisitEO.ATTRIBUTE_CATEGORY, VisitEO.CLOSE_DATE_TIME, VisitEO.CREATED_BY, VisitEO.CREATION_DATE, VisitEO.DEPARTMENT_ID, VisitEO.DESCRIPTION, VisitEO.ESTIMATED_PRICE, VisitEO.INVENTORY_ITEM_ID, VisitEO.ITEM_INSTANCE_ID, VisitEO.ITEM_ORGANIZATION_ID, VisitEO.LAST_UPDATED_BY, VisitEO.LAST_UPDATE_DATE, VisitEO.LAST_UPDATE_LOGIN, VisitEO.OBJECT_VERSION_NUMBER, VisitEO.ORGANIZATION_ID, VisitEO.OUTSIDE_PARTY_FLAG, VisitEO.OUT_OF_SYNC_FLAG, VisitEO.PRICE_LIST_ID, VisitEO.PRIORITY_CODE, VisitEO.PROJECT_FLAG, VisitEO.PROJECT_ID, VisitEO.PROJECT_TEMPLATE_ID, VisitEO.SCHEDULE_DESIGNATOR, VisitEO.SERVICE_REQUEST_ID, VisitEO.SIMULATION_DELETE_FLAG, VisitEO.SIMULATION_PLAN_ID, VisitEO.SPACE_CATEGORY_CODE, VisitEO.START_DATE_TIME, VisitEO.STATUS_CODE, VisitEO.TEMPLATE_FLAG, VisitEO.UNIT_SCHEDULE_ID, VisitEO.VISIT_ID, VisitEO.VISIT_NAME, VisitEO.VISIT_NUMBER,


STEPS
Complex MRO User > Planning > Visit Work Package > Query the visit > Click on the visit number link .. Get the above mentioned JBO-27122 error

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
References


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