PPM_INT_AGILE_PORTFOLIO_AUDIT
This table stores the audit trail for the integration between PPM portfolio and ALM Octane entities.
Foreign keys
There are no foreign keys for this table.
Column descriptions
Column Name | Null? | Data Type | Description |
---|---|---|---|
AUDIT_ID | NOT NULL | NUMBER | System-generated identifier. |
REPORT_ID | NOT NULL | NUMBER | The report ID in knta_report_submissions. |
PORTFOLIO_NAME | NULLABLE | VARCHAR | The portfolio name synced to agile system. |
PARENT_PORTFOLIO_NAME | NULLABLE | VARCHAR | The parent portfolio name synced to agile system. |
PROCESS_STATUS | NOT NULL | VARCHAR | Whether the integration succeeded or failed. The values include: SUCCESS, FAILED. |
ERROR_CODE | NULLABLE | VARCHAR | Error code returned from the agile system. |
ERROR_MESSAGE | NULLABLE | VARCHAR | Error message returned from the agile system. |
ACTION | NOT NULL | NUMBER |
Whether a PPM request or an ALM Octane entity is created, updated, or deleted. The values include: CREATE, UPDATE, or DELETE. |
NOTE | NULLABLE | CLOB | Notes if the integration was rejected. |
AGILE_ENTITY_ID | NOT NULL | NUMBER | The ID of the agile entity in the agile system. |
PORTFOLIO_UPDATED_BY | NULLABLE | NUMBER | The user who updated the portfolio. |
PORTFOLIO_UPDATE_DATE | NULLABLE | DATE | The time when the portfolio was updated. |
Indexes
This table has no indexes.
Sequences
This table uses no sequences.
Sequence Name | Sequence Type |
---|---|
ppm_int_agile_pf_audit_s | Auto-increment |