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

EBS Concurrent Manager

Posted on November 30th, 2010 by Sanjit Anand ||Email This Post Email This Post

Concurrent program are the batch Processing Sub-System. These programs are run as operating system background processes.These programs may be written using a variety of Oracle tools, programming languages for executables, or OS scripts.

  • The Internal Concurrent Manager (ICM) controls all other concurrent managers. It administers the startup and shutdown of managers as defined by their work shift, monitors for process failure, and cleans up if a failure occurs.
  • The Conflict Resolution Manager (CRM) enforces rules designed to ensure that incompatible concurrent requests do not run in the same conflict domain.
  • The Standard Manager as shipped with Oracle Applications will accept and run any concurrent requests.

dgreybarrowConcurrent Manager – Tables

Here are the list of table assocaited with concurrent programs.

Table Content
FND_CONCURRENT_REQUESTS Details of user requests, including status, start date, and completion date
FND_CONCURRENT_PROGRAMS Details of concurrent programs, including execution method, whether the program is constrained, and whether it must be run alone
FND_CONCURRENT_PROCESSES Cross-references between concurrent requests and queues, and a history of concurrent manager processes
FND_CONCURRENT_QUEUES Information about each of the concurrent manager queues

dgreybarrowConcurrent Request – Lifecycle

Here are summary for concurrent prgram phases in a typical lifecycle of concurrent program.

Phase Activity
Pending / Normal The request is waiting to be run
Pending / Standby The request is waiting at CRM
Running / Normal The request is running
Completed / Normal The request has finished
Inactive / No Manager The request cannot be run. No manager available to process it.

dgreybarrowSimilar Post on Concurrent Program

Posted in AOL | No Comments »

Output Post Processor – OPP – Troubleshooting 2 common issue

Posted on November 28th, 2010 by Sanjit Anand ||Email This Post Email This Post

Before getting insight on two common issue , read this post on “Output Post Processor – OPP

dgreybarrowI S S U E # 1: This error often you get.

The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, and the request will be marked with Warning status.


  • You need to set the Profile Option “Concurrent: OPP Response Timeout” to a higher value may be necessary.
  • If the value of the Profile Option „Concurrent:OPP Response Timeout. is 120 then increase it to 240. (Value * 2).
  • Increase the number of processes or threads (or both) .


dgreybarrowI S S U E # 2 :Program end-up with this error.

The Concurrent Manager has timed out waiting for the Output Post Processor to finish this Request.
Check that there are enough Output Post Processor Service Processes running. More information may be found in the Service Process logfile.


  • You need to check the Profile Option “Concurrent:OPP Process Timeout”.
  • Increase the setting to a higher value.

For example: Set the value to 10800 sec (3 hours). After this change, the Concurrent Request will wait maximum 3 hours, for the Output Post Processor to finish the Request.


hope this helps.



Posted in AOL | No Comments »


Posted on November 28th, 2010 by Sanjit Anand ||Email This Post Email This Post

Capital goods are expensive machines which are used for many years before being disposed of.

Examples like advanced medical systems, electronic microscopes and lithography systems are highly complex and customer-specific. Instead of selling off-the-shelf, these products are configured in consultation with the customer. The end product is in most cases unique and fulfills the exact needs of the customer. It is created through the careful combination of different hardware modules and software. The hardware modules are standardized, designed for flexible use in many customer-specific configurations.

Therefore , Configure-to-Order (CTO) represents the ability for a user to define the component make-up (configuration) of a product at the very moment of ordering that product, and a vendor to subsequently build that configuration dynamically upon receipt of the order.

Do you know , Dell has operated as a pioneer in the “configure to order” approach to manufacturing, whereby delivering individual PCs configured to customer specifications.


Oracle Manufacturing enables you to define options available for products and to process orders for unique product configurations while maintaining control of inventory, planning, and cost accounting.

A Configure to Order environment is one where the product or service is assembled or kitted on receipt of the sales order.

Do you know, Oracle Applications supports the Configure to Order environment with a range of features in order entry, demand forecasting, master scheduling, production, shipping, and financial accounting.

Key points for Configure to Order are:

  • includes Pick-to-Order (PTO) and Assemble-to-Order (ATO) items, models, and hybrids.
  • supports building configurations using other configurations as sub-assemblies (multi-level configure-to-order)
  • supports internal and external sourcing of ATO models at any level in the BOM
  • supports multi-level PTO/ATO hybrids

Some standard Definitions

1Assemble – to – Order Model (ATO Configuration)

  • Model bill of material with optional items and option selection rules
  • Configuration manufactured from mandatory components and selected options, or purchased from a supplier

1Assemble-to-Order Item

  • Standard bill of material with mandatory standard components
  • Item manufactured from mandatory standard components, or purchased from a supplier

1Pick-to-Order Model (PTO Configuration)

  • Model bill of material with optional items and option selection rules
  • Pick slip used to kit included items and selected options

1Pick-to-Order Item (Kit)

  • Standard bill of material with mandatory included items
  • Pick slip used to kit included items


  • Pick-to-Order models with optional Assemble-to-Order items
  • Pick-to-Order model containing Assemble-to-Order model

1Multi-Level Assemble-to-Order Model (Multi-Level ATO Configuration):

  • A model bill of material with a non-phantom model as a component
  • Configuration manufactured from mandatory components selected options, configured sub-assemblies, or purchased from a supplier.

1Multi-Level Assemble-to-Order Items:

  • Standard bill of material with standard components and configured components
  • Item manufactured from standard components and configured components


The following Oracle Application products are integrated to provide Configure to Order features:

  • Bills of Material
  • APS
  • Order Management products
  • Configurator products
  • Work in Process
  • Inventory
  • Flow Manufacturing
  • Cost Management
  • Purchasing
  • iSupplier Portal

Therefore , Configure to Order enables configure to order and discrete manufacturing processes to be integrated directly into your operational processes.

Posted in Oracle Manufacturing | No Comments »

Reclassification of assets

Posted on November 28th, 2010 by Sanjit Anand ||Email This Post Email This Post

Though Reclassification of Financial assets is just a function in Oracle asset, but have larger impact in reporting side for disclosure requirement.

dgreybarrow Reclassification and mass reclassification

Reclassification of an asset is simply changing the category of an asset.

Mass Reclassification is a feature that allows you to reclassify a group of assets from one asset category to another based on flexible selection criteria. Your flexiable flexible selection criteria may be either inherit the depreciation rules of the new category or retain depreciation rules of the old asset category. Also you have an option for an option to choose to amortize or expense any depreciation adjustment resulting from the reclassification. sounds Good:)

Read the rest of this entry »

Posted in Oracle Asset | 1 Comment »

FA Books and Data transfer

Posted on November 24th, 2010 by Sanjit Anand ||Email This Post Email This Post

Couple of questions from reader in FA, here is consolidated one:

In order to give you small background,take a note there are three type of books in Oracle Fixed asset. Corp book, tax book and budget book.

The most commonly used books are Corp and tax books. The basic rule of thumb is that an asset is created in Corp book and then migrated to tax book(s). Each corp book can have multiple tax books associated with them. For example a corp book can have seperate tax book for state, Federal, and other tax reporting needs. You can select the option in Corporate and tax books to report FA activity to GL.

Read the rest of this entry »

Posted in Oracle Asset | No Comments »

Metalink/Oracle Support now gives choice of SR severity

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

Logged a TAR(SR) after a long time, did notice a Oracle asking key-in the severity level , that sounds really a great. Earlier the severity was set by Oracle based out of certain ceriteria expect 1 . No more requirement to call your Oracle sales staff /Global Customer Support (GCS)to raise the SR severity.

Default severity seems to be 3 and 1 still need answer of one question before you key-in the primary and secondary details.

MySupport Severity

Hope with this new options from requstor may help Oracle support to understand the user periority.

Posted in Oracle Application | No Comments »

Output Post Processor – OPP

Posted on November 2nd, 2010 by Sanjit Anand ||Email This Post Email This Post

Concurrent Processing uses the Output Post Processor (OPP) to enforce Post Processing actions for concurrent requests.

The Output Post Processor (OPP) is an enhancement to Concurrent Processing and is designed to support XML Publisher as post-processing action for concurrent requests. If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running the concurrent program, it will contact the OPP to apply the XML Publisher template and create the final output.

Ensure that enough OPP process existing to serve the incoming request load. Otherwise increase “process”.

Thread Vs Process :You can either increase process (or) threads. It depends on the load .

Reseting and altering can be done via these navigation

Concurrent -> Manager -> Define > Output Post Processor




If you refer to metalink node 563233.1 , it is advised to have each PCP node should have one OPP must be defined.

dgreybarrow Locating OPP log file?

whenever XML issues or other publishing problems occurs, first thing you will do is to trace the OPP logfile.Locating such logs is not a big things, just follow the steps below:

  1. logon with System Administrator
  2. Function: Concurrent –> Manager –> Administration and select the Output Post Processor
  3. Click on the Processes button
  4. Select the Concurrent Process which was active during the time that the request ran
  5. Click on the Manager Log button to open the Output Post Processor log file

Directly from the file system based after identifying the corresponding OPP log file name using the following SQL statement:

SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
WHERE fcpp.processor_id = fcp.concurrent_process_id
AND fcpp.action_type = 6
AND fcpp.concurrent_request_id = &&request_id

dgreybarrowBi Publisher Enhancement Parameters

You often encounter issue whenever you have XML Publisher concurrent program with OOP. You can slightly enhance without chasing DBA everytime.

  • Use XML Publisher’s XSLT processor set to True (see fig 1 & 2cbelow)
  • Enable XSLT runtime optimization set to True (see fig 3 below)
  • Enable scalable feature of XSLT processor set to False.
    • Small Report – It is still recommended this remain false at Site level. This has the advantage of faster performance by not using temporary files for XSLT processing for small to medium reports.
    • Large Reports – what you need to do apply Patch 7599031. once Patch is applied this will safely set to True at the data definition level, enabling improved JAVA heap utilization along with ScalableFlag parameter and ‘Options’ field with the value to -Xmx1024M (or higher).

Simply follow these steps

Go to sys admin
add XML publisher administrator and choose the same responsblity
Home ->Administration

select the FO Properties


Fig 1: select FO processing

next is to reset these values


Fig 2: reseting the FO processing paramater

Go to sys admin
add XML publisher administrator and choose the same responsblity
Home ->Data Definition
search for data definition and view
then reset the value to TRUE as per figure below


Fig 3: reseting the XSLT runtime optimization set

Hope this post will help you to understand OOP.

Posted in AOL | No Comments »