Its quite obvious that an organization may have its operations in different locations of the globe which we call as operating units in-terms of oracle… Read More »MOAC – Oracle Apps ORG_ID, Multi Org Concept
/********************************************************** *PURPOSE: To list all forms personalizations * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT ffv.form_id , ffv.form_name , ffv.user_form_name , ffv.description "Form Description", ffcr.sequence ,… Read More »Oracle SQL Query to list all Form Personalizations
There are two system profile options that can be used to change look and feel. Java Look and Feel & Java Color Scheme Java Look… Read More »How to configure Oracle Forms Color
— — Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved. — — NAME — demobld.sql — — DESCRIPTION — This script creates the SQL*Plus… Read More »Demobld.sql – Oracle Database seeded table scripts – EMP – DEPT – BONUS – SALGRADE – DUMMY
fnd_user_pkg.addresp is an Oracle Seeded API to add responsibilities to a user account. Added some logic to select responsibilities of one user to another user.… Read More »Oracle Script to Copy Responsibilites of one user account to another user account
Oracle has a seeded API fnd_user_pkg which has a procedure createuser which is used to create a user login account. Below is the sample script… Read More »Oracle Script to Create User Login Account
Generally developers will be in need of APIs to add/modify data on existing tables but its a bit difficult task to find out APIs What… Read More »Information about Oracle APIs and How to find APIs of Oracle Modules?
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25… Read More »SQL Query to findout information about a Concurrent Request
Most of the times I forget the exact names of profile options related to OAF, so just for reference I am listing out here. •… Read More »Profile options for OAF Personalization
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25… Read More »SQL Query to find out the status of Interface Mangers