How to Implement Poplist/ Drop-Down in OAF
Here in this article, we are going to learn about the implementation of Poplist or Picklist in OAF. Poplist is nothing but a drop-down list in any web development. Usually when the value set and lookup contains very less number …
How to Update/Reset Password For a User in Oracle Apps
We know how to update or reset password for a user. This is how it is: Naigation: System Administrator > Security > Users > Define Query for the User for which the password needs to be updated. Enter New Password …
Advanced Queue in Oracle Database
Here we will create advanced queue in Oracle Database and will perform enqueue and dequeue operations also using DBMS_AQADM package. Follow the below steps to achieve this. Add below two roles to user for queuing operation in database. AQ_ADMINISTRATOR_ROLEA�- Allows …
How to Attach Responsibility To User From Backend
We know how to attach responsibility to a user. This is how it is: Naigation: System Administrator > Security > Users > Define Query for the User for which the responsibility needs to be added. Add Responsibility Now we …
How to Delete Oracle Alert using API
Alert can be enabled or disabled but can not be deleted from Oracle Alert Form. But here is way out to delete from backend using SQL Script: SQL Script to Delete Oracle Alert DECLARE ln_appl_id NUMBER; ln_alert_id NUMBER; BEGIN SELECT …
How to Delete Concurrent Program in Oracle Applications/ EBS
As we know that concurrent programs can not be deleted from the front end i.e. Concurrent Program Definition but we can deactivate the concurrent program by unchecking the Enable Checkbox. Delete Concurrent Program using API DECLARE lc_prog_short_name VARCHAR2(240); lc_exec_short_name VARCHAR2(240); …
Recent Comments