OSS_MRA_SERVICE_MAPPING
Captures customization metadata for batch flows.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
| Name | Columns |
|---|---|
|
OSS_MRA_SERVICE_MAPPING_PK |
FAMILY_CODE, EXECUTION_NUMBER, ALGM_ID, ALGM_VERSION_ID, ALGM_STEP_ID, ALGM_ACTION_ID, ACTION_NAME, SERVICE_MAPPING_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FAMILY_CODE | VARCHAR2 | 30 | Yes | Name for service mapping datasources used. | |
| EXECUTION_NUMBER | NUMBER | 18 | Yes | Unique identifier of the execution. | |
| TARGET_TABLE | VARCHAR2 | 30 | Destination table where data is transformed. | ||
| FILTER_NAME_DEFINED | VARCHAR2 | 100 | Name of the filter conditions defined based on the service mapping data sources. | ||
| FILTER_CONDITION | VARCHAR2 | 4000 | Condiitons participating in the defi niton of filter name. | ||
| FILTER_CONDITION_PARSED | CLOB | Oracle internal use only. | |||
| ACTION_NAME | VARCHAR2 | 100 | Yes | Name of the action to transform data from subscription to Oracle receivables. | |
| FILTER_NAME_APPLIED | VARCHAR2 | 4000 | Filters applied to actions, and the selected filters will be chosen from the predefined set of filters. | ||
| FILTER_NAME_APPLIED_PARSED | CLOB | Oracle internal use only. | |||
| LEVEL_NUMBER | NUMBER | 18 | Specifies the actions at level to execute concurrently. | ||
| ATTRIBUTE_NAME | VARCHAR2 | 4000 | Database column in ra_interface_lines_all table. | ||
| ATTRIBUTE_CONTEXT | VARCHAR2 | 4000 | Signifies standard or descriptive flexfield attribute. | ||
| FLEX_CONTEXT | VARCHAR2 | 4000 | Context code of descriptive flexfield. | ||
| ATTRIBUTE_NAME_PARSED | VARCHAR2 | 4000 | Oracle internal use only. | ||
| FLEX_ATTRIBUTE_CATEGORY | VARCHAR2 | 4000 | Oracle internal use only. | ||
| FLEX_HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | 4000 | Oracle internal use only. | ||
| ATTRIBUTE_VALUE | VARCHAR2 | 4000 | Value that need to be assigned to the column. | ||
| ATTRIBUTE_VALUE_PARSED | VARCHAR2 | 4000 | Oracle internal use only. | ||
| CASE_ALIAS | VARCHAR2 | 30 | Oracle internal use only. | ||
| ACTION_SEQUENCE | NUMBER | 18 | Sequence of action. | ||
| SERVICE_MAPPING_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| ALGM_ID | NUMBER | 18 | Yes | Algorithm unique identifer of this table. | |
| ALGM_VERSION_ID | NUMBER | 18 | Yes | Algorithm version id | |
| ALGM_VERSION_NUM | NUMBER | 9 | Yes | Algorithm version number | |
| ALGM_STEP_ID | NUMBER | 18 | Yes | Step in the algorithm. | |
| ALGM_ACTION_ID | NUMBER | 18 | Yes | Action id in the algorithm step. | |
| TRANSACTION_TYPE | VARCHAR2 | 30 | Transaction type of the subscription.For example INVOICE,CREDITMEMO. | ||
| ACTION_TYPE | VARCHAR2 | 30 | Type of the action.For example TRANSFER,SKIP. | ||
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OSS_MRA_SERVICE_MAPPING_PK | Unique | Default | FAMILY_CODE, EXECUTION_NUMBER, ALGM_ID, ALGM_VERSION_ID, ALGM_STEP_ID, ALGM_ACTION_ID, ACTION_NAME, SERVICE_MAPPING_ID |