My Oracle Support Banner

JGZZGLTRB: Using Portuguese Template Output Has Several Problems (Doc ID 846448.1)

Last updated on APRIL 25, 2019

Applies to:

Oracle Financials for EMEA - Version 12.0.5 and later
Information in this document applies to any platform.
This problem can occur on any platform.
REPORT:JGZZGLTRB:General Ledger Trial Balance report
REPORT:JEPTGLTRB: Portuguese Ledger Trial Balance report template

Symptoms

Find the General Ledger Trial Balance report (JGZZGLTRB) using the Portuguese General Ledger
Trial Balance Template, has some problems:

1. The 'Period To Date' balance column does not exist - This is a Statutory requirement
2. The report runs with one digit accounts and 9 series accounts
3. The report does not sequence the accounts as per the Statutory Format
4. There is a rounding issue in some amounts in the 'Balance' column

EXPECTED BEHAVIOR
Expect to see :

About the issue in step 3, the output must show the accounts like in the following example:

21 CLIENTES ---> Contains sum of all beginning with 21)
211 CLIENTES C/C
2111800 Clientes C/Corrente (08235)
2111990 Clientes Guest-In (08235)
22 FORNECEDORES ---> Contains sum of all beginning with 22)
221 FORNECEDORES C/C (Contains sum of all beginning with 221)
2211000 Fornecedores Nacionais (21010)
2211010 Accounts Payable Expense Accrual (21105)
2212000 Fornecedores Intracomunitarios (21590)
2213000 Creditors - to Balance (30505)
229 ADIANTAMENTOS A FORNECEDORES ---> Contains sum of all beginning with
229
2290000 Adiantamentos A Fornecedores (11105)
24 ESTADO E OUTROS ENTES PUBLICOS --> Contains sum of all beginning with
24
241 IMPOSTO SOBRE RENDIMENTO --> Contains sum of all beginning with 241
2411000 Pagamentos Por Conta (32025)
2412 RETENCAO NA FONTE Contains sum of all beginning with 2412
2412100 Rendimentos Capitais (32055)
2412200 Rendimentos Prediais (32055)
2413000 Imposto Estimado (32005)
2414000 Imposto Liquidado (32005)
(...)


Note: the class "2" account must not be in the output:
2 ACCOUNTS RECEIVABLE/PAYABLE


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Login to R12 instance using: portugal / welcome
2. GL Portugal Super User Responsability
3. Navigate thru: Reports / Request / Standard
4. Query the General Ledger Trial Balance Report ;
5. Select the Portuguese General Ledger Trial Balance Report Template in the 'Options' screen



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.