Issue with RFI Supplier Integration for Multi-Contact Scenario (Doc ID 2885031.1)

Last updated on APRIL 11, 2024

Applies to:

Symptoms

For multi-contact scenario, while sending suppliers into MFCS via RFI, it is errorring out with below error in RFI supplier adapter log:

2022-02-21T23:45:21,020 [Timer-14] DEBUG BaseOracleDao - QUERY: select CATEGORY_TYPE, CATEGORY_TYPE_DESC, COMMON_ID, RETL_ID, EXT_SYSTEM_ID, EXT_SYSTEM from RFI_XREF_DVM WHERE RFI_XREF_DVM.CATEGORY_TYPE = ? [PUBLISH_EMAIL_NOTIFICATION]
2022-02-21T23:45:21,022 [Timer-14] DEBUG BaseOracleDao - QUERY: select RFI_ODI_LOGS_SEQ.nextVal from dual 2022-02-21T23:45:21,023 [Timer-14] DEBUG BaseOracleDao - EXECUTING : insert into RFI_ODI_LOGS (SEQUENCE_NO, ERROR_TYPE, RUN_DATE, CONSTRAINT_NAME, CONSTRAINT_TYPE, ERROR_ORIGIN, IS_NOTIFIED, ERROR_MESSAGE, LOG_MESSAGE) values (?, ?, ?, ?, ?, ?, ?, ?, ?)[53860][SUPPLIER_NOTIFICATION][Thu Feb 17
20:45:12 UTC 2022][null][null][RFI to RMS - Supplier Create/Update][N][Error ORA-30926: unable to get a stable set of rows in the source tables returned by program unit RMSAIASUB_SUPPLIER_SQL.INSERT_ADDRESS.sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

Steps To Recreate:
1. Create supplier parent with one site. Message type ‘suppadd’. This completed successfully.
2. Send the same supplier parent from step 1 with new supplier site. Message type ‘suppadd’. This message aborts.

Cause

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