Search Results func_period_net_cr




Overview
Explore in AI Chat

Overview

APPS.JA_CN_ACCOUNT_BALANCES_V is a reporting view owned by the APPS schema and registered in FND Design Data as FND.JA_CN_ACCOUNT_BALANCES_V. It is part of the Oracle E-Business Suite localization feature set for China (JA_CN), which supports Chinese statutory accounting and reporting requirements. The view presents consolidated account balance information at the ledger, legal entity, company segment, cost center, account segment, and period level, together with optional third-party, project, and personnel dimensions.

The view is designed to expose both functional-currency and original-currency balance figures. For each accounting period it publishes opening balances, period net activity, and closing balances, each split into debit and credit amounts as well as combined net amounts. This structure makes the view suitable for financial statement generation, account balance inquiries, reconciliation between functional and original currency, and downstream integration with external statutory reporting systems. Its status is VALID in the documented environment, indicating that it compiles and is accessible to reporting tools such as Oracle Reports, BI Publisher, and ad hoc SQL clients.

Underlying Base Objects

The documented dependency information identifies a single referenced object: the base table APPS.JA_CN_ACCOUNT_BALANCES, which is accessed through the synonym JA_CN_ACCOUNT_BALANCES. The view therefore acts as a presentation and namespace layer over the China account balances base table, exposing selected and possibly derived columns in a stable column order.

Because the view is registered in FND Design Data and is owned by APPS, it follows the standard Oracle EBS convention for seeded localization views: the base table stores the transactional and summarized balances, while the view provides a governed interface for reporting and integration. Customers should treat the view as read-only and reference it rather than the base table where possible, since the view definition may be patched or enhanced during localization upgrades.

Key Columns

Common Use Cases and Queries

The view is typically queried to produce Chinese statutory account balance reports, to reconcile functional and original currency balances, and to feed external reporting extracts. A common pattern is to retrieve the closing original-currency debit balance for a given ledger, account segment, and period.

The following query returns closing original-currency debit balances for a specified period:

  • SELECT ledger_id, period_name, account_segment, currency_code,
  •        orig_begin_balance_dr, orig_period_net_dr, orig_end_balance_dr
  • FROM  apps.ja_cn_account_balances_v
  • WHERE  period_name = :period_name
  • AND    ledger_id  = :ledger_id
  • ORDER BY account_segment;

Another frequent scenario aggregates net functional closing balances by legal entity and account type for financial statement preparation:

  • SELECT legal_entity_id, account_type, SUM(func_end_balance) end_balance
  • FROM  apps.ja_cn_account_balances_v
  • WHERE  period_name = :period_name
  • GROUP BY legal_entity_id, account_type;

Because the view exposes the underlying table columns directly, standard EBS security and ledger access controls apply at the data level rather than being enforced within the view itself. When used in concurrent programs or BI Publisher data models, the period name and ledger identifiers should always be bound parameters to keep result sets small and consistent with the reporting ledger context.