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

Happy New Year 2011

Posted on December 31st, 2010 by Sanjit Anand ||Email This Post Email This Post

Happy New Year, everyone! Wishing you all a promising year ahead. :)

If you already read my blog, do stop by and encourage me with your comments, likes, and goodwill along the way. Thank you all for your support. 2011 is going to be a fantastic and abundant year!


Posted in Misc | 3 Comments »

Oracle Supplier Hub Insights

Posted on December 29th, 2010 by Sanjit Anand ||Email This Post Email This Post

Oracle Supplier Data Hub is part of a full suite of Master Data Management (MDM) tools unifies and shares critical information about an organization’s supply base. It does this by enabling customers to centralize all supplier information from heterogeneous systems and thus creates a single view of supplier information that can be leveraged across all functional departments.

dgreybarrow Oracle Supplier Hub feature :

Oracle Supplier Hub can be broadly categorize into five major coverage area as per fig 1.

Oracle Supplier Hub

  1. Consolidate – Data Import Management, Source System , Cross Reference
  2. Cleanse – Matching, D & B Data Enrichment
    • Various Functionality Coverage are
      • Supplier Registration DQM and D&B
      • Supplier attribute classification
      • Merge, validate duplicates. Similar supplier names are checked.
    • Integrated with D&B out of box. Import data in real-time or batch mode
  3. Master – Supplier Classification & Relationship
  4. Share – Publication and Synchronization, Web Services, Security. This is also called as called OSN Integration.
  5. Govern -Classification Management, Hierarchy Management and Task Management

Typically data administrator functionalities are available from Supplier Data Librarian Super User application responsibility where the data librarian functionalities are available from Supplier Data Librarian application responsibility.

Take a note profile option POS:SM: Supplier Data Hub Configuration with a value Standalone at site level if you are deploying Supplier Hub as a centralized standalone MDM solution OR configure the profile option with a value Integrated EBS if you are deploying Supplier Hub as an Add-on for E-Business Suite to an existing EBS R12.1 application Installation after you purchase the application licenses.

dgreybarrow From R12.1.2 to R12.1.3

Oracle Supplier Hub was first added in EBS in R12.1.2. With recent version 12.1.3, there is slight enhancements as below:

  • Tasks and Notes , Contact points and Party Relationship
  • Bulk Import & Spreadsheet Import
  • Smart Search , Enable party as supplier , Supplier Creation De-duplication
  • Supplier Data Publications and supplier Profile Report

dgreybarrow Supplier Hub and TCA

Oracle Supplier Hub is built on top of Oracle Trading Community Architecture (TCA) of Oracle E-Business suite and leverage TCA implementations features like Data Quality, Batch Management, Source System Management, Adapters, Classifications, Relationships/Hierarchies, Tasks/Notes (available via Customer Data Hub (CDH)).

If you refer back to TCA and CDH documentations for the various profile options and implementations that are applicable at the party level for the functionalities exposed from Supplier Hub navigations.

You can take advantage of TCA DQM APIs to identify the potential duplicate Supplier parties in Supplier Master.

Customers can implement and use Supplier Lifecycle Management (SLM) to streamline the supplier relationship management processes through the trading lifecycle.

dgreybarrow License Requirement

Supplier HUB Data requires a separate license. Those who already using isupplier can requires a separate license

It is a new module introduced in Oracle Applications release 12.1.2, and it allows integration with other systems besides Oracle Applications.

Option 1: Oracle Supplier Life cycle Management can be deployed on an existing E-Business suite R12.1 application instance.
Oracle Supplier Hub Add-on for E-Business Suite which has the same features that of Oracle Supplier Hub can be deployed on an existing E-Business suite R12.1 application instance.

Option 2: Customers who want to deploy a standalone Supplier master data management system can implement Oracle Supplier Hub using Oracle E-Business suite R12.1 platform. They can implement Oracle Supplier Life cycle Management along with Oracle Supplier Hub or as a standalone E-Business Suite application like any other E-Business Suite application in a new instance.

Posted in Oracle Purchasing, R12 | No Comments »

Supplier Management Overview & EBS

Posted on December 27th, 2010 by Sanjit Anand ||Email This Post Email This Post

If your company or Customer have a multi-supplier environment, then managing Supplier is always be a challenge. In that case if you are using EBS R12.1.2 or higher version then you use solution from Oracle that helps you to manage and track supplier data a bit more easier way. The Oracle Supplier Hub and Oracle Supplier Lifecycle Management applications are designed to keep a record of all your suppliers and also model (TCA way) and track suppliers through processes that are built-in.

Oracle Supplier Hub(SDH) application helps maintain supplier information. Supplier data from various sources can be Extracted ,cleaned up and loaded in this application ( and Published too). The data can also be merged with data from third party sources such as D & B. Each supplier’s quantity metrics like quality, on-time delivery, and qualitative metrics in terms of supplier performance, quality and reliability can all be stored here. Oracle Supplier Hub is a stand-alone data management application and have the great capability to integrate with legacy applications.

Other Oracle Supplier Lifecycle Management(SLM) application supports on boarding, performance evaluation(Qualification and On-boarding ), and governance of suppliers based on risk” by mean of web-based application allows supplier registration. Ongoing performance is documented through template questionnaires and a centralized record of suppliers by risk, compliance and adherence to local laws, regulations, etc. are all stored in this application.

Putting together, these two applications really have great potential to make supply chain management section easier.

dgreybarrow Reference:

Posted in Oracle Purchasing | No Comments »

Understanding Amazon Web Services (AWS)

Posted on December 26th, 2010 by Sanjit Anand ||Email This Post Email This Post

Running Oracle Apps on Amazon EC2 is going to be easy in near future as full Oracle Software Stack Certified and Supported on Oracle VM on Amazon EC2.

Question you might have is what is EC2 or Amazon EC2 , let try to understand ?

dgreybarrow What is Amazon Web Services?

AWS provides flexible, scalable, secure, and cost-effective IT infrastructure for businesses of all sizes around the world.

Read the rest of this entry »

Posted in Emerging Technologies | No Comments »

Oracle Applications Now Available In Amazon’s EC2 Cloud

Posted on December 20th, 2010 by Sanjit Anand ||Email This Post Email This Post

Now you can run Oracle Apps on Amazon EC2. That’s cool, Hoping this will be useful to the SMB segment Oracle Customer ..

EC2 requires applications be submitted as Amazon Machine Image workloads. A wide variety of EBS have been certified for use on Amazon EC2 with virtualization provided by the Oracle VM.So far the following products are now fully supported :

  • Oracle E-Business Suite
    • Oracle E-Business Suite 12.1.3 App Tier
    • Oracle-E-Business-Suite-12.1.3-DB
  • Oracle PeopleSoft – Enterprise Applications
  • Oracle Siebel -CRM Applications
  • Oracle Database
  • Oracle Fusion Middleware

dgreybarrow Going Forward

  • All Oracle products certified on OVM, including E-Business Suite are now fully certified and supported on Amazon EC2 using OVM with full license portability
  • Organizations deploying E-Business Suite on Amazon Web Services are able to reduce deployment times from days or weeks to minutes
  • By deploying Oracle E-Business Suite on the Amazon Cloud, Oracle customers are able to fully leverage the scalability, reliability, security.
  • Customer can take advantage for utility-based pricing model of Amazon Web Services for production workloads.

Read the Original Article Oracle Applications Now Available In Amazon’s EC2 Cloud

Posted in Emerging Technologies | No Comments »

Retirement of Oracle AIM & AIM for Business Flows

Posted on December 19th, 2010 by Sanjit Anand ||Email This Post Email This Post

Last week there was an email from Oracle for retirement for legacy Methods like AIM Advantage, AIM for Business Flows, EMM Advantage. These methods and Methodology been used by mostly Oracle Consulting,and there partners. The retirement date is January 31, 2011. Going Forward , OUM is going to be replaced by these methods, and not to forgot OUM version 5.3 was released a month back (November 13,2010).

OUM aka ORACLE UNIFIED METHOD is currently available to certified Oracle Partners(Platinum and Gold) and it is not freely downloadable publically. OUM supports the complete range of Oracle technology projects including:

  • Oracle Database
  • Oracle E-Business Suite
  • Oracle Enterprise 2.0
  • Oracle Fusion Middleware
  • Oracle Service-Oriented Architecture (SOA)
  • Oracle Business Intelligence – Applications
  • Oracle Business Intelligence – Technology
  • Oracle Data Warehousing
  • Governance, Risk, & Compliance (GRC)
  • Identity Management (IdM)
  • Oracle Transportation Management
  • Performance Management – Business Intelligence and Analytics
  • JD Edwards EnterpriseOne
  • PeopleSoft Enterprise
  • Siebel

Will keep you posted with some more updated on OUM time to time.

To be continued ….

dgreybarrow Reference

Posted in Methodology/Process | 1 Comment »

Payable open interface and WithHolding Tax

Posted on December 18th, 2010 by Sanjit Anand ||Email This Post Email This Post

When you are attempting to run Payables Open Interface Import and populated AWT related information, you might get the following error occurs.
“Line type cannot be AWT”

If you get this , donot get panic, this is intended functionality i.e Open Interface Import will not import invoices with an invoice type (INVOICE_TYPE_LOOKUP_CODE) of AWT (automatic withholding tax).

you can refer AP user guide(Part No. B25454-01) pg no 3-152

However you can have the Import process to calculate the withholding tax for the ITEM lines you are importing.

If you want to import invoices that include withholding information, you have these options:

  1. You can enter an INVOICE with the AWT_GROUP_ID or AWT_GROUP_NAME populated in AP_INVOICES_INTERFACE table, The withholding tax group you identify in this table (AWT_GROUP_ID or AWT_GROUP_NAME) is used to assign a withholding tax group to a line only if you do not identify one for the invoice in one of the following columns: AP_INVOICE_LINES_INTERFACE.AWT_GROUP_ID or
  2. Or you can just populate directly the AP_INVOICE_LINES_INTERFACE.AWT_GROUP_ID or AP_INVOICE_LINES_INTERFACE.AWT_GROUP_NAME for the ITEM line that you are importing.
  3. Or, if you setup the supplier site with Withholding information, then the Import process will inherit that information and create the invoices with the corresponding withholding lines.

You can refer back to old post for technical details. you can check some of old post on the subject.

PS: to make your legacy & AP tax calculation in sync please have AP & legacy tax structure same & for concern wrt decimal point you can set required Precision in Tax Financial option.

Posted in Oracle Payable | No Comments »

Financials Accounting Hub

Posted on December 14th, 2010 by Sanjit Anand ||Email This Post Email This Post

Financials Accounting Hub (FAH) provides an orderly, streamlined process to manage Financial Data of Source Systems.

It houses the transformations from business event to accounting generation and then transfers balanced entries to GL.

FAH allows you to create detailed, auditable, reconcilable accounting from a variety of source systems.

It includes an accounting transformation engine with validations plus accounting and rules repositories. The transformation engine consistently enforces accounting policies. The repositories provide centralized control, detailed audit trails, and simultaneously accommodates diverse corporate, management and reporting requirements.

FAH – What’s not for

  • Data Extraction
  • Event Creation
  • Calculation Engine for Source System calculations
  • Inbuilt Intelligence for IFRS Accounting or any GAAP Accounting

Is FAH a fit for you?

FAH may be right for you if:

  • Oracle EBS and/or PeopleSoft are not a good fit to replace your proprietary operational (ordering, billing, inventory, purchasing) systems;
  • Detailed financial reporting is required on legacy system attributes not typically a part of the Chart of Accounts;
  • Accounting requirements for legacy systems are complex and subject to change; and/or
  • You are in the financial services (insurance, banking, brokerage), telecommunications, or distribution industry.

Check out the Oracle data sheet for more information.

Posted in Oracle General Ledger | No Comments »

Accounting entries for the Asset Life Cycle

Posted on December 12th, 2010 by Sanjit Anand ||Email This Post Email This Post

Finally am able to put the detailed accounting entries for the Asset Cycle. As highlighted in one of the post Oracle Assets creates journal entries for the following general ledger accounts:

  1. Asset Cost
  2. Asset Clearing
  3. Depreciation Expense
  4. Accumulated Depreciation
  5. Revaluation Reserve
  6. Revaluation Amortization
  7. CIP Cost
  8. CIP Clearing
  9. Proceeds of Sale Gain, Loss, and Clearing
  10. Cost of Removal Gain, Loss, and Clearing
  11. Net Book Value Retired Gain and Loss
  12. Intercompany Payables
  13. Intercompany Receivables
  14. Deferred Accumulated Depreciation
  15. Deferred Depreciation Expense
  16. Depreciation Adjustment

Read the rest of this entry »

Posted in Oracle Asset | 1 Comment »

Oracle Enterprise Content Management – A Brief Overview

Posted on December 12th, 2010 by Sanjit Anand ||Email This Post Email This Post

dgreybarrow What is Enterprise Content Management

Enterprise Content Management (ECM) is the strategies, methods and tools used to capture, manage, store, preserve, and deliver content and documents related to organizational processes.

ECM tools and strategies allow the management of an organization’s unstructured information, wherever that information exists.

ECM has employed the technologies and strategies of digital content management to address business process issues, such as records and auditing, knowledge sharing, personalization and standardization of content, and so on.

dgreybarrow Why Enterprise Content Management is Needed

  • ECM manages the entire life cycle of unstructured data (e.g. Invoices, email, documents, spreadsheets, multimedia etc.)
  • ECM solutions help corporations organize, control and access this vital business content
  • ECM Market is driven by customers’ needs for regulatory compliance
  • ECM helps deliver fast ROI by streamlining business processes

dgreybarrow Who needs most

  • Pharmaceutical companies for controlling and managing documents to bring new drugs to market quickly and in a compliant manner.
  • Government agencies streamlining largely paper-driven processes, improve the services offered to citizens, ensure compliancy and optimise efficiency.
  • Media and broadcast companies want to manage large image and audio content libraries as part of an overall information management strategy.
  • Insurance companies require rapid access to all relevant information in order to respond to customers quickly, reduce risk and ensure compliance.
  • Retail companies want to understand their customers’ preferences in order to reduce churn, engender loyalty, and increase the value of the relationship.
  • Telecoms companies want to minimise customer churn and comply fully with regulations and legislation.
  • Utilities and energy companies want to maintain accurate customer records, reduce risk and ensure compliance.
  • Retail banks want to reduce risk, retain and grow their customer base and comply.
  • Financial services firms want to service customers efficiently, reduce their exposure to risk, ensure compliance and reduce churn.

dgreybarrow Oracle Enterprise Content Management

Oracle Enterprise Content Management provides a unified application for delivering document management, web content management, digital asset management, and retention management.

The suite of products offers a flexible, robust and scalable content management solution that allows employees, customers and partners to collaborate contribute and access business content anywhere worldwide.

If you look the life cycle of content , this address entire life cycle as fig below .

Oracle Enterprise Content Management

Oracle helps companies fully maximize the value of their information and intellectual assets by bringing content, such as spreadsheets, contracts, marketing materials, CAD drawings, digital assets, records and catalogs, to the Web where it can be efficiently managed.

Some of the Key components are :

  • Document, Records and Retention Management – manage content centrally from creation to archiving and disposition to improve operational efficiencies, control access to critical business information, increase productivity by streamlining document intensive processes and provide a platform to standardize information management practices, achieve compliance and mitigate risks.
  • Web Content Management (WCM) – enables organizations to deploy and manage business-critical web sites as well as to deploy content to enterprise portals and other applications.
  • Digital Asset Management (DAM) – enables management of digital assets allowing users to store, find, and access multimedia assets and automate the creation or print-quality, web-friendly and thumbnail renditions.
  • Content / Image Enabled Enterprise Applications – enables streamlining of business processes and improvement in cost-efficiency, consistency and auditability by integrating content into enterprise applications.
  • Imaging and Process Management – enables end-to-end management of document images within transactional business processes providing content and business process management capabilities from document capture and recognition, to imaging and workflow integrated to Oracle’s business applications.
  • Social Collaboration / Enterprise 2.0 and ECM – enables organizations means to promote collaboration, productivity, knowledge sharing, enriched user experience and centralised access using a system of web-based technologies.

Posted in Emerging Technologies | No Comments »

« Previous Entries