How to call Autoinvoice Import Program (Program short name is RAXTRX) using FND_REQUEST.SUBMIT_REQUEST API
Auto invoice Import Program takes the following parameters :
argv[0] program name
argv[1] parallel module name [MAIN|PU?]
argv[2] running mode [V|T|P]
argv[3] batch source id
argv[4] batch source name
argv[5] default date
argv[6] concatenated transaction flexfield attribute value
argv[7] transaction type id
argv[8] low bill to customer number
argv[9] high bill to customer number
argv[10] low bill to customer name
argv[11] high bill to customer name
argv[12] low gl date
argv[13] high gl date
argv[14] low ship date
argv[15] high ship date
argv[16] low transaction number
argv[17] high transaction number
argv[18] low sales order
argv[19] high sales order
argv[20] low invoice date
argv[21] high invoice date
argv[22] low ship to customer number
argv[23] high ship to customer number
argv[24] low ship to customer name
argv[25] high ship to customer name
argv[26] Call RAXTRX from RAXMTR flag
argv[27] Base Due Date on invoice date flag
argv[28] Minimum Due Date offset from trx date
argv[29] Org_id
First, find out user_id and RESPONSIBILITY_ID through which you will submit the program to set the context :
SELECT USER_ID,RESPONSIBILITY_ID,RESPONSIBILITY_APPLICATION_ID,
SECURITY_GROUP_ID
FROM FND_USER_RESP_GROUPS
WHERE USER_ID = (SELECT USER_ID
FROM FND_USER
WHERE USER_NAME = '&user_name')
AND RESPONSIBILITY_ID = (SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_VL
WHERE RESPONSIBILITY_NAME = '&resp_name');
Using above query to get User ID, Resp Id and Application ID to pass in below code,
DECLARE
l_request_id NUMBER;
BEGIN
Fnd_Global.apps_initialize(userId,responsibilityId,applicationId)
-- replace the following code with correct value as get from sql above
Fnd_Global.apps_initialize(10178,50559,222);
l_request_id :=
fnd_request.submit_request
(application => 'AR',
program => 'RAXTRX',
description => NULL,
start_time => NULL,-- To start immediately
sub_request => FALSE,
argument1 => 'MAIN',
argument2 => 'T',
argument3 => '1228',--batch_source_id
argument4 => 'LEGACY', --batch_source_name
argument5 => '2010/06/11 00:00:00', -- should be in format -- RR-MON-DD
argument6 => '',
argument7 => '',
argument8 => '',
argument9 => '',
argument10 => '',
argument11 => '',
argument12 => '',
argument13 => '',
argument14 => '',
argument15 => '',
argument16 => '',
argument17 => '',
argument18 => '63737', --sales_order low
argument19 => '63737', --sales_order high
argument20 => '',
argument21 => '',
argument22 => '',
argument23 => '',
argument24 => '',
argument25 => '',
argument26 => 'N',
argument27 => 'Y',
argument28 => '',
argument29 => '204', -- org_id
argument30 => chr(0) -- end with chr(0)as end of parameters
);
dbms_output.put_line(l_request_id);
END;
Post a Comment
Post a Comment