Oracle Apps Guide
A guide for E-Business suit
ORACLE APPS TRICKS AND TIPS
Continue Reading
Error
Support
Continue Reading
Functional Consultant
Guide
Continue Reading
Technical Consultant
Guide
Continue Reading

Disclaimer

OracleAppsGuide (OAG) is a dedicated platform for Oracle Apps R12, 11i, and Oracle Fusion, designed to facilitate knowledge sharing and real-world learning experiences. As an online knowledge hub, OAG serves both beginners and experienced professionals, helping them navigate assignments and gain practical insights. While we strive to provide accurate information and solutions, OAG is not responsible for any faults, failures, data loss, or errors arising from the implementation of shared knowledge. Users are advised to exercise caution and verify all actions before making changes to their instances. All copyrighted content, trademarks, processes, and images used on this platform are strictly for educational purposes. The responsibility for any modifications, errors, or system-related issues remains solely with the user. For professional guidance and expert insights, stay connected with OracleAppsGuide (OAG)!
Phone NumberWhatsApp
+1 509-494-3137Chat
+1 360-487-0533Chat
+1 541-948-3048Chat
+1 541-731-4255Chat
+1 509-901-6918Chat
+1 859-307-1799Chat
+1 812-265-3917Chat
+1 513-532-5675Chat
+1 317-392-2115Chat
+1 937-232-1200Chat
+1 405-414-4158Chat
+1 918-225-1364Chat
+1 602-460-0154Chat
+1 602-434-5628Chat
+1 770-432-6442Chat
+1 256-797-7789Chat
+1 478-737-7967Chat
+1 770-846-0623Chat
+1 678-760-5626Chat
+1 404-430-8975Chat
+1 505-265-2084Chat
+1 661-529-8436Chat
+1 916-236-9828Chat
+1 530-661-7462Chat
+1 209-232-1099Chat
+1 626-679-3399Chat
+1 805-300-2293Chat
+1 310-895-1839Chat
+1 818-326-0934Chat
+1 760-998-9351Chat
Continue Reading..

What is PO Module in Oracle Apps R12

What is PO Module in Oracle Apps R12? A Complete Guide


Introduction

The Purchase Order (PO) Module in Oracle Apps R12 is designed to simplify procurement and purchasing operations. It allows organizations to create, approve, track, and manage purchase orders efficiently. This module is integrated with other Oracle EBS modules like Inventory, Accounts Payable, iProcurement, and Sourcing, making procurement seamless across the enterprise.

In this guide, we will explore the key features, types of purchase orders, approval process, and how the PO module works in Oracle R12.

Key Features of Oracle PO Module

Feature

Description

Automated PO Creation

Converts approved requisitions into purchase orders automatically.

Approval Workflow

Uses AME (Approval Management Engine) and position-based approvals.

Multiple PO Types

Supports Standard, Blanket, Contract, and Planned POs.

Integration with AP & INV

Seamless connection with Accounts Payable (AP) and Inventory (INV) for smooth processing.

Supplier Management

Enables supplier qualification, sourcing, and negotiations.

Receiving Controls

Tracks goods received and manages returns.

Price Breaks & Agreements

Handles vendor pricing and long-term purchase agreements.

Types of Purchase Orders in Oracle Apps R12

 

PO Type

Purpose

Standard PO

Used for one-time purchases where the price and quantity are fixed.

Blanket Purchase Agreement

Used for long-term agreements with suppliers where items are purchased periodically.

Contract PO

A legal agreement with a supplier without specifying items and quantities.

Planned PO

A PO created for future purchases, where releases are required before ordering.


How the Purchase Order Process Works in Oracle R12

The PO module follows a systematic process from request to final payment.

1. Requisition Creation

  • Users create Purchase Requisitions to request goods or services.
  • Requisitions can be created manually or through iProcurement.

2. Purchase Order Creation

  • Approved requisitions are converted into Purchase Orders.
  • Buyers can create POs manually or use AutoCreate functionality.

3. PO Approval Process

  • PO goes through Approval Hierarchy (Position-Based) or AME (Approval Management Engine).
  • Approvers receive workflow notifications and approve/reject POs.

4. Supplier Confirmation & Dispatch

  • Once approved, POs are sent to suppliers via Email, Fax, or EDI.
  • Suppliers acknowledge and confirm delivery timelines.

5. Goods Receipt & Inspection

  • Received goods are verified against the PO in Oracle Inventory (INV).
  • Quality checks are performed before accepting the delivery.

6. Invoice Matching & Payment Processing

  • Invoices are matched with POs in Oracle Accounts Payable (AP).
  • Once verified, payment is processed to the supplier.

Key Tables Used in Oracle PO Module


Table Name

Description

PO_HEADERS_ALL

Stores Purchase Order headers.

PO_LINES_ALL

Stores PO line details (items, quantity, price).

PO_DISTRIBUTIONS_ALL

Stores charge account details.

PO_VENDORS

Stores supplier information.

PO_ACTION_HISTORY

Tracks approval and status changes.




“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 More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide .
Continue Reading..

Query to find Locked Object in Oracle Apps R12


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
     , b.object_type
     , a.locked_mode
FROM   ( SELECT object_id
              , session_id
              , oracle_username
              , os_user_name
              , locked_mode
        FROM   v$locked_object ) a
     , ( SELECT object_id
              , owner
              , object_name
              , object_type
        FROM   dba_objects ) b
WHERE  a.object_id = b.object_id;







“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 More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.
Continue Reading..

Query to find - Is an employer also a buyer or not in oracle Apps or How can check that employee is a buyer


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, 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 More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide
Continue Reading..

Terminology Used in EBS Oracle Apps R12


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 Application Implement (Reimplement) with the best-fitted design.

5- Rollout - Same Structure develops and design for another Operating Unit within the Busines Group is called Rollout. In this process, one operating unit works for other preceding operating units as a base.

6- Support - Support is the maintenance of Oracle Application after Implementation or GO LIVE of Oracle Apps.


Note -: Link for Oracle Application Implementation guide document.



“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 More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide
Continue Reading..

How can make entry for "TNSNAMES.ORA" on the local host for Oracle Application (In Oracle Apps R12).





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 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 More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide
Continue Reading..

Top 35 SQL Interview Question asked in Oracle Apps Technical Interview or SQL TOP 35 Frequently asked question in Technical Interview

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 Last 10-row output

select * from emp minus select * from emp where rownum <= (select count(*) - &Enter_row_num from emp);

7.    Use of Not in, Not Exists and /Department name without allocation of any Employee in it.
select * from dept where deptno not in (select deptno from emp);  

OR

select * from dept a where not exists (select * from emp b where a.deptno = b.deptno);

8.    To find 21 Max salaries?

select distinct sal from emp a where 21 >= (select count(distinct sal) from emp b where a.sal <= b.sal) order by a.sal desc;

9.    To find 11 Min salaries?

select distinct sal from emp a where 11 >= (select count(distinct sal) from emp b  where a.sal >= b.sal);

10.    To find the Nth maximum salary of an employee with a distinct function?

select distinct hiredate from emp a where &n =  (select count(distinct sal) from emp b where a.sal >= b.sal);

11.    Example of Left or right join

select empno,ename,b.deptno,dname from emp a, dept b where a.deptno(+) = b.deptno and empno is null;

select empno,ename,b.deptno,dname from emp a, dept b where a.deptno = b.deptno(+) and empno is null;

12.    To delete duplicate Records from Table 

delete from emp a where rowid != (select max(rowid) from emp b where  a.empno=b.empno);

13.    Use of Group by Function 

select count(EMPNO), b.deptno, dname from emp a, dept b  where a.deptno(+)=b.deptno  group by b.deptno,dname;

14.    Use of Mathematical Function in the query 

select ename,sal/12 as monthlysal from emp;

15.    Select all record "OR" 

select * from emp where deptno=90 or deptno=40;

16.    Select all record Using Less than and greater than.

select * from emp where deptno=40 and sal>1100;

17.    Use of "Not in" by example 

select * from emp where job not in ('SALESMAN','CLERK');

18.    Use of "IN" by example 

select * from emp where empid in('10','20','30');

19.    Select all records where ename starts with 'Sonu' and its length is 8 char.

select * from emp where ename like'Sonu___';

20.    Select all records where ename end with 'Chauhan'/Use of "%"

select * from emp where ename like'%Chauhan';

21.    Use of Count function

select count(MGR),count(sal) from emp;

22.    Use Formula in select 

select ename,(sal+nvl(comm,0)) as totalsal from emp;

23.    Select  any salary <15000 from emp table using a subquery

select * from emp  where sal> any(select sal from emp where sal<15000);

24.    Select  all salary <5000 from emp table using a subquery 

select * from emp  where sal> all(select sal from emp where sal<5000);

25.    Select all the employee group by deptno and sal in descending order.

select ename,deptno,sal from emp order by deptno,sal desc;

26.    How can I create an empty table emp1 with the same structure as emp?

Create table emp1 as select * from emp where 3=5;

27.    How to retrieve record where sal between 3000 to 7000? / Use of "Between"

Select * from emp where sal>=3000 And  sal<7000

28.    Select all records where dept no of both emp and dept table matches.

select * from emp where exists(select * from dept where emp.deptno=dept.deptno)

29.    How to use Union between two table 

(Select * from emp) Union (Select * from emp1)

30.    To find Intersect/Common attribute value 

(Select * from emp) Intersect (Select * from emp1)

31.     Use of "Minus"

(Select * from emp) Minus (Select * from emp1)

32.    Count the total sal deptno wise where more than 2 employees exist.

SELECT  deptno, sum(sal) As totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) > 2

33.    Example of Subquery 

SELECT * FROM   AP_EXPENSE_REPORT_HEADERS_ALL WHERE  EMPLOYEE_ID IN ( SELECT PERSON_ID FROM   PER_ALL_PEOPLE_F WHERE  EMAIL_ADDRESS = &Email_id )

34.    Example of Union 

SELECT PO_HEADER_ID FROM   PO_headers_all 
union 
SELECT PO_HEADER_ID FROM   PO_lines_all

35     Example of Function Like Sum, Avg, etc 

SELECT avg(RATE) from PO_headers_all




“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 More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide
Continue Reading..

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?







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 database columns reference the lookup via a lookup code.
If in the future your organization wants the users to see “Undisclosed” instead of “Unknown,” you will have to make a change to just one record in the lookups table via the lookup screen. By doing so, you will avoid having to update thousands of records in PER_ALL_PEOPLE_F. Your new lookup will look like the following:

Code       Meaning
M             Male
F             Female
U             Unknown


Here lies the power of the lookups; you do not need to modify thousands of records in a transactional table. A simple change via the lookup screen will suffice. Using the lookup screen, you can either create new custom lookups or modify existing lookups.


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 allowed
  • Updating of the start date, end date, and enabled fields are allowed
  • Deletion of codes is allowed
  • Updating of the tag is allowed
Extensible
  • Deletion of lookup type is not allowed
  • 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
System
  • Deletion of lookup type is not allowed
  • 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
The following table shows the differences between system, extensible, and user lookup types:

Brief, some pre-seeded lookups given by Oracle cannot be modified. For example, Oracle has a lookup type called a termination type as shown in the above figure. Oracle has some rules defined within the Payroll Engine program that read the value of a termination type code for employees before calculating their final salaries. Such lookup codes, if changed, can affect the logic within the Payroll Engine. For this reason, Oracle flags some lookups as system lookups, and the Lookup Entry screen will not let you modify those lookup codes.


How can a lookup type be directly attached to a flexfield segment to do validations in Oracle Apps R12?


To do this, create a value set of Table type that validates against FND_LOOKUP_VALUES using the desired lookup. In this manner, you can validate flexfield segments against lookup values.

The point here is that a lookup type cannot be directly attached to a flexfield segment to do validations; however, it is indirectly possible to do so.


Examples and use cases where we use lookups in Oracle Apps R12.

Example: Interfacing Data to Third-Party Systems

Sometimes there is a need to create a database view that becomes the source of information for data transfer to other third-party systems. You might have to put filtration rules in place; for example, for HRMS Extract, people with person types Employee and Applicant should be extracted. To achieve this, instead of hard-coding Employee and Applicant in the database view, you can do the following:

1-Create a lookup type XX_EXTRACT_EMPLOYEE_TYPES.
2-Add lookup codes Employee and Applicant to this lookup type.
3-In the database view, join the HR Person Types from HR Tables with FND_LOOKUP_VALUES for this lookup type.

So through this manner, Lookup also gives you the flexibility to change hard-code Value in Code.




“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 More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide 
Continue Reading..
Subscribe to: Comments (Atom)

OracleAppsGuide.com © Coprights 2013,