Oracle Workflow is tightly integrated with Oracle Apps and it is very common to invoke workflow from OAF Pages too.
The class oracle.apps.fnd.framework.webui.OANavigation provides Java wrappers for Oracle Workflow Engine’s PL/SQL APIs.
It is very simple to invoke Workflow using OAF, again there are two options first using Java wrappers and second through calling PL/SQL procedures but [...]
Archive for June 2nd, 2009
Integrating Workflow and OAF
Posted in OA Framework on June 2, 2009 | Leave a Comment »
How to call Java stored procedures/Classes from PL/SQL
Posted in PL/SQL Tips on June 2, 2009 | Leave a Comment »
There is lot of requirements where we need to use Java like zipping the files stored in database, deleting files from server.
Oracle provides the way to access Java stored Procedure and classes from PL/SQL, we can use according to our need
Following steps are required:
Create Java class according to your requirement
Compile and load it into database
Write [...]
Integrating XML Publisher and OAF:Generating output in PDF, MSWord, MSExcel and HTML Format
Posted in OA Framework on June 2, 2009 | Leave a Comment »
It is a very common requirement where we want to generate reports in PDF, MSWord, MS Excel and HTML format from an OAF page itself without submitting any concurrent program.
To generate the output in PDF or other formats we need the following:
XML Data Definition, registered with Apps
Template, registered with Apps
XML Publisher APIs to process the [...]
