FIF Ap Header Publish Prg History
In ScopeTechnical: FIF_AP_HEAD_PUBLISH_PRG_HIST | ID: OR-FIN-FIF_AP_HEAD_PUBLISH_PRG_HIST-FIF_AP_HEADER_PUBLISH_PRG_HISTORY
Stores program or batch execution history for fif AP head 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_HEAD_PUBLISH_PRG_HIST
Field Definitions(142)
Rules & Considerations(119)
Sample Load Data(4)
| _scenario | HIST_WRITTEN_DATER | SOURCE | CREATE_ID | IM_SEQ_NO | PAY_ALONE | PAY_GROUP | IMPORT_SET | TERMS_DATE | ATTRIBUTE_1 | ATTRIBUTE_2 | ATTRIBUTE_3 | ATTRIBUTE_4 | ATTRIBUTE_5 | ATTRIBUTE_6 | ATTRIBUTE_7 | ATTRIBUTE_8 | ATTRIBUTE_9 | DESCRIPTION | ATTRIBUTE_10 | ATTRIBUTE_11 | ATTRIBUTE_12 | ATTRIBUTE_13 | ATTRIBUTE_14 | ATTRIBUTE_15 | INVOICE_DATE | INVOICE_TYPE | SUPPLIER_NAME | SUPPLIER_SITE | IM_CREATE_DATE | INVOICE_AMOUNT | INVOICE_DOC_ID | INVOICE_NUMBER | LAST_UPDATE_ID | PAYMENT_METHOD | VOUCHER_NUMBER | ACCOUNTING_DATE | CONVERSION_DATE | CONVERSION_RATE | CORRECTION_YEAR | CREATE_DATETIME | APPLICATION_NAME | ATTRIBUTE_DATE_1 | ATTRIBUTE_DATE_2 | ATTRIBUTE_DATE_3 | ATTRIBUTE_DATE_4 | ATTRIBUTE_DATE_5 | INVOICE_CURRENCY | PAYMENT_CURRENCY | PAYMENT_PRIORITY | SHIP_TO_LOCATION | TAXATION_COUNTRY | CORRECTION_PERIOD | DOCUMENT_SUB_TYPE | PREPAYMENT_NUMBER | REMIT_TO_SUPPLIER | ATTACHMENT_EXT_URL | ATTRIBUTE_CATEGORY | ATTRIBUTE_NUMBER_1 | ATTRIBUTE_NUMBER_2 | ATTRIBUTE_NUMBER_3 | ATTRIBUTE_NUMBER_4 | ATTRIBUTE_NUMBER_5 | BANK_CHARGE_BEARER | FIF_AP_HEAD_SEQ_NO | 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 | PORT_OF_ENTRY_CODE | TAX_CONTROL_AMOUNT | DISCOUNTABLE_AMOUNT | EXTRACT_DATE_RUN_ID | 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 | GOODS_RECEIVED_DATE | PAYMENT_REASON_CODE | REQUESTER_LAST_NAME | SETTLEMENT_PRIORITY | CONVERSION_RATE_TYPE | IMPORT_DOCUMENT_DATE | LAST_UPDATE_DATETIME | REMITTANCE_MESSAGE_1 | REMITTANCE_MESSAGE_2 | REMITTANCE_MESSAGE_3 | REQUESTER_FIRST_NAME | DELIVERY_CHANNEL_CODE | EXTERNAL_LEGAL_ENTITY | INVOICE_RECEIVED_DATE | LIABILITY_COMBINATION | REMIT_TO_ADDRESS_NAME | WITHHOLDING_TAX_GROUP | DOCUMENT_CATEGORY_CODE | EXTERNAL_BUSINESS_UNIT | EXTERNAL_PAYMENT_TERMS | IMPORT_DOCUMENT_NUMBER | PREPAYMENT_LINE_NUMBER | CUSTOMER_TAX_REG_NUMBER | GLOBAL_ATTRIBUTE_DATE_1 | GLOBAL_ATTRIBUTE_DATE_2 | GLOBAL_ATTRIBUTE_DATE_3 | GLOBAL_ATTRIBUTE_DATE_4 | GLOBAL_ATTRIBUTE_DATE_5 | PAYMENT_REASON_COMMENTS | SUPPLIER_TAX_REG_NUMBER | EXTERNAL_ORG_UNIT_REF_ID | EXTERNAL_SUPPLIER_NUMBER | REMIT_TO_SUPPLIER_NUMBER | ADD_TAX_TO_INVOICE_AMOUNT | GLOBAL_ATTRIBUTE_CATEGORY | GLOBAL_ATTRIBUTE_NUMBER_1 | GLOBAL_ATTRIBUTE_NUMBER_2 | GLOBAL_ATTRIBUTE_NUMBER_3 | GLOBAL_ATTRIBUTE_NUMBER_4 | GLOBAL_ATTRIBUTE_NUMBER_5 | REQUESTER_EMPLOYEE_NUMBER | SUPPLIER_TAX_INVOICE_DATE | CUSTOMER_REGISTRATION_CODE | FIRST_PARTY_TAX_REG_NUMBER | PREPAYMENT_ACCOUNTING_DATE | TAX_INVOICE_RECORDING_DATE | CALCULATE_TAX_DURING_IMPORT | INVOICE_INCLUDES_PREPAYMENT | SUPPLIER_TAX_INVOICE_NUMBER | TAX_INVOICE_INTERNAL_SEQ_NO | UNIQUE_REMITTANCE_IDENTIFIER | PREPAYMENT_APPLICATION_AMOUNT | SUPPLIER_TAX_INVOICE_CONV_RATE | UNIQUE_REMITTANCE_IDNT_CHK_DIG |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 2026-01-01 | SAMPLE | SAMPLE | 1 | S | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 1.0000 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | 1.0000000000 | 1 | 2026-01-01 | SAMPLE | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | 1 | 1 | 1 | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | 1 | 1 | 1 | 1 | 1 | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 | S | S | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | SA |
Example values from field definitions
- HIST_WRITTEN_DATER
- 2026-01-01
- SOURCE
- SAMPLE
- CREATE_ID
- SAMPLE
- IM_SEQ_NO
- 1
- PAY_ALONE
- S
- PAY_GROUP
- SAMPLE
- IMPORT_SET
- SAMPLE
- TERMS_DATE
- 2026-01-01
- 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
- DESCRIPTION
- SAMPLE
- ATTRIBUTE_10
- SAMPLE
- ATTRIBUTE_11
- SAMPLE
- ATTRIBUTE_12
- SAMPLE
- ATTRIBUTE_13
- SAMPLE
- ATTRIBUTE_14
- SAMPLE
- ATTRIBUTE_15
- SAMPLE
- INVOICE_DATE
- 2026-01-01
- INVOICE_TYPE
- SAMPLE
- SUPPLIER_NAME
- SAMPLE
- SUPPLIER_SITE
- SAMPLE
- IM_CREATE_DATE
- 2026-01-01
- INVOICE_AMOUNT
- 1.0000
- INVOICE_DOC_ID
- 1
- INVOICE_NUMBER
- SAMPLE
- LAST_UPDATE_ID
- SAMPLE
- PAYMENT_METHOD
- SAMPLE
- VOUCHER_NUMBER
- SAMPLE
- ACCOUNTING_DATE
- 2026-01-01
- CONVERSION_DATE
- 2026-01-01
- CONVERSION_RATE
- 1.0000000000
- CORRECTION_YEAR
- 1
- CREATE_DATETIME
- 2026-01-01
- APPLICATION_NAME
- SAMPLE
- 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
- INVOICE_CURRENCY
- SAMPLE
- PAYMENT_CURRENCY
- SAMPLE
- PAYMENT_PRIORITY
- 1
- SHIP_TO_LOCATION
- SAMPLE
- TAXATION_COUNTRY
- SAMPLE
- CORRECTION_PERIOD
- SAMPLE
- DOCUMENT_SUB_TYPE
- SAMPLE
- PREPAYMENT_NUMBER
- SAMPLE
- REMIT_TO_SUPPLIER
- SAMPLE
- ATTACHMENT_EXT_URL
- SAMPLE
- ATTRIBUTE_CATEGORY
- SAMPLE
- ATTRIBUTE_NUMBER_1
- 1
- ATTRIBUTE_NUMBER_2
- 1
- ATTRIBUTE_NUMBER_3
- 1
- ATTRIBUTE_NUMBER_4
- 1
- ATTRIBUTE_NUMBER_5
- 1
- BANK_CHARGE_BEARER
- SAMPLE
- FIF_AP_HEAD_SEQ_NO
- 1
- 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
- PORT_OF_ENTRY_CODE
- SAMPLE
- TAX_CONTROL_AMOUNT
- 1
- DISCOUNTABLE_AMOUNT
- 1
- EXTRACT_DATE_RUN_ID
- 1
- 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
- GOODS_RECEIVED_DATE
- 2026-01-01
- PAYMENT_REASON_CODE
- SAMPLE
- REQUESTER_LAST_NAME
- SAMPLE
- SETTLEMENT_PRIORITY
- SAMPLE
- CONVERSION_RATE_TYPE
- SAMPLE
- IMPORT_DOCUMENT_DATE
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
- REMITTANCE_MESSAGE_1
- SAMPLE
- REMITTANCE_MESSAGE_2
- SAMPLE
- REMITTANCE_MESSAGE_3
- SAMPLE
- REQUESTER_FIRST_NAME
- SAMPLE
- DELIVERY_CHANNEL_CODE
- SAMPLE
- EXTERNAL_LEGAL_ENTITY
- SAMPLE
- INVOICE_RECEIVED_DATE
- 2026-01-01
- LIABILITY_COMBINATION
- SAMPLE
- REMIT_TO_ADDRESS_NAME
- SAMPLE
- WITHHOLDING_TAX_GROUP
- SAMPLE
- DOCUMENT_CATEGORY_CODE
- SAMPLE
- EXTERNAL_BUSINESS_UNIT
- SAMPLE
- EXTERNAL_PAYMENT_TERMS
- SAMPLE
- IMPORT_DOCUMENT_NUMBER
- SAMPLE
- PREPAYMENT_LINE_NUMBER
- 1
- CUSTOMER_TAX_REG_NUMBER
- SAMPLE
- 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
- PAYMENT_REASON_COMMENTS
- SAMPLE
- SUPPLIER_TAX_REG_NUMBER
- SAMPLE
- EXTERNAL_ORG_UNIT_REF_ID
- SAMPLE
- EXTERNAL_SUPPLIER_NUMBER
- SAMPLE
- REMIT_TO_SUPPLIER_NUMBER
- SAMPLE
- ADD_TAX_TO_INVOICE_AMOUNT
- S
- 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
- REQUESTER_EMPLOYEE_NUMBER
- SAMPLE
- SUPPLIER_TAX_INVOICE_DATE
- 2026-01-01
- CUSTOMER_REGISTRATION_CODE
- SAMPLE
- FIRST_PARTY_TAX_REG_NUMBER
- SAMPLE
- PREPAYMENT_ACCOUNTING_DATE
- 2026-01-01
- TAX_INVOICE_RECORDING_DATE
- 2026-01-01
- CALCULATE_TAX_DURING_IMPORT
- S
- INVOICE_INCLUDES_PREPAYMENT
- S
- SUPPLIER_TAX_INVOICE_NUMBER
- SAMPLE
- TAX_INVOICE_INTERNAL_SEQ_NO
- SAMPLE
- UNIQUE_REMITTANCE_IDENTIFIER
- SAMPLE
- PREPAYMENT_APPLICATION_AMOUNT
- 1
- SUPPLIER_TAX_INVOICE_CONV_RATE
- 1
- UNIQUE_REMITTANCE_IDNT_CHK_DIG
- SA
Rule Validation Summary
- Source Rule Count
- 127
- Governed Rule Count
- 119