FIF Ap Detail Publish Prg History
In ScopeTechnical: FIF_AP_DETAIL_PUBLISH_PRG_HIST | ID: OR-FIN-FIF_AP_DETAIL_PUBLISH_PRG_HIST-FIF_AP_DETAIL_PUBLISH_PRG_HISTORY
Stores program or batch execution history for fif AP detail publish prg hist in Oracle Retail Merchandising, including run identifiers, start and end timestamps, status, and processing counts. Used for…
See how this object fits into Finance
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- FIF_AP_DETAIL_PUBLISH_PRG_HIST
Field Definitions(170)
Rules & Considerations(158)
constraint
validation
Sample Load Data(4)
| _scenario | LINE_NUMBERR | INVOICE_DOC_IDR | APPLICATION_NAMER | HIST_WRITTEN_DATER | FIF_AP_DETAIL_SEQ_NOR | TAX | UOM | AMOUNT | TASK_ID | TAX_RATE | CREATE_ID | LINE_TYPE | PO_NUMBER | TASK_NAME | WORK_TYPE | PROJECT_ID | UNIT_PRICE | ATTRIBUTE_1 | ATTRIBUTE_2 | ATTRIBUTE_3 | ATTRIBUTE_4 | ATTRIBUTE_5 | ATTRIBUTE_6 | ATTRIBUTE_7 | ATTRIBUTE_8 | ATTRIBUTE_9 | FINAL_MATCH | TASK_NUMBER | ATTRIBUTE_10 | ATTRIBUTE_11 | ATTRIBUTE_12 | ATTRIBUTE_13 | ATTRIBUTE_14 | ATTRIBUTE_15 | INTENDED_USE | MANUFACTURER | MODEL_NUMBER | PACKING_SLIP | PRODUCT_TYPE | PROJECT_NAME | CONTRACT_NAME | SERIAL_NUMBER | IM_CREATE_DATE | LAST_UPDATE_ID | PO_LINE_NUMBER | PROJECT_NUMBER | RECEIPT_NUMBER | TRACK_AS_ASSET | ACCOUNTING_DATE | CONTRACT_NUMBER | CREATE_DATETIME | INCOME_TAX_TYPE | TAX_REGIME_CODE | TAX_STATUS_CODE | WARRANTY_NUMBER | ASSESSABLE_VALUE | ATTRIBUTE_DATE_1 | ATTRIBUTE_DATE_2 | ATTRIBUTE_DATE_3 | ATTRIBUTE_DATE_4 | ATTRIBUTE_DATE_5 | COST_FACTOR_NAME | DISTRIBUTION_SET | EXPENDITURE_TYPE | INVOICE_QUANTITY | ITEM_DESCRIPTION | LINE_DESCRIPTION | PRODUCT_CATEGORY | SHIP_TO_LOCATION | ASSET_CATEGORY_ID | FUNDING_SOURCE_ID | INCOME_TAX_REGION | LINE_GROUP_NUMBER | PO_RELEASE_NUMBER | ATTRIBUTE_CATEGORY | ATTRIBUTE_NUMBER_1 | ATTRIBUTE_NUMBER_2 | ATTRIBUTE_NUMBER_3 | ATTRIBUTE_NUMBER_4 | ATTRIBUTE_NUMBER_5 | FISCAL_CHARGE_TYPE | GLOBAL_ATTRIBUTE_1 | GLOBAL_ATTRIBUTE_2 | GLOBAL_ATTRIBUTE_3 | GLOBAL_ATTRIBUTE_4 | GLOBAL_ATTRIBUTE_5 | GLOBAL_ATTRIBUTE_6 | GLOBAL_ATTRIBUTE_7 | GLOBAL_ATTRIBUTE_8 | GLOBAL_ATTRIBUTE_9 | PO_SCHEDULE_NUMBER | SHIP_FROM_LOCATION | TAX_CONTROL_AMOUNT | EXPENDITURE_TYPE_ID | EXTRACT_DATE_RUN_ID | FUNDING_SOURCE_NAME | GLOBAL_ATTRIBUTE_10 | GLOBAL_ATTRIBUTE_11 | GLOBAL_ATTRIBUTE_12 | GLOBAL_ATTRIBUTE_13 | GLOBAL_ATTRIBUTE_14 | GLOBAL_ATTRIBUTE_15 | GLOBAL_ATTRIBUTE_16 | GLOBAL_ATTRIBUTE_17 | GLOBAL_ATTRIBUTE_18 | GLOBAL_ATTRIBUTE_19 | GLOBAL_ATTRIBUTE_20 | PURCHASING_CATEGORY | RECEIPT_LINE_NUMBER | REQUESTER_LAST_NAME | ASSET_BOOK_TYPE_CODE | LAST_UPDATE_DATETIME | REQUESTER_FIRST_NAME | STATISTICAL_QUANTITY | EXPENDITURE_ITEM_DATE | FUNDING_SOURCE_NUMBER | PRICE_CORRECTION_LINE | TAX_JURISDICTION_CODE | WITHHOLDING_TAX_GROUP | EXTERNAL_TAX_RATE_CODE | PO_DISTRIBUTION_NUMBER | GLOBAL_ATTRIBUTE_DATE_1 | GLOBAL_ATTRIBUTE_DATE_2 | GLOBAL_ATTRIBUTE_DATE_3 | GLOBAL_ATTRIBUTE_DATE_4 | GLOBAL_ATTRIBUTE_DATE_5 | OVERLAY_ACCOUNT_SEGMENT | PRICE_CORRECTION_INV_NO | TAX_CLASSIFICATION_CODE | DISTRIBUTION_COMBINATION | EXPENDITURE_ORGANIZATION | PJC_RESERVED_ATTRIBUTE_2 | PJC_RESERVED_ATTRIBUTE_3 | PJC_RESERVED_ATTRIBUTE_4 | PJC_RESERVED_ATTRIBUTE_5 | PJC_RESERVED_ATTRIBUTE_6 | PJC_RESERVED_ATTRIBUTE_7 | PJC_RESERVED_ATTRIBUTE_8 | PJC_RESERVED_ATTRIBUTE_9 | CONSUMPTION_ADVICE_NUMBER | GLOBAL_ATTRIBUTE_CATEGORY | GLOBAL_ATTRIBUTE_NUMBER_1 | GLOBAL_ATTRIBUTE_NUMBER_2 | GLOBAL_ATTRIBUTE_NUMBER_3 | GLOBAL_ATTRIBUTE_NUMBER_4 | GLOBAL_ATTRIBUTE_NUMBER_5 | PJC_RESERVED_ATTRIBUTE_10 | REQUESTER_EMPLOYEE_NUMBER | EXPENDITURE_ORGANIZATION_ID | LOCATION_OF_FINAL_DISCHARGE | MULTIPERIOD_ACCOUNT_ACCRUAL | OVERLAY_COST_CENTER_SEGMENT | MULTIPERIOD_ACCOUNT_END_DATE | PJC_USER_DEFINED_ATTRIBUTE_1 | PJC_USER_DEFINED_ATTRIBUTE_2 | PJC_USER_DEFINED_ATTRIBUTE_3 | PJC_USER_DEFINED_ATTRIBUTE_4 | PJC_USER_DEFINED_ATTRIBUTE_5 | PJC_USER_DEFINED_ATTRIBUTE_6 | PJC_USER_DEFINED_ATTRIBUTE_7 | PJC_USER_DEFINED_ATTRIBUTE_8 | PJC_USER_DEFINED_ATTRIBUTE_9 | PRICE_CORRECTION_INV_LINE_NO | PJC_USER_DEFINED_ATTRIBUTE_10 | PRODUCT_FISCAL_CLASSIFICATION | PRORATE_ACROSS_ALL_ITEM_LINES | TRANSACTION_BUSINESS_CATEGORY | CONSUMPTION_ADVICE_LINE_NUMBER | MULTIPERIOD_ACCOUNT_START_DATE | OVERLAY_PRIMARY_BALANC_SEGMENT | USER_DEF_FISCAL_CLASSIFICATION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 2026-01-01 | 1 | SAMPLE | SAMPLE | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 1 | SAMPLE | SAMPLE | S | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | 1 | 1 | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | 1 | 1 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | S | SAMPLE | 1 | 2026-01-01 | SAMPLE | SAMPLE |
Example values from field definitions
- LINE_NUMBERR
- 1
- INVOICE_DOC_IDR
- 1
- APPLICATION_NAMER
- SAMPLE
- HIST_WRITTEN_DATER
- 2026-01-01
- FIF_AP_DETAIL_SEQ_NOR
- 1
- TAX
- SAMPLE
- UOM
- SAMPLE
- AMOUNT
- 1
- TASK_ID
- 1
- TAX_RATE
- 1
- CREATE_ID
- SAMPLE
- LINE_TYPE
- SAMPLE
- PO_NUMBER
- SAMPLE
- TASK_NAME
- SAMPLE
- WORK_TYPE
- SAMPLE
- PROJECT_ID
- 1
- UNIT_PRICE
- 1
- ATTRIBUTE_1
- SAMPLE
- ATTRIBUTE_2
- SAMPLE
- ATTRIBUTE_3
- SAMPLE
- ATTRIBUTE_4
- SAMPLE
- ATTRIBUTE_5
- SAMPLE
- ATTRIBUTE_6
- SAMPLE
- ATTRIBUTE_7
- SAMPLE
- ATTRIBUTE_8
- SAMPLE
- ATTRIBUTE_9
- SAMPLE
- FINAL_MATCH
- S
- TASK_NUMBER
- SAMPLE
- ATTRIBUTE_10
- SAMPLE
- ATTRIBUTE_11
- SAMPLE
- ATTRIBUTE_12
- SAMPLE
- ATTRIBUTE_13
- SAMPLE
- ATTRIBUTE_14
- SAMPLE
- ATTRIBUTE_15
- SAMPLE
- INTENDED_USE
- SAMPLE
- MANUFACTURER
- SAMPLE
- MODEL_NUMBER
- SAMPLE
- PACKING_SLIP
- SAMPLE
- PRODUCT_TYPE
- SAMPLE
- PROJECT_NAME
- SAMPLE
- CONTRACT_NAME
- SAMPLE
- SERIAL_NUMBER
- SAMPLE
- IM_CREATE_DATE
- 2026-01-01
- LAST_UPDATE_ID
- SAMPLE
- PO_LINE_NUMBER
- 1
- PROJECT_NUMBER
- SAMPLE
- RECEIPT_NUMBER
- SAMPLE
- TRACK_AS_ASSET
- S
- ACCOUNTING_DATE
- 2026-01-01
- CONTRACT_NUMBER
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- INCOME_TAX_TYPE
- SAMPLE
- TAX_REGIME_CODE
- SAMPLE
- TAX_STATUS_CODE
- SAMPLE
- WARRANTY_NUMBER
- SAMPLE
- ASSESSABLE_VALUE
- 1
- ATTRIBUTE_DATE_1
- 2026-01-01
- ATTRIBUTE_DATE_2
- 2026-01-01
- ATTRIBUTE_DATE_3
- 2026-01-01
- ATTRIBUTE_DATE_4
- 2026-01-01
- ATTRIBUTE_DATE_5
- 2026-01-01
- COST_FACTOR_NAME
- SAMPLE
- DISTRIBUTION_SET
- SAMPLE
- EXPENDITURE_TYPE
- 1
- INVOICE_QUANTITY
- 1
- ITEM_DESCRIPTION
- SAMPLE
- LINE_DESCRIPTION
- SAMPLE
- PRODUCT_CATEGORY
- SAMPLE
- SHIP_TO_LOCATION
- SAMPLE
- ASSET_CATEGORY_ID
- 1
- FUNDING_SOURCE_ID
- SAMPLE
- INCOME_TAX_REGION
- SAMPLE
- LINE_GROUP_NUMBER
- 1
- PO_RELEASE_NUMBER
- 1
- ATTRIBUTE_CATEGORY
- SAMPLE
- ATTRIBUTE_NUMBER_1
- 1
- ATTRIBUTE_NUMBER_2
- 1
- ATTRIBUTE_NUMBER_3
- 1
- ATTRIBUTE_NUMBER_4
- 1
- ATTRIBUTE_NUMBER_5
- 1
- FISCAL_CHARGE_TYPE
- SAMPLE
- GLOBAL_ATTRIBUTE_1
- SAMPLE
- GLOBAL_ATTRIBUTE_2
- SAMPLE
- GLOBAL_ATTRIBUTE_3
- SAMPLE
- GLOBAL_ATTRIBUTE_4
- SAMPLE
- GLOBAL_ATTRIBUTE_5
- SAMPLE
- GLOBAL_ATTRIBUTE_6
- SAMPLE
- GLOBAL_ATTRIBUTE_7
- SAMPLE
- GLOBAL_ATTRIBUTE_8
- SAMPLE
- GLOBAL_ATTRIBUTE_9
- SAMPLE
- PO_SCHEDULE_NUMBER
- 1
- SHIP_FROM_LOCATION
- SAMPLE
- TAX_CONTROL_AMOUNT
- 1
- EXPENDITURE_TYPE_ID
- 1
- EXTRACT_DATE_RUN_ID
- 1
- FUNDING_SOURCE_NAME
- SAMPLE
- GLOBAL_ATTRIBUTE_10
- SAMPLE
- GLOBAL_ATTRIBUTE_11
- SAMPLE
- GLOBAL_ATTRIBUTE_12
- SAMPLE
- GLOBAL_ATTRIBUTE_13
- SAMPLE
- GLOBAL_ATTRIBUTE_14
- SAMPLE
- GLOBAL_ATTRIBUTE_15
- SAMPLE
- GLOBAL_ATTRIBUTE_16
- SAMPLE
- GLOBAL_ATTRIBUTE_17
- SAMPLE
- GLOBAL_ATTRIBUTE_18
- SAMPLE
- GLOBAL_ATTRIBUTE_19
- SAMPLE
- GLOBAL_ATTRIBUTE_20
- SAMPLE
- PURCHASING_CATEGORY
- SAMPLE
- RECEIPT_LINE_NUMBER
- 1
- REQUESTER_LAST_NAME
- SAMPLE
- ASSET_BOOK_TYPE_CODE
- SAMPLE
- LAST_UPDATE_DATETIME
- 2026-01-01
- REQUESTER_FIRST_NAME
- SAMPLE
- STATISTICAL_QUANTITY
- 1
- EXPENDITURE_ITEM_DATE
- 2026-01-01
- FUNDING_SOURCE_NUMBER
- SAMPLE
- PRICE_CORRECTION_LINE
- S
- TAX_JURISDICTION_CODE
- SAMPLE
- WITHHOLDING_TAX_GROUP
- SAMPLE
- EXTERNAL_TAX_RATE_CODE
- SAMPLE
- PO_DISTRIBUTION_NUMBER
- 1
- GLOBAL_ATTRIBUTE_DATE_1
- 2026-01-01
- GLOBAL_ATTRIBUTE_DATE_2
- 2026-01-01
- GLOBAL_ATTRIBUTE_DATE_3
- 2026-01-01
- GLOBAL_ATTRIBUTE_DATE_4
- 2026-01-01
- GLOBAL_ATTRIBUTE_DATE_5
- 2026-01-01
- OVERLAY_ACCOUNT_SEGMENT
- SAMPLE
- PRICE_CORRECTION_INV_NO
- SAMPLE
- TAX_CLASSIFICATION_CODE
- SAMPLE
- DISTRIBUTION_COMBINATION
- SAMPLE
- EXPENDITURE_ORGANIZATION
- 1
- PJC_RESERVED_ATTRIBUTE_2
- SAMPLE
- PJC_RESERVED_ATTRIBUTE_3
- SAMPLE
- PJC_RESERVED_ATTRIBUTE_4
- SAMPLE
- PJC_RESERVED_ATTRIBUTE_5
- SAMPLE
- PJC_RESERVED_ATTRIBUTE_6
- SAMPLE
- PJC_RESERVED_ATTRIBUTE_7
- SAMPLE
- PJC_RESERVED_ATTRIBUTE_8
- SAMPLE
- PJC_RESERVED_ATTRIBUTE_9
- SAMPLE
- CONSUMPTION_ADVICE_NUMBER
- SAMPLE
- GLOBAL_ATTRIBUTE_CATEGORY
- SAMPLE
- GLOBAL_ATTRIBUTE_NUMBER_1
- 1
- GLOBAL_ATTRIBUTE_NUMBER_2
- 1
- GLOBAL_ATTRIBUTE_NUMBER_3
- 1
- GLOBAL_ATTRIBUTE_NUMBER_4
- 1
- GLOBAL_ATTRIBUTE_NUMBER_5
- 1
- PJC_RESERVED_ATTRIBUTE_10
- SAMPLE
- REQUESTER_EMPLOYEE_NUMBER
- SAMPLE
- EXPENDITURE_ORGANIZATION_ID
- 1
- LOCATION_OF_FINAL_DISCHARGE
- SAMPLE
- MULTIPERIOD_ACCOUNT_ACCRUAL
- SAMPLE
- OVERLAY_COST_CENTER_SEGMENT
- SAMPLE
- MULTIPERIOD_ACCOUNT_END_DATE
- 2026-01-01
- PJC_USER_DEFINED_ATTRIBUTE_1
- SAMPLE
- PJC_USER_DEFINED_ATTRIBUTE_2
- SAMPLE
- PJC_USER_DEFINED_ATTRIBUTE_3
- SAMPLE
- PJC_USER_DEFINED_ATTRIBUTE_4
- SAMPLE
- PJC_USER_DEFINED_ATTRIBUTE_5
- SAMPLE
- PJC_USER_DEFINED_ATTRIBUTE_6
- SAMPLE
- PJC_USER_DEFINED_ATTRIBUTE_7
- SAMPLE
- PJC_USER_DEFINED_ATTRIBUTE_8
- SAMPLE
- PJC_USER_DEFINED_ATTRIBUTE_9
- SAMPLE
- PRICE_CORRECTION_INV_LINE_NO
- 1
- PJC_USER_DEFINED_ATTRIBUTE_10
- SAMPLE
- PRODUCT_FISCAL_CLASSIFICATION
- SAMPLE
- PRORATE_ACROSS_ALL_ITEM_LINES
- S
- TRANSACTION_BUSINESS_CATEGORY
- SAMPLE
- CONSUMPTION_ADVICE_LINE_NUMBER
- 1
- MULTIPERIOD_ACCOUNT_START_DATE
- 2026-01-01
- OVERLAY_PRIMARY_BALANC_SEGMENT
- SAMPLE
- USER_DEF_FISCAL_CLASSIFICATION
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 164
- Governed Rule Count
- 158