1. Tables and Views for Procurement
  2. PO_ACTION_HISTORY

PO_ACTION_HISTORY

PO_ACTION_HISTORY contains information about the approval and control history of your purchasing documents. There is one record in this table for each approval or control action an employee takes on a purchase order, purchase agreement, release, or requisition. Each row includes references to the document itself, the employee who acted on the document, the date of the action, the type of action taken on the document, and a note each employee can leave when taking an action on the document. . Oracle Purchasing uses this information to display history information about documents and to forward documents in the approval process to the appropriate employee. .

Details

  • Schema: FUSION

  • Object owner: PO

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

PO_ACTION_HISTORY_PK

OBJECT_ID, OBJECT_TYPE_CODE, OBJECT_SUB_TYPE_CODE, SEQUENCE_NUM, ACTION_CODE

Columns

Name Datatype Length Precision Not-null Comments
OBJECT_ID NUMBER 18 Yes Document header unique identifier
ASSIGNMENT_DATE DATE This is a new attribute which captures the date and time a document is assigned to a user for action e.g. when a document is assigned to an approver.
ESIGN_ENVELOPE_ID VARCHAR2 45 Unique identifier of docusign envelope.
ESIGN_ENV_OWNER_EMAIL_ID VARCHAR2 240 Email address of envelope creator.
CORRELATION_ID VARCHAR2 80 CORRELATION_ID
OBJECT_REVISION_NUM NUMBER Document revision number
PO_VERSION_ID NUMBER 18 PO_VERSION_ID
OBJECT_TYPE_CODE VARCHAR2 25 Yes Document type
OBJECT_SUB_TYPE_CODE VARCHAR2 25 Yes Document subtype
SEQUENCE_NUM NUMBER Yes Sequence of the approval or control action for a document
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
ACTION_CODE VARCHAR2 25 Yes Approval or control action type
ACTION_DATE DATE Approval or control action date
NOTE_MESSAGE_CODE_FLAG VARCHAR2 1 NOTE_MESSAGE_CODE_FLAG indicate Note column contains a message code instead of user-input message.
NOTE VARCHAR2 4000 Note for next approver or reason for control action
OFFLINE_CODE VARCHAR2 25 Indicates whether or not the document was sent to an offline approver
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
PROGRAM_DATE DATE No longer used
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
PERFORMER_ID NUMBER 18 Unique identifier of the person taking the action. The types of ids depend on ROLE_CODE column. if ROLE_CODE = 'SUPPLIER', this id is person PARTY_ID for supplier contact. Otherwise, the id is PERSON_ID for internal person, i.e. employee.
ROLE_CODE VARCHAR2 30 Yes Role of the action performer. Possible values are 'BUYER', 'REQUESTER', 'APPROVER', 'CAT_ADMIN', 'SUPPLIER'.
IDENTIFICATION_KEY VARCHAR2 80 Identification Key for approval actions from AMX.
ACTION_LEVEL NUMBER 9 Yes OBSOLETE: Indicate the level of this action. Possible values: 1 or 2. 1 for control actions, 'CHANGE ORDER' and 'ORIGINAL DOCUMENT' dummy actions.
PARENT_VERSION_ID NUMBER 18 Corresponds to PO_VERSION_ID of the parent Purchase Order or Change Order for the action. 'CHANGE ORDER' and 'ORIGINAL DOCUMENT' dummy actions will have NULL value if top level, and NON-NULL value if Supplier Change Order.
SUPPLIER_ACCESSIBLE_FLAG VARCHAR2 1 Yes Indciate this action is accessible to supplier. Possible values: 'Y' or 'N'
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
EMAIL_MESSAGE_ID VARCHAR2 128 Email message identifier of the Communicate Purchasing Documents job
ERROR_CODE VARCHAR2 128 Error code corresponding to the action.

Indexes

Index Uniqueness Tablespace Columns
PO_ACTION_HISTORY_N2 Non Unique Default PERFORMER_ID
PO_ACTION_HISTORY_U1 Unique Default OBJECT_ID, OBJECT_TYPE_CODE, OBJECT_SUB_TYPE_CODE, SEQUENCE_NUM, ACTION_CODE