Search Results jai_fbt_settlement

Overview

The JAI_FBT_SETTLEMENT table is a core data object within the JA – Asia/Pacific Localizations product in Oracle E-Business Suite (available in both 12.1.1 and 12.2.2). It stores the quarterly settlements calculated for Fringe Benefit Tax (FBT), a statutory obligation applicable primarily to Australian and other Asia/Pacific legislative environments. Each row captures a supplier-facing FBT position for a given legal entity and settlement period, enabling organizations to consolidate fringe benefit liabilities, project expected amounts, track deposit and challan activity, and drive regulatory return generation.

Within a Data Vault modeling heuristic, this object is best classified as a link. Its structure is dominated by foreign key references to parties, party sites, operating units, and legal entities, combined with descriptive and amount-bearing attributes. This makes it a transactional association table rather than a pure hub (which would hold only a business key) or a satellite (which would store descriptive history for a single key). The link classification reflects its role in connecting multiple master entities across a defined settlement period.

Key Information Stored

The table contains 20 documented columns. The most significant are described below.

SETTLEMENT_ID – Surrogate primary key defined by constraint JAI_FBT_SETTLEMENT_PK. It is also the sole column in the unique index JAI_FBT_SETTLEMENT_U1, making it the documented business-key candidate.
LEGAL_ENTITY_ID – References FV_LEGAL_ENTITIES; identifies the reporting legal entity for the settlement.
INV_SUPPLIER_ID – Foreign key to HZ_PARTIES; the supplier associated with the settlement.
INV_SUPPLIER_SITE_ID – Foreign key to HZ_PARTY_SITES; the specific supplier site.
INV_OU_ID – Foreign key to HR_ALL_ORGANIZATION_UNITS; the inventory operating unit.
PERIOD_START_DATE and PERIOD_END_DATE – Define the quarterly settlement window.
CONSOLIDATED_AMOUNT – Aggregated FBT liability for the period.
PROJECTED_AMOUNT – Forecasted FBT amount used in planning.
SETTLEMENT_DATE and DEPOSIT_DATE – Track the settlement and deposit timelines.
BANK_NAME and BRANCH_NAME – Capture the payment institution details.
IT_CHALLAN – Reference to the statutory challan document.
RETURN_GENERATE_FLAG – Indicates whether the regulatory return has been generated.
Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) support concurrency and traceability.

Common Use Cases and Queries

Typical usage centers on quarterly FBT reporting, reconciliation, and return generation. Analysts join this table to supplier and legal entity masters to produce statutory FBT summaries, reconcile projected versus consolidated amounts, and verify deposits against challans.

A representative query reconciling consolidated and projected amounts by legal entity:

SELECT legal_entity_id, period_start_date, period_end_date, SUM(consolidated_amount), SUM(projected_amount) FROM jai_fbt_settlement WHERE return_generate_flag = 'Y' GROUP BY legal_entity_id, period_start_date, period_end_date;

Reporting scenarios include FBT liability trend reporting, deposit tracking by bank/branch, and audit trails matching supplier settlements to party records. The RETURN_GENERATE_FLAG drives downstream return creation workflows.

Related Objects

HZ_PARTIES – joined via JAI_FBT_SETTLEMENT.INV_SUPPLIER_ID.
HZ_PARTY_SITES – joined via JAI_FBT_SETTLEMENT.INV_SUPPLIER_SITE_ID.
HR_ALL_ORGANIZATION_UNITS – joined via JAI_FBT_SETTLEMENT.INV_OU_ID.
FV_LEGAL_ENTITIES – joined via JAI_FBT_SETTLEMENT.LEGAL_ENTITY_ID.

These four foreign key relationships define the master-data footprint of the settlement record and are the primary join paths used in localization reporting.

Table: JAI_FBT_SETTLEMENT 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FBT_SETTLEMENT, object_name:JAI_FBT_SETTLEMENT, status:VALID, product: JA - Asia/Pacific Localizations , description: This table is used to store the quarterly settlements for Fringe Benefit Tax , implementation_dba_data: JA.JAI_FBT_SETTLEMENT ,
Table: JAI_FBT_SETTLEMENT 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FBT_SETTLEMENT, object_name:JAI_FBT_SETTLEMENT, status:VALID, product: JA - Asia/Pacific Localizations , description: This table is used to store the quarterly settlements for Fringe Benefit Tax , implementation_dba_data: JA.JAI_FBT_SETTLEMENT ,
SYNONYM: APPS.JAI_FBT_SETTLEMENT 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JAI_FBT_SETTLEMENT, status:VALID,
VIEW: JA.JAI_FBT_SETTLEMENT# 12.2.2
owner:JA, object_type:VIEW, object_name:JAI_FBT_SETTLEMENT#, status:VALID,
SYNONYM: APPS.JAI_FBT_SETTLEMENT 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JAI_FBT_SETTLEMENT, status:VALID,
VIEW: JA.JAI_FBT_SETTLEMENT# 12.2.2
APPS.JAI_FBT_SETTLEMENT_P SQL Statements 12.1.1
PACKAGE BODY: APPS.JAI_FBT_SETTLEMENT_P 12.2.2
TABLE: JA.JAI_FBT_SETTLEMENT 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FBT_SETTLEMENT, object_name:JAI_FBT_SETTLEMENT, status:VALID,
APPS.JAI_FBT_SETTLEMENT_P SQL Statements 12.2.2
TABLE: JA.JAI_FBT_SETTLEMENT 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FBT_SETTLEMENT, object_name:JAI_FBT_SETTLEMENT, status:VALID,
PACKAGE: APPS.JAI_FBT_SETTLEMENT_P 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JAI_FBT_SETTLEMENT_P, status:VALID,
PACKAGE BODY: APPS.JAI_FBT_SETTLEMENT_P 12.1.1
PACKAGE: APPS.JAI_FBT_SETTLEMENT_P 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JAI_FBT_SETTLEMENT_P, status:VALID,
PACKAGE BODY: APPS.JAI_FBT_SETTLEMENT_P 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_FBT_SETTLEMENT_P, status:VALID,
PACKAGE: APPS.JAI_FBT_SETTLEMENT_P 12.1.1
PACKAGE BODY: APPS.JAI_FBT_SETTLEMENT_P 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JAI_FBT_SETTLEMENT_P, status:VALID,
PACKAGE: APPS.JAI_FBT_SETTLEMENT_P 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 FND Design Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
Table: HZ_PARTY_SITES 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTY_SITES, object_name:HZ_PARTY_SITES, status:VALID, product: AR - Receivables , description: Links party to physical locations , implementation_dba_data: AR.HZ_PARTY_SITES ,
Table: HZ_PARTY_SITES 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTY_SITES, object_name:HZ_PARTY_SITES, status:VALID, product: AR - Receivables , description: Links party to physical locations , implementation_dba_data: AR.HZ_PARTY_SITES ,
APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_SETTLEMENT 12.1.1
APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_SETTLEMENT 12.1.1
APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_SETTLEMENT 12.2.2
APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_SETTLEMENT 12.2.2
Table: HR_ALL_ORGANIZATION_UNITS 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:AS.HR_ALL_ORGANIZATION_UNITS PER.HR_ALL_ORGANIZATION_UNITS, object_name:HR_ALL_ORGANIZATION_UNITS, status:VALID, product: PER - Human Resources , description: Organization unit definitions. , implementation_dba_data: HR.HR_ALL_ORGANIZATION_UNITS ,
Table: HR_ALL_ORGANIZATION_UNITS 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:AS.HR_ALL_ORGANIZATION_UNITS PER.HR_ALL_ORGANIZATION_UNITS, object_name:HR_ALL_ORGANIZATION_UNITS, status:VALID, product: PER - Human Resources , description: Organization unit definitions. , implementation_dba_data: HR.HR_ALL_ORGANIZATION_UNITS ,
Table: HZ_PARTIES 12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTIES, object_name:HZ_PARTIES, status:VALID, product: AR - Receivables , description: Information about parties such as organizations, people, and groups , implementation_dba_data: AR.HZ_PARTIES ,
Table: HZ_PARTIES 12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_PARTIES, object_name:HZ_PARTIES, status:VALID, product: AR - Receivables , description: Information about parties such as organizations, people, and groups , implementation_dba_data: AR.HZ_PARTIES ,
APPS.JAI_FBT_SETTLEMENT_P dependencies on AP_INVOICES_INTERFACE 12.2.2
APPS.JAI_FBT_SETTLEMENT_P dependencies on AP_INVOICES_INTERFACE 12.1.1
APPS.JAI_FBT_SETTLEMENT_P dependencies on DUAL 12.1.1
APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_SETTLEMENT_S 12.2.2
APPS.JAI_FBT_SETTLEMENT_P dependencies on DUAL 12.2.2
APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_SETTLEMENT_S 12.1.1
APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_REPOSITORY 12.1.1
APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_SETTLEMENT_P 12.1.1
APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_REPOSITORY 12.2.2
APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_SETTLEMENT_P 12.2.2
APPS.JAI_FBT_SETTLEMENT_P dependencies on FND_LOG 12.2.2
APPS.JAI_FBT_SETTLEMENT_P dependencies on FND_LOG 12.1.1
eTRM - JA Tables and Views 12.1.1
description: The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table. ,
eTRM - JA Tables and Views 12.2.2
description: The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines. ,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
eTRM - JA Tables and Views 12.1.1
description: The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table. ,