应付款管理系统会计核算流程无法创建会计分录

纵横四海

“应付款管理系统会计核算流程”启用了跟踪，check_id=106756, 付款编号＝12045575，OU是在线，PAYMENT EVENT (ID = 209179)无法创建会计分录，Payment Cancellation Event (ID = 209187)也无法创建。请检查原因，如果能产生会计分录，就生成；如果无法生成，请将该付款的“已入帐”修改为已入帐状态。

下面是错误信息：

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

Oracle 应付款管理系统: Version : 11.5.0 - Development

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

APACCENG module: 应付款管理系统会计核算流程

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

当前的系统时间为 03-09-2007 10:04:05

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

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

| 正在启动并发执行程序...

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

变元

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

P_JOURNAL_CATEGORY='All'

P_SUB_TRANSF_TO_GL='Y'

P_SUB_JOURNAL_IMP='Y'

P_VALIDATE_ACCTS='Y'

P_SUMMARIZE_FLAG='N'

P_COMMIT_CYCLE='50'

P_ORG_ID='85'

P_DEBUG_SWITCH='Y'

P_TRACE_SWITCH='N'

P_RUN_ACCT_REPORT='Y'

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

-- Start of Reports Command --

ar60run

P_CONC_REQUEST_ID=2151714

P_JOURNAL_CATEGORY='All'

P_SUB_TRANSF_TO_GL='Y'

P_SUB_JOURNAL_IMP='Y'

P_VALIDATE_ACCTS='Y'

P_SUMMARIZE_FLAG='N'

P_COMMIT_CYCLE='50'

P_ORG_ID='85'

P_DEBUG_SWITCH='Y'

P_TRACE_SWITCH='N'

P_RUN_ACCT_REPORT='Y'

report=/prod/prodappl/ap/11.5.0/reports/ZHS/APXAEREP.rdf

batch=yes

destype=file

desname=/prod/prodcomn/admin/out/PROD_ERP2/o2151714.out

desformat=/prod/prodappl/fnd/11.5.0/reports/HPL

pagesize=132x66

-- End of Reports Command --

Request language is :

SIMPLIFIED CHINESE

Request territory is :

CHINA

Previous NLS_LANG Environment Variable was :

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

'.,'

Spawned Process 4393

MSG-00001: After SRWINIT

MSG-00002: Check that AX is not installed before calling the accounting engine

MSG-00003: AX is not installed, Calling the accounting engine

MSG-00004: After the call to AP_Accounting_Engine_Pkg.Do_Accounting

MSG-00007: After Get_Company_Name

MSG-00008: After Get_NLS_Strings

MSG-00009: After Get_Base_Curr_Data

MSG-00010: After populating report count

MSG-00010: After populating cannot account transaction count

MSG-00011: After getting the chart_of_accounts_id

MSG-00010: After Custom_Init

MSG-00015: About to undo accounting for event_id 209179

MSG-00016: After undo_accounting for event_id 209179

MSG-00015: Before trying to submit GL Transfer

MSG-00017: GL Transfer submitted successfully, Req. ID:2151718

Report Builder: Release 6.0.8.20.2 - Production on 1 09 3 10:04:05 2007

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

输入用户名:

Reset original NLS_LANG in environment as :  

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

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

Plsql 程序的日志信息开始

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

Input Parameter Values :

   P_start_date =

   P_end_date =

   P_journal_category = All

   P_invoice_batch_id =

   P_invoice_id =

   P_payment_batch_name =

   P_check_id =

   P_gl_transfer_flag = Y

  P_journal_import_flag = Y

   P_commit_cycle = 50

   P_validate_accounts = Y

   P_summarize_report = N

   P_debug = Y

   P_calling_sequence = APXAEREP

Initializing and caching all accounting rule info ...

Number of rows in SOB PL/SQL table before calling MRC API = 1

Number of rows in SOB PL/SQL table after calling MRC API = 1

Finished Initialization

Setting posted flag of invoice distributions to S

Starting to account all the events created ...

Calling Create_Accounting_Entry for PAYMENT EVENT (ID = 209179) ...

Inside AP_Accounting_Main_Pkg package.

About to account for Payment Event (ID = 209179) for SOB ID  1 ...

Inside Execute for Payment_Event_Core

SOB ID = 1

SOB Type = P

Check ID = 106756

Check ID = 106756

Inside Derive_Accounting_Entry for Payment_Event_Core

Starting Accrual Basis Accounting for Payment Event...

INSERTing Header into AP_AE_Headers ...

Entering loop for creating the AE lines ...

Accounting Event ID = 209179

Check ID = 106756

Getting Invoice info ...

Getting invoice info for invoice ID 114069

Inside Accrual_Account_Payment_Line for Payment_Event_Core

Getting proration divisor ...

Creating (backing out) Liability Line ...

Inside Create_Accrual_AE_Lines_Liab...

P_rounding_amount =

l_total_rounding =

l_check_rounding = 40300

Creating summarized Cash Line ...

AE Line Accounted Status = ERROR

AE Header Accounted Status =

Calling Create_Accounting_Entry for PAYMENT CANCELLATION EVENT (ID = 209187) ...

Inside AP_Accounting_Main_Pkg package.

About to account for Payment Cancellation Event (ID = 209187) for SOB ID  1 ...

Inside Execute for Payment_Canc_Event_Core

Cannot Account for void of北京北四环支行 bank account's check number 12045575 be

cause some prior event is NOT accounted.

AE Line Accounted Status = CANNOT ACCOUNT FOR THIS EVENT

Finished accounting all the events created. Submitting Accounting Entry Report..

.

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

PlSql 程序的日志信息结尾

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

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

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

未打印输出文件，因为：

已禁用此报表的打印选项。

+------------- 1) PRINT   -------------+

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

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

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

已成功完成并发请求

当前的系统时间为 03-09-2007 10:04:10

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

纵横四海

以下为百度工程师给出的解决方案：

1. 
   
2. UPDATE ap.ap_invoice_payments_all t
   
3. SET t.accrual_posted_flag = 'Y',
   
4.     t.cash_posted_flag    = 'Y',
   
5.     t.posted_flag         = 'Y'
   
6. WHERE t.check_id = 106756;
   
7. 
   
8. UPDATE ap.ap_accounting_events_all t
   
9. SET t.event_status_code = 'ACCOUNTED', t.cannot_account_flag = ''
   
10. WHERE t.accounting_event_id IN (209179, 209180, 209187);
    
11. 
    

复制代码

xinyuliu

没有汇率也不能建立会计科目

zhouyunming

学习了，收藏备用