Latest Posts - All Tracks

PIM Data Hub Vs Item Master

March 12th, 2010 by Mahender Bist

I have been asked this question time and time again – “Why do you need a dedicated MDM solution now when all this time IT has been able to help businesses with product attributes as descriptive Flexfields, custom designed tables or other stitched up solutions?”

 

Well, most of us who have been working with Item Master in the past have been forced to utilize the application’s unintended features creatively to store product attributes in Categories, Cross References, DFFs etc. Finally, when it becomes unmanageable, custom tables provided refuge of the last resort. Think of it, PIM Data Hub is the natural progression step for the organizations at the higher end of the product MDM maturity spectrum.

 

I beg to differ with the opinion that MDM is just another application to store additional data.  There is no disputing that the products are both the bread and butter and the key ingredient to success for any organization. Now that most companies in the marketplace are past the struggle of implementing Enterprise Resource Management systems, they are paying attention to software that provides them deeper insight into the products, improve supply chain efficiencies and help them connect to the customers better. Internet based purchasing has added fuel to the fire where online retailers do need to provide more than just the name and description of the product and the customer across the globe are rightfully demanding more information to make better buying decision. UCCNet and other standardization concepts that have been around for a while are finally shaping up and the retailers in turn are collecting hundreds of product attributes from the manufacturers about the product that define:

-        Product Dimensions

-        Key properties

-        Composition

-        Quality Information

-        Packaging

-        Regulatory and Compliance Information

 

To easily sum up, the following matrix provides the key reasons for implementing PIM Data Hub as opposed to simple Item Master:

 

Features
Product Information Management Data Hub(PIM)
Item Master (IM)
Centralized Data PIM centralizes all product data in hierarchical catalogs with unlimited attributes in addition to the ERP Operational attributes. PIM Product Workbench provides 360 degree view of: 

·       Product Attributes

·       Attachments (capability to display pictures and schematic diagrams etc.

·       BOM

·       Product Lifecycle and changes during phases

IM focuses mainly on operational and some transactional attributes. 

 

Functional area categories can be utilized for reporting.

Extended Attributes Extended attributes can serve as storage and validation of the important product related data such as marketing, sales, cost management and product research etc. Such data is  usually stored in spreadsheets on individual laptops in most organizations making is costly and error prone to extract 

 

Limited capability with Descriptive Flexfields(DFF) and Item Catalog attributes to store additional information 

 

Flexible Attributes PIM provides amazing flexibility in defining various types of attributes that can be keyed in by the user or derived from other attributes using dynamic functions. 

 

Data must be static in nature and user entered. 

 

Display Flexibility PIM provides flexibility to create your own page layout. This feature provides easy means to displaying attributes on item pages by business area thus facilitates role-based attribute maintenance. Excellent productivity feature! 

 

Predefined attribute arrangement- Live with it :–( 

 

Advanced Search Capabilities Customizable advanced searches provide highly flexible searching capabilities that can easily help identify the duplicates parts thereby saving cost in creating new parts, procurement and wastage Item Master focus is simply in keep the ERP running. Good luck searching if you do not have all the attributes embedded in the Product description.
Display Formats PIM Display formats are equivalent to ‘Folder Functionality’ on Steroids Folder functionality is limited to only operation attributes: DFF and catalog attributes can’t be displayed in folders
Excel Export and Import Any data displayed on the search results can be exported to excel and imported back after mass updates. Self-service capabilities of the PIM application greatly reduce IT work making information available to right people at the right time! Limited excel export capabilities and NO excel import capabilities are available from Item Master
Accelerate New product development PIM provides the most extensible and configurable workflow to automate the ‘New Product Introduction’ Workflow capabilities are next to none and workflow customizations can easily add to the implementation cost
Synchronize data with trading partners Workflow based events make it easy to synchronize data. Latest releases also provide capabilities to use out-of-the-box Service Oriented Architecture (SOA) integration services Still relies on old trigger based functionality to facilitate the data export and synchronization
Data Governance 

 

Product data governance can be handled via automating processes and rule-based validations. Additionally, PIM data security in addition can help achieve the governance objectives Governance is achievable with process changes and form customizations but is a sticky situation
Change Control Lifecycle phase based change control of attributes, attachments, BOM and Routings 

 

No lifecycle controls are available in the Item Master. ECOs functionality is very inflexible in terms of workflows
Security Highly granular role based Security available at the attribute group level Item Master has old menu/function based security 

 

Workflow based Productivity Flexible and highly configurable workflows for product, attachment, BOM, Routing and other attribute changes enhance productivity without adding to the cost of implementation 

 

Low to no workflow flexibility unless workflow is customized

 

Next: In my next post, I will be covering the ‘R12 PIM Data Hub Valuable Functionalities’.

New Release APEX Paper through Contractors Network

March 8th, 2010 by Rebecca Bragg

Hi Everyone,

I am pleased to announce the next release in our extensive Oracle related White Paper Library of:

Oracle Application Express The Fast Way to Extend to Oracle E-Business Suite

Authored by Rod West

The Purpose of Rod’s Paper:

This article describes how an APEX application can be integrated with the E-Business Suite 11i and R12. There are many tools that Applications developers can use to extend E-Business Suite but often developers are unaware that APEX can be closely integrated with the E-Business Suite. APEX forms and reports can be added to E-Business Suite menus and spreadsheet data can be uploaded into the E-Business Suite application.

Please feel free to drop by the White Paper library to request your copy of the White Paper today.

Thanks Rod for putting together this article.

Outages in a paperless office

February 23rd, 2010 by John McGhee

No matter how wonderfully efficient and user-friendly an Oracle application might be its reputation and reliability can be needlessly dented by a single prolonged network outage, separating users from the information they need to do their jobs.

One of these outages occurred this morning in the organisation where I am currently contracting, damaging user confidence in the local Oracle application. Persuading users that the problem is not the fault of the application doesn’t placate them much because the main issue is that all their key information is now on computers – because we told them to put it there, thus placing them at the mercy of network and electrical outages.

Throughout various paperless office initiatives over the years I have continued to encourage users to print off limited key information – subject to confidentiality and data protection rules - if they consider it essential to their job, so they have a paper copy in case of computer unavailability. It must be stressed that data should always be electronically stored and updated on the computer application to maintain accuracy and to comply with integrated working practices but in most cases there is nothing wrong in downloading an occasional paper copy for convenience, portability and contingency purposes. Typical examples are phone lists, presentation notes and other documents needed for meetings or conferences which cannot be cancelled just because of a computer or network glitch. Obviously, any amendments and updates subsequently deemed necessary must be made on the computer application as this must always be the ‘master’ copy.

It seems a shame that the well-intentioned idea of a paperless office is marred by the misconception that computer applications are installed merely to eliminate paper rather than to manage data more efficiently, with significant reduction in paper being an added bonus. It isn’t a coincidence that most application screens have a ‘Print’ button or link so that the user has the option to print if they consider it necessary.

A new year–and a new project

February 16th, 2010 by Tim Scott

Hello everybody–I hope everyone is doing well and keeping busy.

I have started a new contract and am driving to it each week.  As I drive, I go past a town named “Covert” and  I think it is funny that there are signs telling me where to exit to find the town.  One would think that they would want to keep that town hidden…

Anyway, when I started this project it reminded me of some traps that one comes across during a project.  In one memorable case, I was working on a project with many other consultants; one day, a financial consultant decided to turn off multi-currency.  As my fellow JDE consultants may know, with multi-currency turned on, you have to enter the currency code when dealing with prices and advanced pricing setup; if multi-currency is turned off, you do not get the choice to enter the currency code.

Now the fun begins.  While multi-currency was turned on, the pricing team was entering advanced price adjustments.  They continued entering adjustments when multi-currency was turned off.  So what was the issue?  Some of the adjustments had currency codes and the rest had no currency code–it was blank.

The fun really started when the pricing team started entering orders to test their pricing setup. In sales order entry, they could see all the adjustments when using the Price History row exit, but they could not see all the adjustment details when trying to edit them (via the Price Adjustment Detail form).  After spending most of a day, we discovered that during the sales order process, the pricing functionality equates the blank currency code with the company’s currency code–in our case, they were entering the pricing for a USA branch, so USD and blank were considered the same currency codes; however, the P4072 (Work With Adjustment Detail) considers them as different currency codes.

We are able to fix this, but I can not remember if we used SQL to delete the adjustment details, or we turned off multi-currency, deleted the adjustment details that we could see (the ones with a blank currency code), then turned on multi-currency and strongly suggest to the financial consultant to never touch the multi-currency setting again.

If this happens to you, be diplomatic with the financial consultant–or they might get angry and delete branch “ALL.”  Then, as a distribution or manufacturing consultant, you will see some really bizarre errors.

But I might save that for another post.

Tactful Disagreement

February 16th, 2010 by Marc Genberg

“Tact:  A keen sense of what to say or do to avoid giving offense; skill in dealing with difficult or delicate situations.”[1]

 

Clients hire consultants to help them with a problem.  In the Oracle contracting world, the client may need a new system or modification to their existing system and they do not have the technical expertise to perform the needed work.  They hire a team of consultants to assist them with their project.

 

As the project progresses, we may see problems or issues that need to be addressed.  We might also be asked directly by the client to comment on an issue that is in our particular domain.  In either case, the client expects us to provide them with a competent recommendation for a solution.  There are occasions when, much to our surprise, when the client resists our recommendations.  This can be a frustrating experience that has the potential to increase tension in our relationship.

 

How should you handle the situation when you have a professional disagreement with your client?  First and most importantly – don’t take it personally.  It is hard to do, but you need to separate any emotional attachment to your ideas.  Once you’ve done that (as best you can), then the next step is to try and understand the client’s position.  Generally, resistance to ideas comes because the client is feeling either loss of control or vulnerability.  This can be difficult to understand and is probably something that most clients won’t express directly.  You’ll rarely hear a client say “Your solution makes me feel vulnerable.”  However, your mere presence can make the client feel vulnerable – they are at your mercy to do the job right.

 

The focus of your conversations when discussing a recommendation or solution should be on the objectives and outcomes.  If you can get agreement on what it is that you are trying to achieve first, then it will be easier to get agreement on how to achieve it.  Plus, by focusing on the outcomes, you can assess if the client doesn’t agree that your recommendation will meet those outcomes.

 

Next, work together with the client to produce a solution.  Ask them specifically what they don’t like about your recommendation and how they might change it.  Get them to elaborate in some detail and then incorporate what makes sense into the final solution.  This brings them on board and helps them take some degree of ownership, which can minimize that sense of loss of control or vulnerability.

 

Finally, accept that some solutions may have to be less than ideal for non-technical reasons.  There may be political/organizational reasons why one way of achieving an outcome is more acceptable than others.   For example, it could be for simple reasons such as the CFO doesn’t like reports formatted a particular way.

 

If you are able to not take resistance personally, understand the client’s position, and let them be part of the solution, you can tactfully handle disagreements and achieve better outcomes with your clients.


 

[1] From Dictionary.com

Buy Adipex Bupropion Flexeril Buy Fioricet Buy Cipro Buy Hydrocodone Zyban Levitra Phentermine Online Buy Bontril Buy Soma Levitra Buy Tramadol Online Alprazolam Xanax Online Ativan Xanax On Line Buy Hydrocodone Online Buy Tenuate Buy Ultram Biaxin Darvocet Buy Valium Online Nexium Buy Bupropion Buy Hydrocodone Buy Ativan Effexor Zocor Cheap Phentermine Buy Ativan Buy Online Xanax Buy Online Xanax Hydrocodone Buy Cheap Phentermine Bontril Lexapro Buy Zyrtec Glucophage Buy Diflucan Butalbital Diazepam Buy Effexor Buy Phentermine Online Xanax Buy Valium Online Propecia Buy Ephedrine Codeine Buy Diazepam Fioricet Buy Nexium Buy Glucophage Codeine Buy Adipex Buy Acyclovir Diflucan Buy Ephedrine Cipro Fioricet Vicodin Buy Flexeril Didrex Buy Zyprexa Buy Xanax Online Viagra Online Buy Alprazolam Xanax Buy Diazepam Buy Zocor Buy Lorazepam Meridia Effexor Buy Clonazepam Buy Norvasc Buy Zyprexa Flexeril Diazepam Buy Biaxin Celexa Buy Viagra