testoag

How can find Locked Object in Oracle Apps R12 ? or  How can find Locked object name and Oracle User name in Oracle Apps R12? Query 1 - SELECT b.owner      , b.object_name      , a.oracle_username      , a.os_user_name FROM   v$locked_object a      , all_objects b WHERE  a.object_id = b.object_id Query 2 - SELECT c.owner      , c.object_name      , c.object_type      , b.SID      , b.serial#      , b.status      , b.osuser      , b.machine FROM   v$locked_object a      , v$session b      , dba_objects c WHERE  b.SID = a.session_id AND    a.object_id = c.object_id; Query 3 - SELECT a.session_id      , a.oracle_username      , a.os_user_name      , b.owner "OBJECT OWNER"      , b.object_name    ...

What is Implementation, Upgradation, Migration, Reimplementation, Rollout, Support in terms of Oracle Apps R12  or Difference between Implementation, Upgradation, Migration, Reimplementation, Rollout, Support in terms of Oracle Apps R12  Here are some of Important and frequently use Terminology in Oracle Apps EBS Listed below -: Implementation Upgradation Migration Reimplementation Rollout Support 1- Implementation - First-time implementation or fresh implementation of Oracle application on the server is called Oracle Implementation. 2- Upgradation - Upgrade Any lower version into its higher version is called Oracle Apps EBS Upgradation e.g 11i - R12(12.1.1) or R12 (12.1.1) to R12 (12.2.4). 3- Migration - Migrate some of the Selected data from one instance to another instance as per business requirement is called Migration of Data. 4-  Reimplementation - Somehow fresh implementation is not working properly or  it is not suitable for the business then again...

TNSNAMES.ORA entry to runs Oracle Application R12 at local Host  OR  TNS Entry steps to runs Oracle Application R12       Please follow the given steps -: 1- Go to  Host Desktop Screen  2- Press Home key + R and Type 'drivers' Then Press Enter. 3- Now Go to Folder etc < Hosts Then Then In the Host File please make an entry for - IP Address   |   Hostname   |  SID As - 192.168.1.5  ebs.example.com  EBSDB Important -:  Default setup for Oracle Vision Instance to connect database and Application  Host -  Host IP Address -   192.168.1.5  (It will be different as per network accordingly) Port -  Port Number       - 1521 SID -   Service Identification  -  EBSDB Note - You can also Explorer the path directly. Follow the given below directory for the same. C:\Windows\System32\drivers\etc “A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solut...

Definition of Lookup in Oracle Apps R12 Or What is Lookup in Oracle Apps R12? Or What is the main purpose of lookups in Oracle Apps R12? The main purpose of a lookup is to keep programs flexible and easier to configure. Lookups are an approach of creating a configurable “list of values” in E-Business Suite. One of the simplest examples of a lookup type is gender. A “gender lookup” will have definitions as shown next: Code       Meaning M             Male F              Female U             Unknown Suppose that there is a table for employees named PER_ALL_PEOPLE_F and it has the following columns: FIRST_NAME LAST_NAME DATE_OF_BIRTH GENDER The screen that displays an employee’s gender will display a value of Male, Female, or Unknown. However, the database column PER_ALL_PEOPLE_F table. GENDER will store a value of M, F, or U. Hence, the screen displays the meaning, whereas the dat...

What are the differences between system, extensible, and user lookup types in Oracle Apps R12? OR Type of Lookups in Oracle Apps R12 User Updating of the start date, end date, and enabled fields are allowed Deletion of codes is allowed Updating of the tag is allowed Insertion of new codes is allowed Extensible Insertion of new codes is allowed Updating of the start date, end date, enabled fields, and the tag is allowed  only  if the code is not 'seed data' Deletion of codes is allowed  only  if the code is not 'seed data' Updating of the module is  not  allowed Deletion of lookup type is  not  allowed System Insertion of new codes is  not  allowed Updating of the start date, end date, and enabled fields are  not  allowed Deletion of codes is  not  allowed Updating of the tag is  not  allowed Updating of the module is  not  allowed Deletion of lookup type is  not  allowed For more detail...

FND (Foundation) Basic Table Name in Oracle Apps R12  Basic Table List -: FND_USER FND_MENUS FND_FORM_FUNCTIONS FND_APPLICATION FND_APPLICATION_TL FND_CONCURRENT_PROGRAMS FND_CONCURRENT_PROGRAMS_TL FND_CONCURRENT_QUEUES FND_CONCURRENT_QUEUES_TL FND_CONCURRENT_QUEUE_CONTENT FND_CONCURRENT_QUEUE_PARAMS FND_CONCURRENT_QUEUE_SIZE FND_CONCURRENT_REQUESTS FND_CONCURRENT_REQUEST_CLASS FND_CONCURRENT_TIME_PERIODS FND_CONC_PP_TEMPLATES_TL “A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For ...

How can create a User in Oracle Apps R12  or  How Can Assign a Responsibility to a User  1) Go to " System Administrator" > Security  > User > Define  2) Username -: As per User Number      Password - : Fill the password and press Enter then type again same password .     Responsibility-: Select Responsibility from LOV whatever you want to Assign to user .   Note-: If you will Assign System Administrator Responsibility to the User then a Indirect Responsibility Application Diagnostic  will assign automatically to user . 3) Now Save the form . Now your User Created . 4) Go to User Login form of Oracle Apps ERP 5) Login with your User Credential. 6) Change Your Current Password  Note -: It will ask to change the password at the time of first login . Save the New Password  Select Responsibility    Click on Any form and check   Now Your User are ready to do our Responsibility .  Fo...

Functional Security In ORACLE APPS User End user, using the application front end interface. Responsibility Privileges to the user. Menu Hierarchal arrangement of Sub Menus and Functions . Sub Menu Hierarchal arrangement of functions. Functions A Function calls a form. Form A Form is a GUI (Graphical User Interface). For More Information Visit on  www.OracleAppsGuide.com  Or Subscribe your email-id on OracleAppsGuide