Search Results ja_in_cal_bal




Overview
Explore in AI Chat

Overview

JA_JAINBBR_XMLP_PKG is an Oracle E-Business Suite XML Publisher (BI Publisher) report package body owned by the APPS schema. Its name follows the EBS convention for packages generated to support XML Publisher concurrent programs: the _XMLP_PKG suffix indicates that the package supplies report-level logic to an Oracle Reports or XML Publisher template executed as a concurrent program. Based on the naming ("JA_IN" = India localization, "NBBR" = Bank Book / Bank Reconciliation report), the package supports the Indian Localization bank book or bank reconciliation reporting process. It supplies computed report columns (balances, account codes, and account descriptions) to the report layout and performs session-level trace initialization before the report executes.

Key Procedures and Functions

  • CF_CLOSING_BALANCEFORMULA — Computes the closing balance for a reporting row by combining closing balance, opening balance, receipts, and payments, using NVL to default a missing closing balance to the opening balance.
  • CF_BALANCEFORMULA — Derives a net movement figure as receipts minus payments, defaulting each operand to zero through NVL.
  • CF_ACCOUNT_CODEFORMULA — Resolves a numeric account code into a formatted account number by delegating to JAI_CMN_GL_PKG.GET_ACCOUNT_NUMBER and passing the report's chart of accounts identifier.
  • CF_1FORMULA, CF_ACCT_DESCFORMULA, CF_P_BOOKFORMULA — Additional computed report columns: a generic formula column, an account description column, and a "P_BOOK" (bank book) column used in the report layout.
  • CF_OPEN_BAL_DRFORMULA, CF_OPEN_BAL_CRFORMULA, CF_OPEN_BALANCEFORMULA — Compute opening balance in debit terms, opening balance in credit terms, and the consolidated opening balance, respectively.
  • BEFOREREPORT — The standard XML Publisher before-report trigger. It queries FND_CONCURRENT_REQUESTS for the concurrent program ID and the ENABLE_TRACE flag, optionally issues ALTER SESSION SET EVENTS '10046 trace name context forever, level 4' to enable SQL tracing, and assigns P_CONC_REQUEST_ID from FND_GLOBAL.CONC_REQUEST_ID.
  • JA_IN_CAL_BAL — The user-searched function; it calculates balances for the Indian localization bank book report, driving opening/closing and movement balance derivation for each report row.
  • AFTERREPORT — The standard after-report trigger, used for cleanup or post-processing once the report output is generated.

Tables Accessed

The package reads transactional and setup data through APPS synonyms. Payables data comes from AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_PAYMENTS_ALL, and AP_CHECKS_ALL (payments and check details). Receivables data comes from AR_CASH_RECEIPTS_ALL and AR_CASH_RECEIPT_HISTORY_ALL, with customer information from HZ_CUST_ACCOUNTS. Banking data comes from CE_BANK_ACCOUNTS. General Ledger data comes from GL_JE_HEADERS and GL_JE_LINES (journal entries driving account balances). Key flexfield segment metadata comes from FND_ID_FLEX_SEGMENTS, FND_SEGMENT_ATTRIBUTE_VALUES, and FND_CONCURRENT_PROGRAMS. Concurrent request state is read from FND_CONCURRENT_REQUESTS, and FND_GLOBAL is used to obtain the request ID context.

Usage Notes

This package is invoked automatically when the associated XML Publisher concurrent program runs; BEFOREREPORT and AFTERREPORT are called by the report engine, and the CF_* formula functions are evaluated per report row by the template layout. It is not referenced by any other package, confirming it is a leaf-level report driver. The account code formula depends on JAI_CMN_GL_PKG, so the India Localization shared common package must be present and valid. In 12.1.1 and 12.2.2, the source header (120.1) and the deprecated SRW.MESSAGE comments indicate an Oracle Reports migration lineage; customization of the bank book layout is therefore typically performed by modifying the XML template rather than the package, except for changes to the balance formulas.