1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Calling one rdf file from another rdf -oracle reports 6i

Discussion in 'Oracle Forms and Reports' started by sneha.bharti, Sep 6, 2016.

  1. sneha.bharti

    sneha.bharti Active Member

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Lagos
    Hi Everyone,

    Greetings of the day !!
    I need urgent help in calling one oracle report from another oracle report , the version i am using is 6i.
    Can anyone suggest the ways of doing this.

    Thanks,
    Sneha
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
  3. sneha.bharti

    sneha.bharti Active Member

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Lagos
    Thanks for your reply.
    The thing is I need to call an oracle report from another oracle report.
    There is no form involved in it.
    I have used srw.run_report but somehow it's not able to print the other rdf ,although able to save in pdf but in printing report progress shows not responding.

    Please suggest,
    Thanks
     
    Last edited: Sep 7, 2016
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Call a batch file instead? Or, if in an EBS environment, call the concurrent process to kick off the report.
     
  5. sneha.bharti

    sneha.bharti Active Member

    Messages:
    32
    Likes Received:
    1
    Trophy Points:
    90
    Location:
    Lagos
    Hello,
    Thanks for responding.
    We work in non EBS environment, So Can you please share any batch file example relevant to this.

    I Appreciate your help.
    Thank you
     
  6. raovk13

    raovk13 Premium Member

    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    100
    some thing like...
    function AfterReport return boolean is
    x_req_id number;
    x_img_req_id number;
    v_wait BOOLEAN;
    v_phase VARCHAR2(255);
    v_status VARCHAR2(255);
    v_dev_phase VARCHAR2(255);
    v_dev_status VARCHAR2(255);
    v_message VARCHAR2(1000);
    BEGIN
    SRW.MESSAGE('00000','After Report ');
    if nvl:)CS_NUM_INVOICES,0) > 0 --AND NVL:)P_SUBMIT_BURST,'XXX') <> 'NOPRINT'
    THEN
    x_req_id := FND_REQUEST.SUBMIT_REQUEST('XDO',
    'XDOBURSTREP',
    'XML Publisher Report Bursting Program',
    sysdate,
    FALSE,
    :p_conc_request_id,
    'Yes',
    '','','','','','','','','','','','','','','','','','','','','','','',
    '','','','','','','','','','','','','','','','','','','','','','','','','',
    '','','','','','','','','','','','','','','','','','','','','','','','','',
    '','','','','','','','','','','','','','','','','','','','','','','','',''
    );

    COMMIT;

    IF x_req_id <> 0 THEN
    v_wait := fnd_concurrent.wait_for_request(request_id => x_req_id
    ,INTERVAL => 30
    ,max_wait => 1800
    ,phase => v_phase
    ,status => v_status
    ,dev_phase => v_dev_phase
    ,dev_status => v_dev_status
    ,MESSAGE => v_message
    );
    srw.message(1,' RequestID '||x_req_id||' Has been submitted for Email/Print');
    END IF;
    IF v_dev_phase = 'COMPLETE' AND v_dev_status <> 'ERROR'
    THEN
    x_img_req_id := FND_REQUEST.SUBMIT_REQUEST('AAA',
    'AAA_AR_INV_XML_PDF_ATTACH',
    'AAA AR Invoice Attachment Program',
    sysdate,
    FALSE,
    nvl:)P_FILE_DIR,'/export/home/osupp/') ,--'/u01/oracle/crdevcomn/java/oracle/apps/xdo/oa/cp/',
    :p_conc_request_id,'','','','','','','','','','','','','','','','','','',
    '','','','','','','','','','','','','','','','','','','','',
    '','','','','','','','','','','','','','','','','','','','',
    '','','','','','','','','','','','','','','','','','','','',
    '','','','','','','','','','','','','','','','','','','','');

    COMMIT;
    END IF ;
    srw.message(1,' RequestID '||x_img_req_id||' Has been submitted for Invoice Attachment Program');

    end if;

    SRW.USER_EXIT('FND SRWEXIT');
    RETURN (TRUE);
    END;

    Regards,