rest api for ra_interface_lines_all
Summary:
I've raised the SR for API for RA_INTERFACE_LINE_ALL, RA_INTERFACE_ERRORS_ALL out of these i got the API for lines all interface table but there as well we don't have any column which will uniquely identify the records for that specific batch let say load request id or other columns like this.
below is the query we are using for reconciliation purpose do we have any other way to automate this without using BIP.
select
rila.INTERFACE_LINE_ATTRIBUTE1 header_id,
rila.INTERFACE_LINE_ATTRIBUTE2 line_id,
listagg(riea.message_text,';') message_text,
Tagged:
0