Search Results fbt_settlement




Overview
Explore in AI Chat

Overview

JAI_FBT_SETTLEMENT_P is a technical PL/SQL package owned by the APPS schema and classified under the OTHER API category in Oracle E-Business Suite. The package supports First Build Time (FBT) settlement processing, a functionality associated with the Oracle Financials for India (JAI) localization suite. Its documented purpose is to be called by a concurrent program in order to insert settlement data into the JAI_FBT_SETTLEMENT table and to create corresponding records in the Oracle Payables interface tables. In effect, the package acts as a bridge between the Indian localization settlement repository and the standard Payables invoice import flow, allowing settlement-related accounting entries to be processed through the same mechanisms used for ordinary payables transactions.

The package header carries a source revision identifier of 120.0, dated 2007/12/24, and the creation history attributes the original implementation to Jason Liu on 2007/10/18. This places the package within the India localization code line that is delivered alongside, but separate from, the core Payables schema. The package declares a module prefix global (jai.plsql.JAI_FBT_SETTLEMENT_P) and a date mask constant, which are typical constructs used by JAI localization packages for consistent logging and date formatting.

Key Procedures and Functions

The ETRM metadata documents exactly one program unit within this package: the procedure FBT_SETTLEMENT. Its stated business purpose is to drive the insertion of settlement information into the JAI_FBT_SETTLEMENT table and simultaneously populate the Payables interface tables, so that settlement invoices can subsequently be imported and accounted for by the standard Payables processes. The header source also defines a private record type, inv_interface_rec_type, modeled on the AP_INVOICES_INTERFACE table, indicating that the procedure constructs invoice interface records in memory before inserting them. No parameter lists are documented in the available metadata, and therefore none should be assumed; the procedure is invoked by a concurrent program rather than by an interactive caller.

Tables Accessed

The package references a defined set of tables through APPS synonyms:

  • JAI_FBT_SETTLEMENT — the primary destination table where FBT settlement records are stored.
  • JAI_FBT_SETTLEMENT_S — the sequence used to generate settlement identifiers.
  • JAI_FBT_REPOSITORY — the repository of First Build Time data from which settlement information is derived.
  • AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE — the standard Payables open interface tables written to so that settlement invoices can be imported.
  • AP_INVOICES_INTERFACE_S and AP_INVOICE_LINES_INTERFACE_S — the sequences supplying interface record identifiers.
  • FND_CURRENCIES — used for currency validation or lookup when constructing invoice records.
  • DUAL — used for singleton queries such as sequence retrieval.

Usage Notes

JAI_FBT_SETTLEMENT_P is designed to be invoked exclusively by a concurrent program, as stated in its header description. The typical operating sequence is: the concurrent program submits the request, FBT_SETTLEMENT reads the relevant repository data, inserts settlement records into JAI_FBT_SETTLEMENT, and then stages invoice headers and lines in the Payables interface tables. A subsequent Payables Invoice Import run picks up those staged records. Because the package is classified as OTHER and is not referenced by any other documented package, it should be treated as an entry point rather than a reusable library. Customizations should not modify the package directly; instead, standard concurrent program submission and the Payables import flow should be relied upon. The behavior is consistent across EBS 12.1.1 and 12.2.2 unless the India localization patches alter the repository structure.