GL_INTERFACE Table Empty While LOV for GROUP_ID Shows Values in Import Journals Form

(Doc ID 847917.1)

Last updated on JUNE 25, 2015

Applies to:

Oracle General Ledger - Version 11.5 to 12.1 [Release 11.5.0 to 12.1]
Information in this document applies to any platform.
GLXJIRUN.fmx - Import Journals
GLXJICOR.fmx - Correct Journal Import Data

Symptoms

There are no records in GL_INTERFACE table for the GROUP_IDs
that appear in LOV in Import Journals Form or Correct Journal Import Data Form.

Example one:
Log in as GL Superuser
Nav Journals -> Import-> Run
Select Payables for Source and select Specific GROUP_ID from LOV.
Click on Import
Journal import ends in warning since there are no records

select * from gl_interface where group_id = &groupd_id from LOV
returns no rows.

Example two;
Log in as GL Superuser
Nav Journals -> Import-> Correct
Select Inventory for Source and select Specific GROUP_ID from LOV.
There are no rows to correct.

There is no data in GL_INTERFACE table for these GROUP_IDs.

Changes

For R12, applying a Patch that includes the code changes in an internal bug.
@BUG 7512923 : RCA:CHANGES IN GL TRANSFER PACKAGE FOR VARIOUS ISSUES

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