Search Results populate_interface_control

Overview

GL_JOURNAL_IMPORT_PKG is a public PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite General Ledger. Its documented purpose is to provide functions and procedures used directly with the Journal Import process, the program that transfers unposted journal entries from the GL_INTERFACE table into the GL_JE_BATCHES, GL_JE_HEADERS, and GL_JE_LINES tables. The package header carries the RCS identifier glujimns.pls 120.6, with a creation history dating to 09-OCT-2000 by D. J. Ogg. Its API classification is OTHER, and its lifecycle status is active, with a compatibility rating of S (supported). The package does not perform the import itself; rather, it supplies the supporting infrastructure that allows administrators and developers to prepare, control, and debug Journal Import runs, including the creation and removal of alternate interface tables and the population of the interface control row that governs how imported data is retained after a run.

Key Procedures and Functions

• CREATE_TABLE — Creates a copy of the GL_INTERFACE table using a supplied table name and storage parameters. The table is created in the GL schema, and the routine raises the CANNOT_GET_APPLSYS_SCHEMA exception if the APPLSYS schema information cannot be resolved.
• DROP_TABLE — Removes a table previously created by CREATE_TABLE, sharing the same APPLSYS schema lookup logic and exception behavior.
• POPULATE_INTERFACE_CONTROL — Populates the GL_INTERFACE_CONTROL row that drives Journal Import behavior. It accepts a journal entry source name and a processed_data_action parameter. Invalid source names raise INVALID_JE_SOURCE; invalid actions raise INVALID_PROCESSED_ACTION; and parameter combinations that would force GL_INTERFACE to be dropped raise CANNOT_DROP_GL_INTERFACE. Three documented constants define the processed_data_action values: SAVE_DATA ('S'), DELETE_DATA ('D'), and DROP_INTERFACE_TABLE ('R').
• GET_LAST_SQL — Returns the last SQL statement processed, supporting diagnosis of failed or partially executed import activity.
• GET_ERROR_MSG — Returns the error message associated with the most recent failure, used by callers to surface actionable diagnostics.

Tables Accessed

• GL_INTERFACE_CONTROL and GL_INTERFACE_CONTROL_S — the primary target of POPULATE_INTERFACE_CONTROL; the sequence supplies the control row identifier.
• GL_JE_SOURCES — validated when POPULATE_INTERFACE_CONTROL receives a journal entry source name, producing the INVALID_JE_SOURCE condition.
• GL_JOURNAL_IMPORT_S — the sequence associated with Journal Import runs.
• FND_ORACLE_USERID — used to resolve the APPLSYS schema information required by CREATE_TABLE and DROP_TABLE.
• AD_DDL — the AD utilities package invoked to perform the DDL required for table creation and removal.
• DUAL — used for scalar evaluations and sequence access.

All references are made through APPS synonyms. The package is referenced by four other packages within the EBS codebase.

Usage Notes

GL_JOURNAL_IMPORT_PKG is not intended for direct end-user invocation. It is typically called from the Journal Import concurrent program flow and from General Ledger forms that present import options, and it may be invoked from custom code that needs to stage interface data in a backup table or to set the retention behavior of a Journal Import run before submission. The GET_LAST_SQL and GET_ERROR_MSG functions are commonly used in diagnostic and logging routines to capture the failing statement and Oracle error text when an import aborts. Both EBS 12.1.1 and 12.2.2 APPS installations receive this package; in 12.2.2 the same documented interface applies. Because the package performs DDL against the GL schema, execute privileges are effectively restricted to administrative and application schema accounts, and the DROP_INTERFACE_TABLE action should be used only after confirming that no dependent custom reports reference GL_INTERFACE.