testoag

Query to find Is an employee also a buyer or not In Oracle Apps R12? Query - SELECT pa.agent_id, papf.person_id, papf.employee_number, papf.email_address,        pa.category_id, pa.location_id, papf.effective_start_date,        papf.effective_end_date   FROM po_agents pa, per_all_people_f papf, hr_all_organization_units haou  WHERE pa.agent_id = papf.person_id    AND papf.business_group_id = haou.business_group_id    AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date                            AND papf.effective_end_date --AND    email_address = 'user@oag.com' --AND PAPF.EFFECTIVE_END_DATE > SYSDATE --AND HAOU.BUSINESS_GROUP_ID = 100 “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, Bu...

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...

Top 35 SQL Interview Question asked in Oracle Apps R12 Technical Interview  or  SQL TOP 35 Frequently asked question in Technical Interview       Frequently asked Technical (SQL) question in Oracle apps r12 -: 1.    To find EVEN NUMBER select * from emp where rowid in (select decode(mod(rownum,2),0,rowid, null) from emp); 2.    To find EVEN NUMBER select * from emp where rowid in (select decode(mod(rownum,2),0,null ,rowid) from emp); 3.    To find the 5th MAX salary select distinct sal from emp e1 where 5 = (select count(distinct sal) from emp e2 where e1.sal <= e2.sal); 4.    To find the 9th MIN salary in the emp table. select distinct sal from emp e1 where 9 = (select count(distinct sal) from emp e2 where e1.sal >= e2.sal); 5.    How can we use Rownum function/How can get output for first 10-row output select * from emp where rownum <= &Enter_row_num; 6.    How can get output for Las...

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...