You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!