EeS: Master Agreement Process EM_MG_CREATE Abends at Step EM_MG_CREATE.UPDATE.STEP07
(Doc ID 2899332.1)
Last updated on DECEMBER 21, 2022
Applies to:
PeopleSoft Enterprise FIN eSettlements - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
EM_MG_CREATE went to no success - failed at ABENDED at Step EM_MG_CREATE.UPDATE.Step07
ERROR
Invalid column name 'SETID'. [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180 Failed SQL stmt: INSERT INTO PS_EM_AGREE_TAO4 (PROCESS_INSTANCE, SETID, VENDOR_SETID, VENDOR_ID, VND R_LOC, MATCH_OPT, MATCH_CNTRL_ID, EM_STD_VCH_FLG, EM_SUPPLIER_REF, EM_CASH_COL_NOT, EM_CC_LATEDAYS, EM_CC_REMINDER, EM_READY_FOR_REV, EM_AGREE_BUYER, EM_AGREE_SELLER, EM_CUSTOMER_REF, EM_EXPOSE_CFS_FL G, EM_FACTOR_FLAG, EM_FACTOR_ID, REMIT_LOC, EM_BUYER_COMMENTS, EM_SELLER_COMMENTS, EM_PYMNT_TERMS_OP.
STEPS
1. Pick any Master Agreement ID from the below navigation
Main Menu > eSettlements > Buyer Information > Master Agreements
2. Click on Maintain Supplier Agreement
3. Suppliers without Agreement - Click the checkbox on Create Agreements as Accepted. Choose the supplier and then click on the right arrow to select
4. Then click on the Process Pending Updates
5. Process EM_MG_CREATE went to no success - failed at ABENDED at Step EM_MG_CREATE.UPDATE.Step07
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 |