Monday Jul 20, 2015

Keep Those Sales Orders Flowing

To continue our series on transactions processing, we have some questions for you.

• Are you a power user looking to have a seamless Inventory month end closing?
• Does it seem like every month there is a crisis in your organization because the end users are unable to close the period?
• Have you ever wondered what tools are there to help you troubleshoot stuck sales order transactions?

If the answer is yes to any of these questions, we've got a great training document for you. See, R12 Inventory Sales Order Flow and Troubleshooting (Doc ID 1100764.1).

This document uses different media including a recorded demo to walk an Oracle user through the month end closing process for Inventory Organizations.



The focus of the presentation is to empower any user and/or techno/functional resource about the different options available to identify and correct sales order transactions that are stuck in the Transactions Open Interface.

The presentation will also show you the flow of the My Oracle Support (MOS): Guided Resolution that is offered as you log Service Requests.

Doc ID 1100764.1 is another tool to help keep your transactions processing. As usual, keep tuned in to the Inventory Blog and we will continue to assist in ending your month end headaches.

Monday Jun 29, 2015

Continue Your Work In Process!

In the June 5th post, we discussed "Move Order On Down The Road!" about Pending Transactions related to move orders. Two of many other common Pending Transaction types is a Work In Process (WIP) Completion or a WIP Issue transaction. Pending WIP Completion and Issue transactions can be tricky if you have processing issues. In Support we have seen examples where WIP Completion or Issue transactions have been duplicated, hence creating duplicate WIP Pending Transactions that either won't process or create duplicate Material Transactions historical records. Particularly if the WIP Pending Transactions won't process, they could prevent period close, making them highly visible during month end processing. Don't fret; again The Inventory Social Media Team is here to guide you to a solution.

If you process a lot of WIP Completion and WIP Issue transactions, and you want to check for duplicates, a great place to start diagnosing is note, Duplicate Pending (MMTT) WIP : How To Verify If Pending WIP Completion And Issue Transactions In MMTT Are Duplicates Or Not (Before Resubmitting Or Deleting) (Doc ID 1073279.1).



Doc ID 1073279.1 contains identification sql scripts, root cause analysis, and solution suggestions if you determine you have WIP duplicates. We would also suggest Doc ID 333572.1, which contains an attached Word document which provides details on how to review pending work order transactions; Diagnosing WIP Related Transaction and Data Issues (Doc ID 333572.1).

Duplicate WIP Completion or WIP Issue pending transactions can be tricky, but with the right tools you can turn a period close tsunami into a smooth sailing.

Friday Jun 05, 2015

Move Order On Down The Road!

Is it the end of the month and you are frightened about what you are going to find in your Pending Transactions form? You hesitate to check, but you click “Find” in Pending Transactions, and again there are weird “Allocated” move order lines that seem to happily just sit there. Didn't this happen last month? … Why, why, why won't these move orders resubmit from Pending Transactions!?!? The Inventory Social Media Team is again here with helpful tips to resolve pesky period close stoppers.

For Allocated Move Orders that don't seem to process, we recommend to bookmark note, How to Check the Move Order Status of Pending Transactions (Allocations) Show in Pending Transactions Form (Doc ID 1370430.1). Using Warehouse Management Systems (WMS)? Doc ID 1370430.1 has also got you covered.



Doc ID 1370430.1 will help you find and process Allocated Move Orders. Sometimes you see move order lines in a status 'Allocated' that cannot be processed in the Pending Transactions form. This is situation normal. Processing manual move order lines are as simple as clicking the “Transact” button in Transact Move Orders form.

You'll also see that there are rare examples that are not so ideal. There can be corrupted move order lines related to Closed or Cancelled Move Orders which require different actions. Doc ID 1370430.1 will guide you on how to proceed when data is corrupted, like when move order status is Closed, Cancelled, or Cancelled by Source.

Pending move order transactions do not need to be mysterious. Use Doc ID 1370430.1 and don't let Move Order Allocations roadblock your period close ever again.

Tuesday May 26, 2015

Transactions Resources, Resources, and More Resources

Do you import transactions into EBS Inventory using the Transactions Open Interface functionality? Inventory Support offers many resources to assist in resolving any issues that may occur. One resource the Inventory Social Media team recommends is the diagnostic in note, R12.0.6+ : Inventory Open Interface Transactions Transaction Data Test (Doc ID 732248.1). Want to see all R12 EBS diagnostics? Check out Doc ID 1083807.1. Still on 11i? Check out all the EBS diagnostics in Doc ID 179661.1.

Want more assistance than just a diagnostic? The Inventory Social Media Team is especially excited about the Analyzers being created across Oracle Support and EBS Products that offer warnings, recommendations, and solutions for your data and/or Product set-up. Check out note, Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Doc ID 1545562.1).



Existing Analyzers are currently being reformatted into our new and improved standards, so keep a look out for formatting improvements to existing Analyzers, and new Analyzer offerings. By the way, the Inventory Social Media team is particularly proud of the Inventory Analyzer (Doc ID 1499475.1) which has been previously discussed in this blog. So, be sure to use the many Support resources, and let's get those interface transactions processed!

Tuesday May 12, 2015

Webcast: Basic Troubleshooting Information for Duplicate Sales Order Transactions Stuck in Inventory Tables

Webcast_icon.jpgWebcast: Basic Troubleshooting Information for Duplicate Sales Order Transactions Stuck in Inventory Tables


Date: May 20th, 2015 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 5:00 pm CET, 9:30pm IST


This one-hour advisor webcast is recommended for (technical users, functional users, system administrators, Database Administrators, etc.) who normally work with Inventory Month End Closing process including resolution for stuck transactions in Inventory tables.

Topics will include:

  • Provide basic troubleshooting techniques to identify and fix duplicate sales order transactions between Inventory tables MTL_TRANSACTIONS_INTERFACE, MTL_MATERIAL_TRANSACTIONS_TEMP, and MTL_MATERIAL_TRANSACTIONS
  • Provide information regarding the Root Causes of this data corruption, how to verify your code level and confirm if you area already in a known fixed version, and how to avoid recurrence of this issue
  • Note: This webcast is focus on sales orders and has no affect on Inventory transactions like Miscellaneous Receipts or WIP transactions

REGISTER.jpg
Details & Registration: Doc ID 1290983.1

Wednesday Mar 11, 2015

Webcast: Inventory Sales Order Flow and Troubleshooting – R12

Webcast_icon.jpgWebcast: Inventory Sales Order Flow and Troubleshooting – R12


Date: March 18th, 2015 at 11:00 am ET, 10:00 am CT, 9:00 am MT, 8:00 am PT, 5:00 pm CET, 9:30pm IST


This one-hour adviser webcast is recommended for Order Management and Inventory technical and functional Users. We will review the sales order data flow from Order Management into Inventory with focus on R12, for a Discrete Inventory Org (non WMS enabled). Will provide basic troubleshooting techniques for stuck sales order type transactions in the MTL_TRANSACTIONS_INTERFACE (MTI) and review some of the diagnostics used by Oracle Inventory Support to troubleshoot stuck sales order records during regular daily and monthly end business cycles.

Topics will include:

  • Overview
  • Process Flow
  • Troubleshooting
  • Demonstration
  • Diagnostics: Tools Available
  • References

REGISTER.jpg
Details & Registration: Doc ID 1290983.1

Thursday Mar 05, 2015

Free Training Delivered by Product Experts!!!

Are you a current Oracle EBS Customer? Do you prefer training from Product experts on your own timetable? Would you like to suggest a training topic? If you answered YES! to these questions, we have the training for you. Logistics Product Support delivers Webcast/Webinars every month on key topics, common issues and new features. See, Oracle Inventory, Product Information Management and Warehouse Management Teams Informational Webcast Series (Doc ID 1290983.1).



If you miss a live Webcast, no worries. The Webcasts are recorded and available for viewing at your leisure. As usual, keep an eye on the Inventory Blog. We'll keep you updated on the latest Webcasts scheduled.

Also see Doc ID 1290983.1 to suggest topics that you would like to see as a Webcast. All suggestions are compiled and the most requested topics are at the top-of-the-list for future Webcasts.

Don't miss this opportunity. Suggest a new topic and view the Webcasts available today!

Friday Feb 06, 2015

Cycle Count No Data Found? Find Your Data!

It's a beautiful day. Not a cloud in the sky. It's warm and sunny and everything's right with the world. You leisurely decide to run your Cycle Count Listing Report and oddly enough, the sky starts to darken. Storm clouds gather. The temperature drops. Winds start to blow and...NO DATA FOUND! Nooooo...not the dreaded 'No data Found!' You have an inventory item you know has a scheduled date for today. How can there be no cycle count entry! You feel like the porch light is on but no one is home. Is there a logfile, report, or sql query that can be used to resolve this issue? You wonder where can you find items scheduled for today? How many times was this tested to see if the item should be counted? Are the logfiles annotated? The Inventory Blog Team answers your questions with a yes, Yes, and again, YES! We have the MOS note for you, Investigating Cycle Counting Scheduling Issues (Doc ID 1912738.1). Note 1912738.1 provides information like the constraints placed on creating cycle count entries.



Use the video demonstrations, presentations, and sql scripts in troubleshooting Note 1912738.1, to once again turn those grey skies blue, in your cycle counting day!

Tuesday Jan 13, 2015

Easy Assistance for Troubleshooting Issues

As we have discussed in previous blog entries, sometimes it seems like you have to be 'Carnac the Magnificent' when searching for a solution in MyOracle Support (MOS). Besides our previous suggestions on techniques for knowing how to search, sometimes for broad issues, the hardest part of searching is a starting point. Maybe you are having an issue like a problem logging a service request (SR). Maybe you are looking at an issue in your Oracle Database or EBS Product specific area where there are many MOS notes offering solutions. In scenario's like these, the Inventory Blog Team suggests using a Troubleshooting Assistant.  

Troubleshooting Assistants help narrow a search based on a series of questions that guide you to a solution. They are very much like the new 'Guided Resolution' feature that is now available for some SR problem types when logging SR's. They are also available in many different Oracle Product areas, and for many different issues. Wait...what's that? We are divining that you are asking, "How do I find one of these helpful Troubleshooting Assistants?" Well it's very simple oh honorable one. In MyOracle Support (MOS) make sure your Powerview is off, then search using the term ‘Troubleshooting Assistant’. This will return Troubleshooting Assistants across different Product areas. Or use Powerview to search for Troubleshooting Assistants for a specific Product. Or simply select one when you see it during a search in MOS. It's that easy.



Doc ID 1391970.2 above for EBS Inventory/Receiving RVTII-060 errors, is a prime example of a broad issue where there are many possible solutions. The Inventory Blog Team would certainly recommend using this assistant if the RVTII-060 error occurs.

Troubleshooting Assistants are living documents that are regularly updated with recent updated information, so it's helpful to bookmark the docs for future reference. Troubleshooting Assistants are another tool offered by Oracle Support to help with fast and easy solutions, and again, here's to successful searching in MOS!

Tuesday Jan 06, 2015

Logistics and Inventory Consolidated RUP11 Patches Released

Logistics Consolidated RUP11 (VERSION 12.1.1 TO 12.1.3 [RELEASE 12.1]) Patch 20187263 R12.WMS.B.delta.11 has been released. For non-WMS (Inventory Only) Customers, Inventory Consolidated RUP11 (VERSION 12.1.1 TO 12.1.3 [RELEASE 12.1]) Patch 20187255 R12.INV.B.delta.11 is also now available.

Remember to keep up with your RUP patches in order to reduce outages, improve User productivity, and decrease total cost of ownership of the Oracle EBS Inventory Modules. The Inventory Support Team mantra; keeping on the latest rollup patch is the fastest way to avoid SR's and to get fixes for known issues. Avoid SR's by staying on the latest RUP.

The latest RUP's:

Product Release Latest Released RUP Patch Release Date
WMS

 R12.1  Patch 20187263 Logistics Consolidated RUP11 (VERSION 12.1.1 TO 12.1.3 [RELEASE 12.1])
 December 2014
 R11.5.10  Patch 10129740 WMS RUP 20  February 2011
INV & RCV

 R12.1  Patch 20187255 Inventory Consolidated RUP11 (VERSION 12.1.1 TO 12.1.3 [RELEASE 12.1])  December 2014
 R12.0  Patch 8478486 INV and Receiving (PO): Release 12.0, Rollup Patch 7 (12.0.7)  July 2009
 R11.5.10  Patch 10111967 INV Rollup 23  July 2011
PIM

 R12.1  Patch 16226394:R12.EGO.C PIM 12.1.3.2 RUP CONSOLIDATION
 September 2013
 R12.0 8445429:R12.EGO.A R12 RUP7 PIM PATCHSET (Standalone patch only on top of 12.0.6 (6728000))
 July 2009
 R11.5.10  ROLLUP PATCH E22 (This is the last 11.5.10 rollup patch for PLM.E)
 January 2011

Reference the following resources for the above information and full RUP details, to help keep up with RUP's:
  • INV/WMS/RCV Family Patch Release History / Patchsets / RUPs (Doc ID 726226.1)
  • How To Determine the Product Information Management (PIM) Patchset and Rollup Patch Version (Doc ID 414470.1)
  • Oracle E-Business Suite Release 12 Release Update Pack (RUP) (Doc ID 423541.1)

Monday Dec 22, 2014

A Needle In A Haystack? Not So Fast My Friend!

We commiserate – “I know I found a MOS document in a previous search, why can’t I find it now?” “I can’t be the first person with this search criteria, why isn’t my search returning helpful results?” “I forgot what the acronym APC stands for – how can I be sure I’m getting relevant results for my problem  in APC?” Well, the Inventory Blog Team is right there with you. Searching in My Oracle Support (MOS) can seem like a challenge. But we also know that understanding how to search can be the difference between a quick answer, solution, or...the opposite if you don't know how to search. Lets shed some light.

Every member of Oracle Support that contributes to the knowledge base works hard to provide accurate concise information that can be found quickly and efficiently. We also know that having a high quality knowledge base is only one side of the equation when it comes to finding solutions. Knowing how to search can complete the equation. Whether you're a Customer, Consultant, or even an Oracle Support Engineer, we all benefit when it comes to knowing how to search MOS effectively. Knowing the search tools, along with key searching tips while using the tools, can greatly improve your search results. One highly recommended document to learn more about MOS searching is note MOS: Find Answers. Resolve Issues - Searching Effectively in My Oracle Support (Doc ID 1622660.1). Doc ID 1622660.1 provides key tips like how to use PowerView to refine your search at the Product level.



We especially suggest reviewing the Search Tips, Search Results and Refine Search Results sections of Doc ID 1622660.1. These sections particularly provide helpful searching tips and information to more quickly find solutions.

Remember, knowing how to search is an important key to unlocking MOS solutions. Here's to your next successful MOS search.

Monday Dec 08, 2014

EU You Need Movement Statistics!

For you non-legal experts out there, did you know that trade statistics reporting is a legal requirement in the European Union (EU)? With that requirement in mind, is your company about to start operations between or within the EU? And/or have you recently implemented Oracle EBS R12 and are looking for advice in how to perform the business cycle of producing, reviewing, validating, and approving the reporting of Intrastat/Extrastat movement of materials in the EU? If you answered yes to any of the these questions, Oracle EBS offers a comprehensive solution for your movement statistics reporting needs as part of the Oracle Supply Chain Globalization solution.

Use EBS Movement Statistics for:
  • Collecting and recording movement of materials across International borders- specific to the EU.
  • Compliance with EU Trade statistics reporting and satisfies the ESL declaration of goods sold within the EU to other VAT registered customers within the EU.
  • To review and finalize the movement statistics entered for receipts, shipments, and other material transactions. You can report by specific legal entity, type of movement, and calendar period. You can also choose whether to freeze the information for official reporting. You can choose between summary, detail, and country-specific formats.
For key information on Movement Statistics in R12, see Oracle Supply Chain Globalization - Movement Statistics in R12 - Brown Bag Presentation (Doc ID 1644961.1)

Doc ID 1644961.1 provides easy to understand information like the Movement Statistics simplified model:

Doc ID 1644961.1 also includes helpful information like a recorded demo with complete flow from set-ups to reporting and troubleshooting tips. Use resources like Doc ID 1644961.1 and let Oracle Supply Chain Globalization be your key to opening Movement Statistics solutions!

Sunday Nov 23, 2014

The Power to Request Enhancements!

Is there a feature you would like added to Inventory or Inventory Items? Tired of logging Service Requests with Support to request product enhancements? Well those days are over. You can now submit Enhancement Requests (ER's) for Logistics (Inventory) and/or Inventory Items (APC/PLM/PIM) directly in their respective Communities.

How does it work? First go to the Logistics or Inventory Items (APC/PLM/PIM) Communities.

Then to start an enhancement request, click on 'Create an idea': 



Then, to track and keep tabs on your idea and other ER's, click on 'Top Ideas'. While there, be sure to use the power of democracy and vote for your preferred ideas.


The new ER ability in Communities is the quickest way to get your ideas directly in front of Inventory and PIM Development. Top voted ideas float to the top and certainly draw more attention. As always, Oracle puts you, the Customer, in the forefront. Adding ER's to the Communities now gives you the power over your ER's. Please help us in tracking features that are important to you. Also, for more information on ER's to Communities, see note Oracle E-Business Suite Product Enhancement Request to My Oracle Support Community FAQ (Doc ID 1584210.1).

Thursday Nov 06, 2014

Inventory Consignment Gets More Flexible In Release 12.2

For you Inventory Consignment Users, we have great news! Consignment enhancements in Release 12.2 have made using the consignment feature easier with more flexibility. Check out the 'Transfer To Consigned For Implicit Consumption' feature. Oracle's User Communities have been asking for this ability and now it's available. It provides the power to give back consigned material.



Another valuable feature is the 'Automatic WIP Return' (available in Release 12.2.4) which allows the automatic return of material on a WIP return. For the full details on the new consignment features, visit note New Feature / Enhancement Request Implemented: Consumption To Consigned For Implicit Consumption (Doc ID 1938948.1). These enhancements will truly expand your consignment abilities. Enjoy, and happy consigning!

Wednesday Oct 29, 2014

Webcast: Inventory Period Close - Stuck Transactions

Webcast_icon.jpgWebcast: Inventory Period Close - Stuck Transactions


Date: November 5th, 2014 at 1:00 pm ET, 12:00 pm CT, 11:00 am MT, 10:00 am PT, 6:00 pm, GMT Summer Time (London, GMT+01:00)


This one-hour session is recommended for technical and functional Users who want to learn more about the standard datafixes available for the Inventory Module. The Standard Datafix Note 568012.1 outlines over 2 dozen data issues and their solutions. Newly created content includes the datafix directly downloadable from Note for more rapid resolution. The new datafix notes include an identify script, root-cause patches check, backup script and datafix.

Topics will include:

  • Overview of Common Datafixes in Inventory
  • Most Common Data Issues
  • Applying Common Data Fixes
  • Avoiding the Issue in the Future with Root Cause Patches
  • A short live demonstration will walk thru an example data issue and fix

REGISTER.jpg
Details & Registration: Doc ID 1290983.1

About

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected

Twitter

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today