Step1: Right click on trng2 project and select “New” Step2: Select OA Components and Page Step3: Specify Page name and package. Page names with PG and they will be in webui folder. It being a custom page, the page and package should be <company/customname>.oracle.apps.<application>.<module>.webui Here for custom objects we are using trng2 as starting custom […]
utl_smtp example: UTL_MAIL: This is the new package introduced in 10g. even though this uses the UTL_SMTP in the background the advantage with this script is we can change the mail server and ports in the configuration file with out changing the code.
Scheduling concurrent program in Oracle Apps: Many times you may want to run a concurrent program at a specific time on some specific days of a week. Remembering the schedule and submitting the programs manually may not be feasible all the times. Oracle E- Business suite conveniently let’s you schedule a program to run on […]
Get the list of users who have access to a specific given responsibility
The below script will lanch or kickoff the desired workflow from PL/SQL code:
The below script can be used to auto approve notifications through database procedure. Write your business logic with in the below procedure ,register it as a concurrent program and schedule it as needed to run periodically. The same script can also be used in custom forms, custom or third party applications to respond to notifications from backend procedure.
Steps To Develop a Query_Find Form in Oracle Apps Step 1: Open Template.fmb with form builder save it with another name(XXMZ_Query_Find.fmb) and give the module name as XXMZ_QUERY_FIND. Step2 : Delete BLOCKNAME from Window,Canvas and Data Block and delete DETAILBLOCK from Data Block. Step 3: Create window(DEPT_WINDOW) apply subclass information as WINDOW and give the […]
Companies might have to transfer material from one warehouse (inventory organization) to other warehouse depending on the current on-hand stock and demand at each location. Oracle ERP provides a couple of ways to achieve this requirement. 1) Internal requisition to internal sales order 2) Inter Organization Transfer ( I have covered this in another article) […]