Try in the following way.
Populate the column : GROUP_ID with RCV_INTERFACE_GROUPS_S.NEXTVAL in interface table : RCV_HEADERS_INTERFACE
Populate the column : GROUP_ID with RCV_INTERFACE_GROUPS_S.CURRVAL in interface table : RCV_TRANSACTIONS_INTERFACE
Store the value of sequence : RCV_INTERFACE_GROUPS_S into variable : V_GROUP_ID using :
SELECT rcv_interface_groups_s.CURRVAL INTO V_GROUP_ID FROM DUAL;
when you run the concurrent Prorgram : Receiving Transaction Processor , pass the parameter : Group Id (V_group_id) in the following way.
v_request_id := FND_REQUEST.SUBMIT_REQUEST
application => 'PO',
program => 'RVCTP',
description => 'RECEIVING TRANSACTION PROCESSOR FOR BAR CODE SYSTEM',
start_time => SYSDATE,
sub_request => FALSE,
argument1 => 'BATCH',
argument2 => v_group_id
Thank you for your reply.
By the way, I've did the following and run the Receiving Transaction Processor. Status remain "Error"
Or pls advise if I have to do something else?
You may find the error message in the PO_INTERFACE_ERRORS table to understand the root cause better.
Sent from my iPhone
I don't know why the error message in PO_INTERFACE_ERRORS is still the same as before
Error: The GROUP_ID specified is invalid. The value specified (1525575) does not match the expected value (1525572).