Transaction Date Filters
Data is extracted from Oracle in to IRC using the Process Insights and analyzed. Transaction date filters are used for scoping during extraction and analysis.
This table lists the objects, date fields for full extraction, date fields for Incremental extraction, and additional filters.
| Object Name | Date Field for Full Extraction | Date Field for 'Incremental' Extraction | Additional Filters |
|---|---|---|---|
| GL_CODE_COMBINATIONS | NA | NA | NA |
| PO_VENDOR_SITES_ALL | NA | NA | NA |
| HZ_CUSTOMER_PROFILES | NA | NA | NA |
| HZ_PARTIES | NA | NA | NA |
| HZ_CUST_ACCOUNTS | NA | NA | NA |
| MTL_SYSTEM_ITEMS_B | NA | NA | NA |
| FND_USER | NA | NA | NA |
| PO_VENDORS | NA | NA | NA |
| PO_VENDOR_CONTACTS | NA | NA | NA |
| GL_BALANCES | NA | NA | NA |
| RA_CUSTOMER_TRX_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| RA_CUSTOMER_TRX_LINES_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| WSH_NEW_DELIVERIES | CREATION_DATE | LAST_UPDATE_DATE | NA |
| WSH_DELIVERY_DETAILS | CREATION_DATE | LAST_UPDATE_DATE | NA |
| RCV_SHIPMENT_HEADERS | CREATION_DATE | LAST_UPDATE_DATE | NA |
| RCV_SHIPMENT_LINES | CREATION_DATE | LAST_UPDATE_DATE | NA |
| AP_INVOICES_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| AP_INVOICE_LINES_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| AP_INVOICE_DISTRIBUTIONS_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| GL_JE_HEADERS | CREATION_DATE | LAST_UPDATE_DATE | NA |
| GL_JE_LINES | CREATION_DATE | LAST_UPDATE_DATE | NA |
| OE_ORDER_HEADERS_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| OE_ORDER_LINES_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| AP_INVOICE_PAYMENTS_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| PO_HEADERS_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| PO_LINES_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| PO_DISTRIBUTIONS_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| PO_REQUISITION_HEADERS_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| PO_REQUISITION_LINES_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |
| AP_PAYMENT_SCHEDULES_ALL | CREATION_DATE | LAST_UPDATE_DATE | NA |