Search Results jai_po_osp_line_dtls




Overview
Explore in AI Chat

Overview

The table JAI_PO_OSP_LINE_DTLS is a core data object within the Oracle E-Business Suite Asia/Pacific (JA) localization. It is specifically designed to support statutory reporting requirements, as indicated by its description to store information for "57F4 Line Details." This refers to the Form 57F4, a mandatory document under Indian tax law for reporting Out of State Purchases (OSP). The table's role is to persist detailed line-level transactional data required for the accurate generation and submission of this statutory form within releases 12.1.1 and 12.2.2 of Oracle EBS.

Key Information Stored

While the provided metadata does not list specific column names beyond key identifiers, the table's purpose dictates the nature of its data. Based on its role in 57F4 reporting, it typically stores granular details for each purchase line item that qualifies as an Out of State Purchase. The primary key, DETAIL_LINE_ID, uniquely identifies each record. The foreign key columns, FORM_ID and LINE_ID, link the detail line to its parent form header and the associated purchase order line, respectively. Other columns would likely capture tax-specific information such as the type of goods, applicable tax rates (like Central Sales Tax or VAT), taxable value, and the calculated tax amounts, all necessary for compliance reporting.

Common Use Cases and Queries

The primary use case for this table is the generation and audit of Form 57F4. It serves as the detailed data source for report extraction. Common queries involve joining this table to its parent objects to compile complete transactional records for a given period or supplier. A typical reporting pattern would be:

  • Extracting 57F4 Line Details for a Form: Retrieving all line-level details for a specific form submission to verify data before filing.
  • Reconciliation Reporting: Comparing aggregated taxable values and tax amounts from this table against general ledger accounts for financial period closure.

A sample SQL pattern to fetch details for a specific form might be:
SELECT * FROM ja.jai_po_osp_line_dtls d WHERE d.form_id = :p_form_id ORDER BY d.detail_line_id;

Related Objects

The table maintains defined foreign key relationships, as per the provided metadata. These relationships are critical for data integrity and joining information for reporting.

  • Primary Key: JAI_PO_OSP_LINE_DTLS_PK on column DETAIL_LINE_ID.
  • Foreign Keys (Referencing):
    • Column FORM_ID references a parent form header table (the specific table name is denoted as '%' in the metadata, but is likely JAI_PO_OSP_HEADERS or a similar object).
    • Column LINE_ID references a purchase order line details table (again denoted as '%', but logically links to PO_LINES_ALL or a localization-specific extension).

This table is a child object within a hierarchy, where the FORM_ID links to the form summary and the LINE_ID links back to the originating procurement transaction in the core Purchasing module.