Search Results p_balancing_segment

Overview

The APPS.JL_BR_SPED_DATA_EXTRACT_PUB package is a public PL/SQL API within the Oracle E-Business Suite localization layer for Brazil. It supports the generation of data required for the SPED (Sistema Público de Escrituração Digital) fiscal reporting framework, which Brazilian legislation mandates for corporate bookkeeping records. The package compiles with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking schema rather than the defining schema. The header comment indicates it was last modified in 2009 and carries the noship designation, reflecting its role as a localization-specific object maintained under the Brazilian (JL) product family. Its two procedures register the record blocks that map to SPED fiscal bookkeeping registers, specifically blocks I015, I200, and I250. The package operates against the general ledger and legal entity data model, relying on GL and XLE entities to derive the contextual information required by the tax authority layout. Because it is classified as a PUB (public) API, it is intended for invocation by other EBS components rather than as an internal helper.

Key Procedures and Functions

Two documented procedures are exposed by this package:

• REGISTER_I200_I250 — Registers the data associated with SPED registers I200 and I250, which pertain to the accounting entries and item-level detail within the fiscal bookkeeping record set. It accepts the ledger, legal entity, establishment, and period set context together with a date range, the balancing, account, and cost center segment identifiers, the bookkeeping type, and the originating concurrent request identifier. Results are returned through the standard errbuf and retcode out parameters, consistent with concurrent program conventions.
• REGISTER_I015 — Registers the data associated with SPED register I015, which captures the identification of the subsidiary ledger accounts within the bookkeeping record set. Its parameter signature mirrors REGISTER_I200_I250, drawing the same ledger, entity, establishment, period, date range, segment, bookkeeping type, and concurrent request inputs. The p_balancing_segment parameter referenced by the user's search is common to both procedures and designates the segment used to balance the extracted records.

Tables Accessed

The package references three tables through APPS synonyms:

• GL_LEDGERS — Supplies ledger context, including the ledger identifier and period set name used to scope the fiscal extraction.
• XLE_ENTITY_PROFILES — Provides the legal entity identifier required to attribute records to the correct reporting entity.
• XLE_ETB_PROFILES — Supplies the establishment identifier, enabling records to be segmented by the registered establishment associated with the legal entity.

These tables are read to validate and enrich the parameters passed into the registration procedures, ensuring that SPED records are generated against a correctly configured legal entity, ledger, and establishment combination.

Usage Notes

The package is typically invoked from concurrent programs that drive the Brazilian SPED extraction process. The presence of errbuf, retcode, and p_concurrent_request_id parameters confirms the standard concurrent manager calling pattern, where the request identifier links extracted records back to the submission for audit and reprocessing. ETRM metadata records that the package is referenced by one other package, indicating that it is called from a higher-level orchestration or data extraction routine rather than directly from a form. Implementors customizing SPED output should invoke these procedures only after the ledger, legal entity, and establishment identifiers have been resolved, and should pass the correct p_balancing_segment, p_account_segment, and p_cost_center_segment values to match the chart of accounts configuration. Because the object is a public API, direct modification is not supported; extensions should wrap the documented procedures rather than altering the package body.