My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

Applies to:

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


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


Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT pja.job_id,
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


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

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