error message 如下, 這次結帳好多問題,頭都大了
+---------------------------------------------------------------------------+
Oracle General Ledger: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
GLLEZL module: Journal Import
+---------------------------------------------------------------------------+
Current system time is 31-AUG-2004 21:36:55
+---------------------------------------------------------------------------+
>> gllsob() 31-AUG-2004 21:36:55
sob_id = 3
sob_name = xxxx股份有限公司
coa_id = 50222
num_segments = 7
delim = '-'
segments =
SEGMENT1
SEGMENT2
SEGMENT3
SEGMENT4
SEGMENT5
SEGMENT6
SEGMENT7
index segment is SEGMENT2
balancing segment is SEGMENT6
currency = NTD
sus_flag = N
ic_flag = N
latest_opened_encumbrance_year = 2004
> gllsys() 31-AUG-2004 21:36:55
fnd_user_id = 1684
fnd_user_name = HWFIN06427
fnd_login_id = 775517
con_request_id = 665498
sus_on = 0
from_date =
to_date =
create_summary = 0
archive = 0
num_rec = 1000
num_flex = 2500
run_id = 168424
> gllcsa() 31-AUG-2004 21:36:55
> gllcnt() 31-AUG-2004 21:36:55
SHRD0118: Updated 1 record(s) in table: gl_interface_control
source name = Payables
group id = 167351
LEZL0001: Found 1 sources to process.
>> glluch() 31-AUG-2004 21:36:55
> glifgn() 31-AUG-2004 21:36:55
> gl_import_hook_pkg.pre_module_hook() 31-AUG-2004 21:36:55
> gllpst() 31-AUG-2004 21:36:56
SHRD0108: Retrieved 32 records from gl_period_statuses
> glldat() 31-AUG-2004 21:36:56
Successfully built decode fragment for period_name and period_year
>> gllbud() 31-AUG-2004 21:36:56
> gllenc() 31-AUG-2004 21:36:56
SHRD0108: Retrieved 4 records from gl_encumbrance_types
> glldlc() 31-AUG-2004 21:36:56
> gllcvr() 31-AUG-2004 21:36:56
SHRD0108: Retrieved 5 records from gl_daily_conversion_types
> gllfss() 31-AUG-2004 21:36:56
LEZL0005: Successfully finished building dynamic SQL statement.
> gllcje() 31-AUG-2004 21:36:56
SHRD0108: Retrieved 136 records from gl_je_categories
SHRD0079: 54 record(s) inserted into gl_je_lines
SHRD0118: Updated 54 record(s) in table: GL_INTERFACE
SHRD0108: Retrieved 54 records from GL_INTERFACE
> gllsum() 31-AUG-2004 21:36:56
> glldjc() 31-AUG-2004 21:36:56
LEZL0010: Deleting error je lines ...
LEZL0011: Deleted 54 error je lines.
LEZL0012: Total error je lines deleted: 54.
> gllchd() 31-AUG-2004 21:36:56
> gllcbh() 31-AUG-2004 21:36:56
> gllccl_cross_currency_lines() 31-AUG-2004 21:36:57
> gllper() 31-AUG-2004 21:36:57
> gllups() 31-AUG-2004 21:36:57
SHRD0118: Updated 9 record(s) in table: GL_INTERFACE
SHRD0118: Updated 18 record(s) in table: GL_INTERFACE
SHRD0118: Updated 16 record(s) in table: GL_INTERFACE
SHRD0118: Updated 11 record(s) in table: GL_INTERFACE
> gllref() 31-AUG-2004 21:36:57
SHRD0117: Inserted 0 record(s) into gl_import_references
> glluch() 31-AUG-2004 21:36:57
> gllseq() 31-AUG-2004 21:36:57
> glldhk() 31-AUG-2004 21:36:57
> gllaar() 31-AUG-2004 21:36:57
>> gllric() 31-AUG-2004 21:36:57
LEZL0014: 1 gl_interface_control records reset.
assign the resource : decoupewith operation 20 -> assign the resource : painting - /WIP/discrete/discrete jobscreate a job for this assembly : LDL-CADRE-M - /WIP/move transactions/move transactionsmove from operation 10 to operation 20 - /INV/setup/transactions/interface managersmake sure that " WIP Move Transaction Manager" is runningmake sure that "Cost Manager" is runningand wait for "Resource Cost Worker" and "Overhead Cost Worker" to complete: normal - /INV/accounting/general Ledger transfertsrun "Transfer transactions to GL" (INCTGL) - /GL/journals/import/runrun " Journal Import" (GLLEZL)=> GLLEZL is completed, normal, but in the output of this journal import :"Journal Import Execution Report" you will see either the error EU02 or the warning WU01(this will depend of the setup of your set of books) 2) Why are you getting the error EU02 :----------------------------------/GL/setup/financials/books/define For your set of booksif allow suspense posting flag is offyou will get in the output of this journal import (GLLEZL) :" Journal Import Execution Report" :==== extract of Journal Import Execution Report ==== Error
CodeJournal Entry Name Batch Name Total Debits Total Credits ----- ------------------ ----------------------------- ------------- EU02WIP
336 FRO Inventory430.00130.00. . ... Unbalanced Journal Error Codes ------------------------------ EU02This journal entry is unbalanced and suspense posting is
not allowed in this set of books. ==== end of extract of Journal Import Execution Report ====3) to fix the error EU02 :---------------------3.1) fix for future jobs : you need to find the resource who is making this errorTherefore you can run those selects to sort it out : A) Select set_of_books_id SOB , user_je_category_nameCAT,
user_je_source_name SOURCE, status, reference21 from gl_interface where reference21= '&batch_name';
Batch_name is equals to the batch name number you will get in the output . this will show you result such as : SOBCAT
SOURCE STATUS REFERENCE21 ---- ------ --------------- -------- -----------
1 WIP
Inventory EU02,P 336
1 WIP
Inventory EU02,P 336 B) SELECT M.currency_code CURRENCY CUR, M.REFERENCE_ACCOUNT ACCOUNT,DECODE(sign(SUM(NVL(M.TRANSACTION_VALUE,M.BASE_TRANSACTION_VALUE))),1,SUM(NVL(M.TRANSACTION_VALUE,M.BASE_TRANSACTION_VALUE)),0) d,DECODE(sign(SUM(NVL(M.TRANSACTION_VALUE,M.BASE_TRANSACTION_VALUE))),-1,(-1*SUM(NVL(M.TRANSACTION_VALUE,M.BASE_TRANSACTION_VALUE))),0) c,DECODE(sign(SUM(M.BASE_TRANSACTION_VALUE)),1,SUM(M.BASE_TRANSACTION_VALUE),0) e,DECODE(sign(SUM(M.BASE_TRANSACTION_VALUE)),-1,(-1*SUM(M.BASE_TRANSACTION_VaLUE)),0)fFROM WIP_TRANSACTION_ACCOUNTS MWHERE gl_batch_id = &reference21
GROUP BY
M.CURRENCY_CODE,
M.REFERENCE_ACCOUNT ; reference21 is equals to reference21 in the select above this will show you result such as :CUR ACCOUNT
D
C
E
F--- ------- ---------- ---------- ---------- ----------
-1
0300
0300
1012430
0430
0
1182
0130
0130C) what we are focus on is the line with reference_account=-1 SELECT M.REFERENCE_ACCOUNT ACCOUNT, M.resource_id, M.wip_entity_id,
B.RESOURCE_CODE, B.descriptionFROM WIP_TRANSACTION_ACCOUNTS M, bom_resources Bwhere M.REFERENCE_ACCOUNT=-1 and M.resource_id=B.resource_id and gl_batch_id = &reference21; reference21 is equals to reference21 in the select above this will show you result such as : ACCOUNT RESOURCE_ID WIP_ENTITY_ID RESOURCE_C DESCRIPTION ------- ----------- ------------- ---------- ------------
-1 615
6713 DECOUPEDecoupe
-1 615
6713 DECOUPEDecoupeD) therefore you know that you need to fix the resource DECOUPEin BOMFDORS by doing what is required at step "FIRST" above.So this will avoid this error for future jobs3.2) fix for old jobs that are already stuck in gl_interface => how to fix the error EU02 : look [NOTE:135925.1] CASE 2 :4) Why are you getting the warning WU01 :------------------------------------ /GL/setup/financials/books/define for your set of booksif allow suspense posting flag is on you will get in the output of this journal import (GLLEZL) :" Journal Import Execution Report" :==== extract of Journal Import Execution Report ==== Warning Batch Name
Accounted Debits Accounted Credits ------- --------------------------- ---------------- ----------------- WU01337 FRO Inventory
430
130 Unbalanced Journal Error Codes ------------------------------ WU01Warning: This journal entry is unbalanced.It is accepted
because suspense posting is allowed in this set of books. ==== end of extract of Journal Import Execution Report ====5) to fix the warning WU01 : ----------------------- 5.1) fix for future jobs : you need to find the resource who is making this errortherefore you can run those selects to sort it out :A) Select set_of_books_id SOB , user_je_category_nameCAT, user_je_source_name SOURCE, status, reference21from gl_interfacewhere reference21= '&batch_name';Batch_name is equals to the batch name number you will get in the output As this is a warning and not an error you will have no rows stucked in gl_interfaceB) SELECT M.currency_code CUR, M.REFERENCE_ACCOUNT ACCOUNT,DECODE(sign(SUM(NVL(M.TRANSACTION_VALUE,M.BASE_TRANSACTION_VALUE))),1,SUM(NVL(M.TRANSACTION_VALUE,M.BASE_TRANSACTION_VALUE)),0) d,DECODE(sign(SUM(NVL(M.TRANSACTION_VALUE,M.BASE_TRANSACTION_VALUE))),-1,(-1*SUM(NVL(M.TRANSACTION_VALUE,M.BASE_TRANSACTION_VALUE))),0) c,DECODE(sign(SUM(M.BASE_TRANSACTION_VALUE)),1,SUM(M.BASE_TRANSACTION_VALUE),0) e,DECODE(sign(SUM(M.BASE_TRANSACTION_VALUE)),-1,(-1*SUM(M.BASE_TRANSACTION_VaLUE)),0)fFROM WIP_TRANSACTION_ACCOUNTS MWHERE gl_batch_id = &reference21
GROUP BY
M.CURRENCY_CODE,
M.REFERENCE_ACCOUNT ;reference21 is equals the batch name number you will get in the outputthis will show you result such as :CUR ACCOUNT
D
C
E
F --- ---------- ---------- ---------- ---------- ----------
-1
0300
0300
1012430
0430
0
1182
0130
0130C) what we are focus on is the line with reference_account=-1 SELECT M.REFERENCE_ACCOUNT ACCOUNT, M.resource_id, M.wip_entity_id, B.RESOURCE_CODE, B.descriptionFROM WIP_TRANSACTION_ACCOUNTS M, bom_resources Bwhere M.REFERENCE_ACCOUNT=-1 and M.resource_id=B.resource_id and gl_batch_id = &reference21; reference21 is equals to reference21 in the select above this will show you result such as :ACCOUNT RESOURCE_ID WIP_ENTITY_ID RESOURCE_C DESCRIPTION ---- ----------- ------------- ---------- ------------
-1 615
6714 DECOUPEDecoupe
-1 615
6714 DECOUPEDecoupeD) therefore you know that you need to fix the resource DECOUPEin BOMFDORS by doing what is required at step "FIRST" above.So this will avoid this error for future jobs5.2) fix for old jobs with warning WU01 => look [NOTE:154177.1] RELATED DOCUMENTS -----------------[NOTE:135925.1] how to fix the error EU02 [NOTE:154177.1] how to fix the warning WU01
.
--------------------------------------------------------------------------------
Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. 法律声明和使用条款。
|
