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

Last updated on SEPTEMBER 06, 2016

Applies to:

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

Symptoms

On : 12.2.3 version, Component Maintenance

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

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