POXMLP Errors with Option 'Exclude POs tied to Authored Contract Documents'

(Doc ID 2313521.1)

Last updated on OCTOBER 02, 2017

Applies to:

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

Symptoms

When PO Dispatch is run with option 'Exclude POs tied to Authored Contract Documents' selected. Report goes to No Success.



Steps to Reproduce the Issue:

1. Navigate to the report, Main Menu > Purchase > Purchase Orders > Dispatch POs

2. Add a new control id

3. Select the below run parameters,

a. Select Business Unit from and To

b. Select from date and through date

c. Select any status to include

d. Select any dispatch methods to include

e. In Miscellaneous Options, select `Exclude POs tied to Authored Contract Documents'

f. Number of Copies '1'

g. Sort by Line Number

4. Save and Run

5. Report goes to No Success.

Error:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 1440 Return: 923 - ORA-00923: FROM keyword not found where expected

Failed SQL stmt: INSERT INTO PS_PODISPALL_TAO18 (PROCESS_INSTANCE ,BUSINESS_UNIT , PO_ID , LANGUAGE_CD , TMPLDEFN_ID , DISP_METHOD ,

VENDOR_SETID , VENDOR_ID , VNDR_LOC , CNTCT_SEQ_NUM , WO_FLAG , VALIDATE_FLG , MESSAGE_SET_NBR ,MESSAGE_NBR ,MESSAGE_PARM ,MESSAGE_PARM1 ,MESSAGE_PARM2 ,

MESSAGE_PARM3) SELECT DISTINCT 48062856 , NEWA.BUSINESS_UNIT , NEWA.PO_ID , '' , NEWA.TMPLDEFN_ID , NEWA.DISP_METHOD , NEWA.VENDOR_SETID , NEWA.VENDOR_ID

, NEWA.VNDR_LOC , NEWA.CNTCT_SEQ_NUM , 'N' , 'Y' , 0 , 0 , ' ' , ' ' , ' ' ,' ' FROM PS_PO_HDR NEWA , PS_PO_LINE NEWB WHERE NEWA.BUSINESS_UNIT =

NEWB.BUSINESS_UNIT AND NEWA.PO_ID = NEWB.PO_ID AND ((NEWA.BUSINESS_UNIT >='26012') AND (NEWA.BUSINESS_UNIT <= '26012')) AND NEWA.PO_DT >=

TO_DATE('2016-01-01','YYYY-MM-DD') AND NEWA.PO_DT <=TO_DATE('2016-01-10','YYYY-MM-DD') AND NEWA.PO_STATUS IN ('D','A') AND

NEWA.DISP_METHOD IN ('EDX','EML','FAX','PHN','PRN') AND 0 = (SELECT COUNT(*) FROM PS_PO_LINE_DISTRIB DIST WHERE DIST.PO_ID = NEWA.PO_ID AND

DIST.BUSINESS_UNIT = NEWA.BUSINESS_UNIT AND DIST.CHARTFIELD_STATUS <> 'V') AND NEWA.HOLD_STATUS = 'N' AND NEWA.DISP_ACTION = 'Y' AND 0 = (SELECT

COUNT(*) from PS_PO_LINE_SHIP LNSP WHERE LNSP.PO_ID = NEWA.PO_ID and LNSP.BUSINESS_UNIT = NEWA.BUSINESS_UNIT and LNSP.BAL_STATUS = 'O') AND

NEWA.BUDGET_HDR_STATUS = 'V' AND NEWA.BUDGET_HDR_STS_NP = 'V' AND NEWA.DOC_TOL_HDR_STATUS = 'V' AND NEWA.MID_ROLL_STATUS = 'N' AND

NEWA.DISP_ACTION = 'Y' AND NOT EXISTS (SELECT ''X'' FROM PS_CS_DOC_HDR DOC, PS_CS_DOC_PUR_KEYS PKEY WHERE DOC.CS_DOC_ID = PKEY.CS_DOC_ID AND

PKEY.BUSINESS_UNIT = NEWA.BUSINESS_UNIT AND PKEY.PO_ID = NEWA.PO_ID) 

Process 48062856 ABENDED at Step PO_DISPATCH.GETPOS.Step03 (SQL) -- RC = 923 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

 

Changes

 

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