Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Oracle PIM Integration Capabilities: Business Events Availability by Oracle Product Hub

Posted on December 18th, 2012 by Hub Contributor |Print This Post Print This Post |Email This Post Email This Post

Following is a list of Business Events provided by Oracle Product Hub:

Â

EventÂ

DescriptionÂ

oracle.apps.ego.item.postAML.ChangeÂ

Item AML is changed (such as a manufacturer part number is added, updated, or deleted)

oracle.apps.ego.item.postCatalogCategoryChangeÂ

Catalog category is changed such as when categories are created, updated or deletedÂ

oracle.apps.ego.item.postValidCategoryChangeÂ

Category is added to or is removed from a catalog. This event is also raised when the attributes of catalog are changed.

oracle.apps.ego.item.postItemCreateÂ

Item CreationÂ

oracle.apps.ego.item.postItemUpdateÂ

Item UpdateÂ

oracle.apps.ego.item.postGTINAttributeChangeÂ

GTIN Attribute group row is created or updated.

oracle.apps.ego.item.postItemApprovedÂ

On Item ApprovalÂ

oracle.apps.ego.item.postItemBulkloadÂ

Bulk Item processing (creation, update)Â

oracle.apps.ego.item.postXrefChangeÂ

Item cross-reference creation, update, or deletionÂ

oracle.apps.ego.item.postRevisionChange

Item revision is created or updatedÂ

oracle.apps.ego.item.postItemRoleChangeÂ

An item role grant is changed (added, modified, or removed)Â

oracle.apps.ego.item.postCatalogAssignmentChangeÂ

Item Catalog assignment or removalÂ

oracle.apps.ego.item.preAttributeChange

Item Attribute group row is created, updated, or deleted. This event is raised before the change is committed.Â

oracle.apps.ego.item.postAttributeChangeÂ

Item Attribute group row is created, updated, or deleted. This event is raised after the change is committed.

oracle.apps.eng.cm.changeObject.changeApprovalStatus Â

Approval status changesÂ

oracle.apps.eng.cm.changeObject.changePriority Â

Priority changesÂ

oracle.apps.eng.cm.changeObject.changeStatus Â

Status changesÂ

oracle.apps.eng.cm.changeObject.changeWorkflowStatus

Workflow status changesÂ

oracle.apps.eng.cm.changeObject.create Â

Creation of a change objectÂ

oracle.apps.eng.cm.changeObject.postComment Â

Posted comment on a change objectÂ

oracle.apps.eng.cm.changeObject.reassign

Reassignment of a change objectÂ

oracle.apps.eng.cm.changeObject.requestComment Â

Common request of a change objectÂ

oracle.apps.eng.cm.changeObject.submit Â

Submission of a change objectÂ

oracle.apps.eng.cm.changeObject.update Â

Update of a change object

oracle.apps.eng.cm.changeOrder.changeScheduleDate Â

Schedule date changeÂ

oracle.apps.eng.cm.import.complete Â

Import is completedÂ

oracle.apps.eng.cm.revisedItem.changeScheduleDate Â

Revised item schedule date changeÂ

oracle.apps.eng.cm.revisedItem.changeStatus

Revised item status changesÂ

Â

Posted in MDM | No Comments »

It’s All About The “Data” within an organization

Posted on September 19th, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Different types and structures of data exist within an organization. Here to go:

dgreybarrow Master Data -Enterprise-level data entities that are of strategic value to an organization. These are typically non-volatile and non-transactional in nature. Typically example of such data are Customer, product, supplier, assets, System Name

dgreybarrow Transaction Data-These are Business transactions that are captured during business operations and processes, such examples are PO, Invoices, PR , Payments etc .

Therefore, Data is intrinsically simple and can be divided into data that identifies and describes things, master data, and data that describes events, transaction data.

dgreybarrow Reference Data- There are Internally managed or externally sourced facts to support an organization’s ability to effectively process transactions, manage master data, and provide decision support capabilities.

Typical example are as such :
States/Provinces/Territories
Cities within States/Provinces/Territories
Street names within cities
Street types (Dr, Lane, Boulevard...)
Street direction (N, NE, E, S...)
Blocks & Block Groups
Postal codes within states
Months of the year

dgreybarrowUnstructured Data—This is data found in e-mail, white papers like this, magazine articles, corporate intranet portals, product specifications, marketing collateral, and PDF files.

dgreybarrowMetadata -This is defined as “data about the data.” These data are Typically Used as an abstraction layer for standardized descriptions and operations.

dgreybarrow Analytical Data -These data are derivations of the business operation and transaction data used to satisfy reporting and analytical needs. In the organziation such data typically reside in data warehouses, data marts, and other decision support applications.

dgreybarrow Big Data -Data sets whose size is beyond the ability of commonly used software tools to capture, manage, and process the data within a tolerable elapsed time.

Big data typically refers to the following types of data:

  • Traditional enterprise data includes customer information from CRM systems, transactional ERP data, web store transactions, general ledger data.
  • Machine-generated /sensor data - includes Call Detail Records ("CDR"¨), weblogs, smart meters, manufacturing sensors, equipment logs (often referred to as digital exhaust), trading systems data.
  • Social data includes customer feedback streams, micro-blogging sites like Twitter, social media platforms like Facebook

Posted in Conversion, MDM | No Comments »

Customer Hub: Its all about knowing the Customer !

Posted on January 30th, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Customer Hub: Its all about knowing the Customer ! Agree or disagree ?

Did you encounter situation where you have to answer these question on company's customers and prospects ..

  • Which of our services they are using and what they are NOT using?
  • What do we cross-sell and up-sell to our existing customer base?
  • What product bundles do sales propose that will increase the sale?
  • Are we able to identify who are our top revenue generating top 10 customers?
  • Are we able to identify who are most likely to churn out?
  • Can we identify all the orders that have placed and what are their statuses?
  • Are we billing for all the services that we are providing?
  • Are we able to manage contracts with them both at divisional as well as corporate level?

In order to answer, you need Need a 360 degree view of the customer

dgreybarrow Oracle CDH vs. Oracle-Siebel UCM

Oracle actually sells two products on customer Data hubs -Oracle CDH and Siebel UCM (Which is now Oracle UCM). But these products are positioned differently in the markets .

Both these products revolve around mastering of the “Customer” entity.

Oracle CDH or “Customer Data Hub” is a member of the Oracle Fusion Middleware family of products and has built-in integration capabilities with other Oracle E-Biz suite modules.

Siebel UCM, is the Siebel Customer mastering solution.

Oracle CDH is mainly focused on manufacturing, hi-tech, Retail and Distribution industries whereas Siebel UCM is targeted for telecommunications, media, financial services and government.

Enterprises implementing customer Data Hubs should evaluate these two products and choose from these based on their requirement.

UCM (Universal Customer Master) release 8.0 has more capabilities than CDH in terms of Data extensibility model, Data quality features and its strong interfaces to various third party tools like Trillium etc [Reference www].

On the weaker side, Oracle CDH and UCM are lacking in terms of dash boarding, reporting facilities, data steward facilities through web, registry-style implementations.

if you need more information, take a deeper dive.

 

Posted in MDM | No Comments »

Oracle PIM Integration Capabilities: Business Events Availability by Oracle Product Hub

Posted on April 22nd, 2011 by Hub Contributor |Print This Post Print This Post |Email This Post Email This Post

Following is a list of Business Events provided by Oracle Product Hub:

Event

Description

oracle.apps.ego.item.postAML.Change

Item AML is changed (such as a manufacturer part number is added, updated, or deleted)

oracle.apps.ego.item.postCatalogCategoryChange

Catalog category is changed such as when categories are created, updated or deleted

oracle.apps.ego.item.postValidCategoryChange

Category is added to or is removed from a catalog. This event is also raised when the attributes of catalog are changed.

oracle.apps.ego.item.postItemCreate

Item Creation

oracle.apps.ego.item.postItemUpdate

Item Update

oracle.apps.ego.item.postGTINAttributeChange

GTIN Attribute group row is created or updated.

oracle.apps.ego.item.postItemApproved

On Item Approval

oracle.apps.ego.item.postItemBulkload

Bulk Item processing (creation, update)

oracle.apps.ego.item.postXrefChange

Item cross-reference creation, update, or deletion

oracle.apps.ego.item.postRevisionChange

Item revision is created or updated

oracle.apps.ego.item.postItemRoleChange

An item role grant is changed (added, modified, or removed)

oracle.apps.ego.item.postCatalogAssignmentChange

Item Catalog assignment or removal

oracle.apps.ego.item.preAttributeChange

Item Attribute group row is created, updated, or deleted. This event is raised before the change is committed.

oracle.apps.ego.item.postAttributeChange

Item Attribute group row is created, updated, or deleted. This event is raised after the change is committed.

oracle.apps.eng.cm.changeObject.changeApprovalStatus

Approval status changes

oracle.apps.eng.cm.changeObject.changePriority

Priority changes

oracle.apps.eng.cm.changeObject.changeStatus

Status changes

oracle.apps.eng.cm.changeObject.changeWorkflowStatus

Workflow status changes

oracle.apps.eng.cm.changeObject.create

Creation of a change object

oracle.apps.eng.cm.changeObject.postComment

Posted comment on a change object

oracle.apps.eng.cm.changeObject.reassign

Reassignment of a change object

oracle.apps.eng.cm.changeObject.requestComment

Common request of a change object

oracle.apps.eng.cm.changeObject.submit

Submission of a change object

oracle.apps.eng.cm.changeObject.update

Update of a change object

oracle.apps.eng.cm.changeOrder.changeScheduleDate

Schedule date change

oracle.apps.eng.cm.import.complete

Import is completed

oracle.apps.eng.cm.revisedItem.changeScheduleDate

Revised item schedule date change

oracle.apps.eng.cm.revisedItem.changeStatus

Revised item status changes

[This blog post is contributed by Hub regular Visitor who worked almost 8 years in MDM and PDM area. You can reach them to author via email]

Posted in MDM | No Comments »

Oracle PIM Integration Capabilities : APIs/Web Services Availability by Oracle Product Hub

Posted on April 21st, 2011 by Hub Contributor |Print This Post Print This Post |Email This Post Email This Post

As we aware, Oracle Product Information Management Data Hub is an enterprise data management solution that enables customers to centralize and master all product information from heterogeneous systems, creating a single view of product information that can be leveraged across all functional departments.

Oracle Product Hub provides a full set of business services and data services, both at granular level and at business object level. These include Items creation/update, item change management process support, Items data gathering and data federation.Following is a list of APIs/Web Services provided by Oracle Product Hub , feel free to add in case if anything missed out.

Oracle API/Web servics Description
EGO_USER_ATTRS_DATA_PUB.Get_User_Attrs_Data This API is used to access user-defined attribute data for a particular item
EGO_USER_ATTRS_DATA_PUB.Copy_User_Attrs_Data

This API is used to copy all User-Defined Attribute data from one object instance to another object instance of the same type (e.g., from one EGO_ITEM to another or one PA_PROJECTS to another).

EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data This API processes User-Defined Attribute data for one object instance.
INV_ITEM_CATEGORY_PUB.Create_Valid_Category This API is used to for assigning a category to a category set
INV_ITEM_CATEGORY_PUB.Create_Category This API is used to create a category.
INV_ITEM_CATEGORY_PUB.Create_Category_Assignment This API is used to create an item category assignment
INV_ITEM_CATEGORY_PUB.Delete_Category This API is used to delete a category
INV_ITEM_CATEGORY_PUB.Delete_Valid_Category This API is used to delete category assignment to its category set
INV_ITEM_CATEGORY_PUB.Delete_Category_Assignment This API is used to delete an item category assignment
INV_ITEM_CATEGORY_PUB.Update_Category This API is used to update a category.
INV_ITEM_CATEGORY_PUB.Update_Category_Description This API is used to update a category description
INV_ITEM_CATEGORY_PUB.Update_Valid_Category This API is used to for reassigning the parent category of a category in a given category set
INV_ITEM_CATEGORY_PUB.Update_Category_Assignment This API is used to for re-assigning an item to a new category in the given category set.
EGO_ITEM_PUB.Assign_Item_To_Org This API is used to assign one item to an organization
EGO_ITEM_PUB.Implement_Item_Pending_Changes This API is used to implement pending changes (phase and/or status) for an item/item revision.
EGO_ITEM_PUB.Process_Item

The full parameter-list version of Process_Item

This API is used to create or update one item if you want to specify item attribute values that aren't exposed in the wrapper version of Process_Item, or to create or update an item revision.

EGO_ITEM_PUB.Process_Item (Convenience wrapper)

A convenience wrapper to Process_Item

This API is used to create or update one item by passing only the most important and/or commonly-used item attributes.

EGO_ITEM_PUB.Process_Item_Cat_Assignment This API allows user to assign/remove a catalog/category to/from an item.
EGO_ITEM_PUB.Process_Item_Descr_Elements This API allows user to give the values of item catalog category descriptive elements.
EGO_ITEM_PUB.Process_Item_Org_Assignments Use this API to assign multiple items to organizations.
EGO_ITEM_PUB.Process_Item_Phase_And_Status Use this API to either change the status of an item or promote/demote the lifecycle of an item/item revision.
EGO_ITEM_PUB.Process_Item_Role Use this API to create, update, or delete one role grant on one item, or on one existing instance set.
EGO_ITEM_PUB.Process_Items Use this API to create or update multiple items at once.
EGO_ITEM_PUB.Process_User_Attrs_For_Item Use this API to perform DML operations (insert, update, or delete) on one or more rows of user-defined attributes data for one item.
ENG_ECO_PUB.Process_Eco This procedure allows user to create, update Issues, Change Requests (CRs), and Change Orders (COs) in Product Lifecycle Management (PLM) Product
INV_ITEM_CATALOG_ELEM_PUB.Process_Item_Descr_Elements

[This blog post is contributed by Hub regular Visitor who worked almost 8 years in MDM and PDM area. You can reach them to author via email]

Posted in MDM | No Comments »

Oracle Product Information Management (PIM) Data Hub

Posted on April 3rd, 2011 by Hub Contributor |Print This Post Print This Post |Email This Post Email This Post

Oracle Product Information Management (PIM) Data Hub is an enterprise data management solution that enables customers to centralize all product information from heterogeneous systems,creating a single view of product information that can be leveraged across all functional departments.

Oracle Product Data Hub (PDH) module formerly known as Advanced Product Catalog has now become part of Oracle’s master data management suite of products.

Oracle Product Information Mgmt Solution consist of three major products as:

  • Oracle PIM Data Hub
  • Oracle PIM Data Librarian
  • Oracle Product Data Synchronization for GDSN and UCCnet Services (PDS)

Oracle PIM Data Librarian is a web-based application that extends the functionality of the Oracle Inventory,Bill of Materials, Engineering, and Project Management modules.

Oracle PIM contains its own set of tables under the EGO (Engineering Online) schema, but still uses the standard Oracle Inventory, Bill of Materials, and Engineering tables.

  • The item master in PIM is the same item master used by Oracle Inventory.
  • User-defined product attributes and change management data are stored in the EGO
    tables.

Licensing requirement for Oracle PIM Data Hub gives customers the right to use PIM Data Librarian (which is licensed separately) on an instance other than the instance where the company has deployed the Oracle E-Business Suite. Licensing Oracle PIM Data Hub Add – On gives customers the right to use PIM Data Librarian (which is licensed separately) on the same instance where the company has deployed the Oracle E-Business Suite.

dgreybarrowPIM Data Hub Benefits

With Oracle® Product Information Management Data Hub customers can

  • Consolidate all product information
  • Cleanse: Includes a data import workbench to manage source system mappings and data loads
  • Excel based Imports and Exports: Spreadsheet import for easy upload and maintenance
  • Bulk Imports: Optimized bulk import through staging tables
  • Service Oriented Architecture: Integrate using prebuilt, standards compliant business services and adapters
  • Import data and synchronize multiple systems.
  • Workflow based Collaboration: Highly configurable change management workflows with approval routing
  • Securely access and search your information repository
  • From Governance and Compliance prospective they can automate with the help of workflow based processes that can perform rule based validation and data correction

dgreybarrowWho needs PIM Data Hub?

  • Those who need a 360 Degree secured view of the part attributes and transaction data
  • Those whose item master have extensive item attributes
  • Those who want synchronize product data from and to multiple systems
  • Product information is scattered across desktops, legacy systems and custom applications. Need product data consolidation and cleansing.
  • Need to manage New Part Introduction, Issues and Change Control processes efficiently via configurable robust workflow-driven processes
  • Manage Data Governance and Compliance: Government and industry regulations such as RoHS, WEEE), and FDA Compliance (21 CFR Part 11)

[This blog post is contributed by Hub regular Visitor who worked almost 8 years in MDM and PDM area. You can reach them to author via email]

Posted in MDM | No Comments »

Master Data Management – A Basic Definition

Posted on July 30th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

  • Master Data - This is defined as the critical business information supporting the transactional and analytical operations of the enterprise.
  • Master Data Management – Master Data Management (MDM) is a combination of applications, technologies and processes that
    consolidates, cleans, and augments this corporate master data,and synchronizes it with all applications, business processes, and analytical tools.
  • Customer Data Integration (CDI) is a subset of MDM, specific to automating the management and reconciliation of Customer Data.
  • Product Information Management (PIM) is a subset of MDM, specific to automating the management and reconciliation of Product Data

Posted in MDM | No Comments »

TCA and Web Services

Posted on March 29th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

New CDH Web Services are based on the existing Business Object APIs of TCA;

  • Spoke applications can leverage CDH Web Services to integrate with the Customer Data Hub
  • New DQM Search Web Service to access matching in the Hub from any transactional application
  • CDH Web Services leverage the Web Service standards such as WSDL (Web Services Description Language) and UDDI (Universal Description,
    Discovery and Integration)

Here are the list of some of CDH Web Services, that you can utilize it.

 

Name Description
DQM Search Service DQM search service to search for parties
Organization Business Object Services Manages the Organization business object
Organization Customer Business Object Services Manages the Organization Customer business object
Organization Contact Business Object Services Manages the Organization Contact business object
Person Business Object Services Manages the Person business object
Person Customer Business Object Services Manages the Person Customer business object
Party Site Business Object Services Manages the Party Site business object
Location Business Object Services Manages the Location business object
Phone Business Object Services Manages the Phone business object
Email Business Object Services Manages the Email business object
Web Business Object Services Manages the Web business ob
Relationship Business Object Services Manages the Relationship business object

Posted in MDM, Oracle TCA | No Comments »

Customer Hub: Its all about knowing the Customer -> Siebel UCM

Posted on March 28th, 2009 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

dgreybarrow UCM : What is it?

A Siebel application which is the central master database/application for storing any and all unified profile for enterprise customers, partners, and prospects information.

In a large company, you have hundreds of various proprietary and legacy applications which deal with different parts of the customer information , some deal with service data, some with sales data, some others purely with demographics and contact data. UCM has the capability to synchronize and bring together all this data to give a single unified view of the customer as a whole.

From a Siebel application point of view, it’s just another application like Siebel Sales or Siebel Call Center application, built up on the same Data, Business and UI model

  • Enables a single view of the customer
  • Creates and maintains unique, complete and accurate customer information across the enterprise
  • Distributes customer information to all operational applications just in time
  • Enables organisations to:
  • Know your customers
    • Improve data quality
    • Utilize customer insight during all customer interactions
    • Comply with privacy and regulatory requirements
    • Define events and policies
    • Reduce data management costs
    • Provides Telco-specific data attributes

dgreybarrow UCM : Functionality

  • Receives the transactions from external systems and applies them to it’s base tables and publishes the updates back to all the systems.
  • Publish frequency - real-time, batch or event-based (e.g.:on-update of Contact )
  • Siebel UCM Data Quality - in built component for data de-duplication
  • Survivorship Rules - based on the defined confidence level for each system
  • Easy setup for Auto/Manual merge
  • Features to Un-Merge already merged records later on if desired.

dgreybarrow Deployment Model

There are two deployment models for Siebel Master Data Applications:

  • Combined : In this type of a deployment, Siebel MDM application shares the same database and Enterprise Server as any other Siebel eBusiness Application.

This deployment is used mainly for smaller company .

  • Stand Alone : This is the recommended, and mostly used deployment model in which the Siebel Master is deployed on a separate box having it’s own database, separated from other Siebel eBusiness Application.

This is the preferred approach in big companies where the volume of transactions is large as well as the integrating systems are many.

Posted in MDM | No Comments »

Page 1 of 11