FIF GL Publish 24Apr2025

In Scope

Technical: FIF_GL_PUBLISH_24APR2025 | ID: OR-FIN-FIF_GL_PUBLISH_24APR2025-FIF_GL_PUBLISH_24APR2025

Stores account setup or posting information for fif GL publish 24apr2025 in Oracle Retail Merchandising. Used to map business events to accounting structures and support downstream financial integration and reconciliation.

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_24APR2025

Field Definitions(5)

Rules & Considerations(101)

Sample Load Data(4)

Example values from field definitions

FIF_GL_SEQ_NOR
1
APPLICATION_NAMER
SAMPLE
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
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
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

default

FIF_GL_SEQ_NOR
4
APPLICATION_NAMER
FIF GL Publish 24Apr2025
CREATE_ID
MDM_USER
ATTRIBUTE1
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE2
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE3
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE4
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE5
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE6
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE7
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE8
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE9
FIF GL Publish 24Apr2025-002-ALT
REFERENCE1
FIF GL Publish 24Apr2025-002-ALT
REFERENCE2
FIF GL Publish 24Apr2025-002-ALT
REFERENCE3
FIF GL Publish 24Apr2025-002-ALT
REFERENCE4
FIF GL Publish 24Apr2025-002-ALT
REFERENCE5
FIF GL Publish 24Apr2025-002-ALT
REFERENCE6
FIF GL Publish 24Apr2025-002-ALT
REFERENCE7
FIF GL Publish 24Apr2025-002-ALT
REFERENCE8
FIF GL Publish 24Apr2025-002-ALT
REFERENCE9
FIF GL Publish 24Apr2025-002-ALT
ACTUAL_FLAG
F
ATTRIBUTE10
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE11
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE12
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE13
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE14
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE15
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE16
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE17
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE18
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE19
FIF GL Publish 24Apr2025-002-ALT
ATTRIBUTE20
FIF GL Publish 24Apr2025-002-ALT
LEDGER_NAME
FIF GL Publish 24Apr2025 Secon
REFERENCE10
FIF GL Publish 24Apr2025-002-ALT
REFERENCE21
FIF GL Publish 24Apr2025-002-ALT
REFERENCE22
FIF GL Publish 24Apr2025-002-ALT
REFERENCE23
FIF GL Publish 24Apr2025-002-ALT
REFERENCE24
FIF GL Publish 24Apr2025-002-ALT
REFERENCE25
FIF GL Publish 24Apr2025-002-ALT
REFERENCE26
FIF GL Publish 24Apr2025-002-ALT
REFERENCE27
FIF GL Publish 24Apr2025-002-ALT
REFERENCE28
FIF GL Publish 24Apr2025-002-ALT
REFERENCE29
FIF GL Publish 24Apr2025-002-ALT
REFERENCE30
FIF GL Publish 24Apr2025-002-ALT
STATUS_CODE
ALT
ACCT_SEGMENT1
FIF GL Publish 24Apr2025-
ACCT_SEGMENT2
FIF GL Publish 24Apr2025-
ACCT_SEGMENT3
FIF GL Publish 24Apr2025-
ACCT_SEGMENT4
FIF GL Publish 24Apr2025-
ACCT_SEGMENT5
FIF GL Publish 24Apr2025-
ACCT_SEGMENT6
FIF GL Publish 24Apr2025-
ACCT_SEGMENT7
FIF GL Publish 24Apr2025-
ACCT_SEGMENT8
FIF GL Publish 24Apr2025-
ACCT_SEGMENT9
FIF GL Publish 24Apr2025-
CURRENCY_CODE
ALT-FIF_GL-002
FIN_GL_SEQ_ID
1000000003
ACCT_SEGMENT10
FIF GL Publish 24Apr2025-
ACCT_SEGMENT11
FIF GL Publish 24Apr2025-
ACCT_SEGMENT12
FIF GL Publish 24Apr2025-
ACCT_SEGMENT13
FIF GL Publish 24Apr2025-
ACCT_SEGMENT14
FIF GL Publish 24Apr2025-
ACCT_SEGMENT15
FIF GL Publish 24Apr2025-
ACCT_SEGMENT16
FIF GL Publish 24Apr2025-
ACCT_SEGMENT17
FIF GL Publish 24Apr2025-
ACCT_SEGMENT18
FIF GL Publish 24Apr2025-
ACCT_SEGMENT19
FIF GL Publish 24Apr2025-
ACCT_SEGMENT20
FIF GL Publish 24Apr2025-
ACCT_SEGMENT21
FIF GL Publish 24Apr2025-
ACCT_SEGMENT22
FIF GL Publish 24Apr2025-
ACCT_SEGMENT23
FIF GL Publish 24Apr2025-
ACCT_SEGMENT24
FIF GL Publish 24Apr2025-
ACCT_SEGMENT25
FIF GL Publish 24Apr2025-
ACCT_SEGMENT26
FIF GL Publish 24Apr2025-
ACCT_SEGMENT27
FIF GL Publish 24Apr2025-
ACCT_SEGMENT28
FIF GL Publish 24Apr2025-
ACCT_SEGMENT29
FIF GL Publish 24Apr2025-
ACCT_SEGMENT30
FIF GL Publish 24Apr2025-
LAST_UPDATE_ID
MDM_USER
ACCOUNTING_DATE
2026-01-03
CREATE_DATETIME
2026-01-03
CLEARING_COMPANY
FIF GL Publish 24Apr2025-
ENTERED_CR_AMOUNT
12.5000
ENTERED_DR_AMOUNT
12.5000
STATISTICAL_AMOUNT
12.5000
CONVERTED_CR_AMOUNT
12.5000
CONVERTED_DR_AMOUNT
12.5000
ENCUMBRANCE_TYPE_ID
1000000003
USER_JE_SOURCE_NAME
FIF GL Publish 24Apr2025
AVERAGE_JOURNAL_FLAG
F
LAST_UPDATE_DATETIME
2026-01-03
USER_JE_CATEGORY_NAME
FIF GL Publish 24Apr2025
EXTERNAL_LEDGER_REF_ID
ALT-FIF_GL-002
CURRENCY_CONVERSION_DATE
2026-01-03
CURRENCY_CONVERSION_RATE
12.5000
CURRENCY_CONVERSION_TYPE
FIF GL Publish 24Apr2025-002-A
RECONCILIATION_REFERENCE
FIF GL Publish 24Apr2025-002-ALT
JOURNAL_ENTRY_CREATE_DATE
2026-01-03
CONTEXT_FIELD_CAPTURED_INFO
FIF GL Publish 24Apr2025-002-ALT
CONTEXT_FIELD_JOURNAL_ENTRY
FIF GL Publish 24Apr2025-002-ALT

default

FIF_GL_SEQ_NOR
6
APPLICATION_NAMER
FIF GL Publish 24Apr2025
CREATE_ID
BATCH_USER
ATTRIBUTE1
—
ATTRIBUTE2
—
ATTRIBUTE3
—
ATTRIBUTE4
—
ATTRIBUTE5
—
ATTRIBUTE6
—
ATTRIBUTE7
—
ATTRIBUTE8
—
ATTRIBUTE9
—
REFERENCE1
—
REFERENCE2
—
REFERENCE3
—
REFERENCE4
—
REFERENCE5
—
REFERENCE6
—
REFERENCE7
—
REFERENCE8
—
REFERENCE9
—
ACTUAL_FLAG
F
ATTRIBUTE10
—
ATTRIBUTE11
—
ATTRIBUTE12
—
ATTRIBUTE13
—
ATTRIBUTE14
—
ATTRIBUTE15
—
ATTRIBUTE16
—
ATTRIBUTE17
—
ATTRIBUTE18
—
ATTRIBUTE19
—
ATTRIBUTE20
—
LEDGER_NAME
FIF GL Publish 24Apr2025 Core
REFERENCE10
—
REFERENCE21
—
REFERENCE22
—
REFERENCE23
—
REFERENCE24
—
REFERENCE25
—
REFERENCE26
—
REFERENCE27
—
REFERENCE28
—
REFERENCE29
—
REFERENCE30
—
STATUS_CODE
EDG
ACCT_SEGMENT1
FIF GL Publish 24Apr2025-
ACCT_SEGMENT2
FIF GL Publish 24Apr2025-
ACCT_SEGMENT3
FIF GL Publish 24Apr2025-
ACCT_SEGMENT4
FIF GL Publish 24Apr2025-
ACCT_SEGMENT5
FIF GL Publish 24Apr2025-
ACCT_SEGMENT6
FIF GL Publish 24Apr2025-
ACCT_SEGMENT7
FIF GL Publish 24Apr2025-
ACCT_SEGMENT8
FIF GL Publish 24Apr2025-
ACCT_SEGMENT9
FIF GL Publish 24Apr2025-
CURRENCY_CODE
EDGE-FIF_GL-003
FIN_GL_SEQ_ID
1000000005
ACCT_SEGMENT10
FIF GL Publish 24Apr2025-
ACCT_SEGMENT11
FIF GL Publish 24Apr2025-
ACCT_SEGMENT12
FIF GL Publish 24Apr2025-
ACCT_SEGMENT13
FIF GL Publish 24Apr2025-
ACCT_SEGMENT14
FIF GL Publish 24Apr2025-
ACCT_SEGMENT15
FIF GL Publish 24Apr2025-
ACCT_SEGMENT16
FIF GL Publish 24Apr2025-
ACCT_SEGMENT17
FIF GL Publish 24Apr2025-
ACCT_SEGMENT18
FIF GL Publish 24Apr2025-
ACCT_SEGMENT19
FIF GL Publish 24Apr2025-
ACCT_SEGMENT20
FIF GL Publish 24Apr2025-
ACCT_SEGMENT21
FIF GL Publish 24Apr2025-
ACCT_SEGMENT22
FIF GL Publish 24Apr2025-
ACCT_SEGMENT23
FIF GL Publish 24Apr2025-
ACCT_SEGMENT24
FIF GL Publish 24Apr2025-
ACCT_SEGMENT25
FIF GL Publish 24Apr2025-
ACCT_SEGMENT26
FIF GL Publish 24Apr2025-
ACCT_SEGMENT27
FIF GL Publish 24Apr2025-
ACCT_SEGMENT28
FIF GL Publish 24Apr2025-
ACCT_SEGMENT29
FIF GL Publish 24Apr2025-
ACCT_SEGMENT30
FIF GL Publish 24Apr2025-
LAST_UPDATE_ID
BATCH_USER
ACCOUNTING_DATE
2026-01-05
CREATE_DATETIME
2026-01-05
CLEARING_COMPANY
FIF GL Publish 24Apr2025-
ENTERED_CR_AMOUNT
14.0000
ENTERED_DR_AMOUNT
14.0000
STATISTICAL_AMOUNT
14.0000
CONVERTED_CR_AMOUNT
14.0000
CONVERTED_DR_AMOUNT
14.0000
ENCUMBRANCE_TYPE_ID
1000000005
USER_JE_SOURCE_NAME
FIF GL Publish 24Apr2025
AVERAGE_JOURNAL_FLAG
F
LAST_UPDATE_DATETIME
2026-01-05
USER_JE_CATEGORY_NAME
FIF GL Publish 24Apr2025
EXTERNAL_LEDGER_REF_ID
EDGE-FIF_GL-003
CURRENCY_CONVERSION_DATE
2026-01-05
CURRENCY_CONVERSION_RATE
14.0000
CURRENCY_CONVERSION_TYPE
FIF GL Publish 24Apr2025-003-E
RECONCILIATION_REFERENCE
—
JOURNAL_ENTRY_CREATE_DATE
2026-01-05
CONTEXT_FIELD_CAPTURED_INFO
FIF GL Publish 24Apr2025-003-EDGE
CONTEXT_FIELD_JOURNAL_ENTRY
FIF GL Publish 24Apr2025-003-EDGE

Rule Validation Summary

Source Rule Count
107
Governed Rule Count
101