I am looking to create a business event subscription for the standard business event "oracle.apps.po.rcv.rcvtxn".
This business event is fired upon performing a PO receipt, and I confirmed this by running the query below after performing a receipt:
WHERE corrid = 'APPS:oracle.apps.po.rcv.rcvtxn'
AND enq_time > SYSDATE - 1/24;
Does anyone have any sample logic for a subscription on this event? I am looking to pull out the inventory organization id (organization_id) and transaction_id value for the receipt and drop it into a custom table which will be polled by our SOA middleware platform. This will be used to drive some third party system integrations.
Greatly appreciate if anyone could point me to a example subscription on this event that I could use as a reference.
I created a sample post to have a WF to subscribe to the event you mention, the info you might need is the following:
The event key has two values separated by a hyphen, the second part being the value of the shipment_header_id from the rcv_shipment_headers table, i.e. 12345-98765.
The full document is here.