My Oracle Support Banner

POXMLP Errors with Option 'Exclude POs tied to Authored Contract Documents' (Doc ID 2313521.1)

Last updated on FEBRUARY 05, 2019

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 , A.BUSINESS_UNIT , A.PO_ID , '' , A.TMPLDEFN_ID , A.DISP_METHOD , A.VENDOR_SETID , A.VENDOR_ID

, A.VNDR_LOC , A.CNTCT_SEQ_NUM , 'N' , 'Y' , 0 , 0 , ' ' , ' ' , ' ' ,' ' FROM PS_PO_HDR A , PS_PO_LINE B WHERE A.BUSINESS_UNIT =

B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND ((A.BUSINESS_UNIT >='XXXXX') AND A.BUSINESS_UNIT <= 'XXXXX')) AND A.PO_DT >=

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

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

DIST.BUSINESS_UNIT = A.BUSINESS_UNIT AND DIST.CHARTFIELD_STATUS <> 'V') AND A.HOLD_STATUS = 'N' AND A.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

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

A.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 = A.BUSINESS_UNIT AND PKEY.PO_ID = A.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

 

Cause

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
Symptoms
Cause
Solution
References


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