请求报错快照过久 回滚段过小.docx

问 题文档作者:黎法良创建日期:2013-04-01更新日期:2013-04-01文档编号:当前版本:1.0Note: Title, Subject, Last Updated Date, Reference Number, and Version are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents. When you change any of these values, be careful not to accidentally delete the bookmark. You can make bookmarks visible by selecting Tools-OptionsView and checking the Bookmarks option in the Show region.Note: To add additional approval lines, press Tab from the last cell in the table above.Note: You can delete any elements of this cover page that you do not need for your document. For example, Copy Number is only required if this is a controlled document and you need to track each copy that you distribute.Note: The copy numbers referenced above should be written into the Copy Number space on the cover of each distributed copy. If the document is not controlled, you can delete this table, the Note To Holders, and the Copy Number label from the cover page.目录问题3Step3解决方案4扩大回滚段4问题Periodic Acquisition Cost Adjustment Processor请求报错回滚段过小Step1. 提交请求2. 请求报错当前的系统时间为 01-04-2013 09:41:51+-+*Starts*01-04-2013 09:41:51*Ends*01-04-2013 11:36:18+-+FND_FILE 中日志消息开始+-+Legal Entity : 24283Cost Type : 1001Period : 67053Process Upto date : 31-03-13Cost Group : 3001Source : 2Run Option : 1Receipt No : Invoice No : Exception occured in Acquisition_cost_adj_processor : -1555 CSTPPACQ.acq_cost_processor(40):ORA-01555: 快照过旧: 回退段号 35 (名称为 _SYSSMU35$) 过小+-+FND_FILE 中日志消息结束解决方案扩大回滚段Last login: Mon Apr 1 10:45:34 2013 from 172.28.3.60oraprodshbwdb $ conn / as sysdba;-bash: conn: command not foundoraprodshbwdb $ sqlplus /nologSQL*Plus: Release 10.2.0.3.0 - Production on Mon Apr 1 12:06:35 2013Copyright (c) 1982, 2006, Oracle. All Rights Reserved.SQL conn / as sysdba;Connected.SQL show parameter undoNAME TYPE VALUE- - -undo_management string AUTOundo_retention integer 900undo_tablespace string APPS_UNDOTS1SQL alter system set undo_retention=14400 scope=memory;System altered.SQL show parameter undoNAME TYPE VALUE- - -undo_management string AUTOundo_retention integer 14400undo_tablespace string APPS_UNDOTS1SQL al