Basics

Worklist & notification

The Worklist pages let you view and respond to your notifications using a Web browser. The Advanced Worklist provides an overview of your notifications, from which you can drill down to view an individual notification in the Notification Details page. You can also reassign notifications to another user, request more information about a notification from another user, respond to requests for information, and define vacation rules to handle notifications automatically in your absence.

user name, employee & associated responsibilities

SELECT fu.user_name "User Login", fu.description "Role Description", fu.start_date "Login Start Date", fu.end_date "Login End Date", fu.email_address "E-Mail Associated", fu.employee_id "Employee Id", ppf.employee_number "Employee Number", ppf.full_name "Full Name", hou.NAME "Business Group", fr.responsibility_name "Responsibility Associated", fur.start_date "Association Start Date", fur.end_date "Association End Date" FROM apps.fnd_user fu, apps.per_all_people_f ppf,

Value of a profile in a responsibility

Select fpo.profile_option_name,fpo.user_visible_flag, fpo.user_changeable_flag, fr.responsibility_key, pov.profile_option_value from apps. fnd_profile_option_values pov, apps. FND_RESPONSIBILITY fr, APPS.fnd_profile_options fpo where pov.LEVEL_VALUE_APPLICATION_ID = fr.APPLICATION_ID AND pov.LEVEL_VALUE=fr.responsibility_id AND fpo.profile_option_id= pov.profile_option_id AND fpo.profile_option_name LIKE '%AR%CONTEX%' -- profile name AND fr.responsibility_key LIKE 'XX%AR%SET%' -- responsibility name

OM profiles

1. Retain Time for Non-ATPable Items : In the case of ATP enabled items, the timestamp will always schedule to 23:59:00 as ATP considers all the components and resources available till end of day.

In the case of non-ATPable items, the profile 'MSC: Retain Time stamp for Non ATPABLE items' is used. If this is set to Yes, the timestamp can be saved to the value entered by the user.

The Profile can be set to either Yes or No.

MSC:Retain time for Non-ATPable items set to Yes

Concurrent Programs

A new field Operating Unit Mode is included to the Define Concurrent Programs window which allows users to specify the concurrent programs for multiple organizations. The concurrent programs can be categorized into Single, Multiple or Null. The default value is Null. The concurrent program is used to execute the multiple organizations initialization and also determine when to display Operating Unit field in the Submit Requests window and Schedule Requests window.

There are two categories of Concurrent programs: 1. Single Organization Concurrent Programs

Reports

Oracle Payables All standard Payables and Subledger reports can be run for an operating unit. The following Payables reports can also be run for a ledger or ledger set to report on balances across all operating units assigned to a given ledger or ledger set:

Payables Posted Invoice Register Payables Posted Payments Register for a Ledger or Ledger Set Open Account Balances Listing

Oracle Receivables

Multiple Org Report Example

Assume Acme Inc. has Multiple Organization architecture set up as shown in the figure below. You are an Oracle Applications user connecting to a responsibility that is linked to the Western Division operating unit.

Multiple Organizations Reporting

Multiple Organizations Reporting enhances the reporting capabilities of Oracle Applications products by allowing you to report at the:

Ledger level Operating unit level

The Multiple Organizations Reporting feature is comprised of below components:

Web ADI

Web ADI brings Oracle E-Business Suite functionality to the desktop where the familiar  Microsoft Excel, Word, and Project applications can be used to complete your Oracle E-Business Suite tasks. This guide provides instructions on using the Microsoft Excel functionality.

All Rights Reserved. Copyright 2008-11 OracleUG.com.