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

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

Complete relation Query for SLA(Sub Ledger Accounting _XLA), AP(Account Payable) and GL(General Ledger) Links in oracle apps r12  Or  Link Between AP(Account Payable), GL(General Ledger) and SLA(Sub Ledger Accounting _XLA) SELECT DISTINCT GJH.PERIOD_NAME, TRUNC (GJH.CREATION_DATE) GL_DATE,                 GJH.JE_SOURCE, GJH.JE_CATEGORY, GJH.CURRENCY_CODE,                 GJL.DESCRIPTION, GJL.REFERENCE_5, GJL.REFERENCE_10,                 GJL.ACCOUNTED_CR, GJL.ACCOUNTED_DR, GJL.EFFECTIVE_DATE,                 GJL.REFERENCE_1, GCC.SEGMENT1, GCC.SEGMENT2, GCC.SEGMENT3,                 GCC.SEGMENT4, GCC.SEGMENT5, GCC.SEGMENT6, GCC.SEGMENT7,                 AERLA.JUSTIFICATION, AERLA.PROJECT_NUMBER,             ...

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

Main Interface and Base table in Oracle Apps R12 GL Module (General Ledger Module tables in Oracle Apps R12) Interface Table Base Table gl_interface gl_budget_interface gl_je_batches gl_je_headers gl_je_lines gl_je_sources gl_je_categories gl_sets_of_books gl_daily_rates gl_balances gl_periods gl_period_sets gl_code_conbinations AR Module (Account Receivable Module  tables  in Oracle Apps R12) Interface Table Base Table ra_customers_interface_all   ra_contact_phones_int_all ra_customer_profiles_int_all hz_parties hz_cust_accounts hz_cust_acct_sites_all hz_cust_sit_use_all hz_party_sites hz_locations hz_party_site_uses hz_customer_profiles hz_organization_profiles hz_person_profiles ra_interface_lines_all ra_interface_distributions_all ra_interface_salescredits_all ra_customer_trx_all ra_customer_trx_lines_all ra_cust_trx_line_gl_dist_all ra_cust_trx_types_all ar_payment_schedules_all ra_batch_sources_All ar_vat_tax_all ra_terms ...