EICS - Item CFA Initial Data Seeding Polling Details For Items That Are In Deleted Status (Doc ID 2955187.1)

Last updated on JUNE 20, 2023

Applies to:

Symptoms

Item CFA initial data seeding polling details for items that are in Deleted status.

While validating the fix for Bug 35063224 : SIOCS - Item CFA initial data seeding polling details for items that are in Worksheet status

Above mentioned bug is resolved, while they now are seeing an issue that Item CFA is failing for items that are in status D on Merch while already deleted on SIOCS side. Error is following

ERROR
-----------------------
{"controlId":10269,"logMessage":"ORA-02291: integrity constraint (.) violated - parent key not found","item_id":"102550071","dataKey2":null,"dataKey3":null,"createTime":"2023-05-22T14:28:30.421074Z","createUser":SIM01_MDI}
{"controlId":10269,"logMessage":"ORA-02291: integrity constraint (.) violated - parent key not found","item_id":"102550089","dataKey2":null,"dataKey3":null,"createTime":"2023-05-22T14:28:30.421074Z","createUser":SIM01_MDI}
{"controlId":10269,"logMessage":"ORA-02291: integrity constraint (.) violated - parent key not found","item_id":"102550097","dataKey2":null,"dataKey3":null,"createTime":"2023-05-22T14:28:30.421074Z","createUser":SIM01_MDI}
{"controlId":10269,"logMessage":"ORA-02291: integrity constraint (.) violated - parent key not found","item_id":"103850163","dataKey2":null,"dataKey3":null,"createTime":"2023-05-22T14:28:30.421074Z","createUser":SIM01_MDI}
{"controlId":10269,"logMessage":"ORA-02291: integrity constraint (.) violated - parent key not found","item_id":"103850163","dataKey2":null,"dataKey3":null,"createTime":"2023-05-22T14:28:30.421074Z","createUser":SIM01_MDI}
{"controlId":10269,"logMessage":"ORA-02291: integrity constraint (.) violated - parent key not found","item_id":"103850251","dataKey2":null,"dataKey3":null,"createTime":"2023-05-22T14:28:30.421074Z","createUser":SIM01_MDI}
{"controlId":10269,"logMessage":"ORA-02291: integrity constraint (.) violated - parent key not found","item_id":"103850307","dataKey2":null,"dataKey3":null,"createTime":"2023-05-22T14:28:30.421074Z","createUser":SIM01_MDI}


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Item CFA initial data load module - Delete data
2. Run Item CFA initial data load module - Submit seed

Cause

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