Search Results manual_entries_import




Overview
Explore in AI Chat

Overview

GCS_ENTRY_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, declared with AUTHID CURRENT_USER and maintained as part of the Financial Consolidation Hub / Global Consolidation System (GCS) module. Its primary purpose is to provide the consolidation engine with a programmatic API for creating and maintaining entry headers and their associated lines. The majority of the documented procedures exist to support the Web ADI (Application Desktop Integrator) upload and import path, allowing users to enter consolidation journal entries in a spreadsheet and post them into the application without direct form interaction. The package encapsulates the validation, defaulting, and write-back logic required to transform spreadsheet rows into valid GCS entry structures, thereby insulating callers from the underlying consolidation engine tables.

Key Procedures and Functions

  • UPLOAD_ENTRY_HEADERS — An API to handle entry headers upload from Web ADI. It accepts a broad set of consolidation context attributes, including entry identifier, calendar period range, hierarchy, entity, currency, category, balance type, ledger, and conversion type, and returns the entry identifier as an IN OUT parameter.
  • MANUAL_ENTRIES_IMPORT — An API to import entries from Web ADI. It follows a parameter pattern similar to UPLOAD_ENTRY_HEADERS but additionally returns a new entry identifier, supporting the manual entry import flow.
  • CREATE_ENTRY_HEADER — An API to create a single entry header row. It returns the standard Oracle error buffer and return code (fnd_api.g_ret_sts_success, g_ret_sts_error, or g_ret_sts_unexp_error) and derives the entry identifier from the sequence when one is not supplied.
  • INSERT_ENTRY_HEADER — The procedure the user searched for, providing the lower-level insert operation for entry header records. It is the worker routine that establishes the header row within GCS_ENTRY_HEADERS and its sequence-based identifier.
  • DELETE_ENTRY — Provides the inverse operation, removing an entry (header and its dependent lines) from the consolidation structures.
  • RAISE_DISABLE_EVENT — Raises the disable event associated with the consolidation engine, supporting state notification when entries are manipulated.

Tables Accessed

The package references several APPS synonyms. Its primary write targets are GCS_ENTRY_HEADERS and GCS_ENTRY_HEADERS_S, which hold the header rows and their sequence-generated identifiers, together with GCS_ENTRY_LINES for the associated detail. Lookups to GCS_CATEGORIES_B, GCS_HIERARCHIES_B, and GCS_HIER_GRP_MEMBERS validate category codes, hierarchy definitions, and hierarchy group membership. Calendar period and accounting context are derived from FEM_CAL_PERIODS_ATTR, FEM_EXT_ACCT_TYPES_ATTR, and FEM_LN_ITEMS_ATTR, while FND_CURRENCIES validates the currency code. GCS_CONS_ENG_RUN_DTLS supports consolidation engine run detail tracking, and DUAL and PLITBLM are used for scalar selection and PL/SQL table handling respectively.

Usage Notes

GCS_ENTRY_PKG is typically invoked from Web ADI integrators, concurrent programs, and custom consolidation extensions rather than directly from an Oracle Forms block. The upload and import procedures are designed to be called by the ADI import handler, while CREATE_ENTRY_HEADER and INSERT_ENTRY_HEADER may be called from custom code that programmatically builds consolidation entries. Because the package is declared AUTHID CURRENT_USER, execution privileges depend on the privileges of the invoking user, so grants on the underlying GCS and FEM tables must be in place. Seven other packages reference GCS_ENTRY_PKG, indicating it is a shared dependency within the consolidation subsystem; changes to its signature should therefore be assessed for downstream impact. The package header carries a source control revision from 2007, reflecting the long-standing stability of this interface across 11i, 12.1.1, and 12.2.2.