Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Submitting concurrent program through trigger

edited May 1, 2024 1:18PM in Core Concurrent Processing - EBS (MOSC) 2 commentsAnswered

I am trying to submit a concurrent program through trigger, but it's not getting submitted.

Below is my code:

create or replace trigger xx_notification
AFTER UPDATE OF STATUS_CODE on APPS.fnd_concurrent_requests
for EACH ROW
when (new.concurrent_program_id = 168366)

declare

v_request_id NUMBER := 0;

result BOOLEAN;

Begin

result := fnd_request.set_mode(TRUE);
fnd_profile.put('RESP_ID', 20420);
fnd_profile.put('RESP_APPL_ID', 1);
fnd_profile.put('USER_ID', 0);

--fnd_global.apps_initialize(fnd_global.user_id, fnd_global.resp_id, fnd_global.resp_appl_id);


v_request_id := fnd_request.submit_request(application => 'XX___',

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center