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.
EM_ENABLE_BU fails when there more than 3 suppliers in the run control
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
1. Run Enable Buyer Direct Model with at least 10 supplier in the run control.
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