AR invoices transferred to GL successfully but can't be found in GL module

来源:互联网 发布:生日提醒软件农历 编辑:程序博客网 时间:2024/05/16 10:57
 logfiles:
+---------------------------------------------------------------------------+
General Ledger: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

GLLEZL module: Journal Import
+---------------------------------------------------------------------------+

Current system time is 25-JUL-2008 08:29:55

+---------------------------------------------------------------------------+


>> gllsob() 25-JUL-2008 08:29:55

sob_id = 1003
sob_name = Amertron PH SOB
coa_id = 50268
num_segments = 8
delim = '.'
segments =
SEGMENT1
SEGMENT2
SEGMENT3
SEGMENT4
SEGMENT5
SEGMENT6
SEGMENT7
SEGMENT8
index segment is SEGMENT3
balancing segment is SEGMENT1
currency = PHP
sus_flag = N
ic_flag = Y
latest_opened_encumbrance_year = 2008
<< gllsob() 25-JUL-2008 08:29:56

>> gllsys() 25-JUL-2008 08:29:56

fnd_user_id = 1580
fnd_user_name = ERP_SYSADMIN
fnd_login_id = 5029598
con_request_id = 4991492
sus_on = 0
from_date = 2008/03/01
to_date = 2008/05/31
create_summary = 0
archive = 0
num_rec = 1000
num_flex = 2500
run_id = 397024
<< gllsys() 25-JUL-2008 08:29:56
SHRD0108: Retrieved 10 records from fnd_currencies

>> gllcsa() 25-JUL-2008 08:29:56

<< gllcsa() 25-JUL-2008 08:29:56

>> gllcnt() 25-JUL-2008 08:29:56
SHRD0118: Updated 1 record(s) in table: gl_interface_control

source name = Receivables
group id = 288017
LEZL0001: Found 1 sources to process.

>> glluch() 25-JUL-2008 08:29:56

<< glluch() 25-JUL-2008 08:29:56

>> gl_import_hook_pkg.pre_module_hook() 25-JUL-2008 08:29:56

<< gl_import_hook_pkg.pre_module_hook() 25-JUL-2008 08:29:56

>> glusbe() 25-JUL-2008 08:29:56

<< glusbe() 25-JUL-2008 08:29:56

<< gllcnt() 25-JUL-2008 08:29:56

>> gllpst() 25-JUL-2008 08:29:56
SHRD0108: Retrieved 52 records from gl_period_statuses

<< gllpst() 25-JUL-2008 08:29:56

>> glldat() 25-JUL-2008 08:29:56

Successfully built decode fragment for period_name and period_year
>> gllbud() 25-JUL-2008 08:29:56
SHRD0108: Retrieved 3 records from the budget tables

<< gllbud() 25-JUL-2008 08:29:56

>> gllenc() 25-JUL-2008 08:29:56
SHRD0108: Retrieved 6 records from gl_encumbrance_types

<< gllenc() 25-JUL-2008 08:29:56

>> glldlc() 25-JUL-2008 08:29:56

<< glldlc() 25-JUL-2008 08:29:56

>> gllcvr() 25-JUL-2008 08:29:56
SHRD0108: Retrieved 2 records from gl_daily_conversion_types

<< gllcvr() 25-JUL-2008 08:29:56

>> gllfss() 25-JUL-2008 08:29:56
LEZL0005: Successfully finished building dynamic SQL statement.

<< gllfss() 25-JUL-2008 08:29:56

>> gllcje() 25-JUL-2008 08:29:56
SHRD0108: Retrieved 136 records from gl_je_categories
SHRD0079: 155 record(s) inserted into gl_je_lines
SHRD0118: Updated 155 record(s) in table: GL_INTERFACE
SHRD0108: Retrieved 155 records from GL_INTERFACE

<< gllcje() 25-JUL-2008 08:29:57

>> gllsum() 25-JUL-2008 08:29:57

<< gllsum() 25-JUL-2008 08:29:57

>> glldjc() 25-JUL-2008 08:29:57
LEZL0012: Total error je lines deleted: 0.

<< glldjc() 25-JUL-2008 08:29:57

>> gllchd() 25-JUL-2008 08:29:57
SHRD0105: Inserting into gl_je_headers ...
SHRD0117: Inserted 6 record(s) into gl_je_headers

<< gllchd() 25-JUL-2008 08:29:57

>> gllcbh() 25-JUL-2008 08:29:57
SHRD0105: Inserting into gl_je_batches ...
SHRD0117: Inserted 2 record(s) into gl_je_batches

<< gllcbh() 25-JUL-2008 08:29:57

>> gllccl_cross_currency_lines() 25-JUL-2008 08:29:57

<x gllccl() 25-JUL-2008 08:29:57

Error in: gllccl
Function return status: 0
Function Err Message: failure to get cross currency account
Function warning number: -1

*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 1403 sqlerrml: 25
sqlerrmc:
ORA-01403: no data found

sqlerrp: sqlerrd: 0 2 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.


+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 25-JUL-2008 08:29:57

+---------------------------------------------------------------------------+


I have solved this problem on ERPDB. You can check it now. This problem was caused by cross currency account. So you need to setup suspense account.
Attachment is the method of setuping suspense account. You need to select an apposite account for suspense account.


Here "apposite account" is a transfer account.
After setup  suspense account, you need to run 'Journal Import'.




You don't need to setup new account. The transfer account you use currently is useful. Because the transfer account is just for transfer and then the balance of the transfer account is zero.(See the attachment).
Another way that you can setup new account for suspense account.


1.PATH:GL/Setup/Financials/Books/Define

2.PATH:GL/Setup/Accounts/Suspense