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
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
What is Implementation,Upgradation ,Migration,Reimplementation,Rollout,Support in terms of Oracle Apps R12 orDifference 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 -:
ImplementationUpgradationMigrationReimplementationRolloutSupport
1- Implementation - First Time implementation or fresh implementation of oracle application on the server is called Oracle Implementation.
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
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
Definition of Lookup in Oracle Apps R12OrWhat is Lookup in Oracle Apps R12?OrWhat 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:
What are the differences between system, extensible, and user lookup types in Oracle Apps R12?
OR
Type of Lookups in Oracle Apps R12
User
Insertion of new codes is allowedUpdating of start date, end date, and enabled fields is allowedDeletion of codes is allowedUpdating of tag is allowedExtensible
Deletion of lookup type is not allowedInsertion of new codes is allowedUpdating of start date, end date, enabled fields, and 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 module is not allowedSystem
How can add month in calendar or defining new fiscal year in oracle apps R12 OrHow can add an Adjustment Period in Calendar
Go to General Ledger ,Vision Operation (USA) < Setup
Then Setup < Financials < Calendars < Accounting
Now Query (F11) "Accounting" then press Ctrl + F11
Now Go to File < New and add a new line Accordingly .
