Error "Return: 904 - ORA-00904: "A"."PROCESS_INSTANCE": invalid identifier at the step EOL_PUBLISH.PUBLISH2.Step10" when Running the 'Publish Outbound Message' Process (IN_PUB_MSG) for the ITEM_SYNC Message and the ITEM_STATUS_CHANGE Publish Rule (Doc ID 2146160.1)

Last updated on AUGUST 12, 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 'Publish Outbound Message' process (IN_PUB_MSG) (navigation: SCM Integrations, Publish Outbound Message) fails with the below error when run the for the ITEM_SYNC Message and the ITEM_STATUS_CHANGE Publish Rule.

Publishing Rule ITEM_STATUS_CHANGE for Message ITEM_SYNC (18022,62)

SQL error. Function: CreateSQL

Error Position: 448

Return: 904 - ORA-00904: "A"."PROCESS_INSTANCE": invalid identifier

Statement: select a.setid, a.inv_item_id, a.gs1_gdsn_inf_prov, a.gs1_gdsn_inprf_gln, a.country, a.gs1_gbl_prd_class, a.gs1_brandname, a.gs1_alt_itm_num_ty, a.gs1_returnabl_pack, a.gs1_fda_list_num, a.gs1_fda_mkt_auth_t, a.gs1_fda_mkt_auth_c, a.gs1_fda_prd_code, a.gs1_gmdn_code, a.gs1_mfg_date_cntrl, a.gs1_expire_dte_ctl, a.gs1_lbled_sngl_use, a.gs1_pack_sterile, a.gs1_strliz_bfr_use, a.gs1_strliz_method, a.gs1_contain_dehp from ps_gs1_cls2_in_evw a where A.PROCESS_INSTANCE = :1 ORDER BY A.SETID, A.INV_ITEM_ID

Original Statement: Select A.SETID, A.INV_ITEM_ID, A.GS1_GDSN_INF_PROV, A.GS1_GDSN_INPRF_GLN, A.COUNTRY, A.GS1_GBL_PRD_CLASS, A.GS1_BRANDNAME, A.GS1_ALT_ITM_NUM_TY, A.GS1_RETURNABL_PACK, A.GS1_FDA_LIST_NUM, A.GS1_FDA_MKT_AUTH_T, A.GS1_FDA_MKT_AUTH_C, A.GS1_FDA_PRD_CODE, A.GS1_GMDN_CODE, A.GS1_MFG_DATE_CNTRL, A.GS1_EXPIRE_DTE_CTL, A.GS1_LBLED_SNGL_USE, A.GS1_PACK_STERILE, A.GS1_STRLIZ_BFR_USE, A.GS1_STRLIZ_METHOD, A.GS1_CONTAIN_DEHP from %Table(:1) A where A.PROCESS_INSTANCE = :2 order by A.SETID, A.INV_ITEM_ID

SQL error in Exec. (2,280) EOL_PUBLISH.PUBLISH2.GBL.default.1900-01-01.Step10.OnExecute

Process 3730055 ABENDED at Step EOL_PUBLISH.PUBLISH2.Step10 (PeopleCode) -- RC = 8 (108,524).

 

Changes

Issue starts to occur after installing a PeopleSoft Image starting with the FSCM Image 9.2.010. These Images include the GS1 Healthcare initiative enhancement > Enhancement <Bug 19282358> (ENH : MAIN ALL OBJ FOR IN003 GS1 HEALTHCARE INITIATIVE).

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