Oracle eBS經驗分享

Applies to:

Oracle Payables - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

How to generate the Payment Register report output as an Excel file with proper headings?
 

Solution

To do this will require the use of BI Publisher and the creation of a custom template.
The task of creating the template is considered a customization and is up to the user to complete.  I would suggest using and installing desktop publisher for this step.
If using desktop publisher be sure to the Backward Compatibility in the options before creating the template.

1. From the "System Administrator" responsibility navigate to Concurrent -> Program -> Define
2. Pull up the report with the short name of APXMTDCR
3. Change the output type to XML
4. Save
5. From a Payables Responsibility navigate to Others -> Request Run
6. Submit the "Payment Register" report
7. Once complete View the output, it will be XML.  Save this for the template creation in a later step.
8. From the XML Publisher Administrator responsibility navigate to Data Definitions
9. Create a data definition with a code of APXMTDCR (it must use this code, the name can be anything)
10. From the XML Publisher Administrator responsibility navigate to Templates
11. Create a custom template with the code of APXMTDCR (it must use this code, the name can be anything)
    Use the output from step 7 for the proper tags to use in the template.
    Set the default output type to Excel
12. From a Payables Responsibility navigate to Others -> Request Run
13. Submit the "Payment Register" report
14. View the output, it should create the output specified in the custom template created in step 11