For the ‘WIP Material Requirements’ and ‘WIP Material Requirements – Delete Material’ templates, More4apps uses the following tables:
· WIP_JOB_SCHEDULE_INTERFACE for Discrete Job and
· WIP_JOB_DTLS_INTERFACE for Material details.
Because of the way Oracle has structured their tables and the table record relationship, when any of the material transactions fail, the loader will show the error message next to all the materials that were uploaded for a WIP Job.
In the example below, row 65 is the only one with the incorrect data, the rest of the uploaded rows 60 - 62 are correct.
The concurrent request does not process this transaction successfully and it provides the error shown. When the loader retrieves the error information, it cannot differentiate which record the error came from, therefore the error message is printed against all rows.
