FND_HTTP_TICKETS
Table to store short-lifespan and one-time-use tickets
Details
-
Schema: SECURITY
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_D
Primary Key
| Name | Columns |
|---|---|
|
FND_HTTP_TICKETS_PK |
TICKET, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| TICKET | RAW | 16 | Yes | Random 128-bit binary value assigned as the ticket for the secured operation - this is the primary key for the table. | |
| START_DATE | DATE | Yes | The date the ticket was issued, default SYSDATE | ||
| END_DATE | DATE | The date the ticket will expire; null indicates that the ticket has no pre-set expiration. | |||
| OPERATION | VARCHAR2 | 255 | An optional place to store the operation or function associated with the ticket.This is to provide extra security versus operations that are passed through the client without any other validity checks. | ||
| ARGUMENT | VARCHAR2 | 4000 | An optional place to store arguments to the operation, again as an extra security measure. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_HTTP_TICKETS_U1 | Unique | Default | TICKET, ENTERPRISE_ID |