Oracle Reports (MOSC)

MOSC Banner

FND_REQUEST.SUBMIT_REQUEST('XDO','XDOREPPB'

edited Mar 24, 2012 9:35PM in Oracle Reports (MOSC) 3 comments
Hi Experts,

I am making changes in the Audit Trail Report, our requirement is to generate this report in Excel. I have created the template in word attache the template with the report, changed the output type of the report to "XML".

I have written an sql package and calling it in the After Report trigger in the FNDATREP.rdf report ,

v_req_id := trk_xmlp_pkg.do_submit('SHAWFNDATREP',:P_conc_request_id);

Package is,

CREATE OR REPLACE package body APPS.TRK_XMLP_PKG ASfunction do_submit

( p_code in varchar2, p_request_id in number) return number

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