Understanding TXT file generation

The system uses Oracle's BI Publisher to produce the required text file.

The BI Publisher creates 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 a file schema to another file schema. The programs extract the required information and produce a TXT or PDF schema that is mapped to the schema provided by the government fiscal authorities.

The system uses specific templates and report definitions related to the version to produce a text file that complies with the output information and format, as required by the fiscal authorities.

The following table describes the relationship between the output, templates, and report definitions:

Output

Batch Version Program

Version

Template

BI Publisher Report Definition

F2003 Profit Withholding to External Beneficiaries TXT

R76A4005

ZJDE0001

TP76A4005TE1

RD76A4005A

F2003 Profit Withholding to External Beneficiaries PDF-Single

R76A4005

ZJDE0002

TP76A4005TP1

RD76A4005B

F2003 Profit Withholding to External Beneficiaries PDF-Detailed

R76A4005

ZJDE0002

TTP76A4005TP2

RD76A4005B

Note:

Before you run the TXT generation program, verify that the BI Publisher setup is correct in your system.

See Also