由于用户没有及时更新一月份的成本,今天运行标准成本更新时报错,
应该是库存会计期间问题,目前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
+---------------------------------------------------------------------------+