Home » Applications » Oracle Fusion Apps & E-Business Suite » Concurrent programm request error
Concurrent programm request error [message #204148] Sat, 18 November 2006 03:56
sauami
Messages: 54
Registered: October 2005
Location: india
Member
Dear Sir,

While executing below mentioned concurrent programm i got below mention error., kindly let me know how to resolve the bug.

Thanks,
Saurabh
Procedure is:
CREATE OR REPLACE PROCEDURE EEX_RELEASE_CUSTOM_WAIT_PRC
(retcode OUT VARCHAR2,
errbuf OUT VARCHAR2)
AS

CURSOR cur_item_key IS
SELECT oel.Global_attribute5
FROM wsh_delivery_details wdd,
oe_order_lines_all oel,
wsh_new_deliveries wnd,
wsh_delivery_assignments wda,
wsh_delivery_legs wdl
WHERE wda.delivery_detail_id=wdd.delivery_detail_id
and wda.delivery_id=wnd.delivery_id
and wnd.delivery_id=wdl.delivery_id
AND oel.line_id = wdd.source_line_id
AND oel.Global_attribute5 IS NOT NULL
AND wdd.inv_interfaced_flag = 'Y'
AND wdd.oe_interfaced_flag = 'Y'
AND wdl.booking_number is not null
AND oel.line_id=nvl(null,oel.line_id)
AND oel.Global_attribute5 <> 'RELEASED';


Lv_activity_name VARCHAR2(100);
Ln_activity_id NUMBER;
lc_activity_status VARCHAR2(100);
Ln_line_id NUMBER;

BEGIN

--Loop for all records

FOR cur_item_key_rec IN cur_item_key
LOOP

Lv_activity_name := 'WAIT_FOR_INV_INTERFACE';

Ln_activity_id := WF_ENGINE.GetItemAttrNumber
(Itemtype => 'OEOL',
Itemkey => TO_CHAR (cur_item_key_rec.Global_attribute5),
Aname => Lv_activity_name);



BEGIN
SELECT activity_status
INTO lc_activity_status
FROM wf_item_activity_statuses wias
WHERE wias.item_type = 'OEOL'
AND wias.item_key = TO_CHAR (cur_item_key_rec.Global_attribute5)
AND wias.process_activity = Ln_activity_id;
EXCEPTION
WHEN NO_DATA_FOUND THEN
lc_activity_status := NULL;
WHEN OTHERS THEN
lc_activity_status := NULL;
END;



IF (lc_activity_status != 'NOT_REACHED'
OR lc_activity_status != 'COMPLETE'
OR lc_activity_status != 'ERROR'
OR lc_activity_status IS NOT NULL)
THEN

WF_ENGINE.COMPLETEACTIVITY(
itemtype=>'OEOL',
itemkey=> cur_item_key_rec.Global_attribute5,
activity=>'EEX_WAIT_INV_INTERFACE_PRC',
result=>'COMPLETE');


END IF;



--Update attribute5 of oe_order_lines_all to ¿RELEASED¿


UPDATE oe_order_lines_all
SET Global_attribute5 = 'RELEASED'
WHERE line_id = TO_CHAR (cur_item_key_rec.Global_attribute5) ;

COMMIT;

END LOOP ;
END;
/
-------------------

Error Log:
--------------
ORACLE error 20002 in FDPSTP

Cause: FDPSTP failed due to ORA-20002: 3133: Activity instance 'EEX_WAIT_INV_INTERFACE_PRC' is not a notified activity for item 'OEOL/7136093'.
ORA-06512: at "APPS.WF_ENGINE", line 5267
ORA-06512: at "APPS.EEX
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+


Executing request completion options...


Finished executing request completion options.



+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 18-NOV-2006 15:13:07

+---------------------------------------------------------------------------+
Previous Topic: How to set org_id in apps
Next Topic: Guidance for Oracle Apps Finance (Functional) Training
Goto Forum:
  


Current Time: Sun Dec 04 06:20:45 CST 2016

Total time taken to generate the page: 0.07856 seconds