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: IBY.IBY_SYS_SECURITY_OPTIONS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

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
ENCRYPT_SUPPLEMENTAL_CARD_DATA	VARCHAR2	(1)		Y or N flag to denote if the supplemental cardholder data needs to be encrypted.
ENCRYPTION_PATCH_LEVEL	VARCHAR2	(30)		Stores the current encryption patch level i.e., NORMAL, PADSS etc
SYSTEM_SALT_VERSION	NUMBER	(2)		Security Column

Query Text

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
,      ENCRYPT_SUPPLEMENTAL_CARD_DATA
,      ENCRYPTION_PATCH_LEVEL
,      SYSTEM_SALT_VERSION
FROM IBY.IBY_SYS_SECURITY_OPTIONS;

Dependencies

[top of page]

IBY.IBY_SYS_SECURITY_OPTIONS does not reference any database object

IBY.IBY_SYS_SECURITY_OPTIONS is referenced by following:

IBY: IBY_SYS_SECURITY_OPTIONS#