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

Release 12.2.5 AR Enhacement : Apply Receipts Automatically based on Match Score and Knapsack Method

Posted on July 23rd, 2016 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

This is one of R12.2.5 Enhancement in EBS AR.

The Automatic Cash Application improves accuracy and on-time application of cash receipts with the introduction of two new methods for automatically applying cash receipts.

  • The first method generates match scores using the Levenshtein distance algorithm and automatically applies the receipt based on a score threshold.
  • The second methods applies receipts by knap sacking the receipt amount and the open transactions of the customer.

Both methods provide suggested matches when a receipt cannot be applied automatically

Background information on the Levenshtein distance algorithm [ From Wikipedia, the free encyclopedia ]

In information theory and computer science, the Levenshtein distance is a metric for measuring the amount of difference between two sequences (i.e., the so called edit distance).

The Levenshtein distance between two strings is given by the minimum number of operations needed to transform one string into the other, where an operation is an insertion, deletion, or substitution of a single character. A generalization of the Levenshtein distance (Damerau–Levenshtein distance) allows the transposition of two characters as an operation. Some Translation Environment Tools, such as translation memory leveraging applications, use the Levenhstein algorithm to measure the edit distance between two fuzzy matching content segments.

The metric is named after Vladimir Levenshtein, who considered this distance in 1965.It is often used in applications that need to determine how similar, or different, two strings are, such as spell checkers.
For example, the Levenshtein distance between "kitten" and "sitting" is 3, since the following three edits change one into the other, and there is no way to do it with fewer than three edits:

  1. kitten -> sitten (substitution of 's' for 'k')
  2. sitten -> sittin (substitution of 'i' for 'e')
  3. sittin -> sitting (insert 'g' at the end).

Posted in Oracle Application, Oracle Receivable, Release12 | No Comments »

Oracle E-Business Suite Release 12.2.5 Highlights

Posted on July 15th, 2016 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle E-Business Suite R12.2.5 has been around for a while now. If you are still using an older version, you can think to upgrade. Having the the most up to date version of EBS guarantees that you are utilizing the latest and greatest features that Oracle has to offer.

There are some significant advances in Release 12.2 and specifically Release 12.2.5. Release 12.2.5 has many functional enhancements.


Oracle E-Business Suite 12.2.5 embraces the modern look and feel of other Oracle products so that users navigating between Oracle E-Business Suite and Oracle Cloud applications can have a consistent user experience.

Key business benefits include:

  • Latest Oracle Look and Feel: Business users can leverage touch-friendly, icon-based or tab navigation as well as other new interactions and widgets
  • Tablet Optimized HTML User Interfaces: Receiving, Discrete MES Supervisor
  • Information Discovery: New Areas: Fixed Assets, Customers, Quoting, iStore, OIC, and CMRO; Mobile Templates, DFF Support, Global Search, Quick Links. Rename from Endeca Extensions


Oracle E-Business Suite 12.2.5 delivers customer-driven functional advances across the integrated suite to help organizations further optimize their business processes. Key advances include:

  • Financials: Oracle General Ledger integrates with the Approvals Management framework (AME) to increase automation of journal approvals and improve governance, control and compliance. Oracle Receivables provides new methods for automated receipt application.
  • Procurement: Oracle Procurement Command Center, a new product, allows increased visibility and access to purchasing activities for more value creation. Oracle iProcurement Information Discovery helps improve buying decisions with ratings and reviews for catalog items and services. iProcurement uploads catalogs via the Oracle Supplier Network (OSN) to automate catalog management.
  • Projects: Oracle Advanced Project Planning and Control, a new product, allows increased visibility to project status for more proactive management. Oracle Projects can improve project control with a contractual schedule of values
  • Order Management and Logistics: Oracle Order Management extends support for flexible ordering of products, services, subscriptions, and warranties. Oracle Contract Renewal Command Center, a new product, helps improve visibility to service and lease renewals for higher loyalty. Flexible serial tagging in inventory and warehouse management organizations reduces overhead by capturing serial numbers only at point of use. Zone picking in Oracle Warehouse Management provides reduced idle time and improves picking efficiency.
  • Manufacturing: Outsourced Mfg, Component Availability Mgt
  • Asset Management: Map Visualization, Linear Asset Enhancements
  • Service: Oracle Service enables shared service center operation using multi-org access control (MOAC), with service execution users accessing just the service requests in their operating unit. Configurable HTML UIs in Oracle Field Service and Oracle TeleService helps increase the productivity of field service dispatchers and call center agents
  • Human Capital Management: A flexible, HTML payroll dashboard allows quick validation of payroll readiness and provides improved monitoring of payroll runs. Organizations can configure talent matrices of different dimensions to organize their talent


  • Online Patching: Support for Simplified Dev Environments, Patching Progress Monitoring Tool
  • Technology Stack: Middle Tier Technology Checker
  • Automated System Management: Streamlined Patch Wizard Reports, Patch Wizard Export


  • E-Business Suite R12.2.5, Patch 19676458 with 9 Zip files with 4.3GB in total size
  • Preliminary Pre-Requirements for R12.2.5 Upgrade
    • Oracle E-Business Suite 12.2.5 Release Update Pack requires Fusion Middleware Technology Stack (FMW) (11gR1 PS6) or higher.
    • Apply the Latest AD and TXK Delta Release Update Packs
    • Minimum RDBMS Version is or Higher

Posted in EBS Suite, Oracle Application | No Comments »

Read Only Forms New Feature in 12.2.6

Posted on June 23rd, 2016 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle E-Business Suite Forms-based applications support running a form in read-only mode if the underlying function used to launch the form has passed the parameter query_only = ‘yes’.

In Release 12.2.6, this functionality can be set at the responsibility level, user level, or for an operating unit or a group of users.

You can enable this using the “EBS Read Only” permission set in RoleBased Access Control

Posted in Oracle Application | No Comments »

Go Mobile with E-Business Suite [Smartphone Apps]

Posted on October 17th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oracle has recently released 14 mobile applications for Oracle E-Business Suite. In order to support real-time business decisions and collaboration , today's increasingly mobile workforce requires instant access to targeted enterprise data and functions-wherever and whenever they want.

These mobile applications, including horizontal apps targeted for all employees as well as role-based line of business applications .

These new applications provide simple on-the-go access to horizontal functions such as:

S.N App Name Key HighLights Available as part of Licensed Product Remark
1 Mobile Approvals
  • Quickly filter approval requests by sender or subject
  • Review at a glance header and line details, action history, and comments
  • Approve or reject with or without comments, or request more information
  • Supports most used approval types in initial release, including expenses, requisitions, purchase orders, recruitment. More approval types to be added

Any Oracle E-Business Suite product

that uses workflow approvals

  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
2 Fusion Mobile Expenses for E-Business Suite
  • Enter expenses via quick entry, direct entry, receipt images, and calendar entries
  • Charge to projects and cost centers
  • Flag policy violations and receipt requirements
  • Download corporate card transactions and edit details
  • Enter mileage expenses
  • Submit expense reports
  • Enter expenses in connected and offline mode
Oracle Internet Expenses
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
3 Mobile Timecards
  • Enter time day-wise for easy time booking
  • Enter time in quick time or regular time modes
  • Support payroll and project based time entry
  • Aggregate day-wise entries into timecard periods
  • Submit timecards
  • View timecard history
Oracle Time and Labor
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
4 Mobile iProcurement
  • Track my requisitions for approval and delivery status
  • View requisition, approvers, lines, and shipments
  • Monitor alerts for rejections, delays, and returns
  • Collaborate in context using device features
Oracle iProcurement
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.

ROLE-BASED LINE OF BUSINESS APPS These role-based line of business applications drive faster business execution and decision making through improved visibility and access to enterprise data and functions

5 Mobile Sales Orders
  • View orders for my customer list
  • Search orders by key attributes
  • View order and line details and status (customer, product, pricing, holds, shipping)
  • Monitor shipment alerts (on hold, backorder)
  • Collaborate in context with device features
Oracle Order Management
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
6 Mobile Inventory
  • Search and barcode scan items and LPNs
  • View on-hand materials and LPNs across facilities
  • Identify loose vs. packed material
  • View existing material reservations
  • Identify material moves in a facility
  • View in-transit and received material
Oracle Inventory Management
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
7 Mobile Product Information
  • Search or scan items
  • Easily access favorite and recently viewed items
  • View product operational and user-defined attributes
  • View product images
  • View suppliers and on-hand quantities in list or map
  • View key transaction metrics, related to SOs, POs, WOs
  • Personalize what information is displayed
  • Collaborate in context using device features

Any Oracle E-Business Suite product that defines or uses Items.

Items are defined in an item master organization to represent products and services you buy, sell, or otherwise transact.

  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
8 Mobile Procurement
  • Track purchase orders requiring attention
  • Search purchase orders based on key attributes
  • View purchase order, approvers, lines, and shipments
  • Monitor alerts for shipment delays
  • Collaborate in context using device features
Oracle Purchasing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
9 Mobile Project Manager
  • Monitor overall project status in dashboard
  • Contact team members and customer contacts
  • View open payables summary and invoices
  • View open receivables summary and invoices
  • View open issues and change orders
  • Collaborate in context using device features
Oracle Project Costing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
10 Mobile Discrete Production Supervisor
  • Search or barcode scan work orders to view progress
  • View work order and operations detail
  • Perform quick actions like expedite and add notes
  • View component issue and resources charges
  • Manage exceptions like component shortage
  • Collaborate in context using device features
Oracle Discrete Manufacturing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
11 Mobile Process Production Supervisor
  • Search batches and steps or barcode scan to view WIP
  • View batch, steps, material, and resource detail
  • Perform quick actions like release and reschedule
  • Manage exceptions like unallocated ingredients
Oracle Process Manufacturing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
12 Mobile Project Manufacturing
  • Search project inventory by item, project, and task
  • View project on-hand quantities by locator
  • View outstanding project borrow and payback transactions
  • Identify project materials for transfer and borrow/payback
  • Collaborate in context with device features
Oracle Discrete Manufacturing
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
13 Mobile Maintenance
  • View and complete assigned operations
  • Issue materials and charge time to operations
  • View and search work orders and assets
  • View asset summary, work history, and meter readings
  • Record asset meter readings
  • View work request details
  • Create simple work orders and work requests
Oracle Enterprise Asset Management
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.
14 Mobile Field Service
  • View customer, product, service request, and task info
  • View and update tasks
  • Capture materials, time, and expense details
  • Check inventory levels
  • Return, transfer, and request parts
  • Work online or disconnected
  • Synchronize when online
Oracle Mobile Field Service
  • iOS and Android
  • EBS 12.1.3 and 12.2.3 and above
  • No additional costs for licensed users of base products.

For app availability search ‘Oracle EBS America’ on app store

Oracle E-Business Suite mobile applications are extremely easy to use, resulting from a user-centered design process and user experience (UX) design principles based on simplicity, action ability, consistency, and device integration.

Oracle E-Business Suite mobile applications are built using Oracle Mobile Application Framework .

Oracle MAF framework accelerates and simplifies mobile development with the ability to build once and deploy to multiple platforms, providing tight integration with camera and other device services, device-native user experience, and enables end-to-end encryption and security

This framework accelerates and simplifies mobile development with the ability to build once and deploy to multiple platforms, providing tight integration with camera and other device services, device-native user experience, and enables end-to-end encryption and security

  • EBS Mobile Apps Documentation: Note 1641772.1
  • EBS Mobile Apps Administrator's Guide: Note 1642431.1

Posted in Oracle Application, Oracle Order Management, Oracle Payable, Oracle Pricing, Oracle Product, Oracle Purchasing, Technical | No Comments »

Oracle Environmental Accounting and Reporting [ EAR] -Solution for capturing and reporting environmental and emissions data

Posted on February 19th, 2014 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

In Release 12.1.3 of the eBusiness Suite, Oracle included an Environmental Accounting and Reporting application.

Environmental Accounting and Reporting (EAR) enables to record and account for activities that have an impact on the environment. It provides the ability to store date effective energy consumption and emissions by location that are later used for environmental reporting.

EAR provides several flexible means to record environmental data through the use of standard transactions , such as invoice processing, inventory issues, batch entry, and manual
data entry.

Supported by a built-in emissions calculation engine that takes the emission factors, the emission sources and the transactional data, it computes the CO2 equivalent and the inventory usage, and stores the data where all the reporting is then done, the Environmental Data Ledger.

It allows the classification of green house gas (GHG) emissions data by Scope 1, 2, or 3 [ see more details at the end] , and also by standard industry codes

The application was originally built by an Australian company NDEVR and subsequently acquired by Oracle . [ Source Oracle Website]

Oracle Environmental Accounting and Reporting is an add-on module to Oracle E-Business Suite and provides multiple modes to capture environmental data, a GHG emissions accounting engine, and pre-built dashboards and reports to:

  • Record, account, track, and report activities that impact the environment.
  • Participate in voluntary GHG monitoring and disclosure programs such as Carbon Disclosure Project.
  • Identify opportunities to improve energy efficiencies and reduce GHG emissions.
  • Recognize and undertake early voluntary actions for reducing greenhouse gas emissions.
  • Fulfill mandatory GHG reporting requirements enforced by global and local legislations.
  • Enhance shareholders confidence as an environmentally conscious organization.

Some of the key features of Oracle EAR that allow you to achieve the above are:

  • Store date effective energy and emission factors for location specific GHG accounting.
  • Maintain an emissions audit data trail in the Environmental Ledger for a time based analysis, reporting, and statutory auditing requirements.
  • Classify GHG emissions data as Scope 1, 2, or 3 and by standard industry codes. Refer to the Setting Up chapter for more information on Scopes.
  • Configure organization hierarchy to meet specific analysis and reporting needs of the enterprise.
  • Record environmental data through several flexible means – through ERP transactions, manual batches or import using WebADI templates.
  • Report emissions data using Oracle Business Intelligence dashboards.
  • Define KPIs for tracking an enterprise’s sustainability performance.

Technology Overview

Oracle Environmental Accounting and Reporting uses the following Oracle technologies:

  • Oracle Business Intelligence Enterprise Edition (OBIEE).
  • Oracle E-Business Suite (EBS) Technology Stack.
    • Following applications of Oracle E-Business Suite to be able to run the EAR application:
      • Oracle System Administration
      • Oracle Inventory
      • Oracle General Ledger
      • Oracle Human Resource Management System
      • Oracle Payables
      • Oracle Assets
      • Oracle Projects
  • Oracle Data Integrator (ODI).

Oracle Environmental Accounting and Reporting

The centre of the diagram [ Fig 1] shows the environmental ledger [ CHG Ledger] – the central storage for EAR, which is supported by a number of configuration screens.
The top section of the diagram shows how environment source data may be collected from:

  • Oracle Payables (e.g. from electricity invoices which show usage statistics)
    • EAR integrates with Oracle Payables to capture data while processing Invoices with or without Purchase Order match, related to the supply and use of products and services that have environmental impact.
  • Oracle Inventory (e.g. if you have an onsite petrol bowser)
    • EAR integrates with Oracle Inventory to record data related to the issue of Items to Assets that result in environmental emissions
  • The Environmental Transaction Batches window (manual data entry specifically related to environmental sources)
  • Or upload data from spread-sheets using Oracle WebADI Templates (e.g. from data extracted fromother systems)
  • EAR leverages Oracle Data Integrator (ODI) to transfer the data from the Environmental Ledger to the Environmental Data Warehouse. The Oracle Business Intelligence application uses the data for environmental reporting through the pre-built dashboards and reports.
  • EAR enables you to record environmental transactions involving the issue of items, to assets defined in the Oracle Assets application.
  • EAR allows you to map Environmental Organizations to projects and tasks defined in Oracle Projects. While processing Invoices that have references to projects and tasks, EAR uses this information to identify organizations to calculate and store environmental data based on the projects and tasks mapped to the organization.

Environmental Reporting Overview

Oracle Environmental Accounting and Reporting provides the following pre-built dashboards to report the source usage, emissions data, carbon disclosure, and KPI measures for organizations:

  • Emissions
  • Energy
  • Metrics
  • Reporting
  • Summaries
  • Test
  • Transaction
  • Usage

Categorization of Emission Types

  1. Scope 1 : Direct GHG Emission from sources owned or controlled by the organization (i.e. gasoline that is put into a fleet of vehicles owned by the organization)
  2. Scope 2 : Energy Indirect GHG Emission from the generation of imported electricity, heat or steam consumed by the organization (i.e. electricity or gas bought by the organization)
  3. Scope 3 : GHG emission that arises from GHG sources that are owned or controlled by other org anizations (i.e. business travel)

Additional Reference

  • Oracle Environmental Accounting and Reporting User's Guide 12.1 (# E23439-02)
  • MOS 1327248.1 - Oracle Environmental Accounting and Reporting Release Notes 12.1.3

Posted in Functional, General Interest, Oracle Application | No Comments »

Rolling Time Zone- LETZ

Posted on January 10th, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Timezone handling is bit tricky in EBS. Currently you may have only two options:

  1. Entering data in the standard corporate time zone as recommended by Oracle
  2. Entering data in their own local time zone and using a custom solution to resolve the issues that arise when comparing data across transactions in different time zones.

If your company/Client uses the second approach (entry in local time zone), enabling the user preferred time zone feature might result in unwanted date with time conversions (local date with times that are converted to the user preferred time zone) because the system assumes that all dates with time are stored in the corporate time zone.

If your company uses the standard corporate time zone for all business transactions, you can enable the user preferred time zone feature and have the choice to continue working in the standard corporate time zone as before, or to set your preferred time zone and start interacting with the system in your preferred time zone.

If you do not set the user level time zone preference, then the system will continue to operate in the standard corporate time zone as it always has, even though user time zone support is enabled for the implementation.

Lets discuss out-of-box LETZ feature.

Legal entity timezone(LETZ) feature will automatically report transactions in the relevant period .

In other word LETZ means that you can choose between recording accounting transactions according to a single worldwide reference location or by referring to the time zone of the legal entity involved. It means that you can select to have a rolling close, which allows you to close periods in relation to the local date, or you can continue to use a single world-wide reference when period close should take place.

This feature was introduced in 11i10 in Controlled Availability status and is also available on R12 - also in a Controlled Availability status.

arrow-up-3 Enbling LETZ

It required two simple steps to achieve this :

  1. Turn on and Set the 'Enable Legal Entity Time Zone' profile option to 'Yes' at site level.
    • Profile Option, 'Enable Legal Entity Time Zone', has been added and is available at site level only.
    • By default, this profile option is visible to the system administrator only. You will need to change its control access in the 'Application Developer' responsibility before it can be turned on.
  2. Set up the Time zone of the legal entity in HR Locations . Leave it blank for Non LETZ entities.

arrow-up-3How this works:


Conceptually, there are two types of date fields:

  • Dates with a time component – meant to indicate a specific point in time
  • Dates without a time component – meant to show a day but not a specific time

Majority of Finanancial Module , as consider as dates without time represent pointers to a financial period.

When the user preferred time zone feature enabled, date with time fields will be converted to the user’s preferred time zone.. That means if these profile setup :

  • 'Server Timezone' profile must be set at the Site level, and must be set to the same standard corporate time zone as the database
  • 'Client Timezone' profile must be set at the userlevel
  • 'Enable Timezone Conversions' must be set to 'Yes' ('Y') at the Sitelevel.


Example 1:

Lets assume ,

  • End user local timezone is GMT-6
  • Server timezone is GMT+8

Therefore , AR invoice date and GL date in AR Invoice Form is the date in server timezone (GMT+8), not end user local timezone.

whereas ship_date_actual in Sales Order form is in end user local timezone GMT-6, since it is a date with time and utilize the user preferred timezone feature.

Example 2:

Lets assume

  • Local timezone is GMT+9,
  • Server timezone is GMT-5

Invoice dates and GL dates are now based on the time zone of the legal entity from which goods are shipped ( end user local timezone), this would ensure that the invoice and the resulting revenue accounting is aligned with the localized GL period.

That means, when a sales order shipment is made from end user who based in Japan, on 01-Jan-2014 at 10:00Hrs, the invoice created in receivables with an invoice date of 01-Jan-2014.

Changes to support Legal Entity Time Zone have been made in Purchasing, Receiving, Inventory, Cost Management, Order Management and Process Manufacturing applications

arrow-up-3 Limitation

  • Legal Entity Time Zone features do not address encumbrance accounting transactions. Therefore you should not enable these features if you are using encumbrance accounting.
  • Oracle Reports do not display transaction dates/times in Legal Entity Time Zone, including internal reports which are used in the period end reconciliation process.
  • Legal Entity Time Zone has not yet been addressed entirely throughout Supply Chain Management (SCM).
  • Legal Entity Time Zone features do not address Periodic Costing, and Consigned Inventory Pay-on-Use Invoice Creation.
  • As per Oracle Note, in Oracle AR except for auto-invoice or debit memo documents created through upstream products such as Order Management and Procurement , all the dates for manually created transactions within Financials will be defaulted to the corporate time zone.
    • If the user wishes to enter a manual transaction and default certain dates (GL dates) in the context of the legal entity and not in the context of the corporate time zone (server time zone), the user will need to manually adjust the date and not accept the system defaulted date.

arrow-up-3 Limitation

Therefore when Implementaing , legal Entity Time Zone features make sure this does not changes to financial information, and therefore is recomendated

  • Work with Senior Finance person to determination as to whether the solution is correct for your company teams and get their buy-in.
  • Work with Oracle engagement team for Oracle Development approval for supporting LETZ. Remember this is still Controlled Availability status
  • Explore if you need to implement 'User Preferred Time Zone' along with LETZ.

arrow-up-3 Suggested Reading

Posted in AOL, Oracle Application | No Comments »

Overview of ‘Auditing ‘

Posted on January 10th, 2013 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

What is Auditing of data?

In simple terms it is defined as a procedure to examine a set of data carefully for accuracy with the intent of verification.

What is the need for auditing?

Any company is accountable for the data it stores. So any modification that is done to the data impacting the company financially or legally should be traceable to its source. The data may include sales/purchase orders ledger accounts, employee records etc.

Auditing in ERP.

  • ERP software of a company is used to do all the transactions of the company. It may also store account information of clients and other sensitive data.
  • Access to such data should be controlled.
  • Any illegitimate modification could cost a company heavily.
  • Company should be answerable for any change to this data.
  • Hence an audit component in the ERP is very much vital.

Posted in Oracle Application | No Comments »

What is Credit Management and Why is used

Posted on December 3rd, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Oacle Credit Management is designed to balance the desired receivables portfolio risk, thus reducing exposure of revenue collection and recognition. Automated revenue recognition transactions increased the timeliness of cash availability to the organization

Oracle Credit Management , a member of receivables and revenue management helps to improve the timeliness of the credit decision making process based on the credit data collected for customers and prospects. It helps to achieve:

  • Established credit policies and standards for customers and prospects across the enterprise
  • Periodic credit review and assessments
  • Flexible credit scoring models for customers and prospects
  • Monitor existing customers’ payment practices throughout the business relationship
  • Seamless integration with Dun & Bradstreet


  • Improve profitability by minimizing bad debt
  • Seize revenue opportunities
  • Balance short term debt with long term financial solvency
  • Reduce resource-intensive tasks
  • Respond to global customer credit needs
  • Provide consistent purchasing power
  • Reduce Campaign-to-Cash life cycle
  • Provide soup-to-nuts financial instruments
  • Resolve credit issues faster
  • Work in ‘best practices’ environment with ‘best of breed’ tools
  • Reduce collections efforts
  • Minimize ‘valueless’ tasks and create value-added work

Oracle Credit Management focus on four major Business Flow areas covering majority of key capabilities:

  1. Credit Policy Management : In Credit Policy Management, we use a unique matrix approach to defining Credit policies, based upon the assignment of the customer’s credit classification or risk assessment, coupled with the type of review being conducted. Credit personnel can use checklist to determine what data points will be gathered from the application tables, what data points are required on a credit application and in the credit review case folder.
  2. Credit Application : The credit application flow enables personnel to submit credit application information on behalf of a customer or prospect. There are also business events that would drive the initiation of a credit review, such as an order being placed on credit hold due to the pre-calculate credit exposure or an externally defined user event.
  3. Credit Analysis and Decision : Within the credit analysis and decision flow, the case folder is the central repository for all data, analyst notes, calculated credit scores and recommendations for the credit review. Because Credit Management is a cross-org application, data displayed in the case folder for a credit review can show transactions counts and amounts for all operating units. Also, because Credit Management utilizes the TCA Relationship Manager hierarchy, the data in a credit review can be consolidated and calculated for Party / Customer Account and Site levels.
  4. Performance: Credit Management provides you with comparison tools that help you to determine if your credit policies have adequately assessed the creditworthiness of your customers. You can access simple views into the workload and effectiveness of the checklists and scoring models that you have set up and used in credit reviews.


Credit Managment is licensed through the Core Financial and Receivables License, you should be able to use Credit Management without issue with either of these licenses enabled.


Remember OCM is not designed to segregate data by operating unit. Therefore this is designed to be more location or operation specific.

In other words, the typical client world that implements OCM has one location that does the credit reviews for all customers, or perhaps a few credit centers that evaluate customer credit by country or locale. Because of this, the focus is not on which customers you can see in the LOV, but rather who is assigned a credit request based on conditions and information in that request.

Check out the data sheet for Credit Application , here.

Posted in Oracle Application | No Comments »

Localizations, Internationalizations, and Translations

Posted on October 8th, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Do you know, Oracle’s E-Business Suite is used in over 150 countries.

In order to help global companies lower costs, drive compliant processes, and deploy country-specific capabilities to operate anywhere in the world, Oracle has developed 3 strategies called as localizations, internationalizations, and translations.

Localizations refer to functionality that is specific to certain regions or countries, usually based on regulations, legislation, or business processes in those regions/countries. You can refer to Country Specific Data Sheet for more details.

Internationalizations refer to products with the flexibility to be used worldwide with capabilities to allow for choice of locale (i.e. date format, currency, number format, etc.) and use with multiple languages.

Translations refer to changing the actual User Interface text of a module from English to another language.

Not all modules are translated into all languages, but with each release Oracle provides more and more translations.

dgreybarrow The difference

Internationalization and localization are different procedures.

Internationalization is the process of making software portable between languages or regions, while localization is the process of adapting software for specific languages or regions.

Internationalized software can be developed using interfaces that modify program behavior at runtime in accordance with specific cultural requirements.

Localization involves establishing online information to support a language or region, called a locale.These Locale are best understood as Date format, number format, currency, name/address order …etc.In EBS, Profile options control regional preferences (locale)

Whereas, in Translation, Translating product UI strings and Help from English to another language .

Posted in AOL, Oracle Application | No Comments »

Understanding Time Zone Features in Oracle E-Business Suite 12

Posted on October 6th, 2012 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

One unique aspect of a global implementation is that multiple locations may use the same system at the same time.

What if , You need to implement Timezones for each Legal entity like US, UK, Singapore and China in your Global single Instance.

Business transactions need to be accounted for in the correct period, in particular for financial transactions such as invoicing, collections,
etc. In addition, global instances with locations in vastly different geographical regions need the ability to close each location at period end in their own time zone.Therefore , you need to have understanding for Time Zone Features in EBS R12.

Date Fields in Oracle E-Business Suite can be classified under these broad categories

Transaction Date

This is Typically Date/Time which are associated as a part of transaction creation or maintenance.

Typical example in EBS context are Transaction date, Order Date, Shipment Date, service order effective date etc.

Accounting Date This is Typically GL Date. This date determines which Accounting period the transaction Accounting period the should be booked in.
Server (database) Date

This is dates that are primarily used in Data base operations.

Such dates are typically user to capture as Creation Date,Last updated Date

Standard Oracle provides three Time Zone features that can be used:

Server Time Zone

This determines the date and time on which Database dates are determined

In absence of Legal Entity Time Zone or User Preferred Time zone set up, this is the default time zone on which all date fields are determined

Legal entity Time Zone This determines the Accounting Date for certain in-scope transactions related to Accounting
User Preferred Time Zone This determines the time zone displayed for in-scope Transaction Dates
you can check out these two easy refrence note for more insights.
  • Doc ID 402650.1 -UPTZ User-Preferred Time Zone Support in Oracle E-Business Suite Release 12
  • Doc ID 726851.1 -LETZ (Legal Entity Timezone)

Posted in AOL, Oracle Application | No Comments »

Page 1 of 71234567

« Previous Entries