Thursday Nov 19, 2015

Try Our New Inventory Transactions Analyzer!

Back in our early November 2015 post, we announced the release of the EBS Inventory Consignment Analyzer Doc ID 2048039.1. The Inventory Social Media Team is now excited to announce the release of the EBS Inventory Transactions Analyzer Doc ID 1499475.1.

You may be familiar with Doc ID 1499475.1, it used to offer the Inventory Analyzer. The Inventory Support Team upgraded the Inventory Analyzer to the new Transactions Analyzer to offer a more transactions specific focus.

The new Transactions Analyzer provides the same Inventory patch level checks and Inventory Administration information as the Inventory Analyzer, but it then takes transactions solution capabilities to a different level. It provides a snapshot of your current transactions tables in the 'Transactions Summary' section, then provides definitive solutions to known data issues in the 'Common Data Issues' section.

All of our EBS Analyzers are Support Tools designed to help Customers find quick solutions. We hope you take advantage of the EBS Inventory Transactions Analyzer as another tool to help manage and prevent roadblocks for transactions processing. By the way, don't forget to provide Feedback using the Feedback button at the bottom of Doc ID 1499475.1. We welcome suggestions for improving the Transactions Analyzer. Here's to using the Transactions Analyzer and successful transactions processing!

Wednesday Nov 04, 2015

Checkout the Brand New Consignment Analyzer!

The Inventory Social Media Team is proud to announce the release of the 'EBS Inventory Consignment Analyzer'. The EBS Conignment Analyzer is the first tool offered by Oracle Inventory Support to deal specifically with Inventory Consignment issues. Check out note - EBS Inventory Consignment Analyzer (Doc ID 2048039.1).

Use the EBS Inventory Consignment Analyzer to review Inventory consignment related set-up, consignment proactive recommendations, consignment processing, and to help diagnose known consignment issues.

The EBS Inventory Consignment Analyzer is an all-in-one tool to help get ahead of known issues, or just to maintain your consignment health. If you use the Consignment functionality, the EBS Consignment Analyzer will be an indispensable tool to help manage your Inventory. By the way, don't forget to give us Feedback (at the bottom of Doc ID 2048039.1) on the analyzer, and let us know what you like and where you would like to see enhancements

Monday Oct 26, 2015

Have You Seen 'Allow Cross Project for Pick Wave Allocation'?

Are you on EBS 12.1.3 or above? Do you use Project Manufacturing (PJM)? If yes, you already have the options to 'Allow Cross Project Issues' and 'Allow Cross Unit Number Issues'. Now you can also choose to select the 'Allow Cross Project Pick Wave' in the Project Manufacturing Parameters window. This will enable cross project sales order or internal order pick wave allocation.

With the enhancement, you can still 'Allow Cross Project Issues' to other move order types and transactions (WIP jobs, etc), but Users now also have the ability to decide whether to allow cross project issue based on the move order type – pick wave or others.

For more information on the the patches required to get the enhancement, and the enhancement itself, see notes:
*PJM - R12 - Pick Release Unexpectedly Allocating Common or Different Project Stock For Hard Pegging Items (Doc ID 1613522.1)
*PJM - R12 - Pick Release Failing to Allocate Project Sales Orders After Applying Inventory Management Rollup Patch (Doc ID 1613656.1)
*Oracle Project Manufacturing Release Notes for Release 12.2.4 (Doc ID 1912375.1)

Sunday Oct 11, 2015

Clean Your Supply/Demand

So you noticed that there is inconsistent data in the Supply/Demand form (INVDVDSD) for a specific item/organization? No need to worry. We have some suggestions that may clear things up.

First, check out note, INVDVDSD - Troubleshooting Issues With The Inventory Supply/Demand Form (Doc ID 286755.1). Then download script 'INVDVDSD_data_check.sql' and run it in sqlplus for the item and organization.

After running 'INVDVDSD_data_check.sql', review the output for data corruption or issues for your specific item/organization. The script output will show different areas that that may need clean-up.

You can also further troubleshoot Supply/Demand by using note, Troubleshooting the Item Supply/Demand Form (Doc ID 404459.1).

As always, use Support tools and diagnostics to help keep you data sparkling clean.

Friday Sep 25, 2015

Finally Eliminate Those Duplicate WIP Transactions!

Back in our June 29th, 2015 Inventory Blog post, we discussed Doc ID 1073279.1 dealing with duplicate Work in Process (WIP) transactions issues. We have an update! The Inventory Social Media Team is happy to announce that Oracle Development has just released a root cause fix to resolve duplicate WIP transactions. See the 'Root Cause Analysis' section of 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).

The root cause fix adds a profile option to allow or deny repeated submission of WIP transactions processed through mobile apps or forms, in background mode, if pending transactions exist for a WIP job. Get full details from Doc ID 1073279.1.

Need more information on diagnosing WIP transaction issues? Check out the recording of the Advisor Webcast Questions? "Solving Issues with the Work In Process (WIP) Job Diagnostics", from the Logistics Communities. Also don't forget that all Inventory Webinar's are available in Doc ID 1290983.1 and all EBS wide Webinar's are at Doc ID 1455369.1.

Follow the directions in Doc ID 1073279.1 and let's end those duplicate WIP transactions!

Tuesday Sep 08, 2015

Webcast: Solving Issues Using Work In Process (WIP) Job Diagnostics

Webcast_icon.jpgWebcast: Solving Issues Using Work In Process (WIP) Job Diagnostics

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

This one-hour advisor webcast is recommended for technical users and functional users who use E-Business Logistics, Inventory, and Work In Process. The presentation will provide a summary of various diagnostics available focusing on the WIP Job Diagnostic and related wipjob11i.sql. The presenters will walk through the differences between the various diagnostics and deciding which is the best for you to use. Key differences between the diagnostics will be provided then presenters will apply the diagnostics to demonstrate using them to resolve issues. References will be made to the WipJob11i.sql Doc ID 316142.1 and the Work Order Tests Doc ID 732341.1.

Topics will include:

  • Review of the various WIP diagnostics
  • Key differences between WIP diagnostics
  • Demonstration using WIP diagnostics
  • Using WIP diagnostics to solve issues

Details & Registration: Doc ID 1290983.1

Monday Aug 10, 2015

Webcast: Oracle Product Hub Web Services - Setup, Use, and Troubleshooting

Webcast_icon.jpgWebcast: Oracle Product Hub Web Services - Setup, Use and Troubleshooting

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

This one-hour advisor webcast is recommended for Oracle Product Hub users who are implementing web services from Oracle Product Hub. Oracle Product Hub provides the following ODI based web services:

  • Item web service (includes structure service)
  • Item catalog category web service
  • Value set web service
  • Attribute group web service (from 12.2 only)

Topics will include:

  • How web services work
  • Setup and test of web services
  • Troubleshooting web services issues

Details & Registration: Doc ID 1290983.1

Friday Aug 07, 2015

What's The High Cost Of Not Patching?

As you know, everything in the E-Business Suite is interconnected. One Product connection very important to Inventory is the Oracle Cost Management. Our friends in Costing have just released their latest Consolidated Patch 21449070:R12.BOM.C. For more information, see note, Oracle Cost Management Recommended Patch Collection (RPC) Priority Patches (Doc ID 1213663.1).

By the way, if you're interested in how to find Inventory and/or other EBS Products recommended patches, a really helpful resource is note, How to Find E-Business Suite Recommended Patches (Doc ID 1400757.1).

We know your heard it from us before, but again we can't stress it enough: Patching is the easiest way to avoid known issues. So apply recommended patches and keep your Costs processing!

Thursday Jul 30, 2015

BOM Calendar - Is Your MRP Bucket Half Full?

Oracle Master Resource Planning (MRP) uses ‘bucketing’ to help keep control of forecasts for demand for a particular product. The forecasts estimate future demand for items using any combination of historical, statistical, and intuitive forecasting techniques.

The forecasts can be gathered together in Time Buckets. You can forecast with daily buckets in the short term, weekly buckets in the midterm, and periodic buckets in the longer term.

Do you you need to manage your buckets in Calendar Months? What if you expect a bucket to ‘end-date’ on March 31 – but if March 31 is a Wednesday, and the Workday Calendar for “March” runs until Friday April 2? Then requirements from April 1 and 2 will be included in the “March” bucket. Some customers and users want to more closely link the BOM Workday Calendar to the common Calendar in use around the world.

If you would like to manage your buckets in Calendar months, we invite you to vote on Idea 'MRP Bucketing Should Happen For The Monthly BOM Calendar' in the EBS Logistics Communities.

You can also review note, It Is Not Possible To Setup Calendar For Monthly Bucketing (Doc ID 2027380.1).

If you'd like more information on using EBS Communities for Enhancement Requests (Ideas), see note, Oracle E-Business Suite Product Enhancement Request to My Oracle Support Community FAQ (Doc ID 1584210.1).

The power to request enhancements is in your hands, so don't forget to vote if you'd like MRP bucketing to happen for a monthly BOM Calendar.

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

Details & Registration: Doc ID 1290983.1

Friday May 08, 2015

Data Solutions For Your Inventory Items

Does it seem that you sometimes experience what appears to be the same data issues when adding or updating Inventory Items? It's not happenstance. Oracle Product Information Management (PIM) Development and Support have identified certain data corruption scenario's that might be common to certain Inventory Item data. Development and Support have worked together to create, test, and approve Standard Datafixes (SDF's) that can be safely used by PIM and/or Inventory Items Customers, without logging a Service Request. Be sure to bookmark note, FAQ: Item And PIM (APC/PLM) Standard Datafixes (Doc ID 1295001.1).

The note references 7 data issues, identifies if error identification scripts are available for each, let's you know if each issue has a standard datafix and/or a root cause patch, and shows the Product versions covered. You can have confidence using the SDF's because they were thoroughly tested and have Oracle PIM Developments stamp-of-approval. Use the fixes in Doc ID 1295001.1 to limit down time, and let's get those Inventory Items ready for processing.

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



« December 2015