You are browsing the archive for Oracle Subledger Accounting.

Oracle Subledger Accounting Forms

Oracle Subledger Accounting Forms

FORM SHORT CODE ORACLE FORM NAME
XLAIQACL View Accounting Lines
XLAIQDRL Subledger Accounting Details
XLAABSAM Subledger Accounting Methods
XLAABAPP Subledger Applications
XLAABDEE Event Model
XLAABPRC Process Categories
XLAABDEC Event Classes Attributes
XLAABDSS Seeded Sources
XLAABSSA Source Assignments
XLAABAAA Accounting Attribute Assignments
XLAABDDS Derived Sources
XLAABDLT Journal Line Types
XLAABDAD Journal Entry Descriptions
XLAABDMS Mapping Sets
XLAABADR Account Derivation Rules
XLAABJLD Journal Lines Definitions
XLAABPAD Application Accounting Definitions
XLAABINQ Account Methods Builder Inquiry
XLAABPRG Post-Accounting Programs

Sub Ledger Accounting Tables

Oracle Sub Ledger Accounting Tables:

  • XLA_AAD_GROUPS
  • XLA_AAD_HDR_ACCT_ATTRS
  • XLA_AAD_HEADER_AC_ASSGNS
  • XLA_AAD_LINE_DEFN_ASSGNS
  • XLA_AAD_LOADER_DEFNS_T
  • XLA_AAD_LOADER_LOGS
  • XLA_AAD_SOURCES
  • XLA_ACCOUNTING_ERRORS
  • XLA_ACCTG_METHODS_B
  • XLA_ACCTG_METHODS_TL
  • XLA_ACCTG_METHOD_RULES
  • XLA_ACCT_ATTRIBUTES_B
  • XLA_ACCT_ATTRIBUTES_TL
  • XLA_ACCT_CLASS_ASSGNS
  • XLA_ACCT_LINE_TYPES_B
  • XLA_ACCT_LINE_TYPES_TL
  • XLA_AE_HEADERS
  • XLA_AE_LINES
  • XLA_AE_LINES_GT
  • XLA_AE_SEGMENT_VALUES
  • XLA_AMB_COMPONENTS_H
  • XLA_AMB_SETUP_ERRORS
  • XLA_AMB_UPDATED_COMPS
  • XLA_ANALYTICAL_ASSGNS
  • XLA_ANALYTICAL_BALANCES
  • XLA_ANALYTICAL_DTLS_B
  • XLA_ANALYTICAL_DTLS_TL
  • XLA_ANALYTICAL_DTL_VALS
  • XLA_ANALYTICAL_HDRS_B
  • XLA_ANALYTICAL_HDRS_TL
  • XLA_ANALYTICAL_SOURCES
  • XLA_APPLI_AMB_CONTEXTS
  • XLA_ASSIGNMENT_DEFNS_B
  • XLA_ASSIGNMENT_DEFNS_TL
  • XLA_BALANCE_STATUSES
  • XLA_CONDITIONS
  • XLA_CONDITIONS_T
  • XLA_CONTROL_BALANCES
  • XLA_DESCRIPTIONS_B
  • XLA_DESCRIPTIONS_TL
  • XLA_DESCRIPT_DETAILS_B
  • XLA_DESCRIPT_DETAILS_TL
  • XLA_DESC_PRIORITIES
  • XLA_DIAG_EVENTS
  • XLA_DIAG_LEDGERS
  • XLA_DIAG_SOURCES
  • XLA_DISTRIBUTION_LINKS
  • XLA_ENTITY_ID_MAPPINGS
  • XLA_ENTITY_TYPES_B
  • XLA_ENTITY_TYPES_TL
  • XLA_EVENTS
  • XLA_EVENTS_INT_GT
  • XLA_EVENT_CLASSES_B
  • XLA_EVENT_CLASSES_TL
  • XLA_EVENT_CLASS_ATTRS
  • XLA_EVENT_CLASS_GRPS_B
  • XLA_EVENT_CLASS_GRPS_TL
  • XLA_EVENT_CLASS_PREDECS
  • XLA_EVENT_MAPPINGS_B
  • XLA_EVENT_MAPPINGS_TL
  • XLA_EVENT_SOURCES
  • XLA_EVENT_TYPES_B
  • XLA_EVENT_TYPES_TL
  • XLA_EVT_CLASS_ACCT_ATTRS
  • XLA_EVT_CLASS_ORDERS_GT
  • XLA_EVT_CLASS_SOURCES_GT
  • XLA_EXTRACT_OBJECTS
  • XLA_GL_LEDGERS
  • XLA_GL_TRANSFER_BATCHES_ALL
  • XLA_GL_TRANSFER_PROGRAMS
  • XLA_GL_TRANSFER_PROGRAM_LINES
  • XLA_JE_CATEGORIES
  • XLA_JE_LINE_TYPES
  • XLA_JLT_ACCT_ATTRS
  • XLA_LAUNCH_OPTIONS
  • XLA_LEDGER_OPTIONS
  • XLA_LINE_ASSGNS_T
  • XLA_LINE_DEFINITIONS_B
  • XLA_LINE_DEFINITIONS_TL
  • XLA_LINE_DEFN_AC_ASSGNS
  • XLA_LINE_DEFN_ADR_ASSGNS
  • XLA_LINE_DEFN_JLT_ASSGNS
  • XLA_MAPPING_SETS_B
  • XLA_MAPPING_SETS_TL
  • XLA_MAPPING_SET_VALUES
  • XLA_MERGE_SEG_MAPS
  • XLA_MPA_HEADER_AC_ASSGNS
  • XLA_MPA_JLT_AC_ASSGNS
  • XLA_MPA_JLT_ADR_ASSGNS
  • XLA_MPA_JLT_ASSGNS
  • XLA_PARTIAL_MERGE_TXNS
  • XLA_POST_ACCT_PROGS_B
  • XLA_POST_ACCT_PROGS_TL
  • XLA_PRODUCT_RULES_B
  • XLA_PRODUCT_RULES_TL
  • XLA_PROD_ACCT_HEADERS
  • XLA_PROD_ACCT_LINES
  • XLA_PROD_SEG_RULES
  • XLA_REFERENCE_OBJECTS
  • XLA_RULES_T
  • XLA_RULE_DETAILS_T
  • XLA_SEG_RULES_B
  • XLA_SEG_RULES_TL
  • XLA_SEG_RULE_DETAILS
  • XLA_SOURCES_B
  • XLA_SOURCES_TL
  • XLA_SOURCE_PARAMS
  • XLA_STAGE_ACCTG_METHODS
  • XLA_STAGING_COMPONENTS_H
  • XLA_SUBLEDGERS
  • XLA_TAB_ACCT_DEFS_B
  • XLA_TAB_ACCT_DEFS_TL
  • XLA_TAB_ACCT_DEF_DETAILS
  • XLA_TAB_ACCT_TYPES_B
  • XLA_TAB_ACCT_TYPES_TL
  • XLA_TAB_ACCT_TYPE_SRCS
  • XLA_TB_BALANCES_GT
  • XLA_TB_DEFINITIONS_B
  • XLA_TB_DEFINITIONS_TL
  • XLA_TB_DEFN_DETAILS
  • XLA_TB_DEFN_JE_SOURCES
  • XLA_TB_DEF_SEG_RANGES
  • XLA_TB_LOGS
  • XLA_TB_USER_TRANS_VIEWS
  • XLA_TB_WORK_UNITS
  • XLA_TPM_WORKING_HDRS_T
  • XLA_TRANSACTION_ACCTS_GT
  • XLA_TRANSACTION_ENTITIES
  • XLA_TRANSFER_LEDGERS
  • XLA_TRANSFER_LOGS
  • XLA_TRIAL_BALANCES
  • XLA_UPGRADE_DATES
  • XLA_UPGRADE_REQUESTS
  • XLA_UPG_BATCHES
  • XLA_UPG_ERRORS
  • XLA_VALIDATION_LINES_GT

Subledger Accounting Profile Options

Oracle Subledger Accounting Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
XLA_BAL_BATCH_COMMIT_SIZE SLA: Balances Batch Commit Size
XLA_MO_SECURITY_PROFILE_LEVEL MO: Security Profile
XLA_SHOW_ZERO_AMT_JRNL SLA: Show zero amount journal lines
XLA_MO_TOP_REPORTING_LEVEL MO: Top Reporting Level
XLA_JE_SOURCE_ALLOW_OVERRIDE SLA: Allow Reports Journal Source Override
XLA_DISABLE_GLLEZL SLA: Disable Journal Import
XLA_DEBUG_FILE_OVERRIDE_FILENAME SLA: Trace File Override Filename
XLA_DEBUG_FILE_OVERRIDE_DIRECTORY SLA: Trace File Override Directory
XLA_DEBUG_TRACE SLA: Enable Trace
XLA_DEBUG_PROFILER SLA: Enable PL/SQL Profiler
XLA_DEBUG_OF_MODE SLA: Oracle Forms Trace Mode
XLA_DEBUG_TIMEOUT SLA: Trace Timeout
XLA_DEBUG_SRS_OUTPUT_ENABLE SLA: Enable SRS Log/Output
XLA_DEBUG_TRACE_LEVEL SLA: Trace Level
XLA_DEBUG_SRS_MODE SLA: SRS Trace Mode
XLA_DEBUG_SQLTRACE SLA: Enable SQL Trace
XLA_DEBUG_FILE_FLUSH_OPTION SLA: Flush Trace File
XLA_DEBUG_TRACE_DATETIME SLA: Display Timestamp on Trace
XLA_AMB_CONTEXT SLA: Accounting Methods Builder Context
XLA_USE_LEDGER_SECURITY SLA: Enable Data Access Set Security in Subledger
XLA_USE_TRANSACTION_SECURITY SLA: Enable Subledger Transaction Security in GL
XLA_GL_SECONDARY_ACCESS_SET_ID SLA: Additional Data Access Set
XLA_DIAGNOSTIC_MODE SLA: Enable Diagnostics
XLA_INITIAL_UPGRADE_DATE SLA: INITIAL DATE FOR HISTORICAL UPGRADE
XLA_OA_ORDER_BY SLA: Enable Sorting for Inquiry