GL Journal Statuses and Meanings

 

The full list of GL_JE_HEADERS.Status codes are :

- Bad rounding account

> Reserved for country - specific functionality

< Reserved for country - specific functionality

U Unposted

P Posted

1 Invalid currency code

2 Invalid source

3 Invalid category

4 Invalid set of books

5 Invalid set of books

6 (Actual) Unopened period

6 (Budget) Invalid budget version

6 (Encumbrance) Invalid exchange type

7 Invalid entry

8 Invalid entry

A Code combination does not exist

B Multiple lines have code combination error

C Code combination detail posting not allowed

D Multiple lines have code combination error

E Multiple lines have code combination error

F Code combination not enabled

G Multiple lines have code combination error

H Multiple lines have code combination error

I Multiple lines have code combination error

J Code combination not yet effective (date)

K Multiple lines have code combination error

L Multiple lines have code combination error

M Code combination past effective date

N Multiple lines have code combination error

O Multiple lines have code combination error

Q Multiple lines have code combination error

R Multiple lines have code combination error

T Multiple lines have code combination error

V Multiple lines have code combination error

Z Multiple lines have code combination error

The full list of posting error codes that get written to GL_JE_BATCHES.STATUS are held in GL_LOOKUPS

 in the DESCRIPTION field for LOOKUP_TYPE = 'MJE_BATCH_STATUS' 

 

The GL_JE_BATCHES.STATUS values :-  

 

Status	MEANING	DESCRIPTION
+	CTA failed validation	Error25 - Unable to validate or create CTA
-	Bad rounding account	Error22 - Invalid or inactive rounding differences account in journal entry
<	Sequence assignment failed	Error23 - Showing sequence assignment failure
>	Cutoff rule violated	Error24 - Showing cutoff rule violation
A	Funds reservation failed	Error12 - Funds reservation failed
B	Batch total violation	Error1  - Showing batch control total violation
C	Unopen reporting period	Error19 - Unopened reporting period
D	Post to not open period	Error2  - Selected for posting to an unopened period
E	No journal entries	Error3  - Showing no journal entries for this batch
F	Unopen reporting enc yr	Error20 - Unopened reporting encumbrance year
G	Bad suspense account	Error14 - Showing journal entry with invalid or inactive suspense account
H	Bad reserve account	Error15 - Showing encumbrance entry with invalid or inactive reserve account
I	Processing	Processing
J	Journal total violation	Error4  - Showing journal control total violation
K	Unbalanced IC JE	Error10 - Showing unbalanced intercompany journal entry
L	Unbalanced JE by acct category	Error11 - Showing unbalanced journal entry by account category
M	Multiple problems	Error5  - Showing multiple problems preventing posting of batch
N	Intercompany processing error	Error16 - Unable to balance intercompany accounts
O	No reporting conv info	Error21 - Unable to convert amounts into reporting currency
P	Posted	Posted
Q	Untaxed journal entry	Error17 - Showing untaxed journal entry
R	Unbalanced enc JE	Error8  - Showing unbalanced encumbrance entry without reserve account
S	Selected	Selected for posting
T	Invalid conversion information	Error13 - Showing invalid period and conversion information for this batch
U	Unposted	Unposted
V	Unapproved journal batch	Error18 - Showing unapproved journal batch
W	Enc JE with no enc type	Error9  - Showing an encumbrance journal entry with no encumbrance type
X	Unbalanced JE	Error6  - Showing an unbalanced journal entry but suspense not allowed
Z	Invalid or no JE lines	Error7  - Showing invalid journal entry lines or no journal entry lines