Friday 5 August 2011

Multiple Operating Unit setup in Oracle Apps Reports R12.1.3

Problem:
With the introduction of multi-org access control in release 12, an applications responsibility
can access multiple operating units. Some concurrent programs have been enhanced to process multiple operating units simultaneously, while for other requests the operating unit must be specified when you run the program. To support this, concurrent programs are defined with an operating unit mode of 'S' for single operating unit or 'M' for multiple operating units. If the 'Operating Unit Mode' is not set for the concurrent program it will fail.




This is described in (unpublished) Documentation Bug 5587132

Solution:
To support this, concurrent programs are defined with an operating unit mode of 'S' for single
operating unit or 'M' for multiple operating units. This mode is set automatically during
the upgrade to release 12.

However, if you have modified the definition for any concurrent programs, the upgrade will not set
this. This is done to preserve your customizations. Depending on how you run the customized
program, you may need to set this operating unit mode.
To do this, execute the following SQL to set a concurrent program to run for a single operating
unit:

UPDATE FND_CONCURRENT_PROGRAMS
SET MULTI_ORG_CATEGORY='S'
WHERE CONCURRENT_PROGRAM_NAME = ''


Enter 'M' instead of 'S' for multiple operating units.

If you want to know which setting is appropriate for a given program, you may
review the setting in the appropriate .ldt file.
Please note, however, that if you have customized the concurrent program definition,
this setting may not be appropriate given the way you use the program.



This can also be done via Applications User Interface:


1. Login into application with System Administration responsibility (NOT System
Administrator)
2. Navigate: Concurrent -> Programs
3. Query for short name of the concurrent program
4. Click on Update pencil icon of your program
5. Under 'Update Concurrent Program' region, select Request tab
6. Under 'Request Setting' region, select 'Single' from the drop down of 'Operating Unit
Mode' field
7. Save changes by clicking on 'Apply' button.

3 comments:

  1. Hi..
    Could you send me the details of operating unit and need for multiple operating units in detail....

    My id - nishraghav27@gmail.com

    ReplyDelete
  2. Thank you for posting that SQL script! The Applications User Interface was disabled for modifications. Thank you very much!

    ReplyDelete