WEB ADI Journal Import “Function Err Message: there is no suspense account defined”

This is the second time i received this error report, so I thought about putting this here to save me hours of searching 🙂

Hope it help others too.

Cause:
Profile GLDI: Create Group Id was not set.This caused the error.

Solution:
To implement the solution, please execute the following steps:

1. Set the Profile GLDI : Create Group Id
2. This would ensure a group_id is populated for import.

953515.1- Function Err Message There Is No Default Suspense Account Defined In Journal Import From Web ADI

Sample logfile of the error:

+—————————————————————————+
General Ledger: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
GLLEZL module: Journal Import
+—————————————————————————+
Current system time is 21-NOV-2011 02:35:45
+—————————————————————————+
>> gllsys() 21-NOV-2011 02:35:45
    fnd_user_id = 1130
    fnd_user_name = CGLANCERO
    fnd_login_id = 62967
    con_request_id = 400224
    sus_on = 1
    from_date = 2011/10/31
    to_date = 2011/10/31
    create_summary = 1
    archive = 0
    num_rec = 1000
    run_id = 196
<< gllsys() 21-NOV-2011 02:35:45
SHRD0108: Retrieved 3 records from fnd_currencies

>> gllcnt() 21-NOV-2011 02:35:45
SHRD0118: Updated 1 record(s) in table: gl_interface_control

 source name = Closing Journal 
 interface source name = Closing Journal 
 group id = -1
 ledger_id = -1
LEZL0001: Found 1 sources to process.
>> glluch() 21-NOV-2011 02:35:45
<< glluch() 21-NOV-2011 02:35:45
>> gl_import_hook_pkg.pre_module_hook() 21-NOV-2011 02:35:45
<< gl_import_hook_pkg.pre_module_hook() 21-NOV-2011 02:35:45
>> glusbe() 21-NOV-2011 02:35:45
<< glusbe() 21-NOV-2011 02:35:45
<< gllcnt() 21-NOV-2011 02:35:45
>> gllacc() 21-NOV-2011 02:35:45
<< gllacc() 21-NOV-2011 02:35:45
>> gllenc() 21-NOV-2011 02:35:45
SHRD0108: Retrieved 6 records from gl_encumbrance_types
<< gllenc() 21-NOV-2011 02:35:45
>> gllfss() 21-NOV-2011 02:35:45
LEZL0005: Successfully finished building dynamic SQL statement.
<< gllfss() 21-NOV-2011 02:35:45
>> gllcje() 21-NOV-2011 02:35:45
>> gllalb() 21-NOV-2011 02:35:45
<< gllalb() 21-NOV-2011 02:35:45
>> glllgr() 21-NOV-2011 02:35:45
>> gllpst() 21-NOV-2011 02:35:45
SHRD0108: Retrieved 72 records from gl_period_statuses
<< gllpst() 21-NOV-2011 02:35:45
>> gllbud() 21-NOV-2011 02:35:45
<< gllbud() 21-NOV-2011 02:35:45
    currency = USD
    sus_flag = N
    ic_flag = N
    bc_flag = N
    latest_opened_encumbrance_year = 2011
<< glllgr() 21-NOV-2011 02:35:45
SHRD0108: Retrieved 164 records from gl_je_categories
>> gllcsa() 21-NOV-2011 02:35:45
<< gllcsa() 21-NOV-2011 02:35:45
<x gllsus() 21-NOV-2011 02:35:45
<x gllerp() 21-NOV-2011 02:35:45
<x gllcje() 21-NOV-2011 02:35:45
Error in: gllsus.gllsus
Function return status: 0
Function Err Message: there is no suspense account defined
Function warning number: -1
*****************************************************
sqlcaid:   sqlabc: 0  sqlcode:  1403  sqlerrml: 25
sqlerrmc:
ORA-01403: no data found

sqlerrp:      sqlerrd: 0 0 0 0 0 538976288
sqlwarn:           sqltext: 
*****************************************************SHRD0044: Process logging off database and exiting …
+—————————————————————————+
Start of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
End of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
Executing request completion options…
Finished executing request completion options.
SHRD0014: GLLEZL – process exiting with failure.
+—————————————————————————+
Exceptions posted by this request:
Concurrent Request for “Journal Import” has completed with error.
+—————————————————————————+
Concurrent request completed
Current system time is 21-NOV-2011 02:35:45
+—————————————————————————+

Advertisements

About this entry