|
|
|
|
|
|
| Re: Output CSV format file for aging report in AR [message #178958 is a reply to message #178942] |
Fri, 23 June 2006 10:18   |
agostino_neto
Messages: 180
Registered: July 2005
|
Senior Member |
|
|
Once the results are in a custom table (you will to do insert in the custom report), you can call another concurrent program (type sql – for dbms_output or pl/sql – for FND_FILE) in the After Report Trigger.
If you want you can also create a request set (this solution supposes you are using two concurrent programs to accomplish this task).
If want to use only reports, you can always concatenate alls columns of the custom table including ';' (using a formula for example) and print the result in the layout.
That's only a suggestion. You can surely accomplish this work differently.
|
|
|
|
|
|
| Re: Output CSV format file for aging report in AR [message #179044 is a reply to message #178995] |
Sat, 24 June 2006 03:29 |
agostino_neto
Messages: 180
Registered: July 2005
|
Senior Member |
|
|
I think it is better to do it this way rather than rewriting all the codes(it could not be simple).
For insert, you can do it in the format trigger of the appropriate repeating frame. You should use concurrent_request_id (insert it in the first program and select only rows which have the correct request_id on the second program) in other to have the good results if two person or more launch the request at the same time (or define appropriate incompatibility to avoid errors – the first solution with request_id is better).
|
|
|
|
| Re: Output CSV format file for aging report in AR [message #179196 is a reply to message #178876] |
Mon, 26 June 2006 05:27 |
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
|
Senior Member |
|
|
If:-
1.) you do not want to recode the report, and
2.) you want to be able to have all of the reports available in CSV format and
3.) you do not mind having the page headings in your CSV file,
then you could consider opening the report output in a viewer other than the standard report viewer or your browser.
Log in to MetaLink and search for INSTALL and "VIEWER OPTIONS" which will display several articles, my favourite (so far) being Note:178133.1 However, there is a small error in this article, where there are two lines that both say:
Text application/vnd.msexcel 11i
when they should say
Text application/vnd.ms-excel 11i
the difference being the hyphen (-).
I said that my favourite (so far) was Note:178133.1 but I haven't yet had time to read Note:316752.1 properly, except to find that
1.) it says that it applies to 11.5.10 and
2.) it looks worth reading
There is a certain amount of information in the System Administrator's Guide, but I think that it is a bit sketchy, and the articles on MetaLink are much more detailed.
 HTH
David.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
If you don't have a copy of the System Administrator's Guide for 11.0.2, it can be downloaded, with all of the other Applications Documentation from 
It is about 8 or 9 years since I worked on 11.0.2. Don't you think that it is about time you upgraded to 11.5?