Unexpected Errors Appearing In IProcurement Contractor Request JBO-27122, ORA-00904, "PJA"."SHOPPING_CATEGORY_ID" Invalid Identifier (Doc ID 2143618.1)

Last updated on MAY 31, 2016

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a Contractor Request an Selecting a Job the following error occurs.

Error

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT pja.job_id,
  pja.category_id,
  pja.shopping_Category_id,
  icatl.attribute_name
FROM po_job_associations_b pja, ICX_CAT_ATTRIBUTES_TL icatl
WHERE job_id = :1
AND category_id = :2
.
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "PJA"."SHOPPING_CATEGORY_ID": invalid identifier

Steps to reproduce

1. Sign on to Application
2. Select Responsibility: iProcurement
3. Navigation: iProcurement - Home Page > Shop Tab
4. Sub Menu: Contractor Request > Try to Create a Contractor Request >
5. Select: Type: Rate Based Temporary Labor
7. Select: Job: % > "Account/Relationship Management Administrator-B2"
8. Receive 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