Search Results rg_xbrl_pkg




Overview
Explore in AI Chat

Overview

APPS.RG_XBRL_PKG is a server-side PL/SQL package body in the Oracle E-Business Suite that supports the extraction and delivery of General Ledger data in XBRL (eXtensible Business Reporting Language) format. It ships under the APPS schema with a status of VALID and falls into the generic OTHER API classification in the ETRM 12.2.2 documentation set. The package underpins the XBRL publishing capability that allows organizations to map GL account balances to a regulatory taxonomy and produce instance documents suitable for external filing. Its functions are administrative and infrastructural: loading an XBRL taxonomy definition, validating its contents, populating lookup and label structures, and removing obsolete taxonomies. Because the object is a package body, all of its logic is private and reachable only through the public specifications declared in RG_XBRL_PKG.

Key Procedures and Functions

The documented package exposes ten procedures and functions. UPLOAD_TAXONOMY serves as the primary entry point, accepting a taxonomy source and orchestrating the import sequence. LOAD_TAXONOMY performs the substantive load work, parsing the taxonomy definition and inserting its elements. VERIFY_IMPORT validates that the loaded content is complete and structurally usable before it is released for mapping. UPDATE_FLAGS maintains status indicators on taxonomy and element records to reflect their import or activation state.

Three procedures manage CLOB columns within the taxonomy data model: INSERT_TAX_CLOB inserts the taxonomy document content, UPDATE_LBL_CLOB refreshes the label linkbase content, and UPDATE_DFN_CLOB refreshes the definition linkbase content. Complementing these, READ_URL retrieves taxonomy content from a network or file location, while the combination of REMOVE_TAXONOMY and DELETE_TAXONOMY handles retirement of taxonomies that are no longer required.

Tables Accessed

The package reads and writes the core XBRL configuration tables. RG_XBRL_TAXONOMIES and its RG_XBRL_TAXONOMY_S sequence store taxonomy headers and identifier generation, while RG_XBRL_ELEMENTS and RG_XBRL_ELEMENTS_S hold the individual element definitions and their sequence. RG_XBRL_MAP_ELEMENTS and the view RG_XBRL_MAP_V represent the linkage between taxonomy elements and GL reporting structures. RG_REPORT_AXIS_SETS supplies the axis and dimension definitions used when tagging GL balances. Supporting dependencies include FND_GLOBAL for session context such as user and responsibility identifiers, ALL_DIRECTORIES for server-side file access paths, DBMS_LOB for CLOB manipulation, GL_MESSAGE for user-facing error messaging, and DUAL and STANDARD for basic SQL and PL/SQL operations.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, RG_XBRL_PKG is invoked primarily from the General Ledger XBRL administration forms, where the taxonomy upload, verification, and removal actions trigger the corresponding package procedures. It may also be called from concurrent programs responsible for scheduled taxonomy refresh, and from custom code where a site needs to automate taxonomy deployment across environments. Organizations extending the seeded XBRL workflow should call only the public specification rather than attempting to reach the private body elements. Exercise care with READ_URL, since it depends on a valid directory alias in ALL_DIRECTORIES and appropriate file system or network privileges on the database tier. Because the package is not referenced by any other database object, changes to its behavior do not cascade into dependent PL/SQL units.