ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
iJournals upload template instructions
4
Use the template on the next tab to prepare journal transactions for upload into Oracle Financials iJournals.
5
6
File requirementSave your final file in tab delimited file (.txt) format for the iJournals upload. The file must follow the column order, formatting, and field requirements defined in the template (for file structure, header, and details). File name cannot be longer than 100 characters.
7
Data formattingReconstruct the source file as needed so all journal data aligns to the upload template, including required fields, date formats, account segments, journal category, journal source, debit and credit values, and any other required attributes.
8
Review fileConfirm all required fields are populated, journal lines are complete, and debits and credits are balanced, with no formatting issues (such as extra spaces, invalid characters, or blank rows) that could cause upload errors.
9
Upload fileNavigate to the upload screen in the iJournals system and proceed with the upload process.
10
11
File structure requirements
12
Each journal must begin with HEAD in Column A.
13
Each journal must end with END in Column A. For multiple journals, leave one blank row between each journal. Note: Multiple feeders cannot be uploaded at the same time.
14
The final row in the file must contain EOF in Column A.
15
16
Header (HEAD) requirements
17
Category is case-sensitive and must be one of the approved values from the drop-down list: Allocation, AP Accrual, AR Accrual, Capital Accrual, Feeder, New Journal
18
Debit Total is required and must match sum of all debits.
19
Feeder ID is required only when the category is "Feeder."
20
Use EXPL to provide journal justification.
21
22
Detail (DETL) requirements
23
Project must be a seven-digit number.
24
Task is not required when using an object code (PFOO transaction).
25
Fund/Award must be a five-character code.
26
Expenditure Item Date is a required field and must reflect as accurately as possible the actual date of the transaction.
27
Department Reference is optional and used for departmental reporting and inquiries.
28
Description appears on the Expenditure Detail Report.
29
A Debit or a Credit is required on every line (amount may be 0.00).
30
Format the Debit Total field and the Debit and Credit columns to numbers without commas and with two digits after the decimal.
31
32
SAMPLE UPLOAD JOURNAL/FEEDER
33
34
DatePeriodCategoryShort TitleDebit Total
Feeder ID (for Feeders only)
35
36
HEAD30-JUN-2026JUN-2026New JournalCollect my revenue1000.00
37
EXPL
Allocate expenses for my service center; recognize revenue.
38
DETL10000451AABDC4811030-Jun-2026Internal Sales1000.00
39
DETL10000342AAFBD5512510-Jun-20261234-ABWidget Shop500.00
40
DETL10000343AAQFD551255-Jun-20261235-ABWidget Shop500.00
41
END
42
EOF
43
ProjectTaskAwardExp Type/ObjectExp Item DateDept RefDescriptionDebitCredit
44
45
46
Resources and general iJournals system questions:
47
How to: create and upload journals
48
Submit a support request
49
50
Last updated:Sep 30, 2026
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100