This content has been marked as final. Show 15 replies
Are you modifying just the layout or are you trying to embed new fields which are currently not in there?1 person found this helpful
I'd like to update the layout and use the same xml tags...
can you pls let me know on how to go about it..
Appreciate your time.
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 those1 person found this helpful
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
Appreciate your inputs but I'm working on R12 International HRMS and
the Process is Cheque Writer(Generic) which is seeded and not xml process for US.
I tried accessing the template for this seeded process but that is protected against update.
That is my concern.
I am sorry, I don't have much idea about non US leg. I assumed there is a Check writer XML program available for your legislation.
Any Help on this. I need to include my own layout to print the cheques.
Hi SRS,1 person found this helpful
Did you try creating a new template under the same data definition ?
You can have multiple templates for a data definition and while submitting the report, you can choose one.
The Cheque Writer(Generic) process is triggering Payroll File Reporter which is giving the seeded layout. I have added my layout in the same data defintion. But it is not picking mine.
Any help on this, Please
I have just looked at the request Cheque Writer(Generic)1 person found this helpful
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.
This is the one that I checked "CHEQUE_GEN "
I was adding one more template but couldnt really achieve anything out of it.
Could you kindly elaborate on the solution you are proposing, Please!!
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 person found this helpful
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).
I am trying to use the XML Report Publisher Program. But it is neither showing any list of values in the request ID nor allowing me to add a request ID?
Any help on this pls?
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
yes,I changed the output to xml.
The query just doesnt give me anything.