My Oracle Support Banner

eS: EM_ENABLE_BU Fails When There Are More Than 3 Suppliers In The Run Control (Doc ID 2689803.1)

Last updated on JULY 20, 2020

Applies to:

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

Symptoms

EM_ENABLE_BU fails when there more than 3 suppliers in the run control

ERROR:

The process fails, with a SQL error as shown.

ile: e:\pt85604y-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 373 Return: 920 - ORA-00920: invalid relational operator Failed SQL stmt: INSERT INTO PS_EM_VNDREG_TMP4 (PROCESS_INSTANCE, SETID, VENDOR_ID) SELECT 143853, A .SETID, A.VENDOR_ID FROM PS_VENDOR A WHERE A.VENDOR_STATUS = 'A' AND (A.SETID = 'XXXX' AND A.VEND OR_ID = 'XXXXX') OR(A.SETID = 'XXXX' AND A.VENDOR_ID = 'XXXXXXX') OR(A.SETID = 'XXXX' AND A.VENDOR_ID = 'XXXXXXXXXX') OR(A.SETID = 'XXXX' AND A.VENDOR_ID = 'XXXXXXXX') OR(A.SETID = 'XXXX' AND A.VENDOR_I


STEPS:

1. Run Enable Buyer Direct Model with at least 10 supplier in the run control.



Changes

 

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
Changes
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.