Monday, November 30, 2009

MOAC in Concurrent Programs/Reporting

A new field "Operating Unit Mode" is added in the Define Concurrent Programs in the OA Framework pages. The user can query the program or report based on an operating unit by updating the "Operating Unit Mode" field with one of the following values:
  • Single
  • Multiple
  • Empty
    The default value is Empty.

    The multiple organizations context is automatically initialized by the concurrent program if the "Operating Unit Mode" is set to either Single or Multiple. The user can also select a value from the Operating Unit field's LOV in Request form when the mode is Single. The value of the "Operating Unit Mode" must be Single for a majority of the existing operating unit context sensitive reports. Example: Invoice Register report.

    In case of Multiple,  Operating Unit field in Request page will be disabled, it indicates that CP will run for all user accessible OUs. You can also define Operating Unit field as a input parameter for CP. In this case you can run CP for selected OU or for all. Example: Invoice Validation report.

    **You should not change "Operating Unit Mode" of  any reports which are owned by Oracle. Use this option for user defined reports only.

    Navigation Path: System Administrator->Concurrent->Programs Here select Request tab. There u can see "Operating Unit Mode".


    Query to check this option from back-end:

    SELECT concurrent_program_name, multi_org_category
    FROM fnd_concurrent_programs
    WHERE concurrent_program_name = '--CP short name';  Ex: 'APXINRIR'

    S-Single
    M-Multiple
    null-Empty
    Related Posts Plugin for WordPress, Blogger...