XLA_PROD_ACCT_HEADERS

This table optionally contains 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 combination of the Application Accounting Definition and the event class or type.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

XLA_PROD_ACCT_HEADERS_PK

APPLICATION_ID, AMB_CONTEXT_CODE, PRODUCT_RULE_CODE, PRODUCT_RULE_TYPE_CODE, ENTITY_CODE, EVENT_CLASS_CODE, EVENT_TYPE_CODE

Columns

Name Datatype Length Precision Not-null Comments
APPLICATION_ID NUMBER 18 Yes Functional area within a software suite of products. For example, Financials or Payroll.
AMB_CONTEXT_CODE VARCHAR2 30 Yes Accounting methods builder context.
PRODUCT_RULE_TYPE_CODE VARCHAR2 1 Yes Unique abbreviated name assigned to indicate whether the product rule is created by user or predefined by the application.
PRODUCT_RULE_CODE VARCHAR2 30 Yes Application accounting definition code.
ENTITY_CODE VARCHAR2 30 Yes Unique abbreviated name assigned to an entity and used for reporting or in reference to an option.
EVENT_CLASS_CODE VARCHAR2 30 Yes Unique abbreviated name assigned to an event class and used for reporting or in reference to an option.
EVENT_TYPE_CODE VARCHAR2 30 Yes Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.
DESCRIPTION_TYPE_CODE VARCHAR2 1 Indicates whether the description is predefined by subledger application.
DESCRIPTION_CODE VARCHAR2 30 Short name of the elements of a description that appear on the subledger journal header and line. The definition determines both the content and sequence in which the elements of the description appear.
ACCOUNTING_REQUIRED_FLAG VARCHAR2 1 Yes Internal flag. Indicates if accounting is required for this product rule and event class or type.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
VALIDATION_STATUS_CODE VARCHAR2 30 Comment: Indicate the validation status of an event class and event type assignment.
LOCKING_STATUS_FLAG VARCHAR2 1 'N' - Unlocked.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ACCT_RULE_DEFINITION_ID NUMBER 30 Accounting rule definition identifier
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Indexes

Index Uniqueness Tablespace Columns
XLA_PROD_ACCT_HEADERS_N1 Non Unique FUSION_TS_TX_IDX APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, EVENT_TYPE_CODE
XLA_PROD_ACCT_HEADERS_N2 Non Unique FUSION_TS_TX_IDX APPLICATION_ID, AMB_CONTEXT_CODE, DESCRIPTION_TYPE_CODE, DESCRIPTION_CODE
XLA_PROD_ACCT_HEADERS_U1 Unique Default APPLICATION_ID, AMB_CONTEXT_CODE, PRODUCT_RULE_CODE, PRODUCT_RULE_TYPE_CODE, ENTITY_CODE, EVENT_CLASS_CODE, EVENT_TYPE_CODE, ORA_SEED_SET1
XLA_PROD_ACCT_HEADERS_U11 Unique Default APPLICATION_ID, AMB_CONTEXT_CODE, PRODUCT_RULE_CODE, PRODUCT_RULE_TYPE_CODE, ENTITY_CODE, EVENT_CLASS_CODE, EVENT_TYPE_CODE, ORA_SEED_SET2