ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 问题集

问题集

原创 Linux操作系统 作者:静夜细藤 时间:2012-09-27 09:42:07 0 删除 编辑
一、APP-SQLAP-10710 Online accounting could not be created. Please submit the   Payables Accounting Process instead to create accounting entries for this transaction.

AN:如此这般即可解决 
a) Verify if there are events not tied to an invoice
select source_id, accounting_event_id, event_type_code, event_status_code
from ap_accounting_events_all aae
where source_table='AP_INVOICES'
and not exists (select 1
from ap_invoice_distributions_all
where accounting_event_id=aae.accounting_event_id);

b) Delete the events not tied to an invoice
delete from ap_accounting_events_all aae
where source_table='AP_INVOICES'
and not exists (select 1
from ap_invoice_distributions_all
where accounting_event_id=aae.accounting_event_id);

commit;

c) Run the Payables Accounting process(应付会计核算流程) again and verify that you are not 
getting the same error

二、java.sql.SQLException: ORA-20001: FLEX-NULL CCID: ORA-06512: at "APPS.HR_ORGANIZATION_API", line 4872 ORA-06512: at "APPS.GL_LEDGERS_PKG", line 111 ORA-06512: at line 1 

AN:
观察错误信息可以发现错误发生在HR_ORGANIZATION设置的时候有的弹性域是空值的错误。
HR_ORGANIZATION是在库存组织下定义业务组的时候的一个属性,这个里面定义了成本信息,而成本信息中使用的弹性域COST_ALLOCATION_FLEXFILE中有五个段均为必输,但是在画面上只能输入一个段的值,这样其余的四个段都是空值,所以会报上面的错误,报了上面的错误就会导致辅助分类账的创建不成功,因此把其余的必输项改成非必输就可以解决。
如何判断辅分类账是否创建成功可以使用下面的SQL检验:
SELECT NVL(TO_CHAR(lr.source_ledger_id), 'No row exists')         Does_it_Exist
FROM (SELECT 'A' token
FROM dual) d,
(SELECT 'A' token,
source_ledger_id
FROM gl_ledger_relationships glr
WHERE glr.source_ledger_id (+)= &ParentLedgerId
AND glr.target_ledger_id (+)= &SecondaryLedgerId
AND glr.target_ledger_category_code(+) = 'ALC'
AND glr.relationship_type_code(+) != 'BALANCE'
AND glr.application_id(+) = 101
AND glr.relationship_enabled_flag(+) = 'Y') lr
WHERE d.token = lr.token (+)

SELECT 'A' token,
glr.source_ledger_id,
glr.target_ledger_category_code,
glr.relationship_type_code,
glr.application_id,
glr.relationship_enabled_flag
FROM gl_ledger_relationships glr
WHERE glr.source_ledger_id (+)= &ParentLedgerId
AND glr.target_ledger_id (+)= &SecondaryLedgerId

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26101098/viewspace-745171/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-07-27

  • 博文量
    43
  • 访问量
    79417