eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKS.OKS_REPROCESSING

Object Details

Object Name:	OKS_REPROCESSING
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_REPROCESSING
Subobject Name:
Status:	VALID

OKS_REPROCESSING table contains details of Service Order lines processed from Order Capture queue. When a Service order line is interfaced to Contracts through Order Capture queue, the details of the order line along with the details of the Contract created are recorded in this table. If processed successfully, the Contract's information is recorded otherwise the errors are recorded. The user can fix the errors and reprocess the Order line.
This table is populated when 'Service Contracts Order Capture' Concurrent program is submitted to process Service order lines.
Contracts are created when 'Order Reprocessing' Concurrent program process these order lines to create contracts.
If processed successfully, the details of the order line along with the details of the Contract are stored in this table. When the Order line fails to interface to Contracts, the cause of the errors are stored in the table. The user can then reprocess the order line through Service Order Reprocessing form.
This table is also populated when a Service Order line, is entered through Service Order Reprocessing form.
The SUCCESS_FLAG indicates if the order line has successfully interfaced to Contracts,
* 'S' for Success
* 'E' for Error.
* 'N' for New Order line entered through Reprocess Order form.
* 'R' when an order line is submitted for processing through Reprocess Order form.
The text in ERROR_TEXT is used to identify the cause of the error, for the user
to fix and submit the line for reprocessing.
SOURCE_FLAG indicates if the source of the of the order line, either Order Capture or Manually entered.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_REPROCESSING_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKS_REPROCESSING_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_NUMBER
OKS_REPROCESSING_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
ORDER_ID	NUMBER		Yes	The Order Header Id of the service order line, which is a unique identifier for Order Header.(References OE_ORDER_HEADERS_ALL.HEADER_ID)
ORDER_LINE_ID	NUMBER			The Service Order Line Id, which is a unique identifier for Order Line.
CONTRACT_ID	NUMBER			The Contract ID created when the service order line is interfaced to Contracts. Unique Identifier for Contract Header (References OKC_K_HEADERS_B.ID)
CONTRACT_LINE_ID	NUMBER			Line ID of the Service line created, when the service order line is interfaced to Contracts. Unique Identifier for Contract Line (References OKC_K_LINES_B.ID)
SUBLINE_ID	NUMBER			Line ID of the covered line created for the product referenced by the Service order line, when a service order line is interfaced to Contracts. Unique Identifier for Contract Line. (References OKC_K_LINES_B.ID)
ERROR_TEXT	VARCHAR2	(2000)		Used to identify the cause of the error if the Order Line failed to interface to OKS, for the user to fix and submit the line for reprocessing.
SUCCESS_FLAG	VARCHAR2	(1)		Status of the Order Line. Indicates if the order line has successfully interfaced to Contracts. Valid Values: * 'S' for Success * 'E' for Error. * 'N' for New Order line entered through Reprocess Order form. * 'R' when an order line is submitted for processing through Reprocess Order form. (References FND_LOOKUPS.lokkupcode where lookup_type = 'PROCESSED_OPTIONS'
SOURCE_FLAG	VARCHAR2	(40)	Yes	Source of the Order Line - Reprocessing form or Order Capture Integration program.( Valid values: 'ASO'- Order Capture, 'Manual')( References FND_LOOKUP.lookup_code with LOOKUP_TYPE='OKS_ORDER_SOURCE')
CONC_REQUEST_ID	NUMBER			Unique Identifier of the concurrent request - Order Reprocessing Concurrent program.
CREATED_BY	NUMBER	(15)	Yes	ID of the user whom created the record.
CREATION_DATE	DATE		Yes	Date the record was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	ID of the last user who updated the record.
LAST_UPDATE_DATE	DATE		Yes	Date the record was last updated.
LAST_UPDATE_LOGIN	NUMBER	(15)		OS ID of the user who last updated the record.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
REPROCESS_YN	VARCHAR2	(1)		Flag whether or not to Reprocess the Order Line ('Y','N')
ORDER_NUMBER	NUMBER			Order Number of the order line being processed (References OE_ORDER_HEADERS_ALL.ORDER_NUMBER)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      ORDER_ID
,      ORDER_LINE_ID
,      CONTRACT_ID
,      CONTRACT_LINE_ID
,      SUBLINE_ID
,      ERROR_TEXT
,      SUCCESS_FLAG
,      SOURCE_FLAG
,      CONC_REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      REPROCESS_YN
,      ORDER_NUMBER
FROM OKS.OKS_REPROCESSING;

Dependencies

[top of page]

OKS.OKS_REPROCESSING does not reference any database object

OKS.OKS_REPROCESSING is referenced by following:

APPS: OKS_REPROCESSING