Search Results delete_taxonomy

Overview

RG_XBRL_PKG is a server-side PL/SQL package owned by APPS that provides the processing engine for XBRL (Extensible Business Reporting Language) taxonomy handling within Oracle E-Business Suite. In the context of Oracle EBS 12.1.1 and 12.2.2, its principal business function is to load, verify, and remove XBRL taxonomies and their associated elements, and to maintain the taxonomy elements storage used by Oracle's XBRL reporting and regulatory filing features. The package is declared with AUTHID CURRENT_USER, meaning privileges for referenced objects are evaluated against the invoking user's schema, and it exposes all of its server-side procedures for taxonomy processing. The package header carries the version identifier rgxbrlps.pls 120.0 and an original creation date of 2003, reflecting its long-standing role in the EBS reporting stack.

Key Procedures and Functions

The package documents ten procedures and functions. Several are SRS wrappers that accept the standard concurrent program OUT parameters (errbuf, retcode) so they can be called from concurrent managers and request sets:

• UPLOAD_TAXONOMY — Wrapper that invokes LOAD_TAXONOMY from a concurrent program. It accepts the taxonomy name, taxonomy alias (file name), and taxonomy description.
• REMOVE_TAXONOMY — Wrapper that invokes DELETE_TAXONOMY from a concurrent program, taking the taxonomy name as its argument.
• DELETE_TAXONOMY — Removes a taxonomy from both the taxonomy storage and the elements storage, keyed by the fully qualified taxonomy name.
• LOAD_TAXONOMY — Loads a taxonomy into the taxonomy storage and elements storage, accepting the taxonomy name, alias, and description.
• UPDATE_FLAGS — Updates flags in the elements storage for a given taxonomy ID. This is the procedure referenced by the search term "update_flags"; it is a maintenance routine that refreshes element-level status indicators after taxonomy processing.
• VERIFY_IMPORT — Retrieves import URLs from the taxonomy schema definition and checks that the referenced import taxonomies have actually been loaded.
• READ_URL — Reads content from a URL, used during taxonomy retrieval and parsing.
• INSERT_TAX_CLOB — Inserts taxonomy definition content as a CLOB.
• UPDATE_LBL_CLOB — Updates label (presentation/label linkbase) content held as a CLOB.
• UPDATE_DFN_CLOB — Updates definition content held as a CLOB.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

• RG_XBRL_TAXONOMIES and RG_XBRL_TAXONOMY_S — master and storage tables holding loaded taxonomy definitions and metadata.
• RG_XBRL_ELEMENTS and RG_XBRL_ELEMENTS_S — element-level storage where UPDATE_FLAGS maintains status flags.
• RG_XBRL_MAP_ELEMENTS — mapping of elements, used during load and verification.
• RG_REPORT_AXIS_SETS — axis set definitions supporting the reporting framework.
• ALL_DIRECTORIES — directory objects used to locate taxonomy files on the database server.
• DBMS_LOB and DUAL — utilized for CLOB manipulation and simple scalar operations.

Usage Notes

RG_XBRL_PKG is normally invoked indirectly rather than called ad hoc. The primary entry points are concurrent programs that call UPLOAD_TAXONOMY and REMOVE_TAXONOMY, which in turn call the internal LOAD_TAXONOMY and DELETE_TAXONOMY routines. UPDATE_FLAGS is typically executed as part of the taxonomy load/maintenance cycle to synchronize element flags rather than being exposed directly to end users. VERIFY_IMPORT supports validation of import dependencies before or during loading. The package is referenced by zero other packages in the documented metadata, so integrations are expected through the concurrent program interface or custom code calling the public SRS wrappers. Because the package uses AUTHID CURRENT_USER, custom callers should ensure the invoking schema has appropriate privileges on the underlying APPS synonyms and directory objects.