A unique session id is created at each sign on – so upon signing into the application, it will create a session_id. This session_id is… Read More »How to open multiple instances of same Form in same Session?
I had a requirement to validate date entered in a free text field (standard field on a standard form). I have solved it by writing… Read More »Date Format validation on Standard Free Text Fields
Data template is one of the method of generating reports in XMLP. Reports in XMLP has two components: Data Definition Template Data Definition Data definition… Read More »Developing XML Publisher Reports using Data Template
Some times we get Error “Java execution failed. Please check the Java Option in the option dialog.” when we preview or validate the template because… Read More »XMLP Error While Previewing RTF: Java execution failed. Please check the Java Option in the option dialog.
Usually we face Java issues in accessing oracle forms, especially when we are accessing the instance for the first time. This is because of not… Read More »How to download instance compatible JRE Plugin
Business Event Business Event is an occurrence of a business activity which has some significance. For example, the activity of creating a purchase order (PO)… Read More »Basics of Business Events and step by step process to subscribe to a Business Event
Sometimes we end up in a situation to close notifications in bulk, in such situation we can use “wf_notification.close” API. Below is the script to… Read More »Script to close FYI workflow notifications from backend
To save a modified workflow we can either do it from workflow builder or WFLOAD but to a remove a workflow or to delete a… Read More »SQL Script to Delete Workflow Item Type definition and all its related data
To generate a HTML notification we can just write HTML code on the message notification but unfortunately message body accepts only content 32kb of content.… Read More »PL/SQL document: Workflow Notification with Dynamic HTML Body
We can use UTL_SMTP API to send Emails using PL/SQL block of code but emails sent through UTL_SMTP has no track like whether the email… Read More »How to Create a Small Workflow just to send EMAIL notifications and Run it from backend