创建会计科目程序报错[会计程序 创建会计科目]

纵横四海

这个是第一次，过账出现的错误，有可能那个地方没有设置好，请大家看看估计是什么地方没有设置好？


该贴已经同步到 纵横四海的微博

纵横四海

这个是我作的应收

纵横四海

纵横四海 发表于 2011/10/12 13:28
这个是我作的应收

查看会计科目，也已经生成了

纵横四海

R12 XLA的部分包可能失效，我们一般验证会计科目请求后正常

微博评论

是Oracleebs？

来自 swrobin7 的新浪微博

zhihuanwang

纵横四海 发表于 2011/10/12 14:35
R12 XLA的部分包可能失效，我们一般验证会计科目请求后正常

不是“可能失效”，是SLA更改或变动后，需要运行请求重新验证，这是正常流程。

纵横四海

zhihuanwang 发表于 2011/10/15 09:58
不是“可能失效”，是SLA更改或变动后，需要运行请求重新验证，这是正常流程。

在OTN上查到一个类似的错误，粘贴上来，看是否有参考意义：

1. +---------------------------------------------------------------------------+
   
2. Subledger Accounting: Version : 12.0.0
   
3. 
   
4. Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
   
5. 
   
6. XLAACCUP module: Accounting Program
   
7. +---------------------------------------------------------------------------+
   
8. 
   
9. Current system time is 14-APR-2010 07:27:27
   
10. 
    
11. +---------------------------------------------------------------------------+
    
12. 
    
13. **Starts**14-APR-2010 07:27:27
    
14. **Ends**14-APR-2010 07:27:29
    
15. An internal error occurred.  Please inform your system administrator or support representative that:
    
16. 
    
17. An internal error has occurred in the program xla_ar_acct_hooks_pkg.main.  Technical problem : Error encountered in product API for extract
    
18. An internal error occurred.  Please inform your system administrator or support representative that:
    
19. 
    
20. An internal error has occurred in the program xla_ar_acct_hooks_pkg.main.  Technical problem : Error encountered in product API for extract
    
21. +---------------------------------------------------------------------------+
    
22. Start of log messages from FND_FILE
    
23. +---------------------------------------------------------------------------+
    
24. 14-APR-2010 07:27:27 - Executing Unit Processor ...
    
25. 14-APR-2010 07:27:27 - Initializing variables
    
26. 14-APR-2010 07:27:27 - Security Context Set
    
27. 14-APR-2010 07:27:27 - Ready to cache the Application and Ledger Level Sources ...
    
28. 14-APR-2010 07:27:28 - Cached the Application and Ledger Level Sources
    
29. 14-APR-2010 07:27:29 - Entering the loop to read document units from the queue ...
    
30. 14-APR-2010 07:27:29 - Checking status of the parent Accounting Program
    
31. 14-APR-2010 07:27:29 - Dequeuing the unit from the queue
    
32. 14-APR-2010 07:27:29 - Fetching event information for the documents in the unit
    
33. 14-APR-2010 07:27:29 - executing extract hook
    
34. ARP_XLA_EXTRACT_MAIN_PKG.extract()+
    
35.      p_application_id  :222
    
36.      p_accounting_mode :F
    
37. Calling upgrade_11i_r12_post +
    
38.   Get 11i application to upgrade
    
39. End upgrade_11i_r12_post -
    
40. arp_xla_extract_main_pkg.load_header_data_ctlgd ()+
    
41. ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-
    
42. ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+
    
43. EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_ctlgd
    
44. Error      :User-Defined Exception
    
45. EXCEPTION OTHERS in arp_xla_extract_main_pkg.extract
    
46. Error      :User-Defined Exception
    
47. Technical problem : Error encountered in product API for extract
    
48. +---------------------------------------------------------------------------+
    
49. End of log messages from FND_FILE
    
50. +---------------------------------------------------------------------------+
    
51. 
    
52. 
    
53. +---------------------------------------------------------------------------+
    
54. Executing request completion options...
    
55. 
    
56. 
    
57. Finished executing request completion options.
    
58. 
    
59. +---------------------------------------------------------------------------+
    
60. Exceptions posted by this request:
    
61. Concurrent Request for "Accounting Program" has completed with error.
    
62. 
    
63. +---------------------------------------------------------------------------+
    
64. Concurrent request completed
    
65. Current system time is 14-APR-2010 07:27:30
    
66. 
    
67. +---------------------------------------------------------------------------+
    
68. 
    
69. 
    
70. 
    
71. 
    

复制代码

Hi user;

Please check below:

R12 Create Accounting Program Fails with EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_ctlgd [ID 427654.1]
XLAACCUP Error In XLA_AR_ACCT_HOOKS_PKG.Main [ID 941729.1]

Regard
Helios

纵横四海

R12 Create Accounting Program Fails with EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_ctlgd [ID 427654.1]
--------------------------------------------------------------------------------

  修改时间 23-MAR-2011     类型 PROBLEM     状态 PUBLISHED   

--------------------------------------------------------------------------------

Applies to:
Oracle Receivables - Version: 12.0.0 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.
XLAACCUP
Symptoms
XLAACCUP module: Accounting Program Ends with the following error in the log files:

An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_ar_acct_hooks_pkg.main. Technical problem : Error encountered in product API for extract

An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_ar_acct_hooks_pkg.main. Technical problem : Error encountered in product API for extract
......
......
EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cr
Error :User-Defined Exception
EXCEPTION OTHERS in arp_xla_extract_main_pkg.extract
Error :User-Defined Exception
Technical problem : Error encountered in product API for extract

-- Steps To Reproduce:
Navigation Path > Receivables Manager > Transactions > Transactions
Create and complete the invoice.
Tools > Create Accounting.

Cause
Item Validation Organization is not set in OM.

For upgrades from any prior release you might have run into bug 6323426 where this setup is lost during the upgrade and needs to be re-done.
For new installations on release 12 you need to have this setup.


Solution
-- To implement the solution, please execute the following steps:
Assign Operating Unit to the seeded OM responsibility.
Assign OM Responsibility to your user.

Setup Item Validation Organization in Order Management.
(N): OM -> Setup -> System Parameters -> Values
Query for Parameter 'Item Validation Organization'
Setup the Item Validation Organization from list of values.

References
BUG:6323426 - ONDEMAND:R12-SETUP OM PARAMETERS WERE NOT COPIED FROM 11.5.9 AFTER UPGRADE


•Oracle E-Business Suite > Financial Management > Credit to Cash > Oracle Receivables
关键字
--------------------------------------------------------------------------------
CREATE ACCOUNTING; ITEM VALIDATION ORGANIZATION; Oracle ORDER MANAGEMENT (Q497); Oracle RECEIVABLES (Q505); USER-DEFINED EXCEPTION; XLAACCUP

纵横四海

XLAACCUP Error In XLA_AR_ACCT_HOOKS_PKG.Main, EXCEPTION OTHERS in arp_xla_extract_main_pkg.postprocessing Error :ORA-00060 [ID 941729.1]
--------------------------------------------------------------------------------

  修改时间 24-FEB-2011     类型 PROBLEM     状态 PUBLISHED   


--------------------------------------------------------------------------------
Applies to:
Oracle Receivables - Version: 12.0.4 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.
***Checked for relevance on 24-Feb-2011***
Create Accounting Program, XLAACCUP
Symptoms
On 12.0.4 in Production:

Period close for Accounts Receivable was prevented by errors in the Submit Accounting concurrent program.  Submit Accounting correctly spawned the Create Accounting Program, XLAACCUP, which ended in error:

An internal error has occurred in the program xla_ar_acct_hooks_pkg.main. Technical problem :
Error encountered in product API for postprocessing
03-SEP-2009 18:11:33 - executing postprocessing hook ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+
EXCEPTION OTHERS in arp_xla_extract_main_pkg.postprocessing Error :ORA-00060: deadlock detected while waiting for resource Technical problem : Error encountered in product API for postprocessing

STEPS
Responsibility: Receivables Manager
Navigation: Control > Request > Run
Submit Request: Create Accounting for month of August

Cause
It appears that the quantity of data to be processed for a full month caused a deadlock in the
database.

When run for a full month, the Submit Accounting process ended in error.
When run week-by-week, it completed normally.


Solution
Run Submit Accounting week-by-week.

纵横四海

采用如下的方法解决问题了：
Setup Item Validation Organization in Order Management.
(N): OM -> Setup -> System Parameters -> Values
Query for Parameter 'Item Validation Organization'
Setup the Item Validation Organization from list of values.

咖啡木糖醇

您好！  我在做AR应收发票的时候，创建会计科目提示已完成，但是有报警，我看我的提示跟你的很像，不知道您之前是怎么解决的
下图是应收界面和请求界面

下面是请求的Log

+---------------------------------------------------------------------------+
子分类帐会计系统: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

XLAACCUP module: 会计程序
+---------------------------------------------------------------------------+

当前的系统时间为 10-01-2012 19:10:59

+---------------------------------------------------------------------------+

**Starts**10-01-2012 19:10:59
**Ends**10-01-2012 19:11:05
Unit Processor completed normally with some events in error
+---------------------------------------------------------------------------+
FND_FILE 中日志消息开始
+---------------------------------------------------------------------------+
10-01-2012 19:10:59 - Executing Unit Processor ...
10-01-2012 19:10:59 - Initializing variables
10-01-2012 19:10:59 - Security Context Set
10-01-2012 19:10:59 - Ready to cache the Application and Ledger Level Sources ...
10-01-2012 19:10:59 - Cached the Application and Ledger Level Sources
10-01-2012 19:10:59 - Entering the loop to read document units from the queue ...
10-01-2012 19:10:59 - Checking status of the parent Accounting Program
10-01-2012 19:10:59 - Dequeuing the unit from the queue
10-01-2012 19:10:59 - Fetching event information for the documents in the unit
10-01-2012 19:10:59 - executing extract hook
ARP_XLA_EXTRACT_MAIN_PKG.extract()+
     p_application_id  :222
     p_accounting_mode :F
Calling upgrade_11i_r12_post +
  Get 11i application to upgrade
End upgrade_11i_r12_post -
arp_xla_extract_main_pkg.load_header_data_ctlgd ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-
arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+
arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-
arp_xla_extract_main_pkg.load_line_data_app_from_cr()+
arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-
arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+
arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-
arp_xla_extract_main_pkg.load_line_data_mcd()+
arp_xla_extract_main_pkg.load_line_data_mcd()-
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+
ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-
ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.extract()-
event key = 139594-1075211-B62B91D3B52ACFE0E040A8C0C2E1772E
10-01-2012 19:10:59 - extract hook executed successfully
***************************************************************************************************
The following REVERSAL events could not be processed. The event/process status is U/U:
Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
-------NO SUCH EVENTS-----------
***************************************************************************************************
10-01-2012 19:11:00 - executing postprocessing hook
ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+
ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-
event key = 139594-1075211-B62B91D3B52ACFE0E040A8C0C2E1772E
10-01-2012 19:11:05 - postprocessing hook executed successfully
10-01-2012 19:11:05 - Completing Journal Entries
10-01-2012 19:11:05 - Checking status of the parent Accounting Program
10-01-2012 19:11:05 - Dequeuing the unit from the queue
10-01-2012 19:11:05 - Submitting the transfer to GL
10-01-2012 19:11:05 -  End of the transfer to GL
10-01-2012 19:11:05 - Unit Processor completed successfully ...
+---------------------------------------------------------------------------+
FND_FILE 中日志消息结束
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
正在执行请求完成选项...


已完成执行请求完成选项。

+---------------------------------------------------------------------------+
已完成并发请求
当前的系统时间为 10-01-2012 19:11:06

zhuhgjava

这个问题，我前些天遇到过。现在解决了。我的解决方法是：
SELECT *
FROM   XLA_ACCOUNTING_ERRORS XAE
WHERE  XAE.EVENT_ID=   
所有创建会计科目失败的数据都会保存再这个表里。这里表里详细的记录的错误原因。找到原因并修改后的
处理方法有两种：
1：如果当前已创建的会计科目是正确的，并且有效。此时只要运行：“传送至总账”的请求。就可以把数据传送至总账。
2：当前的会计科目错误了。从后台删除错误的会计科目信息（XLA_AE_LINES，XLA_AE_HEADERS），然后修改XLA_EVENTS这个表的EVENT_STATUS_CODE，PROCESS_STATUS_CODE内容改成“U”（U：表示未创建会计科目）。然后重新运行创建会计科目请求就可以了。

当然，还有最悲剧的一种情况。就是操作流程错误。
就比如AR的冲销收款。我们都知道，冲销收款会产生一笔负金额进入总账。与原金额进行冲销。但是如果，冲销这笔收款的时候，这笔收款还没有创建会计分录。就没有产生一笔正金额的收款进系统。此时冲销，就只创建一笔负金额会计分录。这种情况从财务的借贷角度来说就行不通。系统当然也走不通。如果遇到这种情况。我目前发现的唯一解决方法就是从后台清理数据。

yyn686

zhuhgjava 发表于 2012/1/11 12:33
这个问题，我前些天遇到过。现在解决了。我的解决方法是：
SELECT *
FROM   XLA_ACCOUNTING_ERRORS XA ...

{:soso_e179:}

wxmjerry

查询——会计事件  输入查询条件，找到该笔业务，点击“事件状态”中的错误信息查看，解决问题，重新创建会计分录就可以了。当然有时候报的错误不是很详细，比如说会计期没有打开，有可能是辅助分类帐或报告币种分类帐的会计期没有打开。

linbos_liu

wxmjerry 发表于 2012/1/16 16:27
查询——会计事件  输入查询条件，找到该笔业务，点击“事件状态”中的错误信息查看，解决问题，重新创建会 ...

请问报告币种的期间在那开启呢

maggiem

我今天在创建会计科目时报这样的错误。

maggiem

我今天在创建会计科目时报这样的错误

maggiem

yyn686 发表于 2012/1/11 15:16

能具体说明一下不

青松

我也遇到这种情况了。好悲催啊。

青松

咖啡木糖醇 发表于 2012/1/10 19:34
您好！  我在做AR应收发票的时候，创建会计科目提示已完成，但是有报警，我看我的提示跟你的很像，不知道您 ...

我也遇到这种情况了。您是怎么解决的。