Implications of populating RA_INTERFACE_ERRORS_ALL table through custom scripts
Before importing the interface lines, we would like to simulate a situation as if Autoinvoice raised an error when processing these interface lines.
Here is what we are planning to do.
1. In RA_INTERFACE_LINES_ALL table, update the STATUS to 'P'.
2. Derive next sequence value from RA_CUSTOMER_TRX_S sequence and populate RA_INTERFACE_LINES_ALL.INTERFACE_LINE_ID.
3. Insert a new record in RA_INTERFACE_ERRORS_ALL with an Error Message and populate the INTERFACE_LINE_ID here with the one generated in #2 above.
With the above, our custom requirement is met, that is Autoinvoice did not process this record.
Here is what we are planning to do.
1. In RA_INTERFACE_LINES_ALL table, update the STATUS to 'P'.
2. Derive next sequence value from RA_CUSTOMER_TRX_S sequence and populate RA_INTERFACE_LINES_ALL.INTERFACE_LINE_ID.
3. Insert a new record in RA_INTERFACE_ERRORS_ALL with an Error Message and populate the INTERFACE_LINE_ID here with the one generated in #2 above.
With the above, our custom requirement is met, that is Autoinvoice did not process this record.
0