FIF GL Publish Prg History

In Scope

Technical: FIF_GL_PUBLISH_PRG_HIST | ID: OR-FIN-FIF_GL_PUBLISH_PRG_HIST-FIF_GL_PUBLISH_PRG_HISTORY

Stores program or batch execution history for fif GL publish prg hist in Oracle Retail Merchandising, including run identifiers, start and end timestamps, status, and processing counts. Used for monitoring,…

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_GL_PUBLISH_PRG_HIST

Field Definitions(101)

Rules & Considerations(96)

Sample Load Data(4)

_scenario	HIST_WRITTEN_DATER	CREATE_ID	ATTRIBUTE1	ATTRIBUTE2	ATTRIBUTE3	ATTRIBUTE4	ATTRIBUTE5	ATTRIBUTE6	ATTRIBUTE7	ATTRIBUTE8	ATTRIBUTE9	REFERENCE1	REFERENCE2	REFERENCE3	REFERENCE4	REFERENCE5	REFERENCE6	REFERENCE7	REFERENCE8	REFERENCE9	ACTUAL_FLAG	ATTRIBUTE10	ATTRIBUTE11	ATTRIBUTE12	ATTRIBUTE13	ATTRIBUTE14	ATTRIBUTE15	ATTRIBUTE16	ATTRIBUTE17	ATTRIBUTE18	ATTRIBUTE19	ATTRIBUTE20	LEDGER_NAME	REFERENCE10	REFERENCE21	REFERENCE22	REFERENCE23	REFERENCE24	REFERENCE25	REFERENCE26	REFERENCE27	REFERENCE28	REFERENCE29	REFERENCE30	STATUS_CODE	ACCT_SEGMENT1	ACCT_SEGMENT2	ACCT_SEGMENT3	ACCT_SEGMENT4	ACCT_SEGMENT5	ACCT_SEGMENT6	ACCT_SEGMENT7	ACCT_SEGMENT8	ACCT_SEGMENT9	CURRENCY_CODE	FIF_GL_SEQ_NO	FIN_GL_SEQ_ID	ACCT_SEGMENT10	ACCT_SEGMENT11	ACCT_SEGMENT12	ACCT_SEGMENT13	ACCT_SEGMENT14	ACCT_SEGMENT15	ACCT_SEGMENT16	ACCT_SEGMENT17	ACCT_SEGMENT18	ACCT_SEGMENT19	ACCT_SEGMENT20	ACCT_SEGMENT21	ACCT_SEGMENT22	ACCT_SEGMENT23	ACCT_SEGMENT24	ACCT_SEGMENT25	ACCT_SEGMENT26	ACCT_SEGMENT27	ACCT_SEGMENT28	ACCT_SEGMENT29	ACCT_SEGMENT30	LAST_UPDATE_ID	ACCOUNTING_DATE	CREATE_DATETIME	APPLICATION_NAME	CLEARING_COMPANY	ENTERED_CR_AMOUNT	ENTERED_DR_AMOUNT	STATISTICAL_AMOUNT	CONVERTED_CR_AMOUNT	CONVERTED_DR_AMOUNT	ENCUMBRANCE_TYPE_ID	USER_JE_SOURCE_NAME	AVERAGE_JOURNAL_FLAG	LAST_UPDATE_DATETIME	USER_JE_CATEGORY_NAME	EXTERNAL_LEDGER_REF_ID	CURRENCY_CONVERSION_DATE	CURRENCY_CONVERSION_RATE	CURRENCY_CONVERSION_TYPE	RECONCILIATION_REFERENCE	JOURNAL_ENTRY_CREATE_DATE	CONTEXT_FIELD_CAPTURED_INFO	CONTEXT_FIELD_JOURNAL_ENTRY
Example values from field definitions	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	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	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAM	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	2026-01-01	2026-01-01	SAMPLE	SAMPLE	1.0000	1.0000	1.0000	1.0000	1.0000	1	SAMPLE	S	2026-01-01	SAMPLE	SAMPLE	2026-01-01	1.0000	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE

Example values from field definitions

HIST_WRITTEN_DATER: 2026-01-01
CREATE_ID: SAMPLE
ATTRIBUTE1: SAMPLE
ATTRIBUTE2: SAMPLE
ATTRIBUTE3: SAMPLE
ATTRIBUTE4: SAMPLE
ATTRIBUTE5: SAMPLE
ATTRIBUTE6: SAMPLE
ATTRIBUTE7: SAMPLE
ATTRIBUTE8: SAMPLE
ATTRIBUTE9: SAMPLE
REFERENCE1: SAMPLE
REFERENCE2: SAMPLE
REFERENCE3: SAMPLE
REFERENCE4: SAMPLE
REFERENCE5: SAMPLE
REFERENCE6: SAMPLE
REFERENCE7: SAMPLE
REFERENCE8: SAMPLE
REFERENCE9: SAMPLE
ACTUAL_FLAG: S
ATTRIBUTE10: SAMPLE
ATTRIBUTE11: SAMPLE
ATTRIBUTE12: SAMPLE
ATTRIBUTE13: SAMPLE
ATTRIBUTE14: SAMPLE
ATTRIBUTE15: SAMPLE
ATTRIBUTE16: SAMPLE
ATTRIBUTE17: SAMPLE
ATTRIBUTE18: SAMPLE
ATTRIBUTE19: SAMPLE
ATTRIBUTE20: SAMPLE
LEDGER_NAME: SAMPLE
REFERENCE10: SAMPLE
REFERENCE21: SAMPLE
REFERENCE22: SAMPLE
REFERENCE23: SAMPLE
REFERENCE24: SAMPLE
REFERENCE25: SAMPLE
REFERENCE26: SAMPLE
REFERENCE27: SAMPLE
REFERENCE28: SAMPLE
REFERENCE29: SAMPLE
REFERENCE30: SAMPLE
STATUS_CODE: SAM
ACCT_SEGMENT1: SAMPLE
ACCT_SEGMENT2: SAMPLE
ACCT_SEGMENT3: SAMPLE
ACCT_SEGMENT4: SAMPLE
ACCT_SEGMENT5: SAMPLE
ACCT_SEGMENT6: SAMPLE
ACCT_SEGMENT7: SAMPLE
ACCT_SEGMENT8: SAMPLE
ACCT_SEGMENT9: SAMPLE
CURRENCY_CODE: SAMPLE
FIF_GL_SEQ_NO: 1
FIN_GL_SEQ_ID: 1
ACCT_SEGMENT10: SAMPLE
ACCT_SEGMENT11: SAMPLE
ACCT_SEGMENT12: SAMPLE
ACCT_SEGMENT13: SAMPLE
ACCT_SEGMENT14: SAMPLE
ACCT_SEGMENT15: SAMPLE
ACCT_SEGMENT16: SAMPLE
ACCT_SEGMENT17: SAMPLE
ACCT_SEGMENT18: SAMPLE
ACCT_SEGMENT19: SAMPLE
ACCT_SEGMENT20: SAMPLE
ACCT_SEGMENT21: SAMPLE
ACCT_SEGMENT22: SAMPLE
ACCT_SEGMENT23: SAMPLE
ACCT_SEGMENT24: SAMPLE
ACCT_SEGMENT25: SAMPLE
ACCT_SEGMENT26: SAMPLE
ACCT_SEGMENT27: SAMPLE
ACCT_SEGMENT28: SAMPLE
ACCT_SEGMENT29: SAMPLE
ACCT_SEGMENT30: SAMPLE
LAST_UPDATE_ID: SAMPLE
ACCOUNTING_DATE: 2026-01-01
CREATE_DATETIME: 2026-01-01
APPLICATION_NAME: SAMPLE
CLEARING_COMPANY: SAMPLE
ENTERED_CR_AMOUNT: 1.0000
ENTERED_DR_AMOUNT: 1.0000
STATISTICAL_AMOUNT: 1.0000
CONVERTED_CR_AMOUNT: 1.0000
CONVERTED_DR_AMOUNT: 1.0000
ENCUMBRANCE_TYPE_ID: 1
USER_JE_SOURCE_NAME: SAMPLE
AVERAGE_JOURNAL_FLAG: S
LAST_UPDATE_DATETIME: 2026-01-01
USER_JE_CATEGORY_NAME: SAMPLE
EXTERNAL_LEDGER_REF_ID: SAMPLE
CURRENCY_CONVERSION_DATE: 2026-01-01
CURRENCY_CONVERSION_RATE: 1.0000
CURRENCY_CONVERSION_TYPE: SAMPLE
RECONCILIATION_REFERENCE: SAMPLE
JOURNAL_ENTRY_CREATE_DATE: 2026-01-01
CONTEXT_FIELD_CAPTURED_INFO: SAMPLE
CONTEXT_FIELD_JOURNAL_ENTRY: SAMPLE

Rule Validation Summary

Source Rule Count: 102
Governed Rule Count: 96

All objects