Understanding XML Files Generation

The system uses Oracle's BI Publisher (Business Intelligence Publisher) to produce all the required XML files. The system has different versions of the extractor process, which relate to different report definition templates to manage the data formatting process of the basic information.

The BI Publisher creates the XML files in a two-phase process:

  1. Information extraction, generation, and data formatting

  2. XSLT transformation

An Extensible Stylesheet Language Transformation (XSLT) is an .xsl script that maps an XML schema to another XML schema. The XML generation programs extract the required information and produce an XML schema that is mapped to the schema provided by the government fiscal authorities.

To generate the different XML files that comply with the output information and format required by the fiscal authorities, the system uses specific templates and report definitions. Review the relationships in the following table:

Output

Batch Version Program

Version

Template

BI Publisher Report Definition

Chart of Accounts by Level XML File

R7009001

ZJDE0001

TP700901TS1

RD700901A

Trial Balance XML File

R7009002

ZJDE0001

TP700902TS1

RD700902A

General Ledger Report

R7009003

ZJDE0001

TP700903TS1

RD700903A

Auxiliary Ledger by Account

R7009004

ZJDE0001

TP700904TS1

RD700904A

Note: Before you run the XML generation programs, verify that the BI Publisher setup is correct in your system.See Also