SBNewsletter2005May by aashu4uiit

VIEWS: 5 PAGES: 12

									Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

Oracle Applications Release 11i Newsletter
The contents of this newsletter were contributed by Solution Beacon consultants who have accumulated extensive experience during the numerous installations, implementations, and upgrades of Release 11i that we have performed for our clients. We also welcome your participation in this newsletter. If you would like to contribute on any Release 11i topic, please send your contact information, topic, and a short abstract to mweiss@solutionbeacon.com. We would also appreciate any feedback from our readers if you have successfully or unsuccessfully implemented one of the suggestions from any of the newsletters. Comments or suggestions are always appreciated. Please send to mweiss@solutionbeacon.com.
Mary Lou Weiss, Alicia Hoekstra, and Randy Giefer, Editors, Solution Beacon

OAUG: Success Through Education
Are you registered for The Big Event? The advance registration deadline for OAUG Connection Point 2005 at the Gaylord Texan June 13-16, 2005, has been extended to May 31, 2005. Register now at www.oaug.org. The OAUG and Solution Beacon teamed up to bring you another series of workshops, The Trail to TexasSM, in March through May of 2005 prior to the OAUG Connection Point conference in June 2005. The Trail to Texas started with the NorCal OAUG on March 7, continued with the New England OAUG on March 21, proceeded on to the SouthWest Regional OAUG in Los Angeles on April 22, followed by the Central States OAUG in St. Louis on April 25, and wrapped up with sessions at IOUG Live! 2005 on May 4 in Orlando. See y’all at OAUG Connection Point 2005 June 13-16, 2005!
Mary Lou Weiss and Randy Giefer, Editors, Solution

Ask the SB Experts
Question: When I start the client-server version of ADI, I need to be able to login to the database. However, when I select a document to publish, I receive the following error message: An error occurred while attempting to establish an Application File Server connection. There may be a network configuration problem, of the TNS listener may not be running. Hostname:host"

©Copyright 2005

Solution Beacon, LLC

All Rights Reserved.

Page 1 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

I can successfully tnsping FNDFS hostname. Answer: This is a pretty common error. Please review MetaLink Doc ID 108934.1 (it's correct even though it uses 10.7 and 11.0 examples): Subject: Viewing Reports In the ADI Request Center Generates Network Error You can also try a tnsping from the problem pc using the command: tnsping FNDFS_hostname – this is the reports connection vs. the database connection which would be: tnsping PROD (or something like that) It's most likely a problem with one of the tnsnames.ora files on your PC is not correct for the FNDFS entry. Scan and make sure ALL entries are correct. Question: Should I separate my concurrent processing tier from the database tier? Answer: Historically, the accepted best practice for concurrent manager deployment has been to run the Concurrent Manager processes on the same server(s) as the database itself, to eliminate network traffic between the managers and their dedicated server processes. However, with the availability of fast LANs between the middle tier servers and database servers, the best practice now is to configure the managers to run on separate middle tier servers. This gives you maximum flexibility on choosing hardware platforms (the database tier can be a different platform than the middle tiers) and allows the database servers to be fully available for database processing, with no cycles needed for batch programs. Note that this is per MetaLink 285267.1 and does not necessarily reflect the views of Solution Beacon.
The Senior Consultants at Solution Beacon, LLC

Reprint Issues – Post 11.5.10
Over the past few months the DBAs at Solution Beacon have been doing many migrations of the Oracle Applications to Release 11.5.10. One issue encountered is the inability to utilize reprint after applying patch 3435480. Additional research on MetaLink (307974.1) revealed that this is a known issue with Release 11.5.10 (in addition to a couple of other printing issues). Oracle recently released one off patches to address the reprint issue as well as reprint duplicate copy creation. However, note that the MetaLink note mentioned above states that these corrections will be included in the Consolidated Update 2 patch for Release 11.5.10 when it is released. If you need to patch now, here are the relevant patches: 4219981 - PRINTERS LOV DOES NOT BRING UP ANY PRINTERS WHEN REPRINTING AFTER PATCH 3435480
©Copyright 2005 Solution Beacon, LLC All Rights Reserved. Page 2 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

4233553 - REPRINT FUNCTIONALITY CREATES DUPLICATE COPIES (AOL)
Kevin Dahl, Solution Beacon

Viewer Output in 11.5.10
If you are having trouble figuring out the viewer output options (Excel, Word) from the Viewer output form in Release 11.5.10, please perform the following actions: In System Administrator responsibility, there is a form under Install->Viewer Options. Add the mime type for Excel, word, text for file format text as in the screenshot below

Sriram Ramachandran, Granite Services Inc.

©Copyright 2005

Solution Beacon, LLC

All Rights Reserved.

Page 3 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

My Configuration and Projects Feature in MetaLink
You may have already seen a new menu button on the main MetaLink menu. If you haven’t, you will soon! Oracle Support is rolling out the My Configs & Projects feature of MetaLink. This new feature will enable Oracle to be more proactive in assisting you with your Oracle products. Configurations Configurations are a description of a computer or a group of computers and the software those computers are running on. Having a knowledge of your configurations will allow Oracle to more proactively suggest solutions, resolve issues faster, and be more aware of critical events in your business that involve their database and applications software. You can create configurations manually or create them automatically by installing and running the Support Agent. The Support Agent collects Database, e-Business suite and system data items, parameters and tables, and automatically creates configurations with this information. Health Checks If you create your configurations automatically you will have the ability to run health checks. Health checks are dynamically generated reports that provide you with immediate feedback and recommendations on potential issues. They use an expert system that applies rules against the configuration information gathered by the Support Agent. These rules, which encapsulate many of the best practices for proactive problem avoidance, are maintained at Oracle and updated continuously to provide up-to-the-minute access to new and emerging issues. Projects My Configurations & Projects also allows you to organize your support environment around projects. Within each project, you can identify contacts and roles, as well as key milestones and project dependencies. This helps Oracle Support to understand critical dates and events as they work on solutions.
Don Driggs, Solution Beacon

Suggestions for Managing Demand in MRP
The following are suggestions made in support of the management of the demand side of the material planning effort. These steps will assist with ensuring that the demand is accurate and reflects the material intentions to meet business goals. Forecast anticipate build sequences, schedules and models in order to maintain a material plan which will support the actual build sequences produced by Sales Orders with specific delivery requirements.

©Copyright 2005

Solution Beacon, LLC

All Rights Reserved.

Page 4 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

Component lead times are longer than product build times so forecasting is used as the “my best guess” approach to what is anticipated to be built in a given time frame. The Sales Order is intended to “consume” forecast, changing the “my best guess” to an actual customer order. Two things affect the accuracy of the material plan from a demand perspective. • • Forecasts Sales Orders

Each of these must be maintained to an accuracy that reflects the material requirements and timing issues associated with managing an expectation to a point where it becomes reality. This refers to the point where a forecast is consumed by a sales order and the material management is to actual requirements vs. anticipated requirements. Demand is identified from two sources: forecast and sales orders. At any given point, the material plan is a mixture of educated guesses and actual demand. Demand is also identified as “independent” or “dependent” demand. Independent demand is represented by the actual part ordered and shipped to a customer. It can be in the form of complete shipments or individual spare parts. The key is the “source” of the demand. It the part was order directly it is independent demand. This type of demand is the easiest to manage as it is obvious, easily identifiable and tracked with a minimum of effort. Dependent demand is an assembly or part that is required because it is a component of something that was ordered and can not be shipped unless the “dependent” part is available for use in the manufacturing processes. Demand is managed by review and control of the “independent demand.” Forecast and Sales Orders are the “independent demand.” If these entries are not managed, the material plan generated in support of the demand will reflect any errors and may be lacking in material requirements or recommending material investments that are either in excess of actual requirements or insufficient to meet actual requirements. The following suggestions are actions which can facilitate the management of demand to ensure as accurate a picture of the business expectations/requirements as possible. Suggestions Sales Orders – Regularly review the status of all sales orders to ensure that line items identified will actually be shipped. Adjust when necessary to remove entries which will not ship, verify that shipped items are recorded against the sales order. This will ensure that only remaining demand is identified and planned. Sales orders that have not been completed must be reviewed and closed if remaining line items will never be shipped. Note! The planning system will relieve sales orders to reflect shipments as long as you have the relief flag set. If this flag is not set and you do partial shipments, your actual demand will remain overstated by the shipment quantity and thus generate additional demand that isn’t real Forecasts – Forecast expected sales to as accurate a level as possible in the time frames expected. Forecast should be reviewed regularly to ensure they are current, still anticipated, in

©Copyright 2005

Solution Beacon, LLC

All Rights Reserved.

Page 5 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

the correct time frame and have been “consumed” by sales orders when appropriate. Remove or adjust forecast entries that are no longer valid. The “Forecast Set Items” should be reviewed to determine if an entry should have consumed an existing forecast. Correct any errors to ensure that demand remains accurate. While a forecast set entry is off set by the sales order, the forecast it should have consumed remains a demand source and inflates the demand above requirements. If a forecast set entry was never forecasted – you booked a sales order line for an item you don’t forecast – it will show up in the forecast set items as an indicator of unexpected demand. It will balance itself by the demand entered in the sales order. This balances the equation for correct demand, but the item will stay in the forecast set items list. It can be removed by entering a forecast for the item/quantity on the appropriate date and then consuming that entry. This keeps the potential list in the forecast set items to a minimum and more manageable level. Spare Parts – Spare parts are demand for items, usually at piece part or subassembly level, that unless forecasted or otherwise accounted for, are not part of the material plan for manufacturing. The issuing or use of material obtained in support of the manufacturing plan, by spare parts, can adversely affect the ability to manufacture and meet shipping schedules. This demand can be supported either as additional forecast in the spares organization or by the use of safety stock as a hedge against affecting the material plan. You should identify items frequently required as spare parts. To insure spares are part of the material planning process, the supplying organization should use the safety stock functionality processed by MRP. This functionality is set in the organization item screen at the part level. Each part will have safety stock generated based on the information entered for the item.
Dave Tipping, Solution Beacon

Exception Sets – Usage
Exception sets are used to manage exception messages generated during MPS or MRP processing. This processing works against exact numbers and dates established from planning parameters defined for each item being planned. If, for example, you require a quantity of 10 for an item on a specific date and you have 11 on hand for that date, an exception message is generated indicating excessive inventory. You probably don’t want to see that message based upon a criteria used to manage the item. You can create an exception set indicating that you don’t want to see the message unless the excess quantity exceeds a defined number such as 5. When this exception set is associated with the item, the excess message is not generated unless the excess quantity is 5 more than the required quantity.
©Copyright 2005 Solution Beacon, LLC All Rights Reserved. Page 6 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

Example of Exception Set form:

Each Exception Set is identified by name. You can have one or more exception sets. However, a set is defined by all the settings used in the form. It is then associated with an item number and used to manage planning messages for the items using the set. This means that you will need additional sets if there are varying definitions required due to the nature of the planning required by an item. As an example, excess quantities can be 5 in one set and 25 in another. You might apply the 5 to low cost filters while the 25 may be applied to bolts where you stock higher quantities. From the Oracle Help Screens:

©Copyright 2005

Solution Beacon, LLC

All Rights Reserved.

Page 7 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

Any entry which is blank in the Exception Set is planned as if there is no exception set. When an exception set entry present and the exception set is associated with an item, that item is planned using the planning “rules” for that item and then the exception set is evaluated to determine if an exception message is generated. The excess quantity input under the sensitivity control is evaluated and the message printed or suppressed based on the quantity on a given day. If the excess time period is entered, then excess are reported based upon the time frame identified. Except for the user defined time fence, all other options are based upon item lead time. Care should be taken when selecting options to ensure the right time frame is used for the item(s) where the exception set will be used.

©Copyright 2005

Solution Beacon, LLC

All Rights Reserved.

Page 8 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

Prior to identifying the number of exception sets required and the set definitions, you should evaluate a few settings on selected items to ensure you understand the results of exception message management. Exception Set Management The number of exception Sets is dependent upon the message management level required for various part groupings. One set could be used for all parts, but that means that large highdollar items would be managed just like small low-dollar items. This usually does not meet actual needs. You could also have one exception set for every item number. This would require specific management of exceptions at the item level and probably require significant maintenance. Ideally, you identify parts with similar planning management parameters and define an exception set to use to manage that grouping. The number of groupings is dependent upon an evaluation of the product lines and components. You should create an assign enough exception sets to cover the parts processed in the planning module. NOTE! An exception set is assigned to an item in an inventory organization. When planning is a supply chain plan and more than one organization is planned, the exception messages are generated for each organization and the exception set used is the one assigned to the item in the organization with the demand. This means that an item in more than one organization can generated differing planning messages depending upon the lack of or presence of exception sets.
Dave Tipping, Solution Beacon

Announcement for Oracle 11i Payroll Customers
Note that the prerequisites for HR/Payroll Family Pack J (precursor to the below patch) requires an upgrade to Workflow 'H', Applications Framework 5.10, Trading Community Architecture ‘M’ and AD.I.1. This may affect a significant number of you. At a minimum, FND.H must be applied which updates Workflow and the Oracle Applications Framework (Java). AD.I.1 must also be applied which affects cloning, autoconfig and administration and maintenance. The XML Publisher module must be installed and updated as well. Additional requirements include the latest Oracle Applications Manager mini-pack, the latest AOL Security rollup patch and the latest TCA (HZ.M) mini-pack. Please reference MetaLink Note 306259.1 (Family Pack K is Mandatory Family Pack for Payroll Customers for Year End 2005). The solution is given as:

©Copyright 2005

Solution Beacon, LLC

All Rights Reserved.

Page 9 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

Year End 2005 will require Family Pack K. Family Pack K is scheduled for release in June 2005. Patch 3500000 – Patch 11i.HR_PF.K will be the patch number. Other references are: Note 135266.1 - Oracle HRMS Product Family - Release 11i Information Note 295406.1 - Mandatory Family pack levels for Oracle Payroll.
John Stouffer, Solution Beacon and Oracle Support

Oracle 8i Desupport Reminder
Please refer to MetaLink Notes 290211.1 and 148054.1 for information on Oracle 8i desupport with Release 11i Applications. Full Error Correction Support (ECS) for Oracle8i ends after December 31, 2004. Any EBusiness Suite 11i customer that is currently running on the Oracle8i database should have a plan in place to upgrade to Oracle9iR2 before the end of the year to ensure that they are running a fully supported configuration. E-Business Suite 11i customers (with certified combinations) running against 8.1.7.4 will remain supported until July 31, 2005.

Release 10.7 Desupport Reminder
Oracle stated that Error Correction Support (ECS) would end June 30, 2004 (which was extended from the original date of June 30, 2003 in cooperation with OAUG) and that Extended Support (ES) would end June 30, 2005. Please review MetaLink docs 99266.1 and 226571.1 for more details. Please feel free to contact me if you have any questions and/or concerns – jstouffer@solutionbeacon.com
John Stouffer, Solution Beacon, Upgrade SIG Chair

©Copyright 2005

Solution Beacon, LLC

All Rights Reserved.

Page 10 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

Book Offer: “Installing, Upgrading and Maintaining Oracle Applications 11i” is Available!
To order your copy of “Installing, Upgrading and Maintaining Oracle Applications 11i (or, When Old Dogs Learn New Tricks)” visit our website or order your book at http://www.oncalldba.com/docs/Books/?&L=sb
Barbara Matthews, OnCallDBA, Karen Brownfield, John Stouffer and Randy Giefer, Solution Beacon

OAUG: Events in the News
OAUG Connection Point® 2005 – Educational Opportunities and Oracle Sessions The OAUG is preparing to launch the OAUG Connection Point 2005 conference in conjunction with the Quest Conference and Expo 2005, July 13-16, 2005, at the Gaylord Texan Resort and Convention Center in Grapevine (Dallas), Texas. The event will provide Oracle Applications users with an unparalleled networking and educational environment that will enable attendees to maximize their knowledge, experience and understanding of the applications that they use to run their organizations. Information about educational opportunities, including keynote speakers, white paper presentations, panel sessions, training sessions, pre-conference workshops and Oracle presentations, are now available on the OAUG Web site at www.oaug.org. OAUG and Quest Announce Formation of Fusion Council The OAUG and Quest International Users Group announce the formation of the Fusion Council, which will provide future users of Oracle’s Fusion software, a merged applications set, with an educational tool and forum for learning more about the product and act as a bridge between users and Oracle Corp. in the collection of business requirements for development of the Fusion product. Additional information can be found on the OAUG Web site at www.oaug.org. IOUG, OAUG and Quest International Users Group Announce Collaborative Conference in 2006 The OAUG, the world's largest user knowledgebase for Oracle Applications users; The IOUG, a leading Oracle database and applications user group and the Quest International Users Group, an independent, not-for-profit association serving PeopleSoft and J.D. Edwards users; have announced an agreement for a collaborative annual user group conference in 2006.

©Copyright 2005

Solution Beacon, LLC

All Rights Reserved.

Page 11 of 12

Release 11i Newsletter
Oracle Applications Services Volume 28 May 2005

The new event will be called Collaborate 06: Technology and Applications Forum for the Oracle Community and will take place April 23-27, 2006 at the Gaylord Opryland Resort in Nashville, Tennessee. The event will be open to all Oracle, PeopleSoft and J.D. Edwards applications and database users. For more information, visit the OAUG Web site at www.oaug.org.
Robin Dahlen for Meeting Expectations

Upcoming Solution Beacon Events
EVENT
PittOAUG Golf Outing, SB Sponsorship OAUG Connection Point 2005 OAUG Connection Point 2005 – Trail To Texas Workshops OAUG Connection Point 2005 – Secrets of the Account Generator, Karen Brownfield, Solution Beacon OAUG Connection Point 2005 – Enterprise Planning and Budgeting (Panel), Okey Bess, Solution Beacon OAUG Connection Point 2005 – Applications DBA 101 – The Basics of A Successful Implementation, Eric Cole, National Institutes of Health, and John Stouffer, Solution Beacon OAUG Connection Point 2005 – Best Practices for Securing the Oracle E-Business Suite (Panel), Randy Geifer, Solution Beacon OAUG Connection Point 2005 – FSGs Made Simple (Training Session), Ronda Ellis, Solution Beacon OAUG Connection Point 2005 – Care and Feeding of Oracle Workflow (Training Session), Karen Brownfield, Solution Beacon ODTUG NOW 2005 ODTUG NOW 2005 – Developing Form Extensions for Oracle E-Business Suite Customers, Susan Behn, Solution Beacon ODTUG NOW 2005 – Designer/Developer Expert Panel, Susan Behn, Solution Beacon Oracle OpenWorld June June June June

DATE
10, 2005 13-16, 2005 14, 2005 13-16, 2005

LOCATION
Pittsburgh, PA Dallas, TX Grapevine, TX Grapevine, TX Grapevine, TX Grapevine, TX Grapevine, TX Grapevine, TX Grapevine, TX New Orleans, LA New Orleans, LA New Orleans, LA San Francisco, CA

June 13-16, 2005 June 13-16, 2005 June 13-16, 2005 June 13-16, 2005 June 13-16, 2005 June 18-22, 2005 June 21, 2005 June 22, 2005 September 18-22, 2005

Solution Beacon Newsletters are designed to help users of Oracle Applications and Solution Beacon makes no warranty for the accuracy, veracity, or completeness of any information herein, nor do they have any responsibility or liability for any losses or damages incurred as a result of reliance on any information provided herein or from the use of any program or program segment discussed herein. Solution Beacon assumes no responsibility for any errors that may appear herein. The information published herein is subject to change without notice. Copyright © 2005 Solution Beacon, LLC. All rights reserved. Any trademarks cited herein are the property of its owner. No part of this publication may be reprinted or reproduced without the prior written consent of Solution Beacon, LLC.

©Copyright 2005

Solution Beacon, LLC

All Rights Reserved.

Page 12 of 12


								
To top