Search Results ld_end_date




Overview
Explore in AI Chat

Overview

JA_CN_FA_BI_EXPORT_PKG is a China-localization package that supports the export of fixed asset basic information required by Chinese statutory reporting and the Golden Tax / national tax authority (CTA) data submission processes within Oracle E-Business Suite. The package resides in the APPS schema and is classified as an "OTHER" API, meaning it is not an Oracle-supported public interface but a localization utility invoked by other EBS components. Its header comment states its purpose plainly: "Use this package to export basic information of fixed asset." The single packaged procedure, ADD_BASIC_Information, gathers fixed asset records scoped to a legal entity, ledger, accounting year, and period range, and assembles the output data set used downstream by the export reporting flow. The header revision ($Header: JACNFBIB.pls 120.1 2010/05/25) confirms the package was authored for release 12.1.x and carried forward into 12.2.x.

Key Procedures and Functions

  • ADD_BASIC_INFORMATION — The sole documented procedure. It exports the basic attribute set of fixed assets for a specified reporting window. Internally it declares a procedure-level identifier and switches on FND_LOG debug levels (G_CURRENT_RUNTIME_LEVEL, LEVEL_PROCEDURE, LEVEL_STATEMENT), which indicates it emits standard EBS debug logging suitable for troubleshooting. Local variables include ld_start_date and ld_end_date — these DATE variables are derived from the accounting year and the period-from / period-to inputs and bound the depreciation and transaction queries. A NO_DATA exception handler is declared for empty result sets, and ln_cost_row_count accumulates the count of rows returned for the fixed asset cost account, supporting output validation and reconciliation.

Tables Accessed

  • FA_BOOK_CONTROLS_SEC — Book control settings used to resolve the depreciation calendar and book context.
  • FA_CATEGORY_BOOKS — Maps asset categories to books, supplying category-level defaults for the export rows.
  • FA_DEPRN_PERIODS — The period-boundary source from which start and end dates are resolved, directly feeding the ld_start_date/ld_end_date logic.
  • FA_DISTRIBUTION_HISTORY — Provides account and cost-center distribution detail for assets within scope.
  • FA_TRANSACTION_HEADERS — Source of asset additions, adjustments, and other transactions within the reporting window.
  • GL_PERIOD_STATUSES — Confirms the open or closed status of the GL periods spanning the requested range.
  • JA_CN_LEDGER_LE_BSV_GT — A China-localization global temporary table bridging ledger and legal entity (balancing segment value) relationships, used to filter assets to the correct statutory entity.

Usage Notes

The package is referenced by one other package, indicating it is called programmatically rather than directly from a form. Typical invocation occurs through a China localization concurrent program or a parent orchestration package that passes legal entity, ledger, accounting year, and period range, then routes the extracted asset data into the statutory export file. Because it is not a public API, customizations should call it with the same parameter semantics used internally and should not rely on its signature remaining stable across patches. When diagnosing issues, enabling FND_LOG debug at the PROCEDURE or STATEMENT level reveals the resolved period boundaries and row counts — particularly useful when the "ld_end_date" value derived from FA_DEPRN_PERIODS does not match the expected reporting period.