是定义暂记帐户后POST的。
日志如下,查METALINK也是关于定义暂记帐户,没解决问题:
+---------------------------------------------------------------------------+
Oracle General Ledger: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
GLPPOS module: Posting
+---------------------------------------------------------------------------+
当前的系统时间为 08-07-2005 15:07:26
+---------------------------------------------------------------------------+
>> glpmai() 08-07-2005 15:07:26
PPOS0003: *** 过帐过程开始 ****
PPOS0004: 所有的过帐事项将被详细登记在这个登记文件中.
PPOS0219: glpmai() - 您的过帐运行标识为 2393
>> glpini() 08-07-2005 15:07:26
>> glusts() 08-07-2005 15:07:26
>> glucce() 08-07-2005 15:07:26
>> glugsn() 08-07-2005 15:07:26
<< glugsn() 08-07-2005 15:07:26
<< glucce() 08-07-2005 15:07:26
<< glusts() 08-07-2005 15:07:26
>> glpuch() 08-07-2005 15:07:26
<< glpuch() 08-07-2005 15:07:26
>> glpueh() 08-07-2005 15:07:26
<< glpueh() 08-07-2005 15:07:26
<< glpini() 08-07-2005 15:07:26
>> glppva() 08-07-2005 15:07:26
<< glppva() 08-07-2005 15:07:26
>> glpmpi() 08-07-2005 15:07:26
>> gluddl() 08-07-2005 15:07:26
<< gluddl() 08-07-2005 15:07:26
>> gluddl() 08-07-2005 15:07:26
<< gluddl() 08-07-2005 15:07:27
>> gluddl() 08-07-2005 15:07:27
<< gluddl() 08-07-2005 15:07:28
>> gluddl() 08-07-2005 15:07:28
<< gluddl() 08-07-2005 15:07:28
<< glpmpi() 08-07-2005 15:07:28
>> glpcjl() 08-07-2005 15:07:28
<< glpcjl() 08-07-2005 15:07:28
>> glpcbs() 08-07-2005 15:07:28
<< glpcbs() 08-07-2005 15:07:28
>> glpisl() 08-07-2005 15:07:28
<< glpisl() 08-07-2005 15:07:28
>> glpcib() 08-07-2005 15:07:28
<< glpcib() 08-07-2005 15:07:28
>> glphok() 08-07-2005 15:07:28
<< glphok() 08-07-2005 15:07:28
>> glperp() 08-07-2005 15:07:28
<< glperp() 08-07-2005 15:07:28
>> glpipi() 08-07-2005 15:07:28
>> glusts() 08-07-2005 15:07:28
>> glucce() 08-07-2005 15:07:28
>> glugsn() 08-07-2005 15:07:28
<< glugsn() 08-07-2005 15:07:28
<< glucce() 08-07-2005 15:07:28
<< glusts() 08-07-2005 15:07:28
GL_POSTING_INTERIM_2393
SHRD0117: 把 55 记录插入 GL_POSTING_INTERIM_2393
SHRD0117: 把 0 记录插入 GL_POSTING_INTERIM_2393
>> glugst() 08-07-2005 15:07:29
<< glugst() 08-07-2005 15:07:29
>> glpip2() 08-07-2005 15:07:29
>> glusts() 08-07-2005 15:07:29
>> glucce() 08-07-2005 15:07:29
>> glugsn() 08-07-2005 15:07:29
<< glugsn() 08-07-2005 15:07:29
<< glucce() 08-07-2005 15:07:29
<< glusts() 08-07-2005 15:07:29
PPOS0206: 未找到以日记帐分录币种表示的统计额...
<< glpip2() 08-07-2005 15:07:29
<< glpipi() 08-07-2005 15:07:29
>> glpire() 08-07-2005 15:07:29
>> glusts() 08-07-2005 15:07:29
>> glucce() 08-07-2005 15:07:29
>> glugsn() 08-07-2005 15:07:29
<< glugsn() 08-07-2005 15:07:29
<< glucce() 08-07-2005 15:07:29
<< glusts() 08-07-2005 15:07:29
<< glpire() 08-07-2005 15:07:29
>> glsamn() 08-07-2005 15:07:29
>> glsini() 08-07-2005 15:07:29
STPM0021: 默认优化系数为 0。
<< glsini() 08-07-2005 15:07:29
>> glsfst() 08-07-2005 15:07:29
>> open_cursor() 08-07-2005 15:07:29
<< open_cursor() 08-07-2005 15:07:29
>> load_segnum_vsid() 08-07-2005 15:07:29
<< load_segnum_vsid() 08-07-2005 15:07:29
>> do_fetch_templates() 08-07-2005 15:07:29
SHRD0108: 从 GL_SUMMARY_TEMPLATES 中取回 1 记录
<< do_fetch_templates() 08-07-2005 15:07:29
<< glsfst() 08-07-2005 15:07:29
>> glsasi() 08-07-2005 15:07:29
<< glsasi() 08-07-2005 15:07:29
>> glsfst() 08-07-2005 15:07:29
>> do_fetch_templates() 08-07-2005 15:07:29
SHRD0108: 从 GL_SUMMARY_TEMPLATES 中取回 2 记录
<< do_fetch_templates() 08-07-2005 15:07:29
<< glsfst() 08-07-2005 15:07:29
>> glsasi() 08-07-2005 15:07:29
<< glsasi() 08-07-2005 15:07:29
>> glsfst() 08-07-2005 15:07:29
>> do_fetch_templates() 08-07-2005 15:07:29
SHRD0108: 从 GL_SUMMARY_TEMPLATES 中取回 3 记录
<< do_fetch_templates() 08-07-2005 15:07:29
<< glsfst() 08-07-2005 15:07:29
>> glsasi() 08-07-2005 15:07:29
<< glsasi() 08-07-2005 15:07:29
>> glsfst() 08-07-2005 15:07:29
>> do_fetch_templates() 08-07-2005 15:07:29
SHRD0108: 从 GL_SUMMARY_TEMPLATES 中取回 4 记录
<< do_fetch_templates() 08-07-2005 15:07:29
<< glsfst() 08-07-2005 15:07:29
>> glsasi() 08-07-2005 15:07:29
<< glsasi() 08-07-2005 15:07:29
>> glsfst() 08-07-2005 15:07:29
>> do_fetch_templates() 08-07-2005 15:07:29
SHRD0108: 从 GL_SUMMARY_TEMPLATES 中取回 5 记录
<< do_fetch_templates() 08-07-2005 15:07:29
<< glsfst() 08-07-2005 15:07:29
>> glsasi() 08-07-2005 15:07:29
<< glsasi() 08-07-2005 15:07:29
>> glsfst() 08-07-2005 15:07:29
>> do_fetch_templates() 08-07-2005 15:07:29
SHRD0108: 从 GL_SUMMARY_TEMPLATES 中取回 6 记录
<< do_fetch_templates() 08-07-2005 15:07:29
<< glsfst() 08-07-2005 15:07:29
>> glsasi() 08-07-2005 15:07:29
<< glsasi() 08-07-2005 15:07:29
>> glsfst() 08-07-2005 15:07:29
>> do_fetch_templates() 08-07-2005 15:07:29
SHRD0108: 从 GL_SUMMARY_TEMPLATES 中取回 7 记录
<< do_fetch_templates() 08-07-2005 15:07:29
<< glsfst() 08-07-2005 15:07:29
>> glsasi() 08-07-2005 15:07:29
<< glsasi() 08-07-2005 15:07:29
>> glsfst() 08-07-2005 15:07:29
>> do_fetch_templates() 08-07-2005 15:07:29
SHRD0108: 从 GL_SUMMARY_TEMPLATES 中取回 8 记录
<< do_fetch_templates() 08-07-2005 15:07:29
<< glsfst() 08-07-2005 15:07:29
>> glsasi() 08-07-2005 15:07:29
<< glsasi() 08-07-2005 15:07:29
>> glsfst() 08-07-2005 15:07:29
>> do_fetch_templates() 08-07-2005 15:07:29
<< do_fetch_templates() 08-07-2005 15:07:29
>> close_cursor() 08-07-2005 15:07:29
<< close_cursor() 08-07-2005 15:07:29
<< glsfst() 08-07-2005 15:07:29
<< glsamn() 08-07-2005 15:07:29
>> glpitr() 08-07-2005 15:07:29
insert into gl_posting_interim_2393 ( code_combination_id, period_name, set_of_books_id, currency_code, period_year, period_num, period_type, account_type, bal_seg_value, actual_flag, encumbrance_type_id, budget_version_id, period_net_dr, period_net_cr, begin_balance_dr, begin_balance_cr, quarter_to_date_dr, quarter_to_date_cr, project_to_date_dr, project_to_date_cr, period_net_dr_beq, period_net_cr_beq, begin_balance_dr_beq, begin_balance_cr_beq, template_id, translated_flag ) select pi.code_combination_id, pi.period_name, pi.set_of_books_id, tt.target_currency, pi.period_year, pi.period_num, pi.period_type, pi.account_type, pi.bal_seg_value, pi.actual_flag, pi.encumbrance_type_id, pi.budget_version_id, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, 'N' from gl_sets_of_books sob, gl_translation_tracking tt, gl_posting_interim_2393 pi where pi.set_of_books_id = tt.set_of_books_id and tt.actual_flag = 'A' and nvl(SUBSTRB(pi.bal_seg_value,1,(INSTRB(pi.bal_seg_value||'
','
',1)-1)),-1) = nvl(tt.bal_seg_value,-1) and (pi.period_year*1000+pi.period_num) >= (tt.earliest_ever_period_year*1000+tt.earliest_ever_period_num) and (pi.period_year*1000+pi.period_num)
<< glpitr() 08-07-2005 15:07:29
>> glpibr() 08-07-2005 15:07:29
>> glpibr.concurrency() 08-07-2005 15:07:29
<< glpibr.concurrency() 08-07-2005 15:07:29
<< glpibr() 08-07-2005 15:07:29
>> glncbe() 08-07-2005 15:07:29
>> glutbe() 08-07-2005 15:07:29
<< glutbe() 08-07-2005 15:07:29
>> glusbe() 08-07-2005 15:07:29
<< glusbe() 08-07-2005 15:07:29
<< glpcbe() 08-07-2005 15:07:29
>> glpubr() 08-07-2005 15:07:29
>> glpubr.concurrency() 08-07-2005 15:07:29
<< glpubr.concurrency() 08-07-2005 15:07:29
PPOS0225: glpubr(): 表 GL_BALANCES 中修改的记录条数跟表 GL_POSTING_INTERIM_2393 中的不相等。
PPOS0226: 余额修改将被“滚回”. 过帐在这里停止.
Error in ROUTINE: glpubr, status: 0
SHRD0043: ERROR:
glpubr:updated balances rows != gl_interim_posting rows. Posting stops.
CALL YOUR CUSTOMER SUPPORT REPRESENTATIVE!
***************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01403: 未找到数据
sqlerrp: sqlerrd: 0 0 266 0 0 0
sqlwarn: sqltext:
*****************************************************
SHRD0044: 处理正在注销数据库并退出 ...
>> glpuch() 08-07-2005 15:07:29
<< glpuch() 08-07-2005 15:07:29
>> glpueh() 08-07-2005 15:07:29
<< glpueh() 08-07-2005 15:07:29
>> glpdit() 08-07-2005 15:07:29
>> gluddl() 08-07-2005 15:07:29
<< gluddl() 08-07-2005 15:07:30
<< glpdit() 08-07-2005 15:07:30
PPOS0002: 致命的错误导致过帐中断
+---------------------------------------------------------------------------+
Plsql 程序的日志信息开始
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
PlSql 程序的日志信息结尾
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
正在执行请求完成选项...
已完成执行请求完成选项。
GLPPOS - process exiting with failure.
+---------------------------------------------------------------------------+
已完成并发请求
当前的系统时间为 08-07-2005 15:07:30
+---------------------------------------------------------------------------+