R12 Basics SLA

Subledger Accounting

Subledger Accounting (SLA) is a new module in R12 which significantly enhances the accounting support across the E-Business Suite. Subledger Accounting includes new ledger support and enhances the legal entity and intercompany accounting features.

In R12 all accounting entries are generated and passed through Subledger Accounting instead of directly going to GL. This avoids huge amount of time spent on reconciliation since reconciliation is already done from Sub Ledger to General Ledger through SLA.

In R12, SLA provides the ability to retain the full link between transaction and accounting data for all modules, and thus allow auditability. The accounting entries that SLA creates are strongly tied to the underlying transactions.

How is the Accounting behaviour due to SLA in R12 Different from that in 11i?

Let us take the example of the Finance Module to understand the difference between the behaviour of SLA in r12 and base accounting in 11i We will take the example of 3 modules related to Oracle Projects and Financials (payables, receivables and projects).

Refer to the diagram below:

 

R12 Bacis-GL

Oracle GL: Table Name

Global Intercompany System

Advanced Global Intercompany System feature

GL_IEA_AUTOGEN_MAP

GL_IEA_CLEARING_ACCOUNTS

GL_IEA_IMPORT_REGISTRY

GL_IEA_INTERFACE

GL_IEA_RECUR_BATCHES

GL_IEA_RECUR_LINES

GL_IEA_SEGMENT_MAP

GL_IEA_SEGMENT_RULE_MAP

GL_IEA_TRANSACTION_LINES

GL_IEA_TRANSACTION_TYPES

GL_IEA_TRANSACTIONS

GL_INTERCOMPANY_ACC_SETS

GL_INTERCOMPANY_ACCOUNTS

Setup Forms and Programs

GL_MC_BOOK_ASSIGNMENTS

GL_LEDGER_RELATIONSHIPS

GL_MC_CONVERSION_RULES

GL_JE_INCLUSION_RULES

GL_MC_REPORTING_OPTIONS

GL_LEDGER_RELATIONSHIPS

Financial Intelligence

GL_OASIS_FIN_ASSIGNMENTS

GL_OASIS_FIN_ITEMS

GL_OASIS_FIN_METRICS

Balances and Related Objects

GL_OPEN_INTERIM

GL_POSTING_INTERIM

Setup Forms and Programs

GL_SETS_OF_BOOKS

GL_LEDGERS

Financial Intelligence

GL_SHARES_ACTIVITY

GL_SHARES_OUTSTANDING

GL_SYSTEM_SETUP

Relevant columns were moved to the GL: Number of formulas to validate for each MassAllocation batch, GL: Number of formulas to validate for each Recurring Journal batch and GL: Archive Journal Import Data profile options

Revaluation, Translation and Conversion Rates

GL_TRANSLATION_RATES

Setup Forms and Programs

GL_DAILY_RATES

Financial Analyzer

Enterprise Planning and Budgeting product

RG_DSS_DIM_SEGMENTS

RG_DSS_DIMENSIONS

RG_DSS_HIERARCHIES

RG_DSS_HIERARCHY_DETAILS

RG_DSS_REQUESTS

RG_DSS_SEG_RANGE_SETS

RG_DSS_SEG_RANGES

RG_DSS_SYSTEM_SEG_ORDER

RG_DSS_SYSTEM_VARIABLES

RG_DSS_SYSTEMS

RG_DSS_VAR_DIMENSIONS

RG_DSS_VAR_SELECTIONS

RG_DSS_VAR_TEMPLATES

RG_DSS_VARIABLES

New Views

A number of new views have been added to support UIs and processing of new features. Some of the views are mentioned below.

View Name

GL_ACCESS_SET_LEDGERS

Setup Forms and Programs

GL_ALC_LEDGER_RSHIPS_V

Journal Entry

GL_AUTOREV_CRITERIA_SETS_V

Budgets and Related Objects

GL_BUDGET_ASSIGNMENTS_UNIQUE_V

GL_BUDORG_BC_OPTIONS_V

Setup Forms and Programs

GL_DEFAS_ASSIGNMENTS_V

GL_DEFAS_RESP_ASSIGN_V

Balances and Related Objects

GL_ENTERED_CURRENCIES_V

Revaluation, Translation and Conversion Rates

GL_HISTORICAL_RATES_PERIOD_V

Journal Entry

GL_JE_LINES_RECON_V

Setup Forms and Programs

GL_LEDGER_LE_BSV_SPECIFIC_V

GL_LEDGER_LE_V

GL_LEDGER_NAMES_V

GL_LEDGER_NORM_BSVS_V

GL_LEDGER_SET_ASSIGNMENTS_V

GL_LEDGER_SET_NORM_ASSIGN_V

GL_LEDGER_SETS_V

GL_LEDGERS_PUBLIC_ALL_V

GL_LEDGERS_PUBLIC_V

GL_LEDGERS_V

Recurring Journals and Budgets

GL_REC_BATCHES_LOV_V

Setup Forms and Programs

GL_SECONDARY_LEDGER_RSHIPS_V

GL_SETS_OF_BOOKS

Summarization

GL_SUMMARY_BC_OPTIONS_V

GL_SUMMARY_TEMPLATES_V

Revaluation, Translation and Conversion Rates

GL_TRANSLATION_RATES

Changed Views

All views used to support Discoverer workbooks have been updated as necessary to uptake the data model changes. Views that retrieve balances have been updated as necessary to retrieve entered ledger currency balances. A large number of other views have also been updated to uptake various data model changes. Some changed views are highlighted below.

View Name

Setup Forms and Programs

GL_SETS_OF_BOOKS_V

Modify to refer to GL_LEDGERS instead of GL_SETS_OF_BOOKS

Setup Forms and Programs

GL_TAX_CODES_V

Modify to uptake new eTax data model

Obsoleted Views

A number of views related to Global Intercompany System and Oracle Financial Analyzer have been obsoleted. Some other obsolete views are mentioned below.

View Name

Setup Forms and Programs

GL_ALL_JE_CATEGORY_NAME_VIEW

Mass Allocations, Budgets and Encumbrances

GL_ALLOC_BATCHES_ACTIVE_V

Posting

GL_AUTOPOST_OPTIONS_CURRENT_V

Consolidation and Eliminations

GL_CONS_FLEXFIELD_MAP_HIGH

GL_CONS_FLEXFIELD_MAP_LOW

Journal Entry

GL_JE_BATCHES_AP_V

GL_JE_HEADERS_LOV_V

Setup Forms and Programs

GL_MC_BOOKS_ASSIGNMENTS_V

GL_MRC_REPORTING_SOB_PROFILE_V

GL_PERIOD_STATUSES_REV_BUD_V

Revaluation, Translation and Conversion Rates

GL_TRANS_BUDGET_PERIODS_V

GL_TRANS_PERIODS_BSV_V

GL_TRANSLATION_RATES_CURR_V

GL_TRANSLATION_RATES_PERIODS_V

GL_TRANSLATION_RATES_V

GL_TRANSLATION_TRACKING_V

Financial Statement Generator

RG_REPORT_STANDARD_AXES_V

R12 Basics-Payables

Release 12 Oracle E-Business Financials

Oracle Payable:

Supplier has been moved into TCA model. Comparing to 11i version, three new AP tables containing supplier unique data been introduced. They have the links to TCA tables:

AP_SUPPLIERS

AP_SUPPLIER_SITES_ALL

AP_SUPPLIER_CONTACTS

And more important we understood three old PO Vendors tables obsolete, by Views provided for backward compatibility

New Tables

Table Name	Feature Area
CE_BANK_ACCOUNTS	Internal Bank Accounts
CE_PAYMENT_DOCUMENTS	Payment Documents to be used for Printed type Payments
IBY_EXTERNAL_PAYEES_ALL	Payee (Trading Partner Info for paying invoices
IBY_PMT_INSTR_USES_ALL	Used for Remit to Bank Accounts
AP_INVOICE_LINES_ALL	Invoice Lines
AP_ALLOCATION_RULES	Invoice Lines
AP_INVOICE_LINES_ALL	Invoice Lines
AP_ALLOCATION_RULES	Invoice Lines
AP_ALLOCATION_RULE_LINES	Invoice Lines
AP_ALLOCATION_RULE_LINES_GT	Global Temp Table for Invoice Lines – Allocations
AP_SELF_ASSESSED_TAX_DIST_ALL	E-Business Tax
AP_PRODUCT_REGISTRATIONS	Invoice Lines
AP_PRODUCT_SETUP	Multi Org Access Control
AP_TOLERANCE_TEMPLATES	Support of complex PO Contracts
AP_NEGOTIATION_HIST	Invoice Requests
AP_NEGOTIATION_HIST	Holds Resolution Workflow

Changed Tables

Table Name	Feature Area	Brief Description of Change
AP_INVOICES_ALL	Invoice Lines, eBusiness Tax, Payments, SLA, Complex Work POs…	Numerous columns were added to this table due to almost all the projects done for R12, for list of columns added please refer to the TDD of the respective projects.
AP_INVOICE_DISTRIBUTIONS_ALL	Invoice Lines, eBusiness Tax…	Number of columns were added to this table due to almost all the projects done for R12, for list of columns added please refer to the TDD of the respective projects.
AP_INV_APRVL_HIST_ALL	Holds resolution workflow	Hold_ID column was added.
AP_CHECKS_ALL	Payables Payments Data	Some new columns are added to AP_CHECKS_ALL table for maintaining real time synchronization with Oracle Payments and Cash Managements. Some existing columns from the same tables have been made obsolete.
AP_HOLDS_ALL	Holds Resolution Workflow	New Columns Added were: Hold_id and wf_status.
AP_HOLD_CODES	Holds Resolution Workflow	New Columns Added were: hold_instruction, wait_before_notify_days, reminder_days
AP_INV_APRVL_HIST_ALL	Holds Resolution and Invoice Approval Workflow	This will be used to record history for both the Invoice level Approvals and Invoice Line level approvals. New Columns Added were:line_number, hold_id and history_type
AP_APINV_APPROVERS	Invoice Approval Workflow	New Columns Added were:child_process_item_key, child_process_item_type, item_type and item_key.

Obsolete Tables

Table Name	Feature Area	Replaced By
AP_BANK_BRANCHES	Bank/Bank Branches	CE_BANK_BRANCHES_V
AP_BANK_ACCOUNTS_ALL	Bank Accounts including Internal and External	CE_BANK_USES_OU_V/IBY_EXT_BANK_ACCOUNTS_V
AP_BANK_ACCOUNTS_USES_ALL	Remit to Bank Account Uses
AP_CHECK_STOCKS_ALL	Payments Documents	CE_PAYMENT_DOCUMENTS
AP_CHECK_FORMATS	Payments Format
AP_TAX_RECVRY_RULES_ALL	EBusiness Tax	Replaced by relevant EBTax tables/views.
AP_TAX_RECVRY_RATES_ALL	EBusiness Tax	Replaced by relevant EBTax tables/views.
AP_CHRG_ALLOCATIONS_ALL	Invoice Lines - Allocations	This feature is replaced by distributions itself, distributions itself represent the allocation of charges.
AP_TAX_DERIVATIONS	EBusiness Tax	Replaced by relevant EBTax tables/views.
AP_LINE_APRVL_HIST_ALL	Invoice Approval Workflow	AP_INV_APRVL_HIST_ALL

New Views

View Name	Feature Area
CE_BANK_BRANCHES_V	Bank/Branches Info
CE_BANK_ACCT_USES_OU_V	Internal Bank Account Uses Info
IBY_EXT_BANK_ACCOUNTS_V	Remit to Bank Account Info
AP_DOCUMENTS_PAYABLE	This view will store interim payables check and payment schedules information. Based on this view Oracle Payments will process data for formatting and building payment. As described in the “Single Payment real-time Flow” diagrams this view will store real time payables data. As a result of this until or unless payment is created, this view will not contain any data for quick payments.
AP_INVOICE_LINES_V	Invoice Lines project. This is the base view for the Lines block on invoice workbench.
AP_PO_CORRECTIONS_V	PO Corrections.
AP_MATCH_CORRECTION_DISTS_V	Distribution level PO/RCV Corrections.
AP_RECEIPT_CORRECTIONS_V	Receipt Corrections.
AP_ALLOCATION_RULES_V	Invoice Lines - Allocations.

Changed Views

View Name	Feature Area
AP_INVOICES_V	All the columns that were added to the base table due to the various projects were added to this view too.
AP_INVOICE_DISTRIBUTIONS_V	All the columns that were added to the base table due to the various projects were added to this view too.
PO_LINE_LOCATIONS_AP_V	PO Matching
AP_PO_DISTRIBUTIONS_AP2_V	PO Matching at distribution level.
PO_AP_RECEIPT_MATCH_V	Receipt Matching view
AP_APPLY_PREPAYS_V	Invoice Lines – Prepayment Application
AP_UNAPPLY_PREPAYS_V	Invoice Lines – Prepayment Application
AP_WF_APPROVAL_HISTORY_V	Invoice Approval Workflow

Obsolete Views

View Name	Feature Area
AP_BANK_ACCOUNTS	Internal/External Bank Accounts Multi-Org View
AP_BANK_ACCOUNT_USES	External Bank Account Uses Multi-Org View
AP_BANK_ACCOUNT_USES_V	External Bank Accounts Uses Reference View

New Tables TCA Changes for Suppliers

The following are the new tables added in Release 12 as a part of this initiative.

Refer to the Oracle E-Business Suite Electronic Technical Reference Manual for the table and column descriptions..

·         AP_SUPPLIERS

·         AP_SUPPLIER_SITES_ALL

·         AP_SUPPLIER_CONTACTS

·         AP_SUPPLIER_INT_REJECTIONS

New Views

The following are the new views added in Release 12 as a part of this initiative.

These are backwards compatible views that join the Suppliers table in Payables and the TCA tables,

so that any teams using the old suppliers tables have no impact.

·         PO_VENDORS

·         PO_VENDOR_SITES_ALL

·         PO_VENDOR_CONTACTS

The following tables are obsolete:

·         PO_VENDORS

·         PO_VENDOR_SITES_ALL

·         PO_VENDOR_CONTACTS