My Oracle Support Banner

Getting Abend at Step PO_PORECON.PX1500.PX1510 RC = 936 When Using Negative Close Or Cancel Days (Doc ID 2574860.1)

Last updated on AUGUST 08, 2019

Applies to:

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

Symptoms



ISSUE
---------------
When setting Close Days = -10 and Cancel Days = -5 on the Purchase Order Definition (Setup Financials/Supply Chain 0 Business Unit Related -> Purchasing -> Purchasing Options) and then running PO CLOSE, customer is getting an error.

ERROR
---------------
-- 14:58:10.108 Process 2299212 ABENDED at Step PO_PORECON.PX1500.PX1510 (Action SQL) -- RC = 936
ROLLBACK
/
-- 14:58:10.118 SQL Error: ORA-00936: missing expression

STEPS
---------------
1) Add negative days to Close Days and Cancel Days
2) Run PO Close

See replication steps here.

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.