VRM_NEW_SYSTEM_OPTIONS
This table contains system options information for Oracle Fusion Revenue Management.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_NEW_SYSTEM_OPTIONS_PK |
NEW_SYSTEM_OPTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| NEW_SYSTEM_OPTION_ID | NUMBER | 18 | Yes | Unique identifier for new system options. | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Yes | Default exchange rate type to be used for currency conversion. | |
| NUMBER_OF_PROCESSORS | NUMBER | 18 | Yes | Number of parallel processors. | |
| PROCESSING_UNIT_SIZE | NUMBER | 18 | Yes | Number of documents to be processed at a time. | |
| ROUNDING_RULE | VARCHAR2 | 30 | Specifies the rounding rule for revenue price calculation. Valid values are from the lookup type VRM_SYSTEM_ROUNDING_RULE. | ||
| CREATED_FROM | VARCHAR2 | 30 | Yes | The process or user interface from which this row is created.. | |
| PERFORMANCE_PREPROCESS_FLAG | VARCHAR2 | 1 | Oracle Internal use only. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| VRM_SYSTEM_OPTIONS | VARCHAR2 | 1 | Oracle internal use only. | ||
| INVALID_LINE_HANDLING_CODE | VARCHAR2 | 30 | Identifies the handling of invalid lines for contract creation. Valid values are Reject Contract and Reject Line. Reject Contract indicates that the Identify Customer Contract process will suspend contract creation for a source document until all of the source document lines are in a status of Processed. Reject Line indicates that the Identify Customer Contract process will create a contract for a source document for the processed source document lines, regardless of whether all of the lines are in a status of Processed. Blank is treated as Reject Line. | ||
| ENABLE_REFERENCE_CURRENCY_FLAG | VARCHAR2 | 1 | Indicates reference currency functionality enabled. Valid values are from the lookup type VRM_YES/NO. | ||
| REFERENCE_CURRENCY_CODE | VARCHAR2 | 15 | Currency to be used as the reference currency. | ||
| REFERENCE_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Rate type to used for converting entered currency amounts to reference currency. | ||
| REFERENCE_EXCHANGE_RATE_DATE | VARCHAR2 | 30 | The date used to convert entered amounts to reference currency. Valid values are from the lookup type ORA_REF_CONVERSION_RATE_DATE. | ||
| DISABLE_SOURCE_EXCHANGE_FLAG | VARCHAR2 | 1 | Indicates overriding of the conversion currency settings at the system option level by the source data is disabled. Valid values are from the lookup type VRM_YES/NO. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_NEW_SYSTEM_OPTIONS | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| VRM_NEW_SYSTEM_OPTIONS | gl_daily_conversion_types | REFERENCE_EXCHANGE_RATE_TYPE |
| VRM_NEW_SYSTEM_OPTIONS | fnd_currencies_b | REFERENCE_CURRENCY_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_NEW_SYSTEM_OPTIONS_U1 | Unique | Default | NEW_SYSTEM_OPTION_ID |