|
|
原帖由 wh991327 于 2010-7-21 14:34 发表 ![]()
xxzhaobb
能请帮忙下这个补丁 Patch:3065274 for linux
刚才估计补丁搞错了
在Metalink中搜索不到这个Patch，
但是可以搜索到这个Bug，贴出来给你看看，是不是你需要的
基本 Bug 3065274
Bug 3060395: CANNOT CREATE RECEIPTS RVTAC SIMPLIFIED CHINESE LANG, WRONG PURCHASING PERIOD
显示 Bug 属性 Bug 属性
类型 B - Defect 已在产品版本中修复 -
严重性 1 - Complete Loss of Service 产品版本 11.5.7
状态 96 - Closed, Duplicate Bug 平台 453 - Oracle Solaris on SPARC (32-bit)
创建时间 21-Jul-2003 平台版本 -
更新时间 06-Jul-2005 基本 Bug 3065274
数据库版本 9.0.2.3
影响平台 Generic
产品来源 Oracle
显示相关产品 相关产品
产品线 Oracle E-Business Suite 系列 Logistics
区域 Logistics 产品 508 - Oracle Inventory Management
Hdr: 3060395 9.0.2.3 RECEIVING 11.5.7 RECEIVING PRODID-508 PORTID-453 3065274
Abstract: CANNOT CREATE RECEIPTS RVTAC SIMPLIFIED CHINESE LANG, WRONG PURCHASING PERIOD
*** 07/21/03 05:39 am ***
=============================================================================
PROBLEM DESCRIPTION
=============================================================================
** DETAILED DESCRIPTION OF PROBLEM, INCLUDING ALL ERRORS:
Users cannot create receipts in iProcurement or Core Apps Purchasing
when language preference is set to SIMPLIFIED CHINESE
Initially we thought the receipt was not created, but after further
evaluation we found that it is created in the wrong purchasing period.
The fix in Bug2554429 was insufficient to handle the date length
- for Simplified Chinese the date length is 13
(See below for more details)
- The issue does NOT occur for the following languages:
AMERICAN, FRENCH, GERMAN, JAPANESE, HUNGARIAN, SPANISH, BRAZILIAN PORTUGUESE,
SWEDISH, ITALIAN, POLISH
UTF8 database primary language is American English
Error is as follows
??
??????????????????????????????????????
"rvtptcontrol failed RVTAC-&ERR_NUMBER?????? rvcacgp_get_accrual_period_name
????? ???????? rvcacgp_get_accrual_period_name
?????????? ????????"
The error message indicates that the process fails at the Get Accrual
Period Name. From the trace file, it does not appear that the date
format is properly handled for Simplified Chinese.
From the trace file I uploaded, the transaction is failing at the
following statement:
select GL_PER.period_name into :b0 from gl_period_statuses GL_PER
,gl_period_statuses PO_PER ,financials_system_parameters FSP where
(((((((((((PO_PER.application_id=201 and
PO_PER.set_of_books_id=FSP.set_of_books_id) and
trunc(PO_PER.start_date)<=to_date(:b1)) and
trunc(PO_PER.end_date)>=to_date(:b1)) and PO_PER.closing_status='O')
and
PO_PER.period_name=GL_PER.period_name) and
GL_PER.set_of_books_id=FSP.set_of_books_id) and GL_PER.application_id=101)
and
trunc(GL_PER.start_date)<=to_date(:b1)) and
trunc(GL_PER.end_date)>=to_date(:b1)) and GL_PER.closing_status in
('O','F'))
and GL_PER.adjustment_period_flag<>'Y')
The bind variable is shown as :
BINDS #122:
bind 0: dty=1 mxl=32(12) mal=00 scl=00 pre=00 oacflg=00 oacfl2=0
size=128
offset=0
bfp=fe05fb50 bln=32 avl=10 flg=05
value="17-7? -0"
Troubleshooting sql
sql*plus:
ALTER SESSION SET NLS_LANGUAGE='AMERICAN'
SELECT TO_CHAR(SYSDATE,'DD-MON-RRRR') FROM DUAL
I repeated this for all of our installed languages and Simplified Chinese did
return a different result. Here are the results returned...
LANGUAGE DATE
AMERICAN 17-JUL-2003
FRENCH 17-JUL-2003
GERMAN 17-JUL-2003
JAPANESE 17-JUL-2003
HUNGARIAN 17-JÚL-2003
SPANISH 17-JUL-2003
BRAZILIAN PORTUGUESE 17-JUL-2003
SWEDISH 17-JUL-2003
ITALIAN 17-LUG-2003
POLISH 17-LIP-2003
SIMPLIFIED CHINESE 17-7¿ -2003
-------
Bug2554429 is very similar
- The fix was to extend the array size from 10 to 12.
- for Simplified Chinese the date length is 13
SELECT TO_CHAR(SYSDATE,'DD-MON-RRRR'), DUMP(TO_CHAR(SYSDATE,'DD-MON-RRRR'))
FROM DUAL;
17-7? -0 Typ=1 Len=13: 49,55,45,55,230,156,136,32,45,50,48,48,51
select to_date('17-7? -0','DD-Mon-RR') from dual;
Results
17-7? -00
select to_date('17-7? -03','DD-Mon-RR') from dual;
Results
17-7? -03
-------
Bug2972538 may also be related.
- CUS tested this but he still gets the same error when date format preference
is set to DD-MM-RR, but this bug may still be applicable
=============================================================================
DUPLICATION DETAILS
=============================================================================
=============================================================================
*** 07/21/03 06:38 am *** (CHG: Sta->10)
*** 07/21/03 06:38 am ***
*** 07/21/03 06:41 am ***
*** 07/21/03 06:41 am *** (CHG: Sta->11)
*** 07/21/03 07:16 am *** (CHG: Asg->NEW OWNER OWNER)
*** 07/21/03 08:15 am ***
*** 07/21/03 11:40 am ***
*** 07/21/03 11:51 am ***
*** 07/21/03 12:12 pm *** (CHG: Pri->1)
*** 07/21/03 12:12 pm ***
*** 07/21/03 12:18 pm ***
*** 07/21/03 12:20 pm *** (CHG: Sta->16)
*** 07/21/03 12:21 pm ***
*** 07/21/03 12:22 pm ***
*** 07/21/03 01:25 pm *** (CHG: Sta->11 Pri->2)
*** 07/21/03 01:25 pm ***
*** 07/21/03 01:26 pm *** ESCALATED
*** 07/21/03 04:28 pm *** (CHG: Sta->10)
*** 07/21/03 04:28 pm ***
*** 07/21/03 04:43 pm ***
*** 07/21/03 05:24 pm *** (CHG: Sta->11)
*** 07/21/03 05:24 pm ***
*** 07/21/03 05:54 pm *** (CHG: Pri->1)
*** 07/21/03 05:54 pm ***
*** 07/21/03 06:18 pm ***
*** 07/21/03 07:07 pm ***
*** 07/21/03 07:10 pm *** -> CLOSED
*** 07/21/03 07:13 pm *** (CHG: Sta->30)
*** 07/21/03 07:13 pm ***
*** 07/21/03 09:17 pm ***
*** 07/21/03 10:00 pm ***
*** 07/21/03 10:01 pm ***
*** 07/22/03 09:44 am *** (CHG: Sta->11)
*** 07/22/03 09:44 am ***
*** 07/22/03 10:13 am ***
*** 07/22/03 12:42 pm *** (CHG: Sta->30)
*** 07/22/03 12:42 pm ***
*** 07/22/03 01:23 pm ***
*** 07/22/03 01:31 pm ***
*** 07/22/03 01:50 pm *** (CHG: Sta->11)
*** 07/22/03 01:50 pm ***
*** 07/22/03 01:54 pm ***
*** 07/22/03 01:54 pm ***
*** 07/22/03 02:44 pm ***
On our internal environment:
SQL> select * from NLS_SESSION_PARAMETERS;
SQL> /
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS DG
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
Thanks
*** 07/22/03 04:11 pm ***
*** 07/22/03 04:31 pm ***
*** 07/22/03 05:20 pm ***
*** 07/22/03 05:21 pm *** (CHG: Sta->30)
*** 07/22/03 05:30 pm ***
*** 07/22/03 05:33 pm ***
*** 07/22/03 07:24 pm *** (CHG: Sta->11)
*** 07/22/03 07:24 pm ***
*** 07/22/03 07:26 pm ***
*** 07/22/03 09:31 pm *** (CHG: Sta->30)
*** 07/22/03 09:31 pm ***
*** 07/23/03 01:15 am ***
*** 07/23/03 01:15 am *** (CHG: Sta->11)
*** 07/23/03 01:20 am ***
*** 07/23/03 02:11 am ***
*** 07/23/03 03:07 am ***
*** 07/23/03 03:50 am ***
*** 07/23/03 05:11 am ***
*** 07/23/03 06:38 am *** (CHG: Sta->30)
*** 07/23/03 06:38 am ***
*** 07/23/03 07:10 am *** (CHG: Sta->11)
*** 07/23/03 07:10 am ***
*** 07/23/03 07:40 am ***
*** 07/23/03 07:41 am *** (CHG: Sta->30)
*** 07/23/03 07:57 am ***
*** 07/23/03 08:11 am ***
*** 07/23/03 08:21 am *** (CHG: Sta->11)
*** 07/23/03 08:21 am ***
*** 07/23/03 08:35 am ***
*** 07/23/03 08:51 am ***
*** 07/23/03 10:23 am *** (CHG: Sta->40)
*** 07/23/03 10:23 am ***
*** 07/23/03 10:24 am ***
*** 07/23/03 01:07 pm ***
*** 07/23/03 01:51 pm ***
*** 07/23/03 02:13 pm ***
*** 07/23/03 05:30 pm *** (CHG: Sta->36)
*** 07/23/03 05:30 pm ***
*** 08/22/03 06:26 am *** (CHG: Sta->96)
*** 07/06/05 08:03 am *** (CHG: Prod->508) |
|
楼主: wh991327
IP卡
狗仔卡
发表于 2010-7-21 15:10
显身卡
楼主
