Oracle Fusion · Data dictionary
QA_IP_EVENTS
SharedUsed in 4 subject areas32 reporting columns
Source object in the Oracle Fusion data model.
Likely primary key: IP_EVENT_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCEPTANCE_NUMBER | ● | Acceptance number. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DISPATCH_STATUS | ● | Status of the dispatch. | |
| DISPOSITION_DATE | ● | Disposition date. | |
| DOC_LINE_NUM | ● | Doc line number. | |
| DOC_NUMBER | ● | Doc number. | |
| DOC_SCHEDULE_NUMBER | ● | Doc schedule number. | |
| DOC_TYPE | ● | Type of doc. | |
| EVENT_TYPE | ● | Type of event. | |
| INSPECTED_BY | ● | Inspected by. | |
| INSPECTION_DATE | ● | Inspection date. | |
| INSPECTION_STATUS | ● | Status of the inspection. | |
| IP_EVENT_ID | PK? | ● | Identifier for the ip event. |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LOT_NUMBER | ● | Lot number. | |
| NON_CONFORMANCE_COUNT | ● | Non conformance count. | |
| OPERATION_SEQ_NUMBER | ● | Operation seq number. | |
| ORIGINAL_DISPOSITION | ● | Original disposition. | |
| QTY_ACCEPTED | ● | Quantity accepted. | |
| QTY_INSPECTED | ● | Quantity inspected. | |
| QTY_REJECTED | ● | Quantity rejected. | |
| QTY_REQUESTED | ● | Quantity requested. | |
| RECEIPT_NUM | ● | Receipt number. | |
| REJECTION_NUMBER | ● | Rejection number. | |
| SAMPLE_SIZE_CODE | ● | Code identifying the sample size. | |
| SAMPLING_QTY | ● | Sampling quantity. | |
| SOURCE_LINE_QTY | ● | Source line quantity. | |
| SUBINVENTORY_CODE | ● | Code identifying the subinventory. | |
| SUPPLIER_LOT_NUM | ● | Supplier lot number. | |
| TOTAL_SAMPLE_QUANTITY | ● | Total sample quantity. | |
| TRANSACTION_TYPE | ● | Type of transaction. | |
| UOM_CODE | ● | Code identifying the unit of measure. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Enterprise Quality Actions Real Time
- Enterprise Quality Issues Real Time
- Maintenance Management - Asset Equipment Qualification Real Time
- Quality Inspection Results Real Time
Need the extract + dbt staging for QA_IP_EVENTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table