Search Results fixed asset table

The JA_CN_FA_CATEGORY_GT table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a Global Temporary (GT) table specifically designed for the China localization module, primarily supporting Fixed Assets (FA) functionality. This table serves as an intermediate storage structure for temporary data processing during the execution of asset category-related operations in the Chinese regulatory and reporting context. Below is a detailed breakdown of its purpose, structure, and usage:

Purpose and Context

The JA_CN_FA_CATEGORY_GT table is part of Oracle's localization features for China, addressing statutory requirements such as tax reporting, depreciation rules, and asset classification unique to the region. It acts as a staging area for temporary data during processes like asset category creation, modification, or reporting. Global Temporary Tables (GTTs) like this are session-specific, meaning data persists only for the duration of a user session or transaction, ensuring data isolation and reducing contention in multi-user environments.

Key Features

Session-Specific Data Storage: Data inserted into JA_CN_FA_CATEGORY_GT is visible only to the session that inserted it, making it ideal for batch processes or complex calculations without impacting other users.
Support for China-Specific Rules: The table facilitates compliance with Chinese accounting standards, including asset categorization for tax purposes, depreciation methods (e.g., straight-line or accelerated), and statutory reporting.
Integration with Fixed Assets Module: It interfaces with core FA tables like FA_CATEGORIES_B and FA_CATEGORIES_TL, enabling localized extensions without modifying base EBS tables.

Table Structure

While the exact columns may vary slightly between EBS 12.1.1 and 12.2.2, typical columns include:

CATEGORY_ID: References the asset category from FA_CATEGORIES_B.
BOOK_TYPE_CODE: Links to the asset book for financial reporting.
DEPRECIATION_METHOD: Stores China-specific depreciation rules.
TAX_CODE: Captures tax-related classifications for compliance.
ATTRIBUTE1-15: Flexfields for custom data capture.

Usage Scenarios

Batch Asset Category Updates: During mass updates or migrations, the table temporarily holds validation data before committing to permanent tables.
Tax Reporting: Aggregates asset data for China-specific tax forms, such as VAT or corporate income tax filings.
Depreciation Calculations: Stores intermediate values for localized depreciation computations before final posting.

Technical Considerations

Performance: As a GTT, it reduces redo/undo overhead and improves performance for transient data operations.
Cleanup: Data is automatically purged at session end (if defined as ON COMMIT PRESERVE ROWS) or transaction end (ON COMMIT DELETE ROWS).
Customization: Organizations may extend its use via flexfields or PL/SQL logic for additional localization needs.

Conclusion

The JA_CN_FA_CATEGORY_GT table exemplifies Oracle's approach to localization, providing a scalable, temporary data structure to meet China's regulatory requirements while maintaining the integrity of the core EBS Fixed Assets module. Its design ensures efficient processing of asset category data without permanent storage overhead, aligning with both functional and technical best practices in Oracle EBS 12.1.1 and 12.2.2.

Table: JA_CN_FA_CATEGORY_GT 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_FA_CATEGORY_GT, object_name:JA_CN_FA_CATEGORY_GT, status:VALID, product: JA - Asia/Pacific Localizations , description: The 'JA_CN_FA_CATEGORY_GP' table stores fixed asset category code and fixed asset category name to filter the same asset category. , implementation_dba_data: JA.JA_CN_FA_CATEGORY_GT ,
Lookup Type: JA_CN_FA_XML_TAGS 12.2.2
product: JA - Asia/Pacific Localizations , meaning: XML Tags for Fixed Assets , description: XML Tags for Fixed Assets ,
Concurrent Program: JAINYEDE_XML 12.1.1
product: JA - Asia/Pacific Localizations , user_name: India - Income Tax Act Fixed Asset Schedules (XML) - Not Supported: Reserved For Future Use - Not Supported: Reserved For Future Use , description: India - Income Tax Act Fixed Asset Schedules , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: JAINYEDE 12.1.1
execution_filename: JAINYEDE , product: JA - Asia/Pacific Localizations , user_name: JAINYEDE , description: Depreciation for one year , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: JAINYEDE_XML 12.2.2
product: JA - Asia/Pacific Localizations , user_name: India - Income Tax Act Fixed Asset Schedules (XML) - Not Supported: Reserved For Future Use - Not Supported: Reserved For Future Use , description: India - Income Tax Act Fixed Asset Schedules , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: JAINYEDE 12.2.2
execution_filename: JAINYEDE , product: JA - Asia/Pacific Localizations , user_name: JAINYEDE , description: Depreciation for one year , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Concurrent Program: JACNFPGP 12.2.2
execution_filename: JA_CN_PS_FA_EXP_PKG.Export_Fixed_Asset , product: JA - Asia/Pacific Localizations , user_name: JACNFPGP , description: Fixed Assets Data Generation for Public Sector , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: JACNFPEP 12.2.2
execution_filename: JA_CN_PS_FA_EXP_PKG.Submit_Request , product: JA - Asia/Pacific Localizations , user_name: JACNFPEP , description: China Fixed Assets Data Export for Public Sector , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Table: JAI_FA_AST_BLOCK_H 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FA_AST_BLOCK_H, object_name:JAI_FA_AST_BLOCK_H, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the Asset block transaction history information. , implementation_dba_data: JA.JAI_FA_AST_BLOCK_H ,
Table: JAI_FA_EXEMPTIONS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FA_EXEMPTIONS, object_name:JAI_FA_EXEMPTIONS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the Exemptions corresponding to the FA Asset Blocks , implementation_dba_data: JA.JAI_FA_EXEMPTIONS ,
Table: JAI_FA_AST_BLOCK_H 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FA_AST_BLOCK_H, object_name:JAI_FA_AST_BLOCK_H, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the Asset block transaction history information. , implementation_dba_data: JA.JAI_FA_AST_BLOCK_H ,
Table: JAI_FA_EXEMPTIONS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FA_EXEMPTIONS, object_name:JAI_FA_EXEMPTIONS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the Exemptions corresponding to the FA Asset Blocks , implementation_dba_data: JA.JAI_FA_EXEMPTIONS ,
Table: JAI_FA_AST_BLOCKS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FA_AST_BLOCKS, object_name:JAI_FA_AST_BLOCKS, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores the information regarding the Block of Asset classification. , implementation_dba_data: JA.JAI_FA_AST_BLOCKS ,
Table: JAI_FA_AST_BLOCKS 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FA_AST_BLOCKS, object_name:JAI_FA_AST_BLOCKS, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores the information regarding the Block of Asset classification. , implementation_dba_data: JA.JAI_FA_AST_BLOCKS ,
Table: JAI_RGM_ITEM_GEN_DOCS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RGM_ITEM_GEN_DOCS, object_name:JAI_RGM_ITEM_GEN_DOCS, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores the information regarding documents generated for TCS Processing , implementation_dba_data: JA.JAI_RGM_ITEM_GEN_DOCS ,
Table: JA_CN_COA_NA_EXCEPTIONS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_COA_NA_EXCEPTIONS, object_name:JA_CN_COA_NA_EXCEPTIONS, status:VALID, product: JA - Asia/Pacific Localizations , description: The table 'JA_CN_COA_NA_EXCEPTIONS' stores natural accounts with invalid length. Each row includes column ACCOUNT_SEGMENT, which can identify one natural account. , implementation_dba_data: JA.JA_CN_COA_NA_EXCEPTIONS ,
Table: JA_AU_SRW_TAX_DEPRN_TMP 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_AU_SRW_TAX_DEPRN_TMP, object_name:JA_AU_SRW_TAX_DEPRN_TMP, status:VALID, product: JA - Asia/Pacific Localizations , description: Australian Schedule 32 report temporary table , implementation_dba_data: JA.JA_AU_SRW_TAX_DEPRN_TMP ,
Table: JAI_CMN_RG_COMP_DTLS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_RG_COMP_DTLS, object_name:JAI_CMN_RG_COMP_DTLS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores detailed balances of each excise component for every RG23A/C record , implementation_dba_data: JA.JAI_CMN_RG_COMP_DTLS ,
Table: JAI_PO_OSP_LINE_DTLS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_OSP_LINE_DTLS, object_name:JAI_PO_OSP_LINE_DTLS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the information of the 57F4 Line Details. , implementation_dba_data: JA.JAI_PO_OSP_LINE_DTLS ,
Table: JAI_RGM_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RGM_TAXES, object_name:JAI_RGM_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores tax details for transactions having TCS tax type. , implementation_dba_data: JA.JAI_RGM_TAXES ,
Table: JAI_AP_MATCH_INV_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_MATCH_INV_TAXES, object_name:JAI_AP_MATCH_INV_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of all MISCELLANEOUS distributions added for tax in AP invoice. , implementation_dba_data: JA.JAI_AP_MATCH_INV_TAXES ,
Table: JA_AU_ACCOUNT_DEFAULTS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_AU_ACCOUNT_DEFAULTS, object_name:JA_AU_ACCOUNT_DEFAULTS, status:VALID, product: JA - Asia/Pacific Localizations , description: AutoAccounting setup information , implementation_dba_data: JA.JA_AU_ACCOUNT_DEFAULTS ,
Table: JAI_CMN_RG_SLNOS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_RG_SLNOS, object_name:JAI_CMN_RG_SLNOS, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores the running balance for the RG and PLA registers , implementation_dba_data: JA.JAI_CMN_RG_SLNOS ,
Table: JA_AU_SUBINV_LOC_ASSOCS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_AU_SUBINV_LOC_ASSOCS, object_name:JA_AU_SUBINV_LOC_ASSOCS, status:VALID, product: JA - Asia/Pacific Localizations , description: Subinventory and location associations , implementation_dba_data: JA.JA_AU_SUBINV_LOC_ASSOCS ,
Table: JAI_OM_OE_BOND_REG_DTLS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_OM_OE_BOND_REG_DTLS, object_name:JAI_OM_OE_BOND_REG_DTLS, status:VALID, product: JA - Asia/Pacific Localizations , description: Hold Information about Order/Invoice types , implementation_dba_data: JA.JAI_OM_OE_BOND_REG_DTLS ,
Table: JAI_CMN_RG_BALANCES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_RG_BALANCES, object_name:JAI_CMN_RG_BALANCES, status:VALID, product: JA - Asia/Pacific Localizations , description: Store the current balances of RG23A, RG23C and PLA Registers. , implementation_dba_data: JA.JAI_CMN_RG_BALANCES ,
Table: JA_CN_ACCOUNT_BALANCES_POST_GT 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_ACCOUNT_BALANCES_POST_GT, object_name:JA_CN_ACCOUNT_BALANCES_POST_GT, status:VALID, product: JA - Asia/Pacific Localizations , description: The table 'JA_CN_ACCOUNT_BALANCES' stores beginning balance, period net DR amount, period net CR amount and ending balance for nature account and subsidiary segments by period and currency. , implementation_dba_data: JA.JA_CN_ACCOUNT_BALANCES_POST_GT ,
Table: JAI_RCV_SUBLED_ENTRIES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_SUBLED_ENTRIES, object_name:JAI_RCV_SUBLED_ENTRIES, status:VALID, product: JA - Asia/Pacific Localizations , description: Localization table similar to Base Apps rcv_receiving_sub_ledger. , implementation_dba_data: JA.JAI_RCV_SUBLED_ENTRIES ,
Table: JA_CN_CASH_VALUESETS_ALL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_CASH_VALUESETS_ALL, object_name:JA_CN_CASH_VALUESETS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: The 'JA_CN_CASH_VALUESETS_ALL' stores information to indicate cash related value set for the Chart of Accounts. , implementation_dba_data: JA.JA_CN_CASH_VALUESETS_ALL ,
Table: JAI_OM_OE_GEN_TAXINV_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_OM_OE_GEN_TAXINV_T, object_name:JAI_OM_OE_GEN_TAXINV_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Holds delivery identifier for which excise invoice no. to be generated , implementation_dba_data: JA.JAI_OM_OE_GEN_TAXINV_T ,
Table: JAI_RGM_CONC_REQUESTS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RGM_CONC_REQUESTS, object_name:JAI_RGM_CONC_REQUESTS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores the Requests information submitted for India - Service Tax Processing , implementation_dba_data: JA.JAI_RGM_CONC_REQUESTS ,
Table: JA_CN_ACCOUNT_BALANCES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_ACCOUNT_BALANCES, object_name:JA_CN_ACCOUNT_BALANCES, status:VALID, product: JA - Asia/Pacific Localizations , description: The table 'JA_CN_ACCOUNT_BALANCES_GT' is a global temporary table used by posting journal to balance. , implementation_dba_data: JA.JA_CN_ACCOUNT_BALANCES ,
Table: JAI_FBT_PAYMENT 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_FBT_PAYMENT, object_name:JAI_FBT_PAYMENT, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores the payment information of FBT tax. Its data is mainly populated by the 'India - Fringe Benefit Tax Payment Process' , implementation_dba_data: JA.JAI_FBT_PAYMENT ,
Table: JAI_RCV_RTV_BATCH_TRXS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_RTV_BATCH_TRXS, object_name:JAI_RCV_RTV_BATCH_TRXS, status:VALID, product: JA - Asia/Pacific Localizations , description: RTV Batch Transactions , implementation_dba_data: JA.JAI_RCV_RTV_BATCH_TRXS ,
Table: JAI_AP_TDS_INV_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_INV_TAXES, object_name:JAI_AP_TDS_INV_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores details of all the TDS taxes that are applicable on an invoice. , implementation_dba_data: JA.JAI_AP_TDS_INV_TAXES ,
Table: JAI_AP_TDS_F16_HDRS_ALL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AP_TDS_F16_HDRS_ALL, object_name:JAI_AP_TDS_F16_HDRS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Header information for TDS certificates. , implementation_dba_data: JA.JAI_AP_TDS_F16_HDRS_ALL ,
Table: JAI_CMN_RG_EXC_INV_NOS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_CMN_RG_EXC_INV_NOS, object_name:JAI_CMN_RG_EXC_INV_NOS, status:VALID, product: JA - Asia/Pacific Localizations , description: Stores setup information to generate excise invoice numbers , implementation_dba_data: JA.JAI_CMN_RG_EXC_INV_NOS ,
Table: JA_CN_ACCOUNT_CHILDREN_GT 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_ACCOUNT_CHILDREN_GT, object_name:JA_CN_ACCOUNT_CHILDREN_GT, status:VALID, product: JA - Asia/Pacific Localizations , description: The 'JA_CN_ACCOUNT_CHILDREN_GT' table is a global temporary table on session level, which is to store the relationship of parent account and child account. , implementation_dba_data: JA.JA_CN_ACCOUNT_CHILDREN_GT ,
Table: JAI_PO_RMA_RTN_TX_LNS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_RMA_RTN_TX_LNS, object_name:JAI_PO_RMA_RTN_TX_LNS, status:VALID, product: JA - Asia/Pacific Localizations , description: Holds RMA Return lines Tax Information , implementation_dba_data: JA.JAI_PO_RMA_RTN_TX_LNS ,
Table: JAI_OM_WSH_LINES_ALL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_OM_WSH_LINES_ALL, object_name:JAI_OM_WSH_LINES_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: Capture localization information picking line wise. , implementation_dba_data: JA.JAI_OM_WSH_LINES_ALL ,
Table: JAI_PO_RMA_RTN_LINES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_PO_RMA_RTN_LINES, object_name:JAI_PO_RMA_RTN_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: Holds details about RMA Receipts created by trigger on mtl_material_transactions , implementation_dba_data: JA.JAI_PO_RMA_RTN_LINES ,
Table: JAI_AR_TRX_INS_HDRS_T 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_AR_TRX_INS_HDRS_T, object_name:JAI_AR_TRX_INS_HDRS_T, status:VALID, product: JA - Asia/Pacific Localizations , description: Table stores values pass'g RGentry when manual ARtransaction done for 1st time , implementation_dba_data: JA.JAI_AR_TRX_INS_HDRS_T ,
Table: JAI_OM_OE_RMA_TAXES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_OM_OE_RMA_TAXES, object_name:JAI_OM_OE_RMA_TAXES, status:VALID, product: JA - Asia/Pacific Localizations , description: This table holds the tax details associated with a return order. , implementation_dba_data: JA.JAI_OM_OE_RMA_TAXES ,
Table: JAI_ENCUM_TAX_DETAILS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_ENCUM_TAX_DETAILS, object_name:JAI_ENCUM_TAX_DETAILS, status:VALID, product: JA - Asia/Pacific Localizations , description: This table is used to capture the tax amount used for encumbrance , implementation_dba_data: JA.JAI_ENCUM_TAX_DETAILS ,
Table: JA_CN_CFS_ACTIVITIES_INTERFACE 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_CFS_ACTIVITIES_INTERFACE, object_name:JA_CN_CFS_ACTIVITIES_INTERFACE, status:VALID, product: JA - Asia/Pacific Localizations , description: The 'JA_CN_CFS_ACTIVITIES_INTERFACE' table is the interface table that stores transaction information related to detailed cash flow items, data in the table are based on detailed transactions or transaction lines and belong to a specific le , implementation_dba_data: JA.JA_CN_CFS_ACTIVITIES_INTERFACE ,
Table: JA_CN_ACCOUNTING_CLASSES_ALL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_ACCOUNTING_CLASSES_ALL, object_name:JA_CN_ACCOUNTING_CLASSES_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: The 'JA_CN_ACCOUNTING_CLASSES _ALL' stores information to indicate cash related accounting classes for the Chart of Accounts. , implementation_dba_data: JA.JA_CN_ACCOUNTING_CLASSES_ALL ,
Table: JA_AU_FA_BOOK_CONTROLS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_AU_FA_BOOK_CONTROLS, object_name:JA_AU_FA_BOOK_CONTROLS, status:VALID, product: JA - Asia/Pacific Localizations , description: Balancing charge book controls , implementation_dba_data: JA.JA_AU_FA_BOOK_CONTROLS ,
Table: JAI_RCV_HEADERS 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RCV_HEADERS, object_name:JAI_RCV_HEADERS, status:VALID, product: JA - Asia/Pacific Localizations , description: India Localization Receipts Header Table same as RCV_SHIPMENT_HEADERS , implementation_dba_data: JA.JAI_RCV_HEADERS ,
Table: JA_CN_JOURNAL_NUMBERING 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_JOURNAL_NUMBERING, object_name:JA_CN_JOURNAL_NUMBERING, status:VALID, product: JA - Asia/Pacific Localizations , description: The 'JA_CN_JOURNAL_NUMBERING' table store next available numbers by Legal Entities and GL periods, the 'Account and Journal Itemization Program' program will use this table to generate gapless numbers for GL journals. , implementation_dba_data: JA.JA_CN_JOURNAL_NUMBERING ,
Table: JAI_RGM_REFS_ALL 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JAI_RGM_REFS_ALL, object_name:JAI_RGM_REFS_ALL, status:VALID, product: JA - Asia/Pacific Localizations , description: This table stores transactions with TCS type of Tax. This is a TCS repository , implementation_dba_data: JA.JAI_RGM_REFS_ALL ,