Product BatchLoad - No Business Event Created for Product (Doc ID 1448869.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite - Version 3.1 and later
Information in this document applies to any platform.

Symptoms

Lead To Order with e-Business
AIA 3.1

Running the Product Batch Load process, the Business Event in e-Business WF_BPEL_Q is not created so causing for no AIA flow to be initiated.

Steps:
1) Running following procedure to create event

DECLARE
l_BATCH_SIZE NUMBER;
l_MAX_EVENTS NUMBER;
l_ERR_MSG VARCHAR2(200);
p_org_id NUMBER;
BEGIN
l_BATCH_SIZE := 1;
l_MAX_EVENTS := 1;
l_ERR_MSG := NULL;
p_org_id := 101;
EGO_EBI_ITEM_LOAD.GENERATE_EVENTS(
p_organization_id=> p_org_id,
p_batch_size => l_BATCH_SIZE,
p_max_events => l_MAX_EVENTS,
X_ERR_MSG => l_ERR_MSG
);
dbms_output.put_line(l_ERR_MSG);
END;

2) Verifying data is in EGO_EBI_ITEM_LOAD_LOG table

3) Checking WF_BPEL_Q table, there is no event created.
SELECT * FROM wf_bpel_qtab where state=0 and enq_time > trunc(sysdate)

4) Checking EM console, there is no instance initiated for BatchLoadItemEbizEventConsumer.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms