Web ADI Errors & Solutions

Error1:
Exception Name: oracle.apps.bne.exception.BneFatalException
Cause: Microsoft VBScript runtime error: 429. ActiveX component can't create object 
Solution for Error1: 
Do the setup changes in IE
1. On the Tools menu -> Internet Options -> Security tab and press the Custom Level button.
2. Set "Initialize and script ActiveX controls not marked as safe" to "Prompt".
3. Press 'OK' button after that press 'APPLY' button.

Error2:
Exception Name: oracle.apps.bne.exception.BneFatalException
Cause: Line 85 - Programmatic access to Visual Basic Project is not trusted
Solution for Error2:
Open excel -> Click on File -> Click on Options -> On the bottom left click on "Trust Center" -> On the bottom right click on "Trust Center Settings" button -> On the left click on "Macro Settings" -> on the right "Check" "Trust access to the VBA project object model" -> Click on OK -> Again click on OK button 

Error3:
Exception Name: oracle.apps.bne.exception.BneFatalException
Cause: Line 5397 - Cannot run the macro 'BneMain.SetSessionID'. The macro may be not be available in this workbook or all macros may be disabled.
Solution for Error3:
Check whether you are using 64 bit Microsoft Excel version. You need to uninstall 64bit MS Office and install 32 bit MS Office. (File -> Help, to check the Microsoft Excel version)

Error4:
Viewer "Excel 2010" is not showing in the list.
Solution for Error4:
Customers who are on R12.0.6 version of apps, please apply patch 10190536:R12.BNE.A
Customers who are on R12.1.1 version of apps, please apply patch 10107918:R12.BNE.B
Customers who are on R12.1.2 version of apps, please apply patch 10130099:R12.BNE.B
Customers who are on R12.1.3 version of apps, please apply patch 10108052:R12.BNE.B

Error5:
When clicking on Create Document Excel file opens with following message
Protected View This file was opened from a potentially unsafe location. Click for more details

When click on 'Enable Editing'
Security Warning Macros have been disabled

Solution for Error5:
File > Options > Trust Center > Trust Center Settings > Protected View > Disable following 3 options.

Error6:
When you click on Create Document, Accounting Flex Field Segment Columns width is squeezed.
Solution for Error6:
Apply Patch 12947598
Refer following Note for additional details.
Web ADI Account Segment Columns Width not increasing individual KFF Segments width [ID 1377692.1]

Error 7:
Viewer : null
Viewer application profile is not set.

Solution for Error7:
Set the profile option GL : Default Desktop Viewer
Navigation: System Administrator > Profile > System

Error 8:
BNE_UIX_PHYSICAL_DIRECTORY is not configured

Solution for Error8:
Remove value for the profile BNE UIX Physical Directory

Error 9:
While uploading through webADI, it gives the success message that all the rows have got uploaded, but when checked from the application, it skips the rows randomly. 
Green smiley face appears [No Error] on this line even if it skips loading
Solution for Error9:
Apply patch 9090447 [For 12.1.3 version]

Error 10:
Unable To Create New Document In Web ADI and screen hangs saying "Verifying WebADI.xls from ..."
Solution for Error10:
Internet Explorer > Tools > Internet Options > Security > Clik on Custom level > Under Scripting > Enable "Allow status bar updates via script"

Error 11: (Excel 2010, IE11, Windows7)
1. Select "Open/Save" when prompted to "Do you want to open or save WebADI.xls from <server>?"
2. Get a warning "Protected View Offices has detected a problem with this file. Editing it may harm your computer. Click for more details"
3. Click on the "Click for more details"
4. Get another warning about why MS opened in protected view. Click on Edit Anyway.

5. Get the "Run-time error '91'; Object variable or With block variable not set" error message.
Solution for Error 11:
In Microsoft Excel, verify the following:

Click ' File' -> 'Options'
Click 'Trust Center' link in the 'Excel Options' window.
Click 'Trust Center Settings...' button.
In the 'Trust Center' window click 'Macro Settings' link from the menu on the left.
Under 'Macro Settings' check 'Disable all macros with notification'.
Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'.
Click 'OK' button to close the 'Trust Center' window.
Click 'OK' button to return to the spreadsheet.
Then retest 

How to join GL tables with XLA (SubLedger Accounting) tables

GL_JE_BATCHES (je_batch_id)                            => GL_JE_HEADERS (je_batch_id)
GL_JE_HEADERS (je_header_id)                           => GL_JE_LINES (je_header_id)
GL_JE_LINES (je_header_id,  je_line_num)               => GL_IMPORT_REFERENCES (je_header_id, je_line_num)
GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id) => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id)
XLA_AE_HEADERS (application_id, event_id)              => XLA_EVENTS (application_id, event_id)   
XLA_AE_LINES (application_id, ae_header_id)            => XLA_AE_HEADERS (application_id, ae_header_id) 
XLA_EVENTS (application_id, entity_id)                 => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id)








The source_id_int_1 column of xla.xla_transaction_entities stores the primary_id value for the transactions. You can join the xla.xla_transaction_entities table with the corresponding transactions table for obtaining additional information of the transaction. For e.g you join the xla.xla_transaction_entities table with ra_customer_trx_all for obtaining receivables transactions information or with mtl_material_transactions table for obtaining material transactions information.

The entity_id mappings can be obtained from the XLA_ENTITY_ID_MAPPINGS table

Oracle Subledger Accounting (SLA) Tables, Views

Oracle Subledger Accounting (SLA) Tables, Views

Oracle Subledger Accounting Tables:

TABLE NAME	DESCRIPTION
XLA_AAD_GROUPS	The XLA_AAD_GROUPS table stores the merge dependencies analyzed during the merge analysis.  All application accounting definitions with the same GROUP_NUM must be merged together.
XLA_AAD_HDR_ACCT_ATTRS	The XLA_AAD_HDR_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the AAD level.
XLA_AAD_HEADER_AC_ASSGNS	Store the analytical criteria for the application accounting definitions.
XLA_AAD_LINE_DEFN_ASSGNS	This table stores the journal lines definitions for the application accounting definitions.
XLA_AAD_LOADER_DEFNS_T	The XLA_AAD_LOADER_DEFNS_T table is the interface table that facilitates the data transfer from data files and the database.
XLA_AAD_LOADER_LOGS	The XLA_AAD_LOADER_LOGS table stores the errors and logs generated by the application accounting definitions loader.
XLA_AAD_SOURCES	XLA_AAD_SOURCES table stores a list of sources used by an Application Accounting Definition.  The table captures sources used by each event class within the Application Accounting Definition.
XLA_AADS_GT	The XLA_AADS_GT table stores modified AMB Components.
XLA_AADS_H	The XLA_AADS_H table stores the history of the application accounting definitions.  The history is updated when the application accounting definitions are exported.
XLA_AC_BAL_INTERIM_GT	Intermediate table used for Balance Computation
XLA_AC_BALANCES
XLA_AC_BALANCES_INT	Supporting Reference Balances Interface table for importing initial balances
XLA_ACCOUNTING_ERRORS	The XLA_ACCOUNTING_ERRORS table stores the errors encountered during execution of the Accounting Program.
XLA_ACCT_ATTRIBUTES_B	The XLA_ACCT_ATTRIBUTES_B table captures accounting attributes available to the end users. Accounting attributes are pre-defined by the Oracle Subledger Accounting Architecture. Oracle Subledger Accounting Architecture has identified accoun
XLA_ACCT_ATTRIBUTES_TL	The XLA_ACCT_ATTRIBUTES_TL table captures translated values for the accounting attributes. Accounting attributes are pre-defined by Subledger Accounting. Accounting attributes are necessary to complete specific processing associated with th
XLA_ACCT_CLASS_ASSGNS	This table stores the accounting class assignments for the Post-Accounting Programs.
XLA_ACCT_LINE_TYPES_B	The XLA_ACCT_LINE_TYPES_B table stores line accounting types for an event class.
XLA_ACCT_LINE_TYPES_TL	The XLA_ACCT_LINE_TYPES_TL table stores translated information about accounting line type definitions.
XLA_ACCTG_METHOD_RULES	The XLA_ACCTG_METHODS_RULES table stores the assignments for all Application Accounting Definitions (AAD) within each Subledger Accounting Method.
XLA_ACCTG_METHODS_B	The XLA_ACCTG_METHODS_B table stores Subledger Accounting Methods (SLAM) across products. SLAMs provided by development are not chart of accounts specific. Enabled SLAMs are assigned to ledgers.
XLA_ACCTG_METHODS_TL	The XLA_ACCTG_METHODS_TL table stores translated information about Subledger Accounting Methods.
XLA_AE_HEADER_ACS	This table stores the relationship between the subledger journal entry lines and the supporting reference detail values.
XLA_AE_HEADERS	The XLA_AE_HEADERS table stores subledger journal entries.  There is a one-to-many relationship between accounting events and journal entry headers.
XLA_AE_HEADERS_GT
XLA_AE_LINE_ACS	This table stores the relationship between the subledger journal entry lines and the analytical detail values.
XLA_AE_LINES	The XLA_AE_LINES table stores the subledger journal entry lines.   There is a one-to-many relationship between subledger journal entry headers and subledger journal entry lines.
XLA_AE_LINES_GT
XLA_AE_SEGMENT_VALUES	The XLA_AE_SEGMENT_VALUES table stores information about the balancing or management segment values associated with the journal entry.
XLA_AMB_COMPONENTS_H	The XLA_AMB_COMPONENTS_H table stores the history of the non-application specific journal entry setups, i.e. analytical criteria and mapping sets. The history is updated when the components are exported.
XLA_AMB_SETUP_ERRORS	The XLA_AMB_SETUP_ERRORS table stores errors reported by the Create and Assign Source program and the Application Accounting Definition validation program.
XLA_AMB_UPDATED_COMPS	The XLA_AMB_UPDATED_COMPS table stores the application accounting definitions and journal entry setups that has been updated.
XLA_ANALYTICAL_ASSGNS	The XLA_ANALYTICAL_ASSGNS table stores the assignment between the Analytical Criteria and the Application Accounting Definition headers or the Application Accounting Definition lines.
XLA_ANALYTICAL_BALANCES	The XLA_ANALYTICAL_BALANCES table stores the balances for each analytical criterion.
XLA_ANALYTICAL_DTL_VALS	The XLA_ANALYTICAL_DTL_VALS table stores the existing values for the analytical criteria details based on the actual data on the sources for each subledger journal entry line. For example, if the analytical criterion 'Project Expense' has o
XLA_ANALYTICAL_DTLS_B	The XLA_ANALYTICAL_DTLS_B table stores the translated header information (name and description) for the Analytical Criteria.
XLA_ANALYTICAL_DTLS_TL	The XLA_ANALYTICAL_DTLS_TL table stores the detail information for the Analytical Criterion.
XLA_ANALYTICAL_HDRS_B	This table stores the header information for the Analytical Criteria. Since some analytical criteria are delivered as seeded data by the product teams, the name and the description are subjected to translation, so there are two tables for t
XLA_ANALYTICAL_HDRS_TL	The XLA_ANALYTICAL_HDRS_TL table stores the translated header information (name and description) for the Analytical criteria.
XLA_ANALYTICAL_SOURCES	The XLA_ANALYTICAL_SOURCES table stores the assignment between the Analytical Criteria detail and the sources.
XLA_APPLI_AMB_CONTEXTS	The XLA_APPLI_AMB_CONTEXTS table stores the information for the application and the AMB contexts.
XLA_ASSIGNMENT_DEFNS_B	This table stores the ledger assignments for the Post-Accountng Programs.
XLA_ASSIGNMENT_DEFNS_TL	This table stores the translated columns for accounting class ledger assignments.
XLA_BAL_AC_CTRBS_GT
XLA_BAL_CONCURRENCY_CONTROL	Table used for locking purpose in balances
XLA_BALANCE_STATUSES	The XLA_BALANCE_STATUSES table stores the status of the balance for a code combination Id and allows the simultaneous execution of the balance calculation, the balance recreation and the balance synchronization. For more details on the tran
XLA_CONDITIONS	The XLA_CONDITIONS table stores the conditions for an accounting line or header types, segment rules and descriptions.
XLA_CONDITIONS_T	Interface table to load the conditions associated to the ADR rule details into SLA.
XLA_CONTROL_BALANCES	The XLA_CONTROL_BALANCES table stores the balances for each third party control account.
XLA_CTRL_BAL_INTERIM_GT	This table stores the interim-summarized data from the transactions (XLA_AE_LINES).
XLA_CTRL_BALANCES_INT	The temporary table stores the balances for each third party control account.
XLA_DESC_PRIORITIES	The XLA_DESc_PRIORTIES table stores priority information about descriptions
XLA_DESCRIPT_DETAILS_B	The XLA_DESCRIPT_DETAILS_B table stores the details of a description. It holds a string of literal and sources in the sequence in which they should appear in the description.A flexfield segment can be specified only if TRANSACTION_COA_ID is
XLA_DESCRIPT_DETAILS_TL	The XLA_DESCRIPT_DETAILS_TL table stores the translation details of a description.
XLA_DESCRIPTIONS_B	The XLA_DESCRIPTIONS_B table stores all descriptions created for an application. These descriptions are then attached to accounting header and line types.
XLA_DESCRIPTIONS_TL	The XLA_DESCRIPTIONS_TL table stores translated information about the descriptions.
XLA_DIAG_EVENTS	Events processed by the diagnostic framework.
XLA_DIAG_LEDGERS	Ledgers processed by the diagnostic framework.
XLA_DIAG_SOURCES	Source values retrieved by the diagnostic framework from the Transaction Objects.
XLA_DISTRIBUTION_LINKS	The XLA_DISTRIBUTION_LINKS table stores the link between transactions and subledger journal entry lines.
XLA_ENTITY_ID_MAPPINGS	The XLA_ENTITY_ID_MAPPINGS table stores the mapping of the primary key columns of the entity table of the event table. It contains one row for each entity for which a maximum of four primary keys columns are supported. Each row includes the
XLA_ENTITY_TYPES_B	The XLA_ENTITY_TYPES_B table stores all event entities that are used to group event classes.
XLA_ENTITY_TYPES_TL	The XLA_ENTITY_TYPES_TL table record translated information related to entity.
XLA_EVENT_CLASS_ATTRS	The XLA_EVENT_CLASSES_ATTR table stores generic or specific attributes related to event classes.
XLA_EVENT_CLASS_GRPS_B	The table XLA_EVENT_CLASS_GRPS_B record groups of event classes for processing purpose.
XLA_EVENT_CLASS_GRPS_TL	The table XLA_EVENT_CLASS_GRPS_TL record translated information about event class groups.
XLA_EVENT_CLASS_PREDECS	This table stores the predecessors of the event classes.
XLA_EVENT_CLASSES_B	The XLA_EVENT_CLASSES_B table stores all event classes for an entity.
XLA_EVENT_CLASSES_TL	The XLA_EVENT_CLASSES table record translated information related to event classes.
XLA_EVENT_MAPPINGS_B	The XLA_EVENT_MAPPINGS_B table stores information to build reports based on information available on the base document.It contains a row for each column name to be printed on these reports.
XLA_EVENT_MAPPINGS_TL	The XLA_EVENT_MAPPINGS_TL table record translated information related to event mappings.
XLA_EVENT_SOURCES	The XLA_EVENT_SOURCES table stores all sources assigned to an event class or an event entity.
XLA_EVENT_TYPES_B	The XLA_EVENT_TYPES_B table stores all event types that belong to an event class.
XLA_EVENT_TYPES_TL	The XLA_EVENT_TYPES_TL table stores translated information about event types.
XLA_EVENTS	The XLA_EVENTS table record all information related to a specific event. This table is created as a type XLA_ARRAY_EVENT_TYPE.
XLA_EVENTS_INT_GT	It is an interface table used to create accounting events in bulk.It is a temporary table. The information in this table is deleted upon COMMIT.
XLA_EVT_CLASS_ACCT_ATTRS	The XLA_EVT_CLASS_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the event class level.
XLA_EVT_CLASS_ORDERS_GT
XLA_EVT_CLASS_SOURCES_GT
XLA_EXTRACT_OBJECTS	It stores the extract object name and type used by the Accounting Program to derive sources for an event class.
XLA_GL_LEDGERS	This table contains ledger information used by subledger accounting.
XLA_GL_TRANSFER_BATCHES_ALL	Transferred Batches History Table.  Maintains the log of the transfers submitted.
XLA_GL_TRANSFER_PROGRAM_LINES	GL Transfer program definition details.
XLA_GL_TRANSFER_PROGRAMS	GL Transfer program definition. Stores runtime parameters for a transfer program.
XLA_HISTORIC_CONTROL
XLA_HISTORIC_MAPPING_GT
XLA_JE_CATEGORIES	This table stores Journal Categories for a combination of an event class and an application.
XLA_JE_LINE_TYPES	This table holds information for journal entry line types.
XLA_JLT_ACCT_ATTRS	The XLA_JLT_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the Journal Line Type level.
XLA_LAUNCH_OPTIONS	The XLA_LAUNCH_OPTIONS table stores the defaults for accounting program launch options for an application and a ledger. For applications that support valuation method accounting, these default options are stored for a primary and secondary
XLA_LEDGER_OPTIONS	This table stores the ledger level default setup information for an application.
XLA_LINE_ASSGNS_T	Interface table to load the assignments between ADR rules and journal line types.
XLA_LINE_DEFINITIONS_B	This table stores the journal lines definitions for an application.
XLA_LINE_DEFINITIONS_TL	This table stores translated information about journal lines definitions.
XLA_LINE_DEFN_AC_ASSGNS	This table stores the analytical criteria assigned to the journal lines definitions.
XLA_LINE_DEFN_ADR_ASSGNS	This table stores the account derivation rules assigned to the journal lines definitions.
XLA_LINE_DEFN_JLT_ASSGNS	This table stores the journal line types assigned to the journal lines definitions.
XLA_MAPPING_SET_VALUES	The XA_MAPPING_SET_VALUES table store the mapping of account or segment values to a source value for a mapping set.
XLA_MAPPING_SETS_B	The XLA_MAPPING_SETS_B table stores Mapping Sets created by End Users. These mapping sets are then used in the definition of account derivation rules.
XLA_MAPPING_SETS_TL	The XLA_MAPPING_SETS_TL table stores all translated information about mapping sets.
XLA_MERGE_SEG_MAPS	This table stores the segment mapping for third party merge
XLA_MPA_HEADER_AC_ASSGNS	This table stores the analytical criteria assigned to a multiperiod header.
XLA_MPA_JLT_AC_ASSGNS	This table stores the analytical criteria for a multiperiod journal line type.
XLA_MPA_JLT_ADR_ASSGNS	This table stores the account derivation rules for a multiperiod journal line type.
XLA_MPA_JLT_ASSGNS	This table stores the multiperiod journal line type assignments.
XLA_PARTIAL_MERGE_TXNS	This table stores the transactions to be processed for a partial third party merge
XLA_POST_ACCT_PROGS_B	This table stores the Post-Accounting Programs.
XLA_POST_ACCT_PROGS_TL	This table stores the translated columns for the Post-Accounting Programs.
XLA_PROD_ACCT_HEADERS	The XLA_PROD_ACCT_HEADERS table optionally stores the accounting headers types for a Application Accounting Definition and event class or type. If not specified, a flag must be set to indicate that no accounting is required for the combinat
XLA_PROD_ACCT_LINES	The XLA_PROD_ACCT_LINES table stores all accounting line types for Application Accounting Definition and event type or class combinations.
XLA_PROD_SEG_RULES	The XLA_PROD_SEG_RULES table stores all account derivation rules attached to an accounting line type and a product rule.
XLA_PRODUCT_RULES_B	The XLA_PRODUCT_RULES_B table stores the accounting rules for an application. Standard product accounting rules are  independent of a chart of .accounts.
XLA_PRODUCT_RULES_TL	The XLA_PRODUCT_RULES_TL table stores translated information about Application Accounting Definitions.
XLA_RC_UPGRADE_RATES	This table holds the conversion rates used during Secondary or ALC ledger upgrade
XLA_REFERENCE_OBJECTS	This table sotores reference objects.
XLA_REVERSE_EVENTS_INTERFACE	The XLA_REVERSE_EVENTS_INTERFACE table stores records for accounting events that are to be reversed in bulk.  The Bulk Reversal Event API reverses all these events in one run.
XLA_RULE_DETAILS_T	Interface table to load ADR rule details into SLA.
XLA_RULES_T	Interface table to load ADR rules into SLA.
XLA_SEG_RULE_DETAILS	The XLA_SEG_RULE_DETAILS table store details for an account derivation rule. It defines the priority in which the rule should be applied if the conditions for that priority are met.
XLA_SEG_RULES_B	The XLA_SEG_RULES_B table stores all account derivation. These account derivation rules are then attached to an accounting line type
XLA_SEG_RULES_TL	The XLA_SEG_RULES_TL table stores translated information about segment rules.
XLA_SOURCE_PARAMS	The XLA_SOURCE_PARAMS table stores all parameters used in the plsql function for a user-defined source.
XLA_SOURCES_B	The XLA_SOURCES_B table stores all sub-ledgers sources and sources customized by user. These sources are used to create accounting rules and conditions
XLA_SOURCES_TL	The XLA_SOURCES_TL table stores translated information about sources.
XLA_STAGE_ACCTG_METHODS	The XLA_STAGE_ACCTG_METHODS table stores the subledger accounting methods imported from the data file to the staging area of an AMB context.
XLA_STAGING_COMPONENTS_H	The XLA_STAGING_COMPONENTS_H table stores the history of the application accounting definitions and the non-application specific journal entry setups, i.e. analytical criteria and mapping sets, imported from the data file to the staging are
XLA_SUBLEDGERS	The XLA_SUBLEDGERS stores information that depend on the application. It includes a row for each application, standard or not, supported by XLA.
XLA_TAB_ACCT_DEF_DETAILS	The XLA_TAB_ACCT_DEF_DETAILS table stores the intersection of Transaction Account Definitions, Transaction Account Types and Account Derivation Rules.
XLA_TAB_ACCT_DEFS_B	The XLA_TAB_ACCT_DEFS_B table stores all Transaction Account Definitions.
XLA_TAB_ACCT_DEFS_TL	The XLA_TAB_ACCT_DEFS_TL table stores translated name and description for Transaction Account Definitions.
XLA_TAB_ACCT_TYPE_SRCS	The XLA_TAB_ACCT_TYPE_SRCS table stores all Transaction Account Type Sources.
XLA_TAB_ACCT_TYPES_B	The XLA_TAB_ACCT_TYPES_B table stores all Transaction Account Types.
XLA_TAB_ACCT_TYPES_TL	The XLA_TAB_ACCT_TYPES_TL table stores translated name and description for Transaction Account Types.
XLA_TB_BALANCES_GT	Global temporary table to store the trial balance upgraded balance information.
XLA_TB_DEF_SEG_RANGES	This tables stores segment ranges generated based on Open Account Balances Listing report definition details.
XLA_TB_DEFINITIONS_B	This table stores Open Account Balances Listing definitions.
XLA_TB_DEFINITIONS_TL	This table stores translated information of the Open Account Balances Listing report definitions.
XLA_TB_DEFN_DETAILS	This table stores the Open Account Balances Listing report definition details
XLA_TB_DEFN_JE_SOURCES	This table stores journal sources associated with the Open Account Balances Listing report definitions.
XLA_TB_LOGS	This table tracks concurrent requests of the Open Account Balances Listing Data Manager.
XLA_TB_USER_TRANS_VIEWS	This table stores user transaction view information.
XLA_TB_WORK_UNITS	This table serves as a work unit table to process open account balances data in parallel.  Accounting entries are split into multiple units based on ledger setups.
XLA_TPM_WORKING_HDRS_T	The journal header identifiers to be processed by third party merge event.
XLA_TRANSACTION_ACCTS_GT
XLA_TRANSACTION_ENTITIES	The table XLA_ENTITIES contains information about sub-ledger document or transactions.
XLA_TRANSFER_LEDGERS	The XLA_TRANSFER_LEDGERS table stores secondary ledgers  processed by the transfer to GL  batch.
XLA_TRANSFER_LOGS	The XLA_TRANSFER_LOGS table stores the transfer to GL log information.  This information is used to recover the failed transfer to GL requests.  The log information is deleted once the transfer the batch is recovered or if the transfer requ
XLA_TRIAL_BALANCES
XLA_TRIAL_BALANCES_GT
XLA_UPG_BATCHES	Upgrade batch information
XLA_UPG_ERRORS	Errors related to upgraded entries
XLA_UPGRADE_DATES	For SLA upgrade: contains start and enddate for a ledger.
XLA_UPGRADE_REQUESTS	For SLA upgrade: stores the parameters for each post upgrade request.
XLA_VALIDATION_LINES_GT

 

Oracle Subledger Accounting Views:

VIEW NAME	DESCRIPTION
XLA_AAD_HDR_ACCT_ATTRS_FVL
XLA_AAD_HEADER_AC_ASSGNS_F_V
XLA_AAD_LINE_DEFN_ASSGNS_F_V
XLA_ACCTG_METHODS_FVL
XLA_ACCTG_METHODS_VL	The view XLA_ACCTG_METHODS_VL returns translated information about accounting method definition.
XLA_ACCTG_METHOD_RULES_FVL
XLA_ACCT_ATTRIBUTES_VL
XLA_ACCT_CLASS_ASSGNS_F_V
XLA_ACCT_LINE_TYPES_FVL
XLA_ACCT_LINE_TYPES_VL
XLA_ACCT_PROG_SEQ_V	This view is used in assigning the completion based sequence numbers to the journal entries generated during a run of accounting program.
XLA_AEL_GL_V
XLA_AEL_SL_V
XLA_AE_HDR_DTL_VALS_V
XLA_AE_HEADERS_V
XLA_AE_LINE_DTL_VALS_V
XLA_ALT_CURR_LEDGERS_V
XLA_ANALYTICAL_ASSGNS_FVL
XLA_ANALYTICAL_DTLS_VL
XLA_ANALYTICAL_HDRS_VL
XLA_APPLICATIONS_V	This view returns untranslated information related to application set with XLA.
XLA_APPLICATIONS_XVL	This view returns translated information related to application set with XLA.
XLA_AP_AEL_SL_V
XLA_AP_INV_AEL_GL_V
XLA_AP_INV_AEL_SL_V
XLA_AP_PAY_AEL_GL_V
XLA_AP_PAY_AEL_SL_V
XLA_AR_ADJ_AEL_GL_V
XLA_AR_ADJ_AEL_SL_MRC_V
XLA_AR_ADJ_AEL_SL_V
XLA_AR_CB_REC_AEL_SL_V
XLA_AR_INV_AEL_GL_V
XLA_AR_INV_AEL_SL_MRC_V
XLA_AR_INV_AEL_SL_V
XLA_AR_REC_AEL_GL_V
XLA_AR_REC_AEL_SL_MRC_V
XLA_AR_REC_AEL_SL_V
XLA_ASSIGNMENT_DEFNS_F_V
XLA_ASSIGNMENT_DEFNS_VL
XLA_DESCRIPTIONS_FVL
XLA_DESCRIPTIONS_VL
XLA_DESCRIPT_DETAILS_FVL
XLA_DESCRIPT_DETAILS_VL
XLA_DIAG_LINES_V	This view retrieves the different extract line numbers for an event identifier stored in XLA_DIAG_SOURCES. This view is defined for the XLA_DIAG_LINE_NUMBERS value set defined for the Transaction Object Diagnostics concurrent request.
XLA_DIAG_NUMBERS_V	This view retrieves the different transaction numbers for an event stored in XLA_DIAG_EVENTS table. This view is defined for the XLA_DIAG_TRANS_NUMBERS value set defined for the Transaction Object Diagnostics concurrent request.
XLA_DIAG_REQUESTS_V	This view retrieves the different Accounting program request identifiers from the XLA_DIAG_LEDGERS table. This view is used by the Transaction Object Diagnostics concurrent request.
XLA_ENTITY_EVENTS_V
XLA_ENTITY_TYPES_FVL
XLA_ENTITY_TYPES_VL
XLA_EVENT_CLASSES_FVL	The view XLA_EVENT_CLASSES_FVL returns entity name and user je category name for the entity code and je category name selected.
XLA_EVENT_CLASSES_VL
XLA_EVENT_CLASS_ATTRS_FVL
XLA_EVENT_CLASS_GRPS_VL
XLA_EVENT_CLASS_PREDECS_F_V	View created to pick up columns from xla_event_class_predecs table and additonal columns to be shown on the form.
XLA_EVENT_MAPPINGS_VL
XLA_EVENT_SOURCES_FVL
XLA_EVENT_TYPES_VL
XLA_EVT_CLASS_ACCT_ATTRS_FVL
XLA_EXTRACT_OBJECTS_V
XLA_FA_AEL_GL_V
XLA_FA_AEL_SL_MRC_V
XLA_FA_AEL_SL_V
XLA_FV_BE_GL_V
XLA_FV_PYA_GL_V
XLA_FV_TC_GL_V
XLA_GL_JE_AEL_V
XLA_GL_LEDGERS_V
XLA_GL_TRANSFER_BATCHES
XLA_INV_AEL_GL_PAC_V
XLA_INV_AEL_GL_V
XLA_INV_AEL_SL_PAC_V
XLA_INV_AEL_SL_V
XLA_JE_CATEGORIES_VL	View displays a list of journal categories that are translated.
XLA_JE_SOURCES_VL
XLA_JLT_ACCT_ATTRS_FVL
XLA_JL_BR_AR_BT_AEL_GL_V
XLA_JL_BR_AR_BT_AEL_SL_V
XLA_JL_FA_AEL_GL_V
XLA_JL_FA_AEL_SL_V
XLA_LEDGER_RELATIONSHIPS_V
XLA_LINE_DEFINITIONS_F_V
XLA_LINE_DEFINITIONS_VL
XLA_LINE_DEFN_AC_ASSGNS_F_V
XLA_LINE_DEFN_ADR_ASSGNS_F_V
XLA_LINE_DEFN_JLT_ASSGNS_F_V
XLA_LNS_AEL_GL_V
XLA_LNS_AEL_SL_V
XLA_LOOKUPS
XLA_MAPPING_SETS_FVL
XLA_MAPPING_SETS_VL
XLA_MO_REPORTING_ENTITIES_V
XLA_MO_REPORTING_ENT_MRC_V
XLA_MPA_HEADER_AC_ASSGNS_F_V	Internal form view for the xla_mpa_header_ac_assgns table.
XLA_MPA_JLT_AC_ASSGNS_F_V	Internal form view for the xla_mpa_header_ac_assgns table
XLA_MPA_JLT_ADR_ASSGNS_F_V	Internal form view for the xla_mpa_jlt_adr_assgns table
XLA_MPA_JLT_ASSGNS_F_V	Internal form view for the xla_mpa_jlt_ac_assgns table
XLA_OKL_AEL_GL_AST_V
XLA_OKL_AEL_GL_CTR_V
XLA_OKL_AEL_GL_QTE_V
XLA_OKL_AEL_GL_TRX_V
XLA_OKL_AEL_SL_V
XLA_OZF_CLA_AEL_GL_V
XLA_OZF_CLA_AEL_SL_V
XLA_OZF_UTL_AEL_GL_V
XLA_OZF_UTL_AEL_SL_V
XLA_PAD_INQ_HEADERS_AC_FVL
XLA_PAD_INQ_HEADERS_FVL
XLA_PAD_INQ_LINES_AC_AF_FVL
XLA_PAD_INQ_LINES_AC_FVL
XLA_PAD_INQ_LINES_AC_SD_FVL
XLA_PAD_INQ_LINES_AC_SS_FVL
XLA_PAD_INQ_LINES_AF_FVL
XLA_PAD_INQ_LINES_AF_SD_FVL
XLA_PAD_INQ_LINES_FVL
XLA_PAD_INQ_LINES_SD_FVL
XLA_PAD_INQ_LINES_SS_FVL
XLA_PAD_INQ_LINES_SUB_FVL
XLA_PAD_INQ_SEG_RULES_FVL
XLA_PA_AEL_DR_MRC_GL_V
XLA_PA_AEL_EI_MRC_GL_V
XLA_PA_DR_AEL_GL_V
XLA_PA_DR_AEL_SL_MRC_V
XLA_PA_DR_AEL_SL_V
XLA_PA_EI_AEL_GL_V
XLA_PA_EI_AEL_SL_MRC_V
XLA_PA_EI_AEL_SL_V
XLA_POST_ACCTG_EVENTS_V
XLA_POST_ACCT_PROGS_F_V
XLA_POST_ACCT_PROGS_VL
XLA_PO_AEL_GL_PAC_V
XLA_PO_AEL_GL_V
XLA_PO_AEL_SL_MRC_V
XLA_PO_AEL_SL_PAC_V
XLA_PO_AEL_SL_V
XLA_PO_ENC_AEL_GL_V
XLA_PRODUCT_RULES_FVL
XLA_PRODUCT_RULES_VL
XLA_PROD_ACCT_HEADERS_FVL
XLA_PROD_ACCT_LINES_FVL
XLA_PROD_HEADER_DESC_FVL
XLA_PROD_SEG_RULES_FVL
XLA_PSA_AP_INV_BC_GL_V
XLA_PSA_BC_LINES_V
XLA_PSA_PO_ENC_BC_GL_V
XLA_PSA_REQ_ENC_BC_GL_V
XLA_REFERENCE_OBJECTS_F_V	This is the base view of the Reference Objects region of the Accounting Event Class Options form.
XLA_REQ_ENC_AEL_GL_V
XLA_SEG_RULES_FVL
XLA_SEG_RULES_VL
XLA_SOURCES_ASSIGNABLE_V
XLA_SOURCES_ASSIGNABLE_XVL
XLA_SOURCES_AVAILABLE_V
XLA_SOURCES_AVAILABLE_XVL
XLA_SOURCES_FVL
XLA_SOURCES_VL
XLA_SUBLEDGERS_FVL
XLA_SUBLEDGER_OPTIONS_V
XLA_TAB_ACCT_DEFS_VL
XLA_TAB_ACCT_TYPES_VL
XLA_TACCOUNTS_V
XLA_TB_DEFINITIONS_VL
XLA_THIRD_PARTIES_V	Third party id, third party type and third party number information
XLA_THIRD_PARTY_SITES_V	third party site information
XLA_WIP_AEL_GL_PAC_V
XLA_WIP_AEL_GL_V
XLA_WIP_AEL_SL_PAC_V
XLA_WIP_AEL_SL_V