[Home] [Help] [Dependency Information]
Object Name: | IBY_SYS_SECURITY_OPTIONS |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_SYS_SECURITY_OPTIONS |
Subobject Name: | |
Status: | VALID |
IBY_SYS_SECURITY_OPTIONS stores the system security options that are used for funds capture processing and funds disbursement processing.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYS_KEY_FILE_LOCATION | VARCHAR2 | (500) | Location of the system password file | |
SYS_KEY_HASH | RAW | (100) | Hash of the system key; used for verification purposes | |
CC_ENCRYPTION_MODE | VARCHAR2 | (30) | Yes | Encryption mode for credit card instruments; values taken from the lookup IBY_ENCRYPTION_MODE. Possible values can be NULL, Scheduled and Immediate. |
EXT_BA_ENCRYPTION_MODE | VARCHAR2 | (30) | Yes | External bank account encryption mode; values taken from the lookup IBY_ENCRYPTION_MODE. Possible values can be Scheduled or NULL. |
INSTR_SEC_CODE_ENCRYPTION_MODE | VARCHAR2 | (30) | Yes | Instrument security code encryption mode. Value used is same as CC_ENCRYPTION_MODE. |
CREDIT_CARD_MASK_SETTING | VARCHAR2 | (30) | Yes | Setup value for the masking of the credit card number. The possible values are - Display Last Digits, Display First Digits and Display None. Value are taken from lookup IBY_PMT_INSTR_MASKING |
CREDIT_CARD_UNMASK_LEN | NUMBER | (2) | The number of digits that can be exposed while displaying the credit card number on the UI or reports | |
EXT_BA_MASK_SETTING | VARCHAR2 | (30) | Yes | Setup value for the masking of the bank account number. The possible values are - Display Last Digits, Display First Digits and Display None. Value are taken from lookup IBY_PMT_INSTR_MASKING |
EXT_BA_UNMASK_LEN | NUMBER | (2) | The number of digits that can be exposed while displaying the bank account number on the UI or reports | |
SUBKEY_USE_MAXIMUM | NUMBER | (10) | Yes | Maximum use count for security sub-keys |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table. |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table. | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. This number is incremented for every update to the row through the application. |
SALT_VERSION | NUMBER | (2) | Denotes the versions of the encryption algorithm used for the Bank account or Credit card number encryption. | |
SUBKEY_AGE_MAXIMUM | NUMBER | (3) | Maximum subkey age |
Cut, paste (and edit) the following text to query this object:
SELECT SYS_KEY_FILE_LOCATION
, SYS_KEY_HASH
, CC_ENCRYPTION_MODE
, EXT_BA_ENCRYPTION_MODE
, INSTR_SEC_CODE_ENCRYPTION_MODE
, CREDIT_CARD_MASK_SETTING
, CREDIT_CARD_UNMASK_LEN
, EXT_BA_MASK_SETTING
, EXT_BA_UNMASK_LEN
, SUBKEY_USE_MAXIMUM
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SALT_VERSION
, SUBKEY_AGE_MAXIMUM
FROM IBY.IBY_SYS_SECURITY_OPTIONS;
IBY.IBY_SYS_SECURITY_OPTIONS does not reference any database object
IBY.IBY_SYS_SECURITY_OPTIONS is referenced by following:
|
|
|