Introduction:
Upgrading from Oracle E-Business Suite 11i to R12 or transitioning between 12.x versions is a crucial step for organizations seeking enhanced functionality and improved performance. As part of this process, it is essential to identify the newly incorporated and currently enabled seeded concurrent programs for various applications. In this blog post, we will explore a comprehensive query to gather information about these programs for specific applications, helping users stay informed and optimize their Oracle E-Business Suite experience.
Query Overview:
Let’s break down the query designed to unveil the newly added seeded concurrent programs:
SELECT a.application_name,
p.user_concurrent_program_name,
CASE p.created_by
WHEN 120 THEN ‘12.0’
WHEN 121 THEN ‘12.1’
WHEN 122 THEN ‘12.2’
ELSE ‘Unknown’
END introduced_in,
l.meaning AS execution_method,
p.output_file_type
FROM fnd_concurrent_programs_vl p
JOIN fnd_application_vl a ON p.application_id = a.application_id
JOIN fnd_lookup_values_vl l ON p.execution_method_code = l.lookup_code
WHERE p.created_by BETWEEN 120 AND 122
AND p.application_id IN (0,50,101,140,200,201,222,235,260,265,
401,602,660,661,665,673,702,7003)
AND p.enabled_flag = ‘Y’
AND l.lookup_type = ‘CP_EXECUTION_METHOD_CODE’
AND p.user_concurrent_program_name NOT LIKE ‘%Obsolete%’
ORDER BY 1, 2;
Breakdown of Key Elements:
- Application Information:
-
- application_name: The name of the Oracle E-Business Suite application.
- user_concurrent_program_name: The name of the seeded concurrent program.
- introduced_in: The Oracle E-Business Suite version in which the program was introduced (12.0, 12.1, 12.2, or Unknown).
2. Execution Method:
-
- execution_method : The execution method used by the concurrent program (e.g., Immediate, Deferred).
3.Output File Type:
-
-
- output_file_type: The type of output file generated by the concurrent program.
-
Filter Criteria:
- created_by BETWEEN 120 AND 122: Filters programs created for versions 12.0, 12.1, and 12.2.
- application_id: Filters programs for specific applications relevant to the upgrade or transition.
- enabled_flag = ‘Y’: Includes only enabled concurrent programs.
- user_concurrent_program_name NOT LIKE ‘%Obsolete%’: Excludes programs marked as obsolete.
Conclusion:
This blog post provides a valuable query for Oracle E-Business Suite users embarking on an upgrade or version transition. By identifying the newly added and currently enabled seeded concurrent programs, organizations can streamline their migration process and leverage the latest features and functionalities available in Oracle E-Business Suite 12.2. Stay informed, stay efficient!
