This content has been marked as final. Show 15 replies
It's relatively easier to just change the layout using the current xml tags than creating new fields. I am not sure if your environment is on 11i or R12 but the below links should help you get started on either of those
http://www.docstoc.com/docs/21535879/Oracle-BI-(XML)-Publisher-with-Oracle-Payroll - Demo on building a check template
http://www.oracle.com/technetwork/middleware/bi-publisher/overview/checkprintingxmlp-1-133080.pdf - exclusively for 11i
459306.1 - How to Set Up and Use XML Checkwriter/Deposit Advice
740727.1 - For Check Writer (XML) And Deposit Advice (XML) Can Custom Changes Be Made To Template?
How To Assign/Modify XML Publisher Payment Templates [ID 414336.1]
Note: 560979.1 - Check Writer (XML) Concurrent Process Does Not Generate An Output When Using A Custom Template
Note: 787570.1 - Functional Set Up Steps and Basic Trouble Shooting Tips for Payroll XML Check Writer
Let me know if you have any questions
I have just looked at the request Cheque Writer(Generic)
It is based on PYUGEN process and the output is TEXT.
So not sure if you can customise it.
What data defintion did you add your template to ?
I guess you will either -
have to write another concurrent request which would take your xml from the generic process and merge it with a custom template.
try using XML Report Publisher which would accept the xml from your cheque writer request and a custom template.
Let me know how it goes.
After you run the Cheque Writer request, see what all output files it creates. If there is an xml file generated, then you can try one of the options I suggested earlier.
1 - create another concurrent request which would take your xml from the generic process and merge it with a custom template.
You can base the report of the executable XDODTEXE, which accepts 2 prameters - XML file and template.
You need to have some understanding of XML publisher concepts for this.
2 - easier way - try using XML Report Publisher
There is a seeded request called XML report publisher which accepts the request_id(for which an XML was generated) and a template(custom)
Search metalink for more details -
XML Publisher Report Issues, Recommendations and Errors [ID 862644.1]
Or just log an SR, they might suggest some easier way(if any).
Sorry, I was on a Holiday.
You can check the Value_set which gets you the requests from the concurrent program definition.
Value_set used for request_id = XDO_REPORT_REQUEST_ID
And the Sql -
Did you make sure the output of your request is XML.
SELECT NVL(R.DESCRIPTION ,CP.USER_CONCURRENT_PROGRAM_NAME) ,'Request ID: '||r.request_id||' Date: '||FND_DATE.DATE_TO_CANONICAL(R.REQUEST_DATE) ,R.REQUEST_ID FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROGRAMS_VL CP, XDO_CONCURRENT_REQUESTS_GT XGT WHERE R.REQUEST_ID = XGT.CONC_REQUEST_ID AND R.PROGRAM_APPLICATION_ID = CP.APPLICATION_ID AND R.CONCURRENT_PROGRAM_ID = CP.CONCURRENT_PROGRAM_ID ORDER BY R.REQUEST_ID DESC