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.

Concurrent 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

Concurrent 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.

Similar Post on Concurrent Program

• Output Post Processor – OPP – Troubleshooting 2 common issue
• Output Post Processor – OPP
• Beginner's Guide : Concurrent program/Manager output and log file- Part - IV
• Beginner's Guide : Understanding Concurrent Managers - Part - III
• Beginner's Guide : Administering Concurrent Program - Part - II
• Beginner's Guide : Administering Oracle Application - Part - I
• Know some of the concurrent managers
• Specialized / Dedicated Concurrent Managers (Enhancing Performance)

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

I 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.

Action

• 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) .

I 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.

Action

• 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.

 

 

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

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 »

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 »

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.

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

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

oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5

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

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

Bi 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.