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

What happens if I don’t create a clearing account?

Posted on February 16th, 2013 by Sanjit Anand ||Email This Post Email This Post

If you do not use an AutoInvoice clearing account and enable the Create clearing option on the transaction source, AutoInvoice requires that the revenue amount be equal to the selling price times the quantity for all of the transactions it processes.

AutoInvoice rejects any transaction line that does not meet this requirement.

dgreybarrowAutoInvoice Clearing Account

During AutoInvoice processing, Receivables uses the AutoInvoice clearing account to store any differences between the specified revenue amount and the (price * quantity) for imported invoice lines.

Receivables only uses the AutoInvoice clearing account if you enabled the Create clearing option on the transaction source assigned to imported transactions. However, you must define a clearing account in any case.

You can use constant value, customer bill-to site, salesperson, transaction type, and standard item for your AutoInvoice clearing account. If you select salesperson or standard item, Receivables uses the specified Revenue Flexfield.

dgreybarrowThe Calculation

The AutoInvoice Clearing Account is used when the supplied Amount does not match Unit Selling Price times the Quantity.

The calculation is the following:

  • AutoInvoice Clearing Account = (quantity * unit_selling_price) – amount
  • Tax(rate based tax) = (quantity * unit_selling_price) * tax_rate
  • Revenue = amount

Account Receivables = Sum of all
1. Revenue Lines
2. Tax lines
3. AutoInvoice Clearing Account

Posted in Oracle Receivable | No Comments »

What is Oracle Endeca Information Discovery?

Posted on February 6th, 2013 by Sanjit Anand ||Email This Post Email This Post

Oracle with Endeca plans to create a comprehensive technology platform to process, store, manage, search and analyze structured and unstructured information together enabling businesses to make stronger and more profitable decisions.

Therefore, Oracle Endeca Information Discovery (Formerly Endeca Latitude) is an enterprise data discovery platform for rapid, intuitive exploration and analysis of data from any combination of structured and unstructured sources.

Oracle Endeca Information Discovery enables organizations to extend their existing business analytics investments to unstructured sources – including social media, websites, content systems, email, and
database text – providing unprecedented visibility into data and business processes, saving time and cost, and leading to better business decisions.

1 With Oracle Endeca Information Discovery, users can:

  • Easily combine structured and unstructured data and metadata to understand key metrics in their relevant context and evaluate new business situations.
  • Ask unanticipated questions of any data through intuitive, flexible, and highly interactive online discovery applications.
  • Mash up and recombine data and visualizations to compose discovery applications.
  • Leverage all of the rich metadata of existing Business Intelligence data models and semantic layers as a basis upon which to build discovery applications.
  • Unburden IT from the constant chasing of new requirements and non-traditional data sources for incorporation into the data warehouse, enabling them to deliver fast access to relevant data and selfservice to business users while maintaining security, governance, and quality.

1The Architecture for Oracle Endeca Information Discovery

Let’s start by briefly reviewing the Endeca Information Discovery architecture. The architecture consists of 3 main components:

  • Oracle Endeca Server. This hybrid, search/analytical database provides unprecedented flexibility in combining diverse and changing data as well as extreme performance in analyzing that data. Oracle Endeca Server has the performance characteristics of in-memory architecture however is not memory bound. Oracle Endeca Server is also used extensively as an interactive search engine on many major e-commerce and media websites.
  • Studio is a Discovery application composition environment for the Oracle Endeca Server. Studio provides drag and drop authoring to create highly interactive, visually-rich, enterprise- class information discovery applications.
  • Integration Suite. Oracle Endeca Information Discovery includes a set of tools used for loading and optionally enriching diverse information—including structured and unstructured content—into Oracle Endeca Server.

This can be best understood as fig 1 below:

Endeca Information Discovery architecture


Apart from this there are Extensible Value-Added Modules are

  • Oracle Endeca Content Management System Connectors- This add-on module allows for integration of content stored in various enterprise content management systems.This is currently supported systems include: EMC Documentum, EMC Documentum eRoom, FileNet P8, FileNet Document & Image Services, Interwoven TeamSite, Lotus Notes/Domino, Microsoft SharePoint, and OpenText LiveLink.
  • Oracle Endeca Text Enrichment. This add-on module includes text analysis capabilities for extraction of people, places, organizations, quotes, and themes as well as core summarization capabilities for automatic creation of abstracts or topical summaries.
  • Oracle Endeca Text Enrichment with Sentiment Analysis. This add-on module includes all of the Text Enrichment capabilities as well as advanced text analysis for extraction of aggregate sentiment related to each extracted concept. Sentiment is extracted with a score indicating the positive and negative nature of a document or an entity in the document. These scores can be used within the faceted search experience by varying ranges of
    positivity and negativity.

1 What type of analysis is Oracle Endeca Information Discovery designed for?

Oracle Endeca Information Discovery is in supporting a users’ need to better understand the data. In expanding analysis inputs beyond structured content to unstructured sources, users can better understand the color and qualitative insights which support quantitative results.

Oracle Endeca Information Discovery enables this type of analysis through Oracle Endeca Server, a hybrid search/analytical database that is specifically optimized for discovery, not reporting or online transaction processing.

Highly scalable, column-oriented, and in-memory – without being memory bound – Oracle Endeca Server supports navigation, search, and analysis of any kind of information including structured, semi-structured, and unstructured content.

This also provide a broad suite of packaged analytic applications to extend corporate business processes to include unstructured data

  • Integrate unstructured data into ERP, Supply Chain, Human Capital, CRM and EPM applications
  • Integrate unstructured data into specialized edge applications – PLM, MDM, Web Commerce, Analytic applications
  • Extend industry specific business processes and vertical applications to include unstructured data

1 Search capabilities of Oracle Endeca Information Discovery provide

Oracle Endeca Information Discovery provides two different, and complementary, types of search:

  1. Value – or dimension – search provides type-ahead autocompletion that enables users to find attribute values and help disambiguate queries by identifying which attributes contain the search terms.
  2. Record search provides advanced full text search across any single or combination of fields, leveraging a variety of configurable term matching and relevancy ranking algorithms to retrieve results for display and analysis.

1 Know the facts and dependecy with other Prducts

  1. Oracle Endeca Information Discovery part of Not of Oracle BI Foundation Suite, this is a separate licensed product.
  2. If you don’t run Oracle BI. You can still benefit from Oracle Endeca Information Discovery, beacuse the diversity of supported data sources is a strength of this product.
  3. Oracle Endeca Server exposes web services for querying existing BI tools.
  4. Oracle Endeca Information Discovery enhances existing business intelligence applications by extending analysis to unstructured sources and supporting exploratory data analysis.
  5. Oracle Endeca Information Discovery is certified on Exalytics.
  6. Oracle Endeca Information Discovery’s primary benefit with respect to Big Data (Read the previous post on Big data) is in solving the problem of Big Variety – relevant data sources for business analysis have never been more diverse, and an increasing share of this information is unstructured.
  7. Oracle Endeca Information Discovery and Hadoop are highly complementary technologies

1 Resources for Oracle Endeca Information Discovery (OEID)

Posted in Centrestage, Emerging Technologies | No Comments »

Oracle Credit Management with/Without Order Management

Posted on February 4th, 2013 by Sanjit Anand ||Email This Post Email This Post

What needs to be done if you are implementing Credit Managment but we have Order Management on a legacy system? If a Sales order is on credit hold at legacy, how will that information come to the Credit analyst to do a credit Analysis before deciding to release the credit hold.

You will need to use the Credit Management API to create a credit application from your OM system.
You will need to call this API from your legacy custom code when ever the order goes on hold due to credit limits to create the Credit Application.

The Credit Management public APIs includes five APIs:

  • Create Credit Request API :The ar_cmgt_credit_request_api.create_credit_request routine is used to create a credit request for initiating a credit review for a party, account, or account site.
  • Update Credit Request API :The ocm_credit_request_update_pub routine is used to update an existing credit request for a party, account, or account site.
  • Withdraw Credit Request API :The ocm_credit_req_withdraw_pub routine is used to withdraw an existing credit request for a party, account, or account site.
  • Guarantor API :The ocm_guarantor_pub routine is used to automatically submit a credit application for a guarantor that is included on a credit application or in a case folder.
  • Get External Decision API :The ocm_get_extrl_decsn_pub routine is used to bypass Credit Management’s scoring functionality and extract case folder contents for scoring by an external scoring engine.

Setting up Credit Management for OM

If you are using Oracle OM , these are mandatory setup

  • Credit check checkbox should be checked in payment terms
  • Setup order credit limit in customer standard page for the currency for which credit application needs to be created.
  • Checklist for review type order hold needs to be created along with credit classification of the customer.
  • Make sure credit check rule is selected on Order Transaction type.

Posted in Oracle Credit Management | No Comments »

How To Set Up Oracle Credit Management

Posted on February 3rd, 2013 by Sanjit Anand ||Email This Post Email This Post

Here is a summary of steps to set up Oracle Credit Management

  1. Maintaining Customer Data :Oracle Credit Management employs the Data Quality Management (DQM) match rules to identify how search results should be displayed in the application’s search screens
    • DQM Match Rule
    • Run DQM Staging
  2. Defining Credit Analysts :Credit analysts assist in the resolution of credit-related issues and evaluate the creditworthiness of your customers and prospects. Credit analysts can view credit applications and case folders in Oracle Credit Management, and can submit recommendations after concluding a credit analysis.
    • Import/assign Credit Analysts – First define your credit analysts as employees in Oracle Human Resources Management System (HRMS).Next, import employees from HRMS into Resource Manager and assign roles.Two seeded roles exist for Credit Management:
      • Credit Analyst :You can assign the credit manager role to a credit analyst
      • Credit Manager : This is setup functionality
  3. Credit Mgmt System Options : You can define these Oracle Credit Management system options.
    • Aging Bucket :Specify which aging buckets to use when presenting aging data in Credit Management. Credit Management presents aging data as data points in several pages, such as from the Aging Details and Credit Summary pages.
      • Take a note, Credit Management calculates its own aging data after pulling certain pieces of information from Oracle Receivables tables.
      • Take a note , Credit Management and Oracle Receivables aging data can be different beacuse of due dates and collection dates.In Receivables, the primary concern is around collection
    • Default Customer Credit Classification :Credit classification assignments can either be assigned by a previously completed credit review, or assigned on the customer profile. Default Value is High Risk
    • Period for Time Sensitive Data :Select the period for which credit data will be collected into the summary tables and used in scoring during a credit analysis. Reviewing summarized order, invoice, and payment data over a period of time can provide you with an overall picture of a customer’s past credit relationship with you, and can help to predict future performance. Default Value is 12
    • Application Numbering Option :Indicate if you want Credit Management to automatically assign a number to each credit application.Default Value is YES
    • Exchange Rate Type :Pick either default exchange rate type that Credit Management will use to convert foreign currency data points to your credit currency during a credit analysis. You can select Corporate, Spot, or User.Default Value is Corporate
    • DSO Days : You have to indicate the time period that Credit Management uses to calculate Days Sales Outstanding (DSO) and Delinquent Days Sales Outstanding (DDSO).The default is 90 days.
  4. Define Hierarchical Relationship :To provide global credit limits that are shared by some or all entities within a complex, multinational organization, you can define credit relationships between parties using Oracle Trading Community Architecture Relationship Manager.
  5. Credit Mgmt Profile Options
  6. Populate Summary Tables
  7. Setup Credit Usage Rules
    • Credit usage rule sets are used as follows:
      • In Oracle Order Management, credit usage rule sets define the set of currencies that will share a predefined credit limit during the credit checking process, and enable the grouping currencies for global credit checking.
      • In Oracle Credit Management, credit usage rule sets ensure that all transactions for the specified currencies are converted to the credit currency and included in data point calculations in the case folder.
    • In Oracle Credit Management, credit usage rules are required. Even if you perform credit reviews in only one currency, or conduct your business in only one currency, you must still set up one credit usage rule.
  8. Remove existing credit limits from Profile Classes and propagate changes to all customers (Optional) : This setup is used to pull and tag dafault setting of customer master.
  9. Assign Credit Info to Profile Classes (Default Credit Analyst, Default Classification)
    • Updating Customer Profile Classes : in AR Customer Profile Classes window, use the Collectors region on the Profile Class tab to assign credit information to your customer profile classes:
    • Classification :use the Assign Customer Credit Classification program.
    • Periodic review cycle :Update Periodic Credit Review Program.
    • Analyst : you can assign credit analysts to indicate who is responsible for monitoring the creditworthiness of the account and for assisting in the resolution of credit-related issues.
      • Take a note, Oracle Credit Management looks for an assigned credit analyst at the customer profile, only after other locations fail to provide an assignment.
  10. Assign Credit Usage Rule
  11. Credit Management Application Workflow :The Credit Management Application workflow manages the process flow of gathering and analyzing account or prospect credit data, and making and implementing credit decisions.
    • Enable Workflow Agent Listener (If not enabled)
    • Schedule WF Agent Listener (WF_DEFERRED)
    • Schedule WF Background for Credit Management
  12. Create hierarchical Party Relationship (Optional) : This is required if you have requirement to keep the customer setup as-is, a hierarchical relationship was created between parent party and its customers.
  13. Define Scoring Model
    • A scoring model is one of the primary credit review tools that Oracle Credit Management uses to assess the creditworthiness of your customers
    • Scoring models include the data points and scoring method that are appropriate for a particular credit review. When defining scoring models, for each data point, (1) indicate a score for each range of values and (2) optionally assign a relative weighting factor.
    • During a credit analysis, Credit Management uses the scores that you assigned to each data point range of values to calculate a score. The lower the credit score, the greater the credit risk.
  14. Define Checklist
    • In Oracle Credit Management, you document your enterprise’s credit policies via user-defined credit checklists. Using various checklists, you manage the credit analysis process by defining the required and optional data points that are included in the credit review.
    • Defining a checklist is a multi-step process, during which you can select checklist criteria in the form of data points from a multitude of sources. Credit Management uses these checklists in two places:
      • Credit application – The checklist determines which fields are required on the application.
      • Credit analysis – The checklist identifies what data should be automatically collected and displayed in the case folder.
    • When defining a checklist, you select a credit review type and credit classification combination. During a credit review, Credit Management uses the intersection of the credit review type and the applicant’s credit classification to select the appropriate checklist to use for the credit analysis. The higher the customer credit classification risk, the more stringent the credit policy (scoring model).
    • Additionally, your enterprise defines these credit classifications:
      • High Risk
      • Moderate Risk
      • Low Risk
  15. Assign Credit Analyst
  16. Define Automation Rule :For any scoring model, you can define a set of automation rules to guide the implementation of credit recommendations without user intervention. Automation rules let a credit review proceed uninterrupted through the workflow, during which a credit recommendation is automatically implemented based on the score that the scoring model calculates.
  17. Define AME Rule :For credit recommendations that require approval, Credit Management works with Oracle Approvals Management (AME) to manage the list of required approvers.

Posted in Oracle Credit Management | No Comments »