XLA_AMB_SETUP_ERRORS
This table contains errors reported by the Create and Assign Source program and the Activate Journal Entry Rule Set program.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
XLA_AMB_SETUP_ERRORS_PK |
AMB_ERROR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AMB_ERROR_ID | NUMBER | Yes | Not currently used. | ||
| MESSAGE_NAME | VARCHAR2 | 30 | Yes | Gives the message name of the error or warning message. | |
| MESSAGE_TYPE_FLAG | VARCHAR2 | 1 | Yes | Describes whether it is a warning or error. | |
| CATEGORY_SEQUENCE_NUM | NUMBER | Yes | Describes the order in which the messages will be displayed. How is this column populated. How do you know how to order these categories. | ||
| MESSAGE_CATEGORY_CODE | VARCHAR2 | 30 | Yes | Describes the category of the message. | |
| APPLICATION_ID | NUMBER | Yes | Functional area within a software suite of products. For example, Financials or Payroll. | ||
| AMB_CONTEXT_CODE | VARCHAR2 | 30 | Internal development context of subledger accounting rule. | ||
| PRODUCT_RULE_TYPE_CODE | VARCHAR2 | 1 | Owner for the application accounting definition. | ||
| PRODUCT_RULE_CODE | VARCHAR2 | 30 | Code for the application accounting definition. | ||
| ENTITY_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an entity and used for reporting or in reference to an option. | ||
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an event class and used for reporting or in reference to an option. | ||
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. | ||
| ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | 1 | Indicates whether the journal line rule is seeded. | ||
| ACCOUNTING_LINE_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to a journal line rule and used for reporting or in reference to an option. | ||
| DESCRIPTION_TYPE_CODE | VARCHAR2 | 1 | Indicates whether the description rule is seeded. | ||
| 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. | ||
| ANALYTICAL_CRITERION_TYPE_CODE | VARCHAR2 | 1 | Indicates whether the supporting reference is seeded. | ||
| ANALYTICAL_CRITERION_CODE | VARCHAR2 | 30 | Supporting reference short name. | ||
| SEGMENT_RULE_TYPE_CODE | VARCHAR2 | 1 | Indicates whether the account rule is seeded. | ||
| SEGMENT_RULE_CODE | VARCHAR2 | 30 | Short name of a rule to derive the account combination or segment value of a journal entry line. | ||
| MAPPING_SET_CODE | VARCHAR2 | 30 | Short name of a mapping rule that is defined based on input source values to target segment or account. | ||
| SOURCE_ORIGIN_CODE | VARCHAR2 | 1 | Indicates whether the subledger source or formula is predefined. | ||
| SOURCE_TYPE_CODE | VARCHAR2 | 1 | Indicates whether the source is seeded | ||
| SOURCE_CODE | VARCHAR2 | 30 | Short name of the transaction information that is used to create journal entries. | ||
| EXTRACT_OBJECT_NAME | VARCHAR2 | 30 | Database object that provides reference information on a transaction. | ||
| EXTRACT_OBJECT_TYPE_CODE | VARCHAR2 | 30 | Types of transaction object: translated header level, untranslated header level, translated line level, and untranslated line level. | ||
| EXTRACT_COLUMN_NAME | VARCHAR2 | 30 | Database column name of a transaction object that provides reference information on a transaction. | ||
| ACCOUNTING_SOURCE_CODE | VARCHAR2 | 30 | Short name of the transaction and reference information from subledger applications or reference systems. Sources correspond to the transaction data available to be used in the accounting rules. A source is generally equivalent to a column in the data model of the application. For example, in Payables, the source Vendor Name refers to the name of the vendor associated to an invoice. | ||
| MAPPING_GROUP_CODE | VARCHAR2 | 30 | Accounting source group code. | ||
| LANGUAGE | VARCHAR2 | 4 | Indicates the code of the language into which the contents of the translatable columns are translated. | ||
| REQUEST_ID | NUMBER | 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. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LINE_DEFINITION_OWNER_CODE | VARCHAR2 | 30 | User who creates the journal entry rule set. | ||
| LINE_DEFINITION_CODE | VARCHAR2 | 30 | Journal entry rule set short name. | ||
| SOURCE_APPLICATION_ID | NUMBER | 18 | Identifier of source application. | ||
| MPA_ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | 30 | Multiperiod journal line type owner code. | ||
| MPA_ACCOUNTING_LINE_CODE | VARCHAR2 | 30 | Multiperiod journal line type code. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XLA_AMB_SETUP_ERRORS_U1 | Unique | Default | AMB_ERROR_ID |