This content has been marked as final. Show 5 replies
Please post the details of the application release, database version and OS.
i'm working on oracle R12 application system. i've one standard report "journals - Entry". Its output is in .pdf format. i want to get its output in excel format. So What i'll do to format it in excel. I tried to get it from navigaion " installl > viewer option ". I set parameter asPlease see these docs/links.
i. file format = pdf
ii. mime type= application/vnd.ms-excel
iii. Description = Microsoft Excel R12
But when i ran this report it show no data. (report was emplty)... Even i selected all available accounts.
Please Guide me.
Missing The 1st Payment Accounting Lines When Export To Excel [ID 1248334.1]
Web ADI Not Validating Journal Entries With Leading / Trailing Zero Before Uploading [ID 1061904.1]
My Actual question is this
" I have one user request to provide him one oracle standard report named "journal Entry" in excel format. By default this report is in .rtf format. I am working on
Oralce R12.2 system with linux os 5.5. Can you please guide me how to change the default format of rtf report into excel format. Please send me the step by step
procedure to complete this task. Shall be very thankfull to you.
Report Name: Jounral Entry
Application : General Ledger
required format: excel
In this case your tempalte format is rtf which has the option to display output in Excel, PDf, HTML and many more.
Now you want to get the output file as pdf ( not just want to be abl;e to view the output with pdf application )
So you need to set the output format of file to 'Excel'
There is a table fnd_pp_actions which has an attribute . ( attribute1 i suppose which needs to be set as 'Excel' for your requirement.
Write a procedure something like
CREATE OR REPLACE PROCEDURE get_excel_out
SET attribute1 = 'EXCEL'
WHERE request_id = fnd_global.conc_request_id;
Now call this procedure in before report trigger of your report