MSC_COLLECTION_DML_ERRORS
This table stores the dml errors that are raised during collection process of planning system.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ORA_ERR_NUMBER$ | NUMBER | Oracle Error Number logged by the Oracle Error logging feature. | ||
| ORA_ERR_MESG$ | VARCHAR2 | 4000 | Oracle Error message logged by the Oracle Error logging feature. | |
| ORA_ERR_ROWID$ | ROWID | ROWID of the error row logged by the Oracle Error logging feature. | ||
| ORA_ERR_OPTYP$ | VARCHAR2 | 2 | Type of the error logged by the Oracle Error logging feature. e.g. I - Insert, D - Delete, U - Update. | |
| ORA_ERR_TAG$ | VARCHAR2 | 4000 | Identifies the tag for the logged error. The tag is concatenated string of request_id and the sql name in the error. | |
| REFRESH_NUMBER | VARCHAR2 | 2000 | Refresh identifier populated by the collection program. | |
| TRANSACTION_ID | VARCHAR2 | 2000 | Unique identifier generated for the supply in the planning system. | |
| ORDER_NUMBER | VARCHAR2 | 2000 | This Column Specifies order number of either supply or demand. | |
| ORDER_TYPE | VARCHAR2 | 2000 | Specifies type of order: planned order, purchase order, etc. | |
| FG_ORDER_TYPE | VARCHAR2 | 2000 | Specifies the Fine grained order type. Ex: For planned orders, defines the type of planned order. 5001-MAKE, 5002-BUY, 5003-TRANSFER | |
| PO_HEADER_NUMBER | VARCHAR2 | 2000 | Purchase order header number collected from source system. | |
| PURCH_LINE_NUM | VARCHAR2 | 2000 | Purchase order line number (for purchase order). | |
| SCHEDULE_LINE_NUM | VARCHAR2 | 2000 | Schedule line number of the purchase order supply. | |
| TO_LINE_NUMBER | VARCHAR2 | 2000 | Transfer order line number collected from source system. | |
| SHIPMENT_HEADER_NUM | VARCHAR2 | 2000 | Shipment header number of a transfer order. | |
| SHIPMENT_LINE_NUM | VARCHAR2 | 2000 | Shipment line number of a transfer order. | |
| RECEIPT_NUM | VARCHAR2 | 2000 | Receipt number of a transfer order. | |
| WIP_ENTITY_NAME | VARCHAR2 | 2000 | This stores the value of WIP job name for an assembly. | |
| NEW_SCHEDULE_DATE | VARCHAR2 | 2000 | End date of the supply (completion date of first unit). | |
| DEMAND_ID | VARCHAR2 | 2000 | Unique identifier generated for the demand in the planning system. | |
| ORIGINATION_TYPE | VARCHAR2 | 2000 | Origin of the demand: Planned order, hard reservation, etc. | |
| SALES_ORDER_NUMBER | VARCHAR2 | 2000 | This value indicates the Sales order number. | |
| SO_LINE_NUM | VARCHAR2 | 2000 | Sales order line number of the sales order demand. | |
| SALES_ORDER_LINE_ID | VARCHAR2 | 2000 | This value indicates the Sales order line identifier. | |
| USING_ASSEMBLY_DEMAND_DATE | VARCHAR2 | 2000 | Using assembly demand date (due date) of the demand. | |
| DISPOSITION_ID | VARCHAR2 | 2000 | Disposition identifier, reference to the supply generating the demand. | |
| ATTRIBUTE_NAME | VARCHAR2 | 2000 | Attribute for which fixed ID is generated. | |
| DELIM_UNIQUE_KEY | VARCHAR2 | 2000 | This is the user key used to generate the fixed ID to be used in planning system. | |
| FIXED_ID | VARCHAR2 | 2000 | Unique identifier for the planning tables. | |
| ENTITY | VARCHAR2 | 2000 | The name of the entity the current attribute name belongs to (as defined in MSC_CC_MASTER_ENTITIES). | |
| USER_KEY | VARCHAR2 | 2000 | This is the user key used to generate the fixed ID to be used in planning schema. | |
| USER_KEY_HASH_VALUE | VARCHAR2 | 2000 | This is the hash key for the user_key used to generate the fixed ID to be used in planning system. | |
| SR_INSTANCE_ID | VARCHAR2 | 2000 | Identifier of the source system from where the data is collected. | |
| ENTITY_NAME | VARCHAR2 | 2000 | The name of the entity the current attribute name belongs to (as defined in MSC_CC_MASTER_ENTITIES). | |
| SOURCE_VALUE | VARCHAR2 | 2000 | The value used in the source system. | |
| TARGET_VALUE | VARCHAR2 | 2000 | The value stored in the planning system. | |
| INVENTORY_ITEM_ID | VARCHAR2 | 2000 | This value Identifies the inventory item. | |
| ITEM_NAME | VARCHAR2 | 2000 | Identifies the inventory item name. | |
| ORGANIZATION_ID | VARCHAR2 | 2000 | Organization identifier in the planning system. | |
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | 2000 | Name of the bill for alternate bills. | |
| ASSEMBLY_ITEM_ID | VARCHAR2 | 2000 | Identifier of the item being assembled. | |
| BILL_SEQUENCE_ID | VARCHAR2 | 2000 | Bill of material Sequence identifier. | |
| SR_ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | 2000 | Source side alternate bom identifier. | |
| COMPONENT_SEQUENCE_ID | VARCHAR2 | 2000 | The Bill Of Material Component Sequence Identifier. | |
| EFFECTIVITY_DATE | VARCHAR2 | 2000 | Date of effectivity for the component. | |
| OPERATION_SEQ_NUM | VARCHAR2 | 2000 | Operation Sequence Number of the component. | |
| SUBSTITUTE_SEQUENCE_ID | VARCHAR2 | 2000 | Substitute Identifier For Bom/wd Component Substitutes. | |
| SUBSTITUTE_ITEM_ID | VARCHAR2 | 2000 | Identifier of the Substitute item for the component item. | |
| ROUTING_SEQUENCE_ID | VARCHAR2 | 2000 | Routing sequence identifier for the routing/work definition. | |
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | 2000 | Name of the alternate routing. Null for primary routing. | |
| WORK_DEFINITION_CODE | VARCHAR2 | 2000 | This value indicates code of the work definition. | |
| OPERATION_SEQUENCE_ID | VARCHAR2 | 2000 | This value identifies the Operation sequence. | |
| EFFECTIVE_FROM_DATE | VARCHAR2 | 2000 | Indicate the date from which this operation is effective. | |
| OPERATION_SEQ_NUMBER | VARCHAR2 | 2000 | Indicates the execution sequence of the operation. | |
| ALTERNATE_NUMBER | VARCHAR2 | 2000 | Represents the priority of the alternate resource. | |
| RESOURCE_ID | VARCHAR2 | 2000 | This value indicates the Resource identifier. | |
| RESOURCE_SEQ_NUM | VARCHAR2 | 2000 | This value indicates the Resource sequence number. | |
| DEPARTMENT_CODE | VARCHAR2 | 2000 | Department code or the work center of the resource. | |
| RESOURCE_CODE | VARCHAR2 | 2000 | The value indicates resource code. | |
| DEPARTMENT_ID | VARCHAR2 | 2000 | Department identifier in which the operation takes place. | |
| CATEGORY_SET_ID | VARCHAR2 | 2000 | Unique identifier for the category set. | |
| CATEGORY_SET_NAME | VARCHAR2 | 2000 | Name assigned to the item category set. | |
| CATEGORY_ID | VARCHAR2 | 2000 | Unique identifier for the category. | |
| CATEGORY_NAME | VARCHAR2 | 2000 | Name assigned to the item category. | |
| UNIT_OF_MEASURE | VARCHAR2 | 2000 | This indicates the name of the unit of measure. | |
| UOM_CODE | VARCHAR2 | 2000 | This indicates the code of the unit of measure. | |
| FROM_UNIT_OF_MEASURE | VARCHAR2 | 2000 | Indicates the from unit of measure used during unit of measure conversion. | |
| FROM_UOM_CODE | VARCHAR2 | 2000 | Indicates the from UOM code used during unit of measure conversion. | |
| TO_UNIT_OF_MEASURE | VARCHAR2 | 2000 | Indicates the to unit of measure used during unit of measure conversion. | |
| TO_UOM_CODE | VARCHAR2 | 2000 | Indicates the to UOM code used during unit of measure conversion. | |
| REGION_ID | VARCHAR2 | 2000 | Region/Zone identifier that is mapped to the location. | |
| PARENT_REGION_NAME_LIST | VARCHAR2 | 4000 | Comma separated string of country code and all parent region names of this region. | |
| REGION_NAME | VARCHAR2 | 2000 | Region Name or Zone Name of the geography record. | |
| LOCATION_ID | VARCHAR2 | 2000 | This indicates the identifier of the location. | |
| LOCATION_CODE | VARCHAR2 | 2000 | This indicates the code of the location. | |
| TP_ID | VARCHAR2 | 2000 | This value indicates the Target partner id. | |
| PARTNER_NUMBER | VARCHAR2 | 2000 | Unique partner number for the Carrier/Supplier/Customer. | |
| PARTNER_ID | VARCHAR2 | 2000 | Unique identifier for the Supplier/Customer. | |
| PARTNER_SITE_ID | VARCHAR2 | 2000 | Unique identifier for the Supplier Site/Customer Site. | |
| TP_SITE_CODE | VARCHAR2 | 2000 | Vendor site code for Supplier Sites/Customer Sites. | |
| SUPPLIER_ID | VARCHAR2 | 2000 | Unique identifier for the Supplier. | |
| SUPPLIER_SITE_ID | VARCHAR2 | 2000 | Unique identifier for the Supplier Site. | |
| CUSTOMER_ID | VARCHAR2 | 2000 | Unique identifier for the Customer. | |
| CUSTOMER_SITE_ID | VARCHAR2 | 2000 | Unique identifier for the Customer Site. | |
| LOOKUP_TYPE | VARCHAR2 | 2000 | This value indicates lookup type. | |
| LOOKUP_CODE | VARCHAR2 | 2000 | This value indicates lookup code. | |
| MEANING | VARCHAR2 | 2000 | This value indicates meaning for lookup code. | |
| SUB_INVENTORY_CODE | VARCHAR2 | 2000 | This value indicates the Sub inventory code. | |
| CALENDAR_CODE | VARCHAR2 | 2000 | This indicates the code of the Calendar. | |
| SEQ_NUM | VARCHAR2 | 2000 | Sequence number of the date on a calendar. | |
| SHIFT_NUM | VARCHAR2 | 2000 | This value indicates the number of the calendar shift. | |
| ASSIGNMENT_ID | VARCHAR2 | 2000 | Unique Identifier of the assignment. | |
| CALENDAR_DATE | VARCHAR2 | 2000 | This indicates Calendar Date for the Calendar. | |
| EXCEPTION_START_DATE | VARCHAR2 | 2000 | Identifies the start date of the calendar exception. | |
| EXCEPTION_END_DATE | VARCHAR2 | 2000 | Identifies the end date of the calendar exception. | |
| PERIOD_START_DATE | VARCHAR2 | 2000 | This value indicates the period start date. | |
| WEEK_START_DATE | VARCHAR2 | 2000 | This value indicates the start date of the week. | |
| CURRENCY_CODE | VARCHAR2 | 2000 | Currency associated with amounts. | |
| NAME | VARCHAR2 | 2000 | Name of payment term/currency/receipt method/sales credit type/Revenue recognition rule name. | |
| CONVERSION_TYPE | VARCHAR2 | 2000 | Represents the currency conversion type. | |
| FROM_CURRENCY | VARCHAR2 | 2000 | Currency code from which the conversion is to be done. | |
| TO_CURRENCY | VARCHAR2 | 2000 | This value indicates the To Currency code in currency conversions. | |
| HIGHER_ITEM_ID | VARCHAR2 | 2000 | This value indicates the identifier of the higher item. | |
| LOWER_ITEM_ID | VARCHAR2 | 2000 | This value indicates the identifier of the lower item. | |
| SOURCING_RULE_ID | VARCHAR2 | 2000 | Sourcing rule unique identifier. | |
| SOURCING_RULE_NAME | VARCHAR2 | 2000 | This value identifies the name of the sourcing rule. | |
| ASSIGNMENT_SET_NAME | VARCHAR2 | 2000 | Name assigned to the assignment set. | |
| ASSIGNMENT_SET_ID | VARCHAR2 | 2000 | Unique Identifier of the assignment set. | |
| ALLOCATION_ID | VARCHAR2 | 2000 | This value indicates allocation identifier. | |
| DEMAND_CLASS | VARCHAR2 | 2000 | Class to which the demand is tied. | |
| TIME_PHASE_ID | VARCHAR2 | 2000 | This value indicates time Phase identifier. | |
| ALLOCATION_RULE_ID | VARCHAR2 | 2000 | Identifier to the allocation rule. | |
| RULE_NAME | VARCHAR2 | 2000 | Name of the Available to Promise rule. Used in order promising. | |
| 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_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. |