FND: Submitting Oracle Reports/XMLP Reports using Forms Personalisation

Submit a concurrent request from menu item AND EXECUTE PROCEDURE

• IF THE REPORT TYPE IS ORACLE REPORTS

1-create procedure to submit it when I called it

CREATE OR REPLACE procedure APPS.CALL_XXCSD_VEH_CHKIN(XX_INCIDENT_NUMBER IN VARCHAR2,XX_INCIDENT_NUMBER2 IN VARCHAR2,RELEASE IN VARCHAR2) AS

v_request_id VARCHAR2(100) ;

BEGIN

-- First set the environment of the user submitting the request by submitting

-- fnd_global.apps_initialize().

-- The procedure requires three parameters

-- Fnd_Global.apps_initialize(userId,responsibilityId,applicationId)

-- replace the following code with correct value as get from sql above

Fnd_Global.apps_initialize(1134,50019,512);

v_request_id := FND_REQUEST.SUBMIT_REQUEST (

'PO', -- Application short name

'XX_CUSTOM_PURCHASE_ORDER', -- Program short name

'', -- description (Not require)

'', -- start_time (start immediately)

FALSE,-- sub_request (default FALSE)

-- Next is the parameters list of ARACCPB

XX_INCIDENT_NUMBER,

XX_INCIDENT_NUMBER2,

release

);

dbms_output.put_line('Request submitted. ID = ' || v_request_id);

commit ;

exception

when others then

dbms_output.put_line('Request set submission failed - unknown error: ' || sqlerrm);

END;

2-create menu item and call the proc from it

-After selecting execute_procedure

-the argument:

='DECLARE

BEGIN

CALL_XXCSD_VEH_CHKIN('''||${item.INCIDENT_TRACKING.INCIDENT_ID.VALUE}||'''

);

END'

Note:

To get value from item from the canvas using personalization will be like this :

('''||${item.block_name.item_name.VALUE}||''')

• IF THE REPORT TYPE IS XML PUBLISHER (ADD LAYOUT TO IT)

CREATE OR REPLACE procedure APPS.CALL_XXCSD_VEH_CHKIN(XX_INCIDENT_NUMBER IN VARCHAR2) AS

v_request_id VARCHAR2(100) ;

xml_layout boolean;

BEGIN

Fnd_Global.apps_initialize(1134,50019,512);

xml_layout := FND_REQUEST.ADD_LAYOUT('CSD','XXCSD_VEH_CHKIN_T','en','US','PDF');

v_request_id := FND_REQUEST.SUBMIT_REQUEST (

'CSD', -- Application short name

'XXCSD_VEH_CHKIN', -- Program short name

'', -- description (Not require)

'', -- start_time (start immediately)

FALSE,-- sub_request (default FALSE)

-- Next is the parameters list of ARACCPB

'402'

);

dbms_output.put_line('Request submitted. ID = ' || v_request_id);

commit ;

exception

when others then

dbms_output.put_line('Request set submission failed - unknown error: ' || sqlerrm);

END;

******************end**********************