建議作法如下:
當超過一小時後
- 先請DBA協助檢查是否有Lock.
- 若無,請User取消其Journal Import Request.此時要再請DBA檢查是否有Lock確定User的session已經結束.
若有,則請DBA協助解除Lock等待程式執行完畢.
- 檢查該帳本是否有其他應關而未關之期間.(正常情況下應該僅開啟兩期)
- 備份該帳本的GL_INTERFACE資料. SELECT * FROM GL_INTERFACE WHERE SET_OF_BOOKS_ID=:帳本ID AND ACCOUNTING_DATE=:日期或日期區間
- 重建Index,方式如下:
Freeze your account structure.
Navigate to the Submit Request window.
Select the Optimizer program.
Enter Yes for Maintain Indexes to create or drop the indexes for your chart of accounts.
The Optimizer creates an index on a segment if one does not yet exist, and drops an index on a segment if you no longer index the segment. This is useful when you define a new chart of accounts for which you want to index particular segments or when you want to add or drop an index for an existing segment in your chart of accounts.
- 再請DBA檢查是否有Lock,若無,才請User執行Journal Import.
- 要定期清GL_INTERFACE不需要的資料.目前AB公司皆有程式針對3003(CLT)拋入GL_INTERFACE的Accrual項目,修改GL_INTERFACE.STATUS=’PROCESSED’,避免這類型的資料拋入總帳中.
Delete GL_INTERFACE
WHERE SET_OF_BOOKS_ID=3003
AND STATUS=’PROCESSED’
AND USER_JE_SOURCE_NAME=’ Periodic Inventory’
如果User很急著要立帳,無法等待處理,則使用下面script,請其用WEBADI立帳.
select
a.currency_code,
a.user_je_category_name,
a.user_je_source_name,
b.segment1,b.segment2,b.segment3,b.segment4,b.segment5,b.segment6, b.segment7,
a.entered_dr,a.entered_cr,
a.accounted_dr,a.accounted_cr,
a.reference1,
a.reference2,
a.reference5,
a.reference10,
a.reference21,
a.group_id
from gl_interface a,
gl_code_combinations b
where b.chart_of_accounts_id=:coa_ID
and a.set_of_books_id=:SOB_ID
and a.CODE_COMBINATION_ID=b.code_combination_id
and a.user_je_category_name=:category_name
其他細節請見Metalink: 11i: How To Improve Performance of General Ledger and Journal Import [ID 198437.1]
