EGL9.1: Brazilian Localization - GLSPED_D_BRL fails with ORA-00904: "L"."HIST_PART_BRL_4": invalid identifier- Brazilian Localization (Doc ID 2056580.1)

Last updated on NOVEMBER 16, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger Brazil - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------

GLSPED_D_BRL process fails with ORA-00904: "L"."HIST_PART_BRL_4": invalid identifier .

Steps to replicate:
-------------------
To reproduce this issue:-

1. Set Up SPED Control
  General Ledger > SPED for General Ledger> SPED Set Up > SPED Control

2. Ensure to have some data (for the Business unit for which the SPED process is run) from Global Payroll that is posted to GL

3. Request to create SPED information
  General Ledger > SPED for General Ledger > Create SPED Information

4. Monitor the status of request by clicking the Process Monitor link on Create SPED Information page

Error:
--------
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1620 Error Position: 1093 Return: 904 - ORA-00904: "L"."HIST_PART_BRL_4": invalid identifier
Failed SQL stmt:INSERT INTO PS_SPD002_BRLTAO4 (PROCESS_INSTANCE , JOURNAL_ID , JOURNAL_DATE , UNPOST_SEQ , JOURNAL_LINE ,
....
O processo 890221 foi INTERROMPIDO na Etapa GLSPED_D_BRL.IRGI2500.INS002 (SQL) - RC = 904 (108,524)


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms