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:
Information extraction, generation, and data formatting
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 |