[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RLM_DEMAND_EXCEPTIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | RLM |
| FND Design Data: |  RLM.RLM_DEMAND_EXCEPTIONS
|
| Subobject Name: | |
| Status: | VALID |
This table stores the exception messages in the form of errors or warnings , which get generated when the Demand Processor is run.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| RLM_DEMAND_EXCEPTIONS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 EXCEPTION_ID
|
| RLM_DEMAND_EXCEPTIONS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID
|
| RLM_DEMAND_EXCEPTIONS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SCHEDULE_HEADER_ID
|
| RLM_DEMAND_EXCEPTIONS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INTERFACE_HEADER_ID
|
| RLM_DEMAND_EXCEPTIONS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MESSAGE_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXCEPTION_ID | NUMBER | Yes | Exception Unique Identifier | |
| MESSAGE_NAME | VARCHAR2 | (30) | Yes | The exception code. FK to FND_NEW_MESSAGES. |
| EXCEPTION_LEVEL | VARCHAR2 | (1) | Yes | Indicates whether the exception is a warning ('W'), an error ('E'), or information ('I') |
| CUST_BILL_TO_EXT | VARCHAR2 | (35) | Bill-To Location | |
| CUST_INTERMD_SHIPTO_EXT | VARCHAR2 | (35) | External Customer Bill-To Cross Reference | |
| CUST_ITEM_DESCRIPTION | VARCHAR2 | (80) | Customer Item Description | |
| CUST_JOB_NUMBER | VARCHAR2 | (50) | Customer Job Number | |
| CUST_MODEL_SERIAL_NUM | VARCHAR2 | (35) | Customer's Vehicle Identification Number for this sequenced detail, e.g. VIN or Chassis ID. | |
| CUST_NAME_EXT | VARCHAR2 | (360) | Customer Name, as sent by the customer in the N1 and/or N2 segment. | |
| CUSTOMER_PROD_SEQ_NUM | VARCHAR2 | (35) | Customer Production Sequence Number, or Delivery Number | |
| CUST_SHIP_FROM_ORG_EXT | VARCHAR2 | (80) | External Inventory Organization Cross Reference | |
| CUST_SHIP_TO_EXT | VARCHAR2 | (35) | External Ship-To Address Cross Reference | |
| CUST_UOM_EXT | VARCHAR2 | (10) | External Customer Unit of Measure Cross Reference | |
| CUSTOMER_ITEM_EXT | VARCHAR2 | (50) | External Customer Part Number Cross Reference | |
| DATE_TYPE_CODE | VARCHAR2 | (30) | Type of Start/End Date, e.g. Ship, Delivery, Pull Signal, Cumulative. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_DATE_TYPE_CODE | |
| ECE_TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | For EDI transactions only, EDI Gateway Trading Partner Code assigned to the transaction in the EDI Gateway Common Control Record. | |
| ECE_TP_TRANSLATOR_CODE | VARCHAR2 | (35) | For EDI transactions only, EDI Gateway Trading Partner Code assigned to the transaction in the EDI Gateway Common Control Record. | |
| EDI_CONTROL_NUM_3 | VARCHAR2 | (15) | EDI control number 3 (ST) assigned by the customer's EDI translator for audit. | |
| EDI_TEST_INDICATOR | VARCHAR2 | (1) | EDI Test/Production trasaction indicator (T or P), assigned by the customer's EDI translator. EDI Gateway rules determine the handling of test transactions within the Demand Processor. | |
| EXCEPTION_ATTRIBUTE1 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE10 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE11 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE12 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE13 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE14 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE15 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE16 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE17 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE18 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE19 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE2 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE20 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE3 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE4 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE5 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE6 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE7 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE8 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| EXCEPTION_ATTRIBUTE9 | VARCHAR2 | (150) | Exception place holder flexfield (not standard AOL) | |
| ITEM_DETAIL_QUANTITY | NUMBER | Requested quantity. If Item_Detail_Type = 0, 1, 2, this is the demand quantity. If Item_Detail_Type = 3, this is the authorization quantity. If Item_Detail_Type = 4, this is the shipped, received or CUM quantity. If Item_Detail_Type = 5, this is a miscellaneous quantity, such as ahead/behind, inventory balance, etc. | ||
| ITEM_DETAIL_SUBTYPE | VARCHAR2 | (30) | Schedule item detail row sub-type: For firm or forecast demand, Bucket type associated with the demand date/quantity; for authorizations, the type of authorizations, the type of authorization; for shipment/receipt, cumulative or last. Validated against FND_LOOKUPS | |
| ITEM_DETAIL_TYPE | VARCHAR2 | (30) | Schedule item detail row type:0 = Past Due Firm,1 = Firm Demand,2 = Forecast Demand, 3 = Authorization,4 = Shipment/Receipt Info,5 = OtherValidated against FND_LOOKUPS.LOOKUP_TYPE = RLM_DETAIL_TYPE_CODE | |
| MESSAGE_TEXT | VARCHAR2 | (3999) | Exception message | |
| QTY_TYPE_CODE | VARCHAR2 | (30) | Actual or Cumulative. Validated against FND_LOOKUPS.LOOKUP_TYPE=RLM_QTY_TYPE_CODE | |
| INTERFACE_HEADER_ID | NUMBER | Interface header Unique Identifier | ||
| INTERFACE_LINE_ID | NUMBER | Interface Line Unique Identifier. This column will be null if an error or warning pertained to the schedule header. | ||
| SCHEDULE_HEADER_ID | NUMBER | Schedule header unique indentifier | ||
| SCHEDULE_LINE_ID | NUMBER | Schedule item unique identifier | ||
| SCHEDULE_TYPE | VARCHAR2 | (30) | Schedule Type: Planning, Shipping or Sequenced. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_TYPE. | |
| SCHED_GENERATION_DATE | DATE | Date customer generated either during the schedule or the planning information on the schedule. | ||
| SCHEDULE_ITEM_NUM | NUMBER | Schedule Item Number, the means to identify how item demand and information is grouped by the customer within the schedule. | ||
| SCHEDULE_PURPOSE | VARCHAR2 | (30) | Schedule purpose code, i.e. Original, Replace, Cancellation, etc. Validated against FND_LOOKUPS.LOOKUP_TYPE = RLM_SCHEDULE_PURPOSE. | |
| SCHEDULE_REFERENCE_NUM | VARCHAR2 | (35) | Customer assigned schedule reference or release number | |
| SCHEDULE_SOURCE | VARCHAR2 | (30) | EDI or manual transaction source for this schedule, i.e. 830, 862, 866, DELFOR, MANUAL, etc. | |
| START_DATE_TIME | DATE | Customer-specified date/time, as transmitted by the customer on the EDI transaction. | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Request Identifier | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
| INVENTORY_ITEM | VARCHAR2 | (50) | Inventory Item Number | |
| SCHEDULE_LINE_NUMBER | NUMBER | Schedule Line Number | ||
| HORIZON_START_DATE | DATE | Horizon Start Date | ||
| HORIZON_END_DATE | DATE | Horizon End Date | ||
| ORDER_HEADER_ID | NUMBER | Order Header Identifier | ||
| ORDER_LINE_ID | NUMBER | Order Line Identifier | ||
| REQUEST_DATE | DATE | Request Date | ||
| INDUSTRY_ATTRIBUTE1 | VARCHAR2 | (150) | Industry Attribute1. Also Customer Record Year. | |
| SCHEDULE_DATE | VARCHAR2 | (240) | Schedule Date | |
| CUST_PO_NUMBER | VARCHAR2 | (50) | Customer Purchase Order Number | |
| CUSTOMER_DOCK_CODE | VARCHAR2 | (35) | Customer Dock Code | |
| CUST_PRODUCTION_LINE | VARCHAR2 | (50) | Customer Production Line | |
| PURGE_STATUS | VARCHAR2 | (30) | Indicates if an exception caused by Purge Concurrent Program | |
| ORIGIN_TABLE | VARCHAR2 | (9) | Indicates to the Purge Schedule Concurrent Program whether the schedule data comes from interface or archive tables. | |
| REPORT_SUMMARY | LONG | (0) | Contains additional information related to the error encountered in Process Order API and specified in MESSAGE_TEXT |
Cut, paste (and edit) the following text to query this object:
SELECT EXCEPTION_ID
, MESSAGE_NAME
, EXCEPTION_LEVEL
, CUST_BILL_TO_EXT
, CUST_INTERMD_SHIPTO_EXT
, CUST_ITEM_DESCRIPTION
, CUST_JOB_NUMBER
, CUST_MODEL_SERIAL_NUM
, CUST_NAME_EXT
, CUSTOMER_PROD_SEQ_NUM
, CUST_SHIP_FROM_ORG_EXT
, CUST_SHIP_TO_EXT
, CUST_UOM_EXT
, CUSTOMER_ITEM_EXT
, DATE_TYPE_CODE
, ECE_TP_LOCATION_CODE_EXT
, ECE_TP_TRANSLATOR_CODE
, EDI_CONTROL_NUM_3
, EDI_TEST_INDICATOR
, EXCEPTION_ATTRIBUTE1
, EXCEPTION_ATTRIBUTE10
, EXCEPTION_ATTRIBUTE11
, EXCEPTION_ATTRIBUTE12
, EXCEPTION_ATTRIBUTE13
, EXCEPTION_ATTRIBUTE14
, EXCEPTION_ATTRIBUTE15
, EXCEPTION_ATTRIBUTE16
, EXCEPTION_ATTRIBUTE17
, EXCEPTION_ATTRIBUTE18
, EXCEPTION_ATTRIBUTE19
, EXCEPTION_ATTRIBUTE2
, EXCEPTION_ATTRIBUTE20
, EXCEPTION_ATTRIBUTE3
, EXCEPTION_ATTRIBUTE4
, EXCEPTION_ATTRIBUTE5
, EXCEPTION_ATTRIBUTE6
, EXCEPTION_ATTRIBUTE7
, EXCEPTION_ATTRIBUTE8
, EXCEPTION_ATTRIBUTE9
, ITEM_DETAIL_QUANTITY
, ITEM_DETAIL_SUBTYPE
, ITEM_DETAIL_TYPE
, MESSAGE_TEXT
, QTY_TYPE_CODE
, INTERFACE_HEADER_ID
, INTERFACE_LINE_ID
, SCHEDULE_HEADER_ID
, SCHEDULE_LINE_ID
, SCHEDULE_TYPE
, SCHED_GENERATION_DATE
, SCHEDULE_ITEM_NUM
, SCHEDULE_PURPOSE
, SCHEDULE_REFERENCE_NUM
, SCHEDULE_SOURCE
, START_DATE_TIME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INVENTORY_ITEM
, SCHEDULE_LINE_NUMBER
, HORIZON_START_DATE
, HORIZON_END_DATE
, ORDER_HEADER_ID
, ORDER_LINE_ID
, REQUEST_DATE
, INDUSTRY_ATTRIBUTE1
, SCHEDULE_DATE
, CUST_PO_NUMBER
, CUSTOMER_DOCK_CODE
, CUST_PRODUCTION_LINE
, PURGE_STATUS
, ORIGIN_TABLE
, REPORT_SUMMARY
FROM RLM.RLM_DEMAND_EXCEPTIONS;
RLM.RLM_DEMAND_EXCEPTIONS does not reference any database object
RLM.RLM_DEMAND_EXCEPTIONS is referenced by following:
APPS
RLM_DEMAND_EXCEPTIONS
|
|
|
|