Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
Patch Wizard helps you identify useful or critical missing patches for your EBS environment.
This tool is updated as needed, with patches that are cumulative: they include new updates as well as all fixes released previously. The latest updates are always documented here:
The last updates to the EBS 12.2 Patch Wizard were released in September 2016 via this patch:
This patch fixed the following issues:
Related Articles
Source:https://blogs.oracle.com/stevenchan/where-can-i-find-the-latest-patch-wizard-updates-for-ebs-122
It returns the Boolean value TRUE if at least one row was processed.
It returns the Boolean value TRUE if no rows were processed.
PL/SQL packages have the following two parts:
There are two way to execute a stored procedure.
From the SQL prompt, write EXECUTE or EXEC followed by procedure_name.
Simply use the procedure name
Following conditions are true for the Commit statement:
The Rollback statement is issued when the transaction ends. Following conditions are true for a Rollback statement:
With SAVEPOINT, only part of transaction can be undone.
Consistency simply means that each user sees the consistent view of the data.
There are two types of cursors in PL/SQL.
A list of predefined exceptions in PL/SQL:
There are 12 types of triggers in PL/SQL that contains the combination of BEFORE, AFTER, ROW, TABLE, INSERT, UPDATE, DELETE and ALL keywords.
Table columns are referred as THEN.column_name and NOW.column_name.
A stored procedure is a sequence of statement or a named PL/SQL block which performs one or more specific functions.
Oracle University has a large number of free recorded webcasts for Oracle E-Business Suite. Here’s a useful one on Web Applications Desktop Integrator (Web ADI) and Oracle Report Manager:
Padmabrabodh Ambale covers the latest standards support in Oracle Web Applications Desktop Integrator and Oracle Report Manager. The session includes new features in Release 12.2 and other proposed design changes that result in vastly improved performance and spreadsheet experience. In addition, it offers information on how you can use Desktop Integration Framework to build your own custom desktop integrations between Oracle E-Business Suite and Microsoft Excel for enhanced end user productivity for mass upload/download of spreadsheet data. This material was presented at Oracle OpenWorld 2015.
Related Articles
All Rights Reserved