问题集

一、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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26101098/viewspace-745171/