Exforsys

Oracle Apps 11i

  1. ERP Overview
  2. Oracle Apps 11i: Overview of popular ERP Products
  3. Oracle Apps 11i: Advantages of Oracle E-Business Suite
  4. Oracle Apps 11i : Getting started with Oracle Applications
  5. Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies
  6. Oracle Apps 11i : File System
  7. Oracle Apps 11i Installation - System Requirements
  8. Oracle Apps 11i - Using Rapid install and the Steps Before Apps Installation
  9. Single Node and Multi Node Installation Part 1
  10. Single Node and Multi Node Installation Part 2
  11. Oracle Apps Application Framework
  12. Oracle Apps Table Registration API
  13. Oracle Apps Concurrent Processing
  14. Oracle Apps Concurrent Library Window
  15. Oracle Apps Message Dictionary
  16. Oracle Apps Flex fields
  17. Oracle Apps Implementing Key Flex field and Descriptive Flex field
  18. Oracle Apps Template Form
  19. Special Triggers in the Template Form in Oracle Apps 11i
  20. Creating New Forms in Oracle Apps 11i
  21. Creation of Master Detail Block in Oracle Apps 11i
  22. Registering New Forms in Oracle Apps 11i
  23. Oracle Apps 11i: Setting up Chart Of Accounts (COA)
  24. Oracle Apps Sys Admin - Users and Responsibilities
  25. Oracle Apps 11i : Creating Journals through Oracle GL
  26. Oracle Apps 11i : Suppliers
  27. Oracle Apps 11i : Asset Management - Asset Book Positioning
  28. Oracle Apps 11i : Asset Management - Asset Books Regions
  29. Oracle Apps 11i : Asset Management - Manual and Quick Additions
  30. Oracle Apps 11i : Asset Management - Mass Additions
  31. Oracle Apps 11i : Asset Management - Asset Adjustments
  32. Oracle Apps 11i : Asset Management - Mass Transfers
  33. Oracle Apps 11i : Asset Management - Depreciation
  34. Oracle Apps 11i : Asset Management - Retirements
  35. Oracle Apps 11i : Asset Management - Journal Entries
  36. Oracle Reports 6i

Ads


Home arrow Technical Training arrow Oracle Apps 11i

Oracle Apps Concurrent Processing Page - 3

Page 3 of 4
Author : Exforsys Inc.     Published on: 12th Jun 2005    |   Last Updated on: 6th Apr 2011

Oracle Apps Concurrent Processing

3. Concurrent Program Parameters :
The 3rd step in defining concurrent program is to define the parameters. To do this, click on the Parameters button as shown at the bottom the form in figure 4. The following screen (figure 5) is displayed when you click on parameters button. This screen is used to define the parameters in the concurrent program.

Ads

Figure 5. Parameter Window

Field Description

i) Program – will be defaulted from Concurrent Program

ii) Application – will be defaulted from Concurrent Program

iii) Conflicts Domain - Enter the parameter which will hold the value of the conflict domain of the program.

iv) Security Group - This field is for HRMS security only.

v) Seq – Enter sequence number for the parameter

vi) Parameter – name of the parameter, will be displayed in parameter entry screen

vii) Description – description about the usage of the parameter

viii) Enabled – check box to enable or disable the parameter. Disable a parameter when you don’t want to use it.

ix) Value set – enter the name of the value set which you want to use to validate the value enter in the parameter field.

x) Description – will be defaulted from value set definition

xi) Default Type – choose the default type for the default value of the parameter. Possible default types are

  • Constant : The default value can be any literal value.
  • Profile : The default value is the current value in the user profile option defined in the Default Value field. Use the profile option name, not the end–user name. You do not need to include $PROFILE$.
  • SQL Statement : The default value is determined by the SQL statement you defined in the Default Value field.
  • Segment : The default value is the value entered in a prior segment of the same parameter window.

xii) Display size – Enter the field length in characters for this parameter. The user sees and fills in the field in the Parameters window of the Submit Requests window.

xiii) Token - For a parameter in an Oracle Reports program, the keyword or parameter appears here. The value is case insensitive. For other types of programs, you can skip this field.

4. Incompatible Programs Window :

To navigate to this form, click on the Incompatibilities button on the bottom of the form shown in figure 4. This window is used for defining the incompatibilities of the concurrent program. Identify concurrent programs that should not run with your concurrent program as they might interfere with its execution.

Ads

Figure 6. Incompatibilities Form

Field Description

i) Program – Defaulted from Concurrent Programs Window

ii) Application – Defaulted from Concurrent Programs Window

iii) Application – Application of the concurrent program which is incompatible to the defined concurrent program.

iv) Name – Name of the concurrent program which is incompatible to the defined concurrent program.

v) Scope – Used to identify if concurrent program is incompatible if the program or also with its child requests.

vi) Type - Enter Domain or Global. If you choose Domain, the incompatibility is resolved at a domain-specific level. If you choose Global, then this concurrent program will be considered globally incompatible with your concurrent program, regardless of which domain it is running in.

5. Session Control :

To navigate to this form, click on the Session Control button on the bottom of the form shown in figure 4. This is a new functionality given in 11.5.10 to control the database session while executing concurrent program using following three parameters. The form would look like as shown in figure 7.

Figure 7. Session Control Form

Field Description

i) Consumer Group – resource consumer group of the concurrent program can be specified. A resource consumer group defines a set of users who have similar resource usage requirements. An overall resource plan specifies how resources are distributed among the different resource consumer groups. Resource consumer groups and resource plans provide a method for specifying how to partition processing resources among different users.

ii) Rollback Segment – Rollback segment specified here would be used instead of the default rollback segment. If you specify a rollback segment here, your concurrent program must use the APIs FND_CONCURRENT.AF_COMMIT and FND_CONCURRENT.AF_ROLLBACK to use the specified rollback segment.

iii) Optimizer mode - Optionally specify an optimizer mode. You can choose ALL_ROWS, FIRST_ROWS, Rules, or Choose. You would specify an optimizer mode only for a custom program that may not perform well with the default cost-based optimizer (CBO) and needs tuning. You can use a different optimizer mode until your program is tuned for CBO.



 
This tutorial is part of a Oracle Apps 11i tutorial series. Read it from the beginning and learn yourself.

Oracle Apps 11i

  1. ERP Overview
  2. Oracle Apps 11i: Overview of popular ERP Products
  3. Oracle Apps 11i: Advantages of Oracle E-Business Suite
  4. Oracle Apps 11i : Getting started with Oracle Applications
  5. Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies
  6. Oracle Apps 11i : File System
  7. Oracle Apps 11i Installation - System Requirements
  8. Oracle Apps 11i - Using Rapid install and the Steps Before Apps Installation
  9. Single Node and Multi Node Installation Part 1
  10. Single Node and Multi Node Installation Part 2
  11. Oracle Apps Application Framework
  12. Oracle Apps Table Registration API
  13. Oracle Apps Concurrent Processing
  14. Oracle Apps Concurrent Library Window
  15. Oracle Apps Message Dictionary
  16. Oracle Apps Flex fields
  17. Oracle Apps Implementing Key Flex field and Descriptive Flex field
  18. Oracle Apps Template Form
  19. Special Triggers in the Template Form in Oracle Apps 11i
  20. Creating New Forms in Oracle Apps 11i
  21. Creation of Master Detail Block in Oracle Apps 11i
  22. Registering New Forms in Oracle Apps 11i
  23. Oracle Apps 11i: Setting up Chart Of Accounts (COA)
  24. Oracle Apps Sys Admin - Users and Responsibilities
  25. Oracle Apps 11i : Creating Journals through Oracle GL
  26. Oracle Apps 11i : Suppliers
  27. Oracle Apps 11i : Asset Management - Asset Book Positioning
  28. Oracle Apps 11i : Asset Management - Asset Books Regions
  29. Oracle Apps 11i : Asset Management - Manual and Quick Additions
  30. Oracle Apps 11i : Asset Management - Mass Additions
  31. Oracle Apps 11i : Asset Management - Asset Adjustments
  32. Oracle Apps 11i : Asset Management - Mass Transfers
  33. Oracle Apps 11i : Asset Management - Depreciation
  34. Oracle Apps 11i : Asset Management - Retirements
  35. Oracle Apps 11i : Asset Management - Journal Entries
  36. Oracle Reports 6i
 

Comments