POR_REQ_HEADERS_INTERFACE_ALL
PO_REQUISITIONS_INTERFACE_ALL contains requisition information from other applications. Each row includes all the information necessary to create approved or unapproved requisitions in Oracle Purchasing. The Oracle Purchasing Requisition Import feature uses this information to create new requisition headers, lines and distributions. . You use the Submit Request window to launch the Requisition Import program for any set of rows. You identify the set of rows you want to import by setting the INTERFACE_SOURCE_CODE and BATCH_ID columns appropriately in the interface table. . The Requisition Import program validates your data, derives or defaults additional information and writes an error message for every validation that fails into the PO_INTERFACE_ERRORS table. Then the program groups and numbers requisition lines according to the criteria you specify in the GROUP_CODE and REQ_NUMBER_SEGMENT1 columns, and creates new requisitions. . Most of the columns in the PO_REQUISITIONS_INTERFACE_ALL table are identical to the corresponding columns in the PO_REQUISITIONS_HEADERS_ALL, PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL tables. You can additionally enter reference information in the INTERFACE_SOURCE_LINE_ID column. . Scope: public Product: PO Display Name: PO Requisitions Interface Category: BUSINESS_ENTITY PO_PURCHASE_REQUISITION Category: BUSINESS_ENTITY PO_INTERNAL_REQUISITION
Details
-
Schema: FUSION
-
Object owner: POR
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
POR_REQ_HEADERS_INTERFACE_PK |
REQ_HEADER_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| REQ_HEADER_INTERFACE_ID | NUMBER | 18 | Yes | Requisition header interface unique identifier. | ||
| INTERFACE_HEADER_KEY | VARCHAR2 | 50 | Cloud interface alternate header key code for integrating applications to be able to identify the requisition header data loaded in the interface table. | |||
| PROCESS_FLAG | VARCHAR2 | 30 | Application-updated flag that indicates whether the requisition is created with all lines that pass validation or is not created if any line does not pass validation. | |||
| INTERFACE_SOURCE_CODE | VARCHAR2 | 25 | Yes | The source from which the requisition lines were submitted for processing. If a value is provided during job submission, it is used to match the requisition lines that are selected for processing. | ||
| INTERFACE_SOURCE_LINE_ID | NUMBER | 18 | Source transaction reference identification. | |||
| DOCUMENT_STATUS | VARCHAR2 | 25 | Code of the status of the requisition. The possible lookup code values are INCOMPLETE, and APPROVED | |||
| BATCH_ID | NUMBER | 18 | An identifier if provided during job submission is used to match the requisition lines that are selected for processing. | |||
| APPROVER_ID | NUMBER | 18 | Unique identification of the approver of the requisition. | |||
| APPROVER_NAME | VARCHAR2 | 240 | *OBSOLETE*Name of the approver of the requisition in list format as: {LastName},{FirstName}.*OBSOLETE* | |||
| JUSTIFICATION | VARCHAR2 | 1000 | Reason for the requisition. | |||
| PREPARER_ID | NUMBER | 18 | Unique identification of the person who created the requisition. | |||
| PREPARER_NAME | VARCHAR2 | 240 | *OBSOLETE*Name of the person who created the requisition in list format as: {LastName},{FirstName}.*OBSOLETE* | |||
| REQUISITION_NUMBER | VARCHAR2 | 64 | Number of the requisition. The number is used to identify the requisition. | |||
| DESCRIPTION | VARCHAR2 | 240 | Description of the requisition. | |||
| CHUNK_ID | NUMBER | 18 | An identifier which is used to chunk the requisition header interface data. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| REQ_BU_ID | NUMBER | 18 | Unique identification of the business unit of the requisition. | |||
| REQ_BU_NAME | VARCHAR2 | 240 | Name of the business unit of the requisition. | |||
| EMERGENCY_PO_NUMBER | VARCHAR2 | 30 | Purchase order number reserved in advance for an emergency requisition. | |||
| PRC_BU_ID | NUMBER | 18 | *OBSOLETE*Unique identification of the business unit that manages and owns the purchasing document.*OBSOLETE* | |||
| PRC_BU_NAME | VARCHAR2 | 240 | *OBSOLETE*Name of the business unit that manages and owns the purchasing document.*OBSOLETE* | |||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | The country where the transaction is deemed to have taken place for taxation purposes. | |||
| DEFAULT_TAXATION_TERRITORY | VARCHAR2 | 80 | The territory where the transaction is deemed to have taken place for taxation purposes. | |||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Document sub type code. | |||
| DOCUMENT_SUB_TYPE_NAME | VARCHAR2 | 240 | Document sub type name. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| 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. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Application-generated number that uniquely identifies the request to create requisitions via cloud interface. | |||
| APPROVER_EMAIL_ADDR | VARCHAR2 | 240 | Email address of the approver of the requisition. | |||
| PREPARER_EMAIL_ADDR | VARCHAR2 | 240 | Email address of the person who created the requisition. | |||
| SOLDTO_LE_ID | NUMBER | 18 | Unique identification of the sold-to legal entity. Sold-to Legal Entity is the party which is financially responsible for the purchases on a purchase order and hence owns the liability for the purchase. This attribute will have a value only when emergency requisition applies and it will be the legal entity that will raise the purchase order with the reserved purchase order number. | |||
| SOLDTO_LE_NAME | VARCHAR2 | 240 | Name of the sold-to legal entity. Sold-to Legal Entity is the party which is financially responsible for the purchases on a purchase order and hence owns the liability for the purchase. This attribute will have a value only when emergency requisition applies and it will be the legal entity that will raise the purchase order with the reserved purchase order number. | |||
| EXTERNALLY_MANAGED_FLAG | VARCHAR2 | 1 | Indicator of whether a requisition is visible and can be managed in Self Service Procurement. If N, then the requisition is visible and can be managed in Self Service Procurement. If Y, then the requisition is not visible and cannot be managed in Self Service Procurement. | |||
| ATTACHMENT_CATEGORY | VARCHAR2 | 30 | Name of the attachment category | |||
| ATTACHMENT_ENTITY_NAME | VARCHAR2 | 40 | Name of the entity from where attachments are retrieved to be stored with the component of the requisition. | |||
| ATTACHMENT_PRIMARY_KEY1 | VARCHAR2 | 150 | Primary key that identifies the attachment. | |||
| ATTACHMENT_PRIMARY_KEY2 | VARCHAR2 | 150 | Primary key that identifies the attachment. | |||
| ATTACHMENT_PRIMARY_KEY3 | VARCHAR2 | 150 | Primary key that identifies the attachment. | |||
| ATTACHMENT_PRIMARY_KEY4 | VARCHAR2 | 150 | Primary key that identifies the attachment. | |||
| ATTACHMENT_PRIMARY_KEY5 | VARCHAR2 | 150 | Primary key that identifies the attachment. | |||
| RFQ_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates whether an RFQ is required prior to placement on a purchase order | Obsolete | ||
| SPECIAL_HANDLING_TYPE_CODE | VARCHAR2 | 30 | Special Handling Descriptive Flexfield Type Code: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SH_ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| por_req_lines_interface_all | por_req_headers_interface_all | REQ_HEADER_INTERFACE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| POR_REQ_HEADERS_INTERFACE_N1 | Non Unique | Default | PROCESS_FLAG | Obsolete |
| POR_REQ_HEADERS_INTERFACE_N2 | Non Unique | Default | REQUEST_ID | |
| POR_REQ_HEADERS_INTERFACE_N3 | Non Unique | Default | LOAD_REQUEST_ID, INTERFACE_HEADER_KEY | |
| POR_REQ_HEADERS_INTERFACE_N4 | Non Unique | Default | NVL("PROCESS_FLAG",'null'), BATCH_ID, INTERFACE_SOURCE_CODE | |
| POR_REQ_HEADERS_INTERFACE_U1 | Unique | Default | REQ_HEADER_INTERFACE_ID |