Error "ORA-00904: "A"."PROCESS_INSTANCE": invalid identifier Statement" when Running the 'Item Loader' Process (IN_ITMLOAD) for the Item Load Type of 'Item PriceList' (Doc ID 2051129.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The 'Item Loader' process (IN_ITMLOAD) (navigation: SCM Integrations, Process Transactions, Items, Item Loader) goes to error when run for the Item Load Type of 'Item PriceList' in order to load Price Lists from a flat file:

SQL error. Function: CreateSQL Error Position: 436 Return: 904 - ORA-00904: "A"."PROCESS_INSTANCE": invalid identifier Statement: select a.setid, a.inv_item_id, a.unit_measure_std, a.mfg_id, a.mfg_itm_id, a.unit_of_ measure, a.upn_type_cd, a.upn_id, a.gs1_primary_idntyp, a.gs1_base_unit, a.gs1_gtin_chld_quom, a.gs1 _net_cont_u_qty, a.gs1_net_unit_q_uom, a.gs1_parent_gtin, a.gs1_consumer_unit, a.gs1_child_gtin, a.g s1_gtin_child_qty, a.gs1_invoice_unit, a.gs1_shipping_unit, a.gs1_variable_measu, a.gs1_orderable, a .gs1_bar_code_type from ps_gs1_upn_att_evw a where A.PROCESS_INSTANCE = :1 ORDER BY A.SETID, A.INV_I TEM_ID, A.UNIT_MEASURE_STD, A.MFG_ID, A.MFG_ITM_ID, A.UNIT_OF_MEASURE, A.UPN_TYPE_CD, A.UPN_ID

SQL error in Exec. (2,280)
EOL_PUBLISH.PUBLISH2...

 

Changes

The issue occurs after installing the fix for the <Bug 19282358> - ENH : MAIN ALL OBJ FOR IN003 GS1 HEALTHCARE INITIATIVE. The fix is incorporated in a PeopleSoft Image for FSCM 9.2 starting with Image 9.2.010.

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