Initial Extract Date is required when you extract data for a full load. It reduces the volume of data in the initial load. The specified initial extract date will be used as a filter on the creation date of the transactional data in the selected full extract mapping.
When you set the Initial Extract Date parameter, ensure that you set it to the beginning of an accounting period and not a date in the middle of an accounting period. For example, if you decide to extract data from June 2005, and the June 2005 accounting period starts on June 5, then set the date to June 5, 2005.
The date format is YYYY-MM-DD
, for example, 2014-12-31. The default date is January 01, 1970.
The following tables use INITIAL_EXTRACT_DATE:
PROJECTS: W_PROJ_BUDGET_F W_PROJ_COMMITMENT_F W_PROJ_COMMITMENT_SNP_F W_PROJ_CONTRACT_LINE_F W_PROJ_COST_LINE_F W_PROJ_CROSS_CHARGE_DIST_F W_PROJ_FORECAST_F W_PROJ_FUNDING_LINE_F W_PROJ_INVOICE_DIST_F W_PROJ_REVENUE_LINE_F FINANCE: W_GL_OTHER_F W_GL_BALANCE_F W_GL_REVN_F W_GL_COGS_F W_GL_COST_REVN_F W_AP_HOLDS_F W_FA_BALANCE_F W_FA_XACT_F W_AP_XACT_F W_AR_XACT_F OM: W_SALES_ORDER_LINE_F W_SALES_INVOICE_LINE_F W_SALES_SCHEDULE_LINE_F W_SALES_PICK_LINE_F W_SALES_ORDER_HOLD_F W_SALES_ORDER_HOLD_1_F W_DOO_PROCESS_F W_SALES_ORDER_CREDIT_F W_SALES_INVOICE_CREDIT_F PIM: W_ITEM_REQUEST_F W_ITEM_REQUEST_STATUS_SNP_F W_ITEM_INTERFACE_F W_ITEM_F PRM: No INITIAL_EXTRACT_DATE usage Procurement: W_PURCH_RQSTN_LINE_F W_RQSTN_LINE_COST_F W_PURCH_AGREEMENT_HEADER_F W_PURCH_AGREEMENT_LINE_F W_PURCH_SCHEDULE_LINE_F W_PURCH_COST_F W_PURCH_RCPT_F W_AP_INV_DIST_F W_PURCH_CHANGE_ORDER_F Sourcing: W_NEG_INVITATIONS_F W_NEG_LINES_F W_NEG_RESPONSES_F Expense: W_EXPENSE_F W_EXPENSE_CC_F W_EXPENSE_VIOLATION_F SCM: W_CST_ITEM_COST_DAILY_F W_CST_INTRANSIT_DAILY_F W_CST_INTRAN_ACCNTED_DAILY_F W_CST_ONHAND_ACCNTED_DAILY_F W_CST_ONHAND_DAILY_F W_INVENTORY_CYCLE_COUNT_F W_PRODUCT_XACT_F HCM: W_WRKFC_EVT_F
Note:
HR needs a specific extract date (used in place of 'initial') such as HR_WRKFC_EXTRACT_DATE, HR_ABSENCE_EXTRACT_DATE, HR_PAYROLL_EXTRACT_DATE and HR_ACCRUAL_EXTRACT_DATE. The requirement for setting up the common INITIAL_EXTRACT_DATE parameter is only that this date should be earlier than any of our four specific extract date values.