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

Learn more about Oracle’s next generation applications, Fusion Applications

Posted on March 23rd, 2012 by Sanjit Anand ||Email This Post Email This Post

Want to learn more about Oracle’s next generation applications, Fusion Applications.Here are some of the post , that helps you to understand better.

ORACLE FUSION APPLICATIONS is the integration of Oracle applications such as E-Business Suite, PeopleSoft, JD Edwards & Siebel into a set of next generation applications based on open industry standards.Fusion Applications is build on top of the Oracle Fusion Middleware Technology Stack using Oracle’s Fusion Architecture as blueprint.

Oracle Fusion Applications provide a complete applications portfolio and a host of deployment options(On premise,Public cloud,Private cloud,Hybrid public/private cloud).This include over 100 modules across seven core enterprise application product areas:

Additional products exist to add significant incremental business value span the entire suite:

  • Oracle Fusion Accounting Hub (Oracle Fusion Financials)
  • Oracle Fusion Talent Review (Oracle Fusion Human Capital Management)
  • Oracle Fusion Territory Management (Oracle Fusion Customer Relationship Management)
  • Oracle Fusion Distributed Order Orchestration (Oracle Fusion Supply Chain Management)

Oracle Fusion Middleware is the underlying Technical Platform used to build Oracle Fusion Applications. Oracle Fusion Architecture is the blueprint that ties together the Fusion Applications, Middleware Platform and Grid Technology.

As an EBS user, the concepts that we have learned over the years are all made obsolete. In their place many of the PeopleSoft concepts has taken over.

  • Identity Manger replaces FND User
  • Business Units replace Operating Units
  • Date Effectivity replaces Date Track
  • ESS replaces Concurrent Manager
  • Access Control Governor replaces OICM

Extensible Attribute Framework introduced allowing unlimited set of attributes with more powerful features than Descriptive Flexfields (DFF). All attributes can be inherited or discovered by business intelligence, business rules, business processes, transactional UI and transactional logic. Gone are the days where one must add custom tables due to limitations of DFF fields. Will align to ‘Rethink Customization Strategy’

Sub-ledger Accounting (SLA) architecture is carried into Fusion Applications combined with Business Unit mapping providing a basis for an excellent Service Provider Model.

Fusion Application Security is built using the Security Manager Tool (part of Fusion Middleware) this means the concept of Responsibilities that EBS users are familiar with are gone and in its place Role based access mechanism is implemented.

Fusion have almost all Technology Stack

Tools and Framework

SOA Suite

Web Center Suite

Content Management

Identity Management

Oracle Data Integrator (ODI)Development Environment –
Oracle J-Developer

Application Developer Framework (ADF)

BI Publisher

Web ServicesApplication

Integration Architecture (AIA)

Business Process Execution Language (BPEL OSB)

Oracle SQL, PL/SQL
Java 2 Enterprise Edition (J2EE)

Hyper Text Markup Language (HTML)/Extended Markup Language (XML)

Cascading Style Sheets (CSS)

Extensible Style Sheet Language (XSL)/JAVA ,

These technology stack create ample opportunity to Functional Analyst,Technical Developer and Application Architects.
Combines the best-in-breed functionalities of EBS, Siebel CRM, PeopleSoft and JD Edwards Enterprise One Applications.All of the current applications mashed up along with usability and business process optimization resulting in a new set of better application.

There is choice of adoption scenarios in order to move to Oracle Fusion Application. Co-existence option ie adding on specific Oracle Fusion application module .

Fusion application Business Intelligence comprises of Oracle Transactional BI (OTBI) a real time self service reporting directly off Fusion Apps data. Oracle BI Applications (OBIA) is a prepackaged data warehouse enabling historical analysis and cross domain insight. Whereas specialized Domain specific Analytics include financial statements, sales territory planning and Project Performance built on Essbase technology. White space analysis built on Real Time decisions and Oracle Data Mining Technologies.

Oracle Fusion Functional Setup Manager provides a single user interface for performing all tasks related to Oracle Fusion Applications setup after installation and helps you to easily move the setup data between instances to reduce implementation time.

More References from Oracle

Posted in Fusion Application | 1 Comment »

Sales Tax Nexus

Posted on March 12th, 2012 by Sanjit Anand ||Email This Post Email This Post

Nexus is a constantly evolving concept, as states (over time) write new rules or reinterpret existing law.

The word nexus refers to a connection between a person and a taxing jurisdiction that is deemed sufficient to allow the jurisdiction to impose a tax.

First of all, sales tax nexus is the basis for all sales tax discussions.

Without sales tax nexus, a business has no further concern from a sales tax perspective. In this context, in its simplest definition, nexus is a physical connection between a state and a business that enables a state to subject that business to its sales tax laws. The connection has to be “substantial” and that’s where the problem arises. “Substantial” is generally left to interpretation and is rarely clearly defined.

If you are part of Tax implementaion, don;t get surprise with this term if you came across while discussing with Tax department.

You can get more insights here

[Adopted from Internet]

Posted in Oracle E-Business Tax | No Comments »

The Newbie’s Jumpstart with Oracle OM

Posted on March 12th, 2012 by Sanjit Anand ||Email This Post Email This Post

Hello I’m a newbie…advice please! where do i start from. I need a guide. I’m enthusiastic and want to learn Oracle Apps/Om. Can you help me out?

These are the questions reader frequently asking, therefore thought to create some post that helps newbie .To start with here to go with OM first.

The first thing you need to understand what is Oracle OM application.

Oracle Order Management lets you record the customer information you need to ship to, bill to and collect from your customers accurately. With Oracle Order Management, you define the business functions for which you want to record customer information.

Any company who use OM can get benefits with these basic and advance need for order processing in the organization :

  • Enter orders
  • Indicate when an order is complete and ready for further processing.
  • Enter as many order lines as you want.
  • Enter sales credits for an entire order or an individual order line.
  • Enter orders in different currencies.
  • Assign as many discounts as you want to an order.
  • Import Sales Orders and Returns
  • Schedule Orders
  • Copy existing orders to create new orders, returns or replacement orders.
  • Easily cancel orders and order lines.
  • Apply and Release Holds
  • Close Orders

Oracle Order Management leverages the Oracle Workflow engine to flexibly model and execute any sales order process. The application provides flows for capture, book and invoice right out of the box. The flexible workflow framework makes it easy to add additional steps that are specific to your business. For example, a step can be added if special approval is required or if routing is dependent on characteristics of the order. With Oracle Order management, you can easily create and execute workflows that enforce your best order management practices.

OM is part , Oracle Order Management Suit which consist of:

  • Oracle Shipping Execution
  • Oracle Configurator
  • Oracle Advanced Pricing
  • Oracle Release Management and e-Commerce Gateway

Modules that support Oracle Order Management

  • Oracle Inventory
  • Oracle Bill of Material
  • Oracle Receivable
  • Oracle Purchasing
  • Customer Relationship Management suit

Order Capture From Any Source

  • Oracle Telesales
  • Oracle I-Store
  • Oracle Marketing
  • Oracle Service
  • Oracle Field Sales
  • Oracle Trade Promotion

Next lets understand different types of order.

The Internal Requisition/Internal Orders process is used for requesting and transferring material from one inventory location to another. An Internal Requisition is initiated in Oracle Purchasing. Sourcing rules can automatically determine if the source type is to be Inventory or an external supplier. Order Management receives information from the Purchasing Application to create an Internal Sales Order. When the sales order is shipped (to indicate either intra or inter-organization movement of goods), the requisition can be received to record receipt of goods.

To generate Internal Sales Order user has to follow the following process steps:

  • Enter Requisition in Oracle Purchasing & Approve the Internal Requisition
  • Run ‘Create Internal Sales Order’ Process for transferring requisitions to Order Management.
  • Run ‘Import Order’ Process in Order Management to create Sales order.
  • Release Sales Order
  • After Order Import completes successfully, book, pick and ship the internal order.
  • Receive against the Internal Requisition.

For more details you can go through these posts.

Drop shipments occur when your customer orders product from you, you order the product from your supplier, and your supplier ships the product directly to your customer.

Order Management sends information to the Purchasing Application to create that PO, and then when that PO is received (to indicate shipment from the supplier to your customer), the order line is automatically updated to indicate that it was fulfilled.

To generate Internal Sales Order user has to follow the following process steps:

  • Create a Drop Ship Sales Order
  • Use the Purchase Release program to create a Requisition from the Sales Order.
  • Use the AutoCreate function to create a PO from this Requisition .
  • Approve the PO .
  • Enter a Receipt for the drop shipped goods after the Supplier sends a confirmation.
  • Invoice the Customer

Required Setup:

  • Logical Warehouse to receive drop shipment
  • Order Type/Line Type for drop shipment order
  • Defaulting rules to make the source type External

For more details you can go through these posts.

Order Management also provides sophisticated tracking of your return material authorizations (RMA).

Returns from a customer occur for a variety of reasons including damage, shipment error, or sampling. Return material processing functionality enables you to manage customer expectations while controlling inventory receipts and customer credit processing.

These are RMA Types:

  1. RMA with Credit Only : This is where your company issues a credit without the customer returning the product.
  2. RMA with Repair :This is where your customer returns a damaged product. Your company repairs and returns the product to the customer.
  3. RMA with Replacement :This is where your customer returns a product and your company sends a replacement product rather than issuing a credit.
  4. RMA With Receipt and Credit :in this senario , customer returns a product and receives credit.
  5. Returned Item Fails Inspection (Exception case) : This is senario , where Your customer returns product, Company inspects product and rejects it. Company scraps product or sends product back to Customer. In this case, you have the option of performing an RMA transaction of type:
  • RMA with Repair
  • RMA with Replacement
  • RMA with Receipt and Credit.

Process Flow of RMA is very simple, but some time getting complex .

  • Create RMA Order using sales order window in Order Management
  • Book RMA Order
  • Receipt the RMA using receipts window in Purchasing
  • Check the on hand quantity of the item in Inventory to verify that correct quantity was received
  • Generate credit memo in Accounts Receivable (If Applicable)
  • View the credit memo in order management
  • Check the shipped and fulfilled quantity on the RMA line


Managing Return Material Authorization (RMA)

Credit Check

  • Automatically check credit during order entry and pick release
  • Flexibly define customer open balance calculations
  • Set customer limits per order and for all orders
  • Assign tolerances to single-order and total-order limits

Credit Checking Limits Hierarchy

Credit Limits can be set at the following 5 levels which is called as Credit Checking Limits Hierarchy

  1. Item category level
  2. Site level
  3. Customer level /Customer account
  4. Party level (This level is applicable only if Credit Management is installed)
  5. Operating Unit Default level.

You should be familar with a term called, Pre-Calculated Exposure . In Oracle use of Pre-Calculated Exposure was incorporated to improve performance. Previous versions of credit checking calculated customer exposure accessing underlying transactional tables. When a credit check request was executed, underlying transaction tables were summed to generate customer balance information.

If you ref to Note.293409.1, its mention, Using the pre-calculated exposure option, credit checking will validate exposure against balance information stored in a summary table. The summary table is updated as often as your business practices require, and updates to the table are performed by submitting the Initialize Credit Summaries concurrent program. This program accesses both Oracle Receivables and Order Management transactional tables. It should be scheduled to run periodically, based on your specific business needs.

In order to trigger automatic Credit checking on sales orders it is necessary that the credit checking is enabled for the order type, customer profile and payment terms associated with the transaction.

Credit check set up involves the following setup steps:

  • Step1:Credit Check Rules Setup
  • Step2:Customer Profiles Setup
  • Step3:Payment Terms Setup
  • Step4:Order Types Setup

For more details you can go through these posts.


  • Mix returns and shipments on the same order
  • Enter return receipts using standard Oracle receiving forms
  • Enter expected lot and serial number for returned goods
  • Print acknowledgements for returns
  • Track returned goods for repair using new Depot Repair Process

As mention earlier, OM is one of the most complex modules in EBS, and in typical complex business model, the integration of other product or third party can’t be denied. Processing an Order requires integration with many other business areas. Most integration points with other Oracle products are implemented via PL/SQL-based APIs.You can check a brief discussion for Order Management EBS Integration points.

  • Order Management(OM) Integration Options

Integration and interfacing with your front end application or any custom application you can easily managed. Two options are avaiable Order import and High Volumn Order Import. Check it out what suits your need

Order Mgmt. – Tables/Interfaces/APIs/Workflows


  • Line Flow – Generic
  • Line Flow – Generic, Bill Only
  • Line Flow – Generic, Ship Only
  • Line Flow – Return for Credit with Receipt


  • Application = Inventory
  • Code = SALES_ORDER
  • Title = Sales Order

Some Important Table Names


More technical details you can find post below:


Hope this good starting point for you.

Posted in Oracle Order Management | No Comments »

“Signal 11” : Not So Scary Anymore..

Posted on March 11th, 2012 by Sanjit Anand ||Email This Post Email This Post

Signal 11’ is one of the most scary things in EBS developer/Apps DBA community . If you haven’t encounter yet , after working couple of years in EBS, that means you are quite lucky ..kidding

If you came from basic C programing skill, then you might be linking with malloc ..memory allocation , believe me, that is totally different.

In this post I will share some of the information which you need to know, rather than a creating a panic situation with developer or DBA .

dgreybarrow WHAT IS SIGNAL 11

In layman term, Signal 11 is an obscure way to say that there is hardware problem with the system’s memory

“Unaligned memory access” is a message coming back from the UNIX operating system letting you know that an Oracle executable has tried to access memory incorrectly. It’s not a problem with UNIX but is part of the operating system’s mechanism of protecting itself from crashing.

Chances are there you might get either of these ..Autoinvoice ,GLPPOS, GLLEZL, GLBMBO, APXXTR, GLNSVI, INCTGL , GLAMAS, ARZCAR, ARGLTP, RGRARG, GLCRVL,GLPAUTOP ,FADEPR – Depreciation, PDF Reports, XML OUTPUT


  • Not enough disk space in $APPL_TOP/out directory where the concurrent manager creates the report output files.
  • Lack of storage space in table spaces, rollback segments etc
  • Very complex SQL statements with many Group By columns (which may not all be required)
  • Incorrect OS permission’s
  • Parameter mismatches
  • The reports were FTPed incorrectly (ASCII instead of binary)
  • A ‘Numeric or Value error’ on some procedure code (although this may also cause a Signal 4 error). Typically this is because you have a field or variable which is too small to hold a value passed to it, which often happens when you are summing values.

dgreybarrow TECHNICALLY

  • All ‘Signal’ messages (there are between 15 and 36 different ones depending on the OS) mean that the OS is telling the current process that something has happened, or is ordering it to do something.
  • Take a example , when you do a ‘kill -9 <proc_id>’ on the server, you are actually sending a Signal 9 (SIGKILL) to that process.
  • Depending on the error, the running process can either ignore the Signal, exit gracefully, or exit and write a copy of its current memory stack to the filesystem
  • Core dump file is always unwanted.
  • Signals 6 (Abort), 10 (Bus Error), 11 (Memory Pointer Error) and 12 (Bad System Call) all fall into the last category and write a ‘core’ file.
  • Signal 11 is : “Process asked to be allocated <x> Bytes of memory, but is now trying to access an address which is not within that allocation or is trying to access a null address”.
  • This may be caused by code or data problems.

You usually find, windows equivalent of a Signal 11 error is when a process terminates with ‘Error -1073741819’


  1. First thing to look at is the last few lines of logfile – preferably with Debug on
  2. Searching that you might find in log file, chances are high you will get some node at metalink. if not
  3. Check with your apps DBA , pass the information , he will try to Analyze/diagnosis and advice.
    • what he will do, he will try to locate core file which got is written to the directory from which the executable was called.
    • Take a note,after a Signal 11 error has occurred, the program may write a dump of itself to $<product>_TOP/bin
    • The ‘core’ file which got located is just a dump of the memory occupied by the program at the time of failure, and as such is not easy to read.
    • they need some utilities to produce a readable output. DBA typically used these utilities adb, dbx, xdb, gdb,
  4. If nothing get solved Quickly, raise a SR with Oracle.

Meantime , you can also check the list of unix signals with their explanation in note id 1038055.6

Posted in AOL | 1 Comment »

eAM/GIS Public APIs

Posted on March 5th, 2012 by Sanjit Anand ||Email This Post Email This Post

Geographical Information Systems (GIS) is software for capturing, managing, analyzing and displaying spatially referenced data.

  • GIS makes it easier to:
    • Locate and point to entities on a map
    • Ask for information about the entity
  • Enables use by company’s maintenance users not skilled in IT

when you are doing integration with any of GSI application, you might need to look the Public API availability.

dgreybarrow eAM/GIS Public APIs

You can integrate GSI application with EAM with the help of Public API EAM_LINEAR_LOCATIONS_PUB


Fig 1:eAM/GIS Public APIs

You can use these API’s to integrate.

  • Create Work Order -You can use EAM_LINEAR_LOCATIONS_PUB.CREATE_EAM_WO

Posted in Oracle eAM | No Comments »

Pre-requisities , Credit hold & credit check ….

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

What is the main difference between Credit check and Credit Hold?

Credit Hold is used to prohibit orders from being progressed beyond entry or booking, from a specific customer. It is not dependent on Credit Limit or Previous Balance or any criteria. This is normally used when you need to immediately stop all ordering for a customer.

Credit Checking allows you to control which customer site is affected, what the credit limit is, what is included in the credit check, etc.Credit Management provides even more control and functionality.

You can use Credit Checking and Credit Hold together or separately.

You Can disable to Credit Hold and enable Credit Check.

You can use Credit Check and Credit Hold together, if you think you need both functionalities. As indicated, Credit Hold will prohibit any
processing of the order. Credit Check is used to evaluate the customer’s credit limit, outstanding balance, etc. It will function differently depending on numerous setting and situations. In case if you are implementing these you need to review OM Documentation to see all the various ways you can chose to opt credit checking.

Do you need to have ‘Credit Management’ module installed in our instance to use Credit Check?

You do not need to have the Credit Management module installed to use standard credit checking.

Does Credit Check will not prevent an order from Pick Releasing and Shipping if we set it up at those levels in the Transaction Type setup?

Defining Credit Checking on the Transaction at Pick Releasing and Shipping SHOULD cause Credit Checking to occur before an order picks or ships. However, there are other settings which impact this. For one, the behavior will depend on whether you have defined Order or Line level credit checking. The credit check will depend on the credit exposure existing at the time of pick release or ship. That is impacted by your credit Rule. Also, the credit checking behavior is dependent on how you have set up the option Override Manual Release on the Credit Checking Rule.

There is something called “OVERRIDE MANUAL RELEASE” which you can use this options. If you are, choose the number of Days to Honor Manual Release.

The Override Manual Release checkbox controls whether the credit check process will be triggered even if holds were released manually or not.

The Override Manual Release checkbox, used in conjunction with Days to Honor Manual Release field, enables you to define the duration (number of days) you will forego additional credit checking if an order or line credit check hold is released manually. Manually released holds are honored only during processes that are performed after Booking such as Picking, Packing, and Shipping.

If Override Manual Release is enabled, the credit checking process will validate if the release date is within the interval defined by the value of Days to Honor Manual Release. If the value is within the range defined, then manually released holds will be honored and additional credit checking is not performed. If the value is not within the range defined, credit checking can occur again and credit check holds can be applied if the order or lines fail the credit check process.

For example, suppose you have defined a Credit Check Rule in which you have enabled the Override Manual Release check box, with a value of 15 within the Days to Honor Manual Release field. Assume that this credit check rule is assigned to the transaction type as a Credit Check Rule for Booking and Shipping. If you manually release an order or line from credit check hold after Booking, and if you ship the order or order line within 15 days, Order Management will not enable credit checking to occur again during Shipping. However, if you ship after day 15, then Order Management will enable the credit checking process to be invoked again.

That means there is no guarantee that Credit Checking will work as you expect, just by defining the activities on the Transaction Type.

Hope this helps.

Posted in Oracle Order Management | No Comments »

GIS based Enterprise Asset Management

Posted on March 2nd, 2012 by Sanjit Anand ||Email This Post Email This Post

Organizations that own operate and/or manage geographically dispersed assets can accrue significant business benefits by leveraging the tremendous value of the GIS related investment with GIS based Enterprise Asset Management. This enables asset and service management users for

  • To view assets in a geospatial context
  • Can more easily and dynamically visualize the spatial relationships among managed assets


  • This enhance Spatial Context
  • Significant Improvement for Measurement Capabilities
  • This help to extend modeling options
  • Deeper Knowledge about asset locations
  • Greatly Improved Visualization Capabilities


  • Cost savings through greater efficiency
  • Better informed decision-making
  • Enhanced communication and collaboration
  • Creation of new business value

dgreybarrowApproaches/Options to GIS/EAM Integration

Whenever it comes to Integration these three options are good to consider:

  1. Un-integrated System -In this approach Asset Information is Entered in EAM and Features are Digitized in GIS. There are few disadvantage of this approach as Work get Duplicated because of inaccurate Data which sometime face Data synchronization
  2. GIS Drives EAM -Asset Information gets created in EAM and same time Features gets updated in GIS
    • Advantages
      • One time entry in GIS based Application
      • Asset Information is propagated to EAM
      • Least amount of duplicate work
      • Achieves goals of most GIS/EAM implementations
    • Disadvantage
      • Complex, costly & risky to implement in first phase of GIS implementation
  3. EAM Drives GIS : In this scenarios, asset Information gets created in EAM and features gets updated in GIS.
    • Advantage
      • This Can be implemented without changing EAM
      • this can be implemented with little impact on Engineering and operations department
      • This keeps GIS & EAM synchronized in real time
    • Disadvantage
      • There may be duplicate Efforts in all systems

Posted in Oracle eAM | No Comments »