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

TABLE: OKS.OKS_RULE_ERROR

Object Details
Object Name: OKS_RULE_ERROR
Object Type: TABLE
Owner: OKS
Subobject Name:
Status: VALID


Table define from 11.5.10 onwards. This is to store the records spit out by the Rule validation job. This table gets populated by the Concurrent job - Service Contracts validate Rule data.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ROW_NUM NUMBER

ID NUMBER

RGP_ID NUMBER

CHR_ID NUMBER

Unique Identifier for Contract Header
CLE_ID NUMBER

Unique Identifier for Contract Line.
CONTRACT_NUMBER VARCHAR2 (120)
With CONTRACT_NUMBER_MODIFIER, used to uniquely identify a contract as a business entity.
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
With CONTRACT_NUMBER, used to uniquely identify a contract as a business entity.
MAJOR_VERSION NUMBER

Tracks the primary version number of a contract.
LINE_NUMBER VARCHAR2 (150)
SCRIPT_NAME VARCHAR2 (10)
PROCESS VARCHAR2 (1)
FLAG VARCHAR2 (1)
RULE_INFORMATION_CATEGORY VARCHAR2 (5)
COLUMN_NAME VARCHAR2 (100)
ATTRIBUTE_NAME VARCHAR2 (100)
ATTRIBUTE_VALUE VARCHAR2 (450)
NEW_VALUE NUMBER

ERROR_MSG VARCHAR2 (2000)
CC_EXPIRY_DATE DATE

Credit Card Expiration date
ALLOW_UPDATE_FLAG VARCHAR2 (3)
Flag to control record display
Query Text

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


SELECT ROW_NUM
,      ID
,      RGP_ID
,      CHR_ID
,      CLE_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      MAJOR_VERSION
,      LINE_NUMBER
,      SCRIPT_NAME
,      PROCESS
,      FLAG
,      RULE_INFORMATION_CATEGORY
,      COLUMN_NAME
,      ATTRIBUTE_NAME
,      ATTRIBUTE_VALUE
,      NEW_VALUE
,      ERROR_MSG
,      CC_EXPIRY_DATE
,      ALLOW_UPDATE_FLAG
FROM OKS.OKS_RULE_ERROR;

Dependencies

[top of page]

OKS.OKS_RULE_ERROR does not reference any database object

OKS.OKS_RULE_ERROR is referenced by following:

SchemaAPPS
SynonymOKS_RULE_ERROR