Search Results ap sites all

The document titled "SFM All tables.pdf" pertains to the Oracle E-Business Suite (EBS) modules, specifically focusing on the Subledger Accounting (SLA) and Subledger Accounting Migration (SLAM) components, which are integral to Oracle Financials in versions 12.1.1 and 12.2.2. This document provides a comprehensive overview of the tables associated with the Subledger Accounting Framework (SFM), which is a critical part of Oracle's Financial Accounting Hub (FAH). The SFM framework is designed to standardize accounting rules, automate accounting entries, and ensure compliance with accounting standards across subledgers such as Payables, Receivables, and Assets. ### **Key Tables in SFM Framework** The document outlines the primary tables involved in the SFM framework, categorized into configuration, transaction, and reporting tables. Below is a detailed breakdown: 1. **Configuration Tables** - **XLA_AE_HEADERS**: Stores accounting entry headers, including ledger IDs, accounting dates, and batch details. - **XLA_AE_LINES**: Contains detailed accounting entry lines with debits, credits, and segment values. - **XLA_EVENTS**: Captures accounting events such as invoices, payments, and journal adjustments. - **XLA_TRANSACTION_ENTITIES**: Links subledger transactions (e.g., AP invoices, AR receipts) to accounting events. 2. **Transaction Processing Tables** - **XLA_DISTRIBUTION_LINKS**: Maps subledger distributions (e.g., AP invoice distributions) to accounting entries. - **XLA_ACCOUNTING_ERRORS**: Logs errors encountered during accounting entry generation. - **XLA_ACCOUNTING_EXTRACT**: Temporarily holds extracted accounting data before posting to GL. 3. **Reporting and Reconciliation Tables** - **XLA_ACCOUNTING_UNBALANCES**: Identifies unbalanced accounting entries for troubleshooting. - **XLA_SUBLEDGER_ACCT_REPORTS**: Supports subledger accounting reports for audit and compliance. ### **Functional Workflow in Oracle EBS 12.1.1/12.2.2** The SFM framework follows a structured workflow: 1. **Transaction Capture**: Subledger transactions (e.g., AP invoice) are recorded in modules like Payables. 2. **Event Creation**: The `XLA_EVENTS` table logs accounting events triggered by transactions. 3. **Accounting Rule Application**: Rules defined in `XLA_AE_HEADERS` and `XLA_AE_LINES` generate accounting entries. 4. **Validation & Posting**: Entries are validated (`XLA_ACCOUNTING_ERRORS`) and posted to GL via `GL_INTERFACE`. ### **Migration Considerations (SLAM)** For migrations from legacy systems or upgrades, the SLAM process ensures data integrity by: - Extracting historical transactions into staging tables (`XLA_ACCOUNTING_EXTRACT`). - Transforming data to align with SFM standards. - Loading validated entries into `XLA_AE_HEADERS` and `XLA_AE_LINES`. ### **Conclusion** The "SFM All tables.pdf" document serves as a technical reference for Oracle EBS functional and technical consultants, detailing the schema and interdependencies of SFM tables. Understanding these tables is crucial for configuring accounting rules, troubleshooting issues, and ensuring accurate financial reporting in Oracle EBS 12.1.1 and 12.2.2.

Lookup Type: ALL 12.1.1
product: AR - Receivables , meaning: All , description: All ,
Lookup Type: ALL 12.2.2
product: AR - Receivables , meaning: All , description: All ,
Lookup Type: LABELS SITES 12.2.2
product: AP - Payables , meaning: Labels Sites , description: Sites, e.g. non-pay, to be included in mailing labels ,
File: SFM All tables.pdf 12.2.2
product: XDP - Provisioning , size: 1.69 MBytes , file_type: PDF Diagram ,
Lookup Type: LABELS SITES 12.1.1
product: AP - Payables , meaning: Labels Sites , description: Sites, e.g. non-pay, to be included in mailing labels ,
File: SFM All tables.pdf 12.1.1
product: XDP - Provisioning , size: 1.69 MBytes , file_type: PDF Diagram ,
File: AP Integration R12.pdf 12.1.1
product: ZX - E-Business Tax , size: 18.223 KBytes , file_type: PDF Diagram ,
File: AP Effective Family Contribution.pdf 12.1.1
product: IGF - Financial Aid , size: 22.5 KBytes , file_type: PDF Diagram ,
File: AP Integration R12.pdf 12.2.2
product: ZX - E-Business Tax , size: 18.223 KBytes , file_type: PDF Diagram ,
Index of locally available sites: 12.2.2
File: AP Effective Family Contribution.pdf 12.2.2
product: IGF - Financial Aid (Obsolete) , size: 22.5 KBytes , file_type: PDF Diagram ,
Lookup Type: ALL OR ACTIVE 12.1.1
product: AP - Payables , meaning: All Or Active , description: Vendors Report vendors, sites, contacts selection option ,
Index of locally available sites: 12.1.1
OLAPSYS.CWM2_OLAP_CUBE dependencies on ALL$OLAP_CUBES 12.1.1
OLAPSYS.CWM2_OLAP_METADATA_REFRESH dependencies on ALL$OLAP2_AGG_OPERATOR_USES 12.1.1
OLAPSYS.CWM2_OLAP_DELETE dependencies on ALL$OLAP_CATALOGS 12.1.1
OLAPSYS.CWM2_OLAP_METADATA_REFRESH dependencies on ALL$OLAP1_FACT_LEVEL_USES 12.1.1
OLAPSYS.CWM2_OLAP_DELETE dependencies on ALL$OLAP2_CATALOGS 12.1.1
OLAPSYS.CWM2_OLAP_METADATA_REFRESH dependencies on ALL$OLAP2_AGG_WEIGHTBY_USES 12.1.1
Lookup Type: ALL OR ACTIVE 12.2.2
product: AP - Payables , meaning: All Or Active , description: Vendors Report vendors, sites, contacts selection option ,
SYNONYM: PUBLIC.java/util/regex/Pattern$All 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:java/util/regex/Pattern$All, status:VALID,
SYNONYM: PUBLIC.java/util/regex/Pattern$All 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:java/util/regex/Pattern$All, status:VALID,
JAVA CLASS: SYS.java/util/regex/Pattern$All 12.2.2
owner:SYS, object_type:JAVA CLASS, object_name:java/util/regex/Pattern$All, status:VALID,
Lookup Type: AP_IMPORT_OPTIONS 12.1.1
product: AP - Payables , meaning: Payables import options , description: Suppliers and Sites Open Interface Import program options ,
Lookup Type: AP_IMPORT_OPTIONS 12.2.2
product: AP - Payables , meaning: Payables import options , description: Suppliers and Sites Open Interface Import program options ,
JAVA CLASS: SYS.java/util/regex/Pattern$All 12.1.1
owner:SYS, object_type:JAVA CLASS, object_name:java/util/regex/Pattern$All, status:VALID,
APPS.IGI_CIS2007_IGIPVERP_PKG dependencies on AP_SUPPLIER_SITES_ALL 12.2.2
APPS.IGI_CIS2007_IGIPVERP_PKG dependencies on AP_SUPPLIER_SITES_ALL 12.1.1
APPS.IGI_CIS2007_IGIPVERP_PKG dependencies on AP_SUPPLIER_SITES 12.2.2
APPS.IGI_CIS2007_IGIPVERP_PKG dependencies on AP_SUPPLIER_SITES 12.1.1
APPS.POS_PROFILE_PKG dependencies on FND_LOG 12.1.1
APPS.POS_PROFILE_PKG dependencies on FND_LOG 12.2.2
Concurrent Program: APXSSIMP_XML 12.2.2
product: AP - Payables , user_name: Supplier Sites Open Interface Import (XML) - Not Supported: Reserved For Future Use , description: Supplier Sites Open Interface Import , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: APXSSIMP_XML 12.1.1
product: AP - Payables , user_name: Supplier Sites Open Interface Import (XML) - Not Supported: Reserved For Future Use , description: Supplier Sites Open Interface Import , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
Concurrent Program: APXSSIMP 12.2.2
execution_filename: APXSSIMP , product: AP - Payables , user_name: Supplier Sites Open Interface Import , description: Supplier Sites Open Interface Import , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: NEW VENDOR OR NEW SITE 12.1.1
product: AP - Payables , meaning: New Vendor Or New Site , description: New vendor or new vendor site report ,
Lookup Type: CS_SR_ADDR_FILTER_OPTION 12.2.2
product: CS - Service , meaning: Service: Address Filter Options , description: This lookup is used to define codes for Profile Service: Address Filter Options ,
Lookup Type: NEW VENDOR OR NEW SITE 12.2.2
product: AP - Payables , meaning: New Vendor Or New Site , description: New vendor or new vendor site report ,
Lookup Type: SITE_TYPE 12.2.2
product: PO - Purchasing , meaning: Ship-To/Bill-To/Office/All select criteria , description: Ship-To/Bill-To/Office/All select criteria ,
Concurrent Program: APXSSIMP 12.1.1
execution_filename: APXSSIMP , product: AP - Payables , user_name: Supplier Sites Open Interface Import , description: Supplier Sites Open Interface Import , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
Lookup Type: SITE_TYPE 12.1.1
product: PO - Purchasing , meaning: Ship-To/Bill-To/Office/All select criteria , description: Ship-To/Bill-To/Office/All select criteria ,
PACKAGE BODY: APPS.IGI_CIS2007_IGIPVERP_PKG 12.1.1
PACKAGE BODY: APPS.IGI_CIS2007_IGIPVERP_PKG 12.2.2
Table: AP_SUPPLIER_INT_REJECTIONS 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_SUPPLIER_INT_REJECTIONS, object_name:AP_SUPPLIER_INT_REJECTIONS, status:VALID, product: AP - Payables , description: Contains suppliers, sites, contacts rejections information. , implementation_dba_data: AP.AP_SUPPLIER_INT_REJECTIONS ,
Table: AP_SUPPLIER_INT_REJECTIONS 12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_SUPPLIER_INT_REJECTIONS, object_name:AP_SUPPLIER_INT_REJECTIONS, status:VALID, product: AP - Payables , description: Contains suppliers, sites, contacts rejections information. , implementation_dba_data: AP.AP_SUPPLIER_INT_REJECTIONS ,
TABLE: AP.AP_VENDOR_KEY_IND_ALL 12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_VENDOR_KEY_IND_ALL, object_name:AP_VENDOR_KEY_IND_ALL, status:VALID,
Lookup Type: CARD TYPE 12.2.2
product: AP - Payables , meaning: Card Type , description: Credit card type ,
Lookup Type: CARD TYPE 12.1.1
product: AP - Payables , meaning: Card Type , description: Credit card type ,
MATERIALIZED VIEW: APPS.IBE_BI_MSITEORG_MV 12.1.1
Lookup Type: RRS_SEC_SITE_GRP_CRITERIA 12.2.2
product: RRS - Site Management , meaning: Site Security Grouping Criteria , description: Site Security Grouping Criteria ,