oracle成本更新,标准成本更新出错!

由于用户没有及时更新一月份的成本,今天运行标准成本更新时报错,

应该是库存会计期间问题,目前JAN-09是OPEN,FEB-09是CLOSE的,

如果把FEB-09打开,那更新事务岂不是要到FEB-09期间去了。

这个请求没有期间范围选择,不知没有没解决之道?

日志文件如下:

=================

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

Bills of Material: Version : 11.5.0

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

CMCICU module: Update Standard Costs

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

Current system time is 02-FEB-2009 00:31:37

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

Page Length = 55, Page Width = 132

===================================================================

Debug Mode :        Enabled

Output to Terminal : No

Argument Method :   Database Fetch

Trace Mode :        Disabled

===================================================================

Argument 1 (ORG_ID) = 430

Argument 2 (BOM_INST_FLAG) = 0

Argument 3 (COST_TYPE_ID) = 12787

Argument 4 (INV_ADJ_ACT) = 300771

Argument 5 (DESCR) = update standard cost

Argument 6 (RANGE) = 1

Argument 7 (RPT_SORT) = 1

Argument 8 (UPDATE_OPT) = 0

Argument 9 (ITEM_DUMMY) =

Argument 10 (CAT_DUMMY) =

Argument 11 (ITEM) =

Argument 12 (CAT_SET_ID) =

Argument 13 (CAT_VAL_FLAG) =

Argument 14 (CAT_STRUCT_ID) =

Argument 15 (CAT_ID) =

Argument 16 (LOW_ITEM) =

Argument 17 (HIGH_ITEM) =

Argument 18 (RES_FROM) =

Argument 19 (RES_TO) =

Argument 20 (OVH_FROM) =

Argument 21 (OVH_TO) =

Argument 22 (RUN_ADJ_RPTS) = 1

Argument 23 (SNAPSHOT) = 1

===================================================================

CMCICU-0001 : Initializing control structure

CMLCCU-0002 : Getting costing organization network

cmcugcn() <<

Date for Acct Period = 2009/02/02 00:31:12

cmcugcn() >>>        @ 02-FEB-2009 00:31:37

+=================================================================+

Debug Level             : Regular

Current Installation    : Standalone Inventory

control->org_id ............... 430

control->update_id ............ 1070049

control->list_id .............. 1070049

control->resource_list_id ..... 1070050

control->overhead_list_id ..... 1070051

control->update_date .......... 02-FEB-09

control->cost_type_id ......... 12787

control->cost_type ............ 20090131

control->def_cost_type ........ 1

control->update_res_flag ...... 0

control->update_act_flag ...... 0

control->adj_ccid ............. 300771

organization_id ........... 430

organization_code ......... XXX

organization_name ......... XXX-YYY

set_of_books_id ........... 124

set_of_books_name ......... XXX-ZZZ

chart_of_accounts_id ...... 101

currency_code ............. HKD

acct_period_id ............ 0

+=================================================================+

CMLCCU-0003 : Verifying accounting periods

cmcuvap() <<

cmcuvap() >XX        @ 02-FEB-2009 00:31:37

+=================================================================+

CMCICU: error processing in main()

Cause:        An error is detected in function main() while executing the module CMCICU.

Action:        Examine the request log file and contact your Oracle support representative if necessary.

No open accounting period is available

Cause:        No open accounting period corresponding to the transaction date is available in your organization.

Action:        Please open the appropriate accounting period in the Open Accounting

***** End Of Program - Update Standard Costs *****

No open accounting period is available

Cause:        No open accounting period corresponding to the transaction date is available in your organization.

Action:        Please open the appropriate accounting period in the Open Accounting

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

Start of log messages from FND_FILE

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

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

End of log messages from FND_FILE

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

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

Executing request completion options...

Output is not being printed because:

The print option has been disabled for this report.

Finished executing request completion options.

No open accounting period is available

Cause:        No open accounting period corresponding to the transaction date is available in your organization.

Action:        Please open the appropriate accounting period in the Open Accounting

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

Concurrent request completed

Current system time is 02-FEB-2009 00:31:37

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值