FND_STR_DEPLOYMENTS
Table to store the APM deployment states and delta deployment details
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FND_STR_DEPLOYMENTS_PK |
DEPLOYMENT_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| DEPLOYMENT_ID | VARCHAR2 | 36 | Yes | Provided by APM deployment request |
| DEPLOYMENT_STATUS | VARCHAR2 | 50 | Yes | APM deployment status like Preparing,Prepared,Activated etc |
| DEFAULTED | VARCHAR2 | 1 | Yes | 'Y' indicates this APM deployment was defaulted , 'N' otherwise. |
| ZERO_DELTA_FLAG | VARCHAR2 | 1 | Yes | 'Y' Indicates this deployment has no delta content, 'N' otherwise |
| SINCE_DEPLOYMENT_ID | VARCHAR2 | 36 | Used for APM delta deployment. It denotes the delta content since this deployment id. | |
| CREATED_DATE | TIMESTAMP | Yes | Creation date .Who column | |
| LAST_UPDATED_DATE | TIMESTAMP | Yes | Last Updated Date. Who column |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_STR_DEPLOYMENTS_U1 | Unique | Default | DEPLOYMENT_ID |