Oracle Apps Technical Training In Hyderabad

Oracle Apps Technical  Training In Hyderabad

Our team of reliable oracle training experts, from RCP Technologies, helps in offering real time placement focused courses on Oracle Apps. Our courses include the basic level to advanced stage and these are designed to avail proper placement in multinational companies. Just after completion of our oracle training certified courses, availing jobs is an easy step to follow. You have the liberty to avail hands on experience from experienced working professionals and certified experts. We have made it a point to designed oracle application course syllabus and also content based on the prospective students and what they expect from a good training institution. There are some practical courses available too, apart from theoretical classes.

Time and duration

There is mainly 25 sessions and duration of each session is of 1 hour. In this hourly rate, people will come to know more about Oracle Application Training. Defined as the best Oracle Apps Technical  training in Hyderabad, we ensure to be by your side from start till end, unless you are completely satisfied with the service. Listed below, are the major modules or technical content course, meant for you.

Introductory note to ERP

  • Basic definition of ERP and with the overview of popular versions of ERPs
  • Comparison of applications with some of the other available ERPs
  • AIM document standards and app architecture
  • OA database structure and proper usage of TOAD

Various types of roles

There are primary four major forms of roles, which you are likely to come across, while dealing with Oracle Apps Technical  training, as a novice. Those four major roles are listed below, under different parameters:

  • Technical consultant with amazing roles
  • Functional consultant with proficient roles
  • Oracle apps DBA service with additional roles
  • Technical and functional consultant with related roles

App objects library

  • AOL or Application object library
  • System administrative servicing areas
  • Definition of app user and assigning some responsibilities to employees
  • AOL meaning along with its related components
  • WHO columns and creating responsibilities
  • Request for group creation and menu creation

Development of this Oracle application

  • Definition of concurrent programs and with parameters
  • Working with various multiple concurrent programs
  • Concurrent values on program incompatibilities
  • Creation of different request set
  • Default types and available value sets

Proficient registration of customized objects

There are three basic divisions, in customized object category of  Oracle Apps Technical  online training, as listed below. These can be further divided into small packages, for availing promising results.

  • Report registration service
  • Proficient use of AD_DD packages with the main aim to register database components as in AOL
  • Proper registration of table

Important sessions to follow

For providing the better understanding of our available training sessions, we have created some training contents. These are available under different module names:

Module 1:

  • Definition of ERP
  • Types of available data
  • Introductory note to oracle application

Module 2:

  • Functional roles and consultant
  • Technical roles and consultant
  • DBA with following roles
  • Various forms of projects

Module 3:

  • Architecture of oracle app
  • Database structure and with introductory note to rice components

Module 4:

  • AOL and system administration
  • Definition of app user with responsibilities
  • Creation of some responsibilities
  • FND tables and understands AOL with available components

Module 5:

  • Table registration of Oracle app
  • AD_DD package
  • Procedures of registering database tables in the available AOL module

Module 6:

  • Report registration and AOL module
  • Executable creation and definition of concurrent programs
  • Creating any form of request groups
  • Relevant application for AOL module

Module 7:

  • Registering to parametric report in available AOL module
  • Introductory note to report parameters
  • Various forms of parameters and create value set
  • Types of value set to default

Module 8:

  • Proficient development of any report from the start like clients wants
  • Defaulting report style
  • Customizing of standardized reports

Module 9:

  • Introductory note to forms
  • Form registration method in the field of oracle application

Module 10:

  • Creation of functions in AOL module
  • Creating new menu
  • Oracle application default menus

Different divisions under conversions

Conversion plays a pivotal role when the main concern lies with Oracle Apps Technical  training institutes in Hyderabad, which make people incline towards this service, accordingly. From us, you will get to know more about the overviews, as related to conversions and also the available difference between conversions and interfaces. Moreover, our team of expert professionals is also going to help you to work with the staging script o table and develop some amazing validation packages. There are some basic standards available, which need to be followed, while in conversion solutions. All these standards are now mentioned by professionals, who are related to this segment for more than a decade now.

More about discoverer tool

Discoverer tool is another plus point while dealing with oracle application training session. Through our discoverer tool, you will get to know more about the introductory note of this tool and discoverer administrator. Moreover, if you are lucky enough, you will also get to know more about proficient steps to create EUL and business areas. There are some other amazing subjects, which are also incorporated with this package. Those are discoverer desktop and creation of wok books.

You have the liberty to ask our professionals about any queries, as related to this field. Moreover, you will also get to come across with conversion projects, which are incorporated in the same course. For any more additional knowledge, our hotline number is available 24 hours in a day and 7 days, in a week. Just get acquainted with us immediately, and you will get to know more about Oracle Apps Technical  online training in Hyderabad, without going through any problem or hassle.

Reliable professionals for your help

We ensure to appoint only reliable professionals for our job. They are not just learned in the field of Oracle application, but you can ask them for any queries, related to oracle programming language. These professionals are also helpful in offering you with the practical hands-on training session if needed. You are devoid of paying any extra money for that, as, for some packages, these training are already included with the chosen option. These training sessions are available online to match the growing needs and demands of customers.


Oracle Apps Technical Classroom Notes:


ERP (Enterprise Resource Planning)

E-Machine, Companies, Time, Man



Oracle Applications is one of the ERP Tool, we have different type of Tools

1. SAP

2. Micro soft ERP

3. JD Ed wards

4. People soft


Major Clients like






They are implemented oracle applications software for their business transactions, when the clients want to implement the oracle applications then client will interact with the S/W developers company like IBM, INFOSYS, WIPRO, GENPACT, MANINDRA, SATYAM, ……

 To implements the oracle applications, three consultants are required

1. Oracle Apps Functional Consultant

2. Oracle Apps Technical Consultant

3. Oracle DBA

1. Oracle Apps Functional Consultant:-

The IBM Manager (or) developers sent oracle applications consultants to the ‘HUTCH’ Client locations when he reached in the client locations he will understand the below things (or) Points

i. Analyzation Business requirement

ii. Understanding Business Functionality

iii. Understanding the daily Business transactions

iv. Understanding the Materials & items of different categories

v. Understanding the Multiple Organization and set of books(Currency, Calendar, Charts, graphs and Account)

vi. Understanding employee information of the company like



*Increments …….etc

vii. Gathering the business relate a documents

viii. We have to analysis gap B/W old S/W to new S/W

ix. Analyzation of multi-organization structure, in case, if he wants to start his business in another country

x. Preparation BR 100, MDO 50,CV040, TEO10, …..etc

xi. Preparation of user training documents

xii. The functional consultant will send document MDO50, CVO40, documents to develop the component as per business requirements

xiii. Understanding the business functionalities setups, data flow diagrams, gaps analysis

BR100 – Business Requirements

MDO50 – Module Documents

CVO40 – Conversions

TEO10 – Testing documents

xiv. Interactive with Clients

2. Oracle Apps Technical Consultant:-

i. Receiving the functional design documents from the functional consultant like MDO50, CVO40 …..

Through mail (lotus notes (or) Micro soft outlook)

ii. Understanding the MDO50, CVO40, documents. If we have any issues in this, documents then we will dieses with the functional consultant either “Telephonic conversions or mail and chanting”.

iii. After completion of issues, we will prepare the technical design documents MDO70, CVO60, MDO20, MDO/20

R –Reports –MDO70


C-Conversions – CVO60

E –Extensions FROMS_MDO70_EF

iv. After approving this documents with the functional consultant then we will start development of RICEF Components developments / customization.

v. Writing the packages, Procedures, functions SQL Queries, SQL *load EAM SQL reports and developments / customize for files log forms

vi. Moving application related(Value sets, Concurrent programs, executables, request, groups, profiles, flex fields) from one instance to another instance using FND load command MDORO) like development instance to test instance and test instance to production to the reporting manager

3. Oracle Apps Database administrator (DBA):-

1. Installation oracle applications software either client or components developments location(off share or ON site)

2. Changing the date from one instance to another instance development / Test /Production

3. Applying the patches

4. interacting with the functional and technical consultants or user when they raised request for any system or S/W problems ETX tools

5. Creation of responsibilities, user names, security, Backup maintains

[sociallocker] P-1




Types of projects:-

1. Implementation projects

2. Supporting projects

3. Customization & Up gradation project

4. Migration projects

1. Implementation projects

Whenever clients want to implement as the oracle apps 11.5.10 then will go for setup, DFD (date flow diagrams), GAP analysis will be taken for the functional consultant we will pick up the legacies system(SAP) that will the oracle Apps

Before (After purchasing the oracle S/W from the oracle corporation which will not have any data in the data base, its means empty application

Here the developing the components reports, interfaces, conversions, forms after completion of these that goes to live (go live) (user location)

2. Supporting projects:-

After completion of implementation, we will have an agreement with the client to give application support

3. Customization / Up gradation Projects:-

If we want to add new modules (or) customization of exists modules then we will go for customization / up gradation projects

4. Migration projects

R11.05    –     oracle 8!    –   Repots 6!     Forms 4.5

R11.5.3    –     Oracle 9!   –   Repots  6!      Forms 6!

R11.5.4   –              –                              –               –

R11.5.5   –               –                             –                –

R11.5.6    –               –                            –                –

R11.5.7     –            –                             –                –

R11.5.8   –                –                            –            –

R11.5.9    –              –                              –          –

R11.5.10    –    oracle log            reports log        – Form log

R.11.5.10  — DAF








OAF—Oracle Applications Framework

BPEL- Business Process Execution Language

ADF- Application Development Framework

OBIEE – Oracle Business Intelligence Enter praise Edition

Whenever we are migrating from old version to new version then we will go for migration project

FINANCE                              MAINFACTURING             CRM                                      HRMS

Account public(AP)            Purchasing(PO)           Mobile Processing              CORE HR

Acct Receivables(AR)                     Order mg (OM)              Service contracts                  Payroll

General Ledger(GL)          Inventory(INV)              Installed based                   SSHR

Fixed Assets(FA)               Bill of Material(BOM)    Oracle lease MGT             OTL

Cash MGT (CM)            Working process(WIP)    Teleservices                          advance benefits

Project Accounting    Pricing Quality dying




FND-Languages tables:-

This is language specific folder when we have developed forms and reports we will transfer into US folder this folder will be available in FND-LANGUAGES TABLES

Select * from FND-LANGUAGES;







Select * from FND _LANGUSGES


From this statement, we can identify the language of our application


This will have (only synonyms, we will) customer related objects we are not creating any custom top

Oracle corp developers were not going to create custom to while implemental oracle apps they will create patches to override functionality in customs

Apps Schema:-

Synonyms, we will not create tables in apps schema, we will create table in PO/ AP/GL etc based on synonym from apps schema we will take grant to access the tables and indexes, views it will  transferring its apps schema

PO Schema:-

It will have tables indexes, views, sequences, clusters, objects




1. Apps Schema will have only synonyms

2. PO, PA, ARGL, OM, INN, HRMS, CRM ——- extra will have tables, Indexes, views ……… sequences

3. We have nearly 4050 schemas

4. Here table name and synonym names same

5. By using synonym from Apps Schema, we can access tables, views, indexes from other schemas like PO, GL, OM

6. We will create table in PO Schema,

7. We will give grants to apps schema, that we will grant to (or) connect to apps schema

8. We will create synonym in apps schema

9. We will create synonym in Apps Schema

10. By using AD_DD register packages, we will register table

11. By using AD_DD. Column package, we will register column





Application implementation Methodology:-





This will be AIM 3.02 is provided by oracle corporation while implementing (or) supporting oracle applications

We will download the documents like MD 70, CV40, MD20, MD120 from this to

Function Design Documents            Technical Design Documents

BPO-30-Data gathering requirement                    —

BPO-80-Furure process Model                                 —-

BPO-100- Setup documents                                      —-

RDO-20- Current Business document                    —-

RDO40- Business volumes and metrics                 —-

TEO40- System Test script                                        —-

MDO50- Functional design document( for            MDO 07

Reports, forms, interfaces, EXTensions,            technical design document

Gaps, workflows, OA framework, ADF,


CVO40 – Conversions                        CVO60

—-                        Technical design documents

MDO20-Migration document

—-                        MDO20-(Testing document)


Desing document from the functional consultant based on that we will prepare that technical design doc(Reports, Forms, Interfaces, extensions, gaps, workflows, OA frame work, ADF, BPL, and OBEE+)

We will receive that CVO40 for conversions based on this we will prepare CVO60 document

Multiple Organizations Flow




Setup books:-



*Chart of A/C

*Profit, less, balance sheet

Legal Entity

*Tax, we have to pay on behalf of supplies

PO, AP, AR, OM, CM Operating unit

*Company transactions

INV BOM, WIP —————->(INV organization)Keep trialling)

*Sub INV organ

*Stock locations

*Items (Store)

Mozilla on desktop

Double click on Mozilla on desktop given

user name— OPERATIONS

Pass word  — WELCOME

Select the system administration responsibility (double click)

Select the security : user .click on

Define in the same page

In yellow box

We have to give user name: Batch-2-use

Password: Oracle apps  Oracle apps

In the bellow Box

Responsibility: Sys administrator %

: Application Developer %

: purchasing %(locator)

+ save button

(logout Exit oracle apps from file

—–>Agin into the Mozilla, its asked


The change password as ur window ()

CE Password = Oracle Apps

New Pass word = XXXXX

Re-enter new pass word = XXXX

Agin Exit from file (logout)

Again login into Mozilla: – Batch 2 –user

: – Oracle apps



*Create a report builder and write a query after that execute then save

Select * for fdn user

*Copy the report filename next go to

D:/Oracle / via apps/ Po/11.5.0/ reports us

In this path paste in

*Go to system administrator responsibility in Mozilla (Select)

*In the same page Concurrent: program Executable”

EX: User-Details

SN: User-Details

App: Purchasing

EM: Oracle Reports (whatever ur wise the method)

EFN: User-details

Create a Report with Parameter

Same as well as creation new user

TOKEN is case sensitive

It is open on Big Value step

Group2 group control F11

Q: -How to register the concurrent Program (Or)

How to register in oracle Apps?

A.1.Develop the report as per client requirement

2. Transfer the file into custom top


PO-TOP \11.5.0\Reports\us

3. Attach report file name to the Executable window

4. Executable will be attached to the concurrent program

5. Concurrent program will be attached to the request group

6. Request group will be attached to the responsibility

7. After that, we’ve to submit our request in SRS window

Types of Execution Methods:-

Execution Method:-

The execution method can’t be changed once the concurrent programs in the concurrent programs window

The Possible Execution Methods are:-

1. Host: -The execution file is a host script

2. Oracle Reports: -The Execution file is an oracle reports file

3. PLISQL stored procedure: -The Execution file is a PL/SQL stored procedure

4. Java Stored Procedure (JSP): – The Execution file is a JSP procedure

5. Java Concurrent program: -The execution file is a program written in Java

Next select Concurrent:-

Program —–>Define (Clicked)

Program Name: User details reports the USA

Short Name: User details

Application: Purchasing

Executable: Name: User-Details

Method: Oracle reports

Output:-Format: HTML

Style: A4 sheet

Then +Save

Again back page security —–>Response


Group: Batch 2-Normal Apps—Group



Type            Name            Application

Program        User details report    Purchasing


+ Then save

*From back page security —–>Responsibility

—->Definr (double click):- —->

Responsibility Name:- Batch-responsibility


Respo Key :- BR

Name: responsibility

Application: Purchasing

Menu: Prdefined menu as ur wise (‘@@@’)

Request group:- Batch2 – Group select

Appli :- Purchasing

Then + Save

+Cntrl ‘C’

—–>Back page security —->User —–>define:——>

User name(Press F11(to get existed data ):Batch-User

Press’ Ctrl F11’

Attached the (Batch2- Responsibility after 3 rows)

+Then eave & close

Go to file(select switch responsibility) —->Batch2-responsicility select

Go to view in tools menu

Select request (Alt+ N)——>

—>+Alt +’0’

Run this request: (Ctrl+Lo)

After select (Alt +M)


+Alt N

Go to Find Alt + I

Click a Refresh data (Alt+R)

Go to view click on that


6. MLS Function:-

The Execution file is a function (MLS Function) that’s supports running concurrent programs in multiple languages

7.SQL*Loader: -The Execution file is an SQL script

8. SQL*Plus: -The Execution file is an SQL* Plus script

9. Spawned: -The execution file is a ‘C’ (or) Pro *C program

10. Immediate: – The execution file is a program written to run as a subroutine of the concurrent manager we recommend against defining new immediate concurrent program and suggest you use either a PL/SQL stored procedure or a spawned ‘C’ program instead

11. Request set : – PL/SQL stored function that can be used

12. Stage Function: – To calculated the completion status of request set stages


Attached to the concurrent program executable

User in SRS:-

Check this box to indicate that user can submit a request to run this program from a standard request submission window (SRS)

Run alone:- (It self)

Indicate, whether UR program should run alone relative to all other, should run alone relative ti all other programs in the same logical database

Default Types: -Pass a default values

1. Constant

2. Current time

3. Concurrent time

4. Profile

5. SQL Statement

6. Segment

  Default types are used to display the default value


This default type is used display the default value

Segment: – It is used to get the previous parameter value as a default value ‘Note’ we have to give previous

Profile: -It is used to display profile value as default value

Current date: -Is used to display the current date of the display

Current time: -It is used to display the current time

Select* from EMP develop the query using “Select * from FND-User where creation –date between

: P-from-date and P-TO-Date”

Here reusing SQL statement us default type.

Select Min(Creation – Date) from

FND-User where(: P-To –Date)

Select Max(Creation-Date) from

FND-user where: P-50-date


Current program parameters with report builders bind variables

Note: -One executable can be multiple concurrent programs

If we don’t want to see concurrent program in SRS window we have to unchecked the check box called enable in concurrent window


(Who columns are created by, update by) go to help tool bar record history

Value Sets:-

Value sets are used to restricted user without entering invalid data as a parameter we’ve 8 types of value sets

1. None

2. Dependent

3. Independent

4. Table

5. Translatable Independent

6. Translatable Dependent

7. Special

8. Paid

1. Note:-

By using none value set, we restrict the numbers zero to nine & upper case letter A to Z

*Go to file switch responsibility

—->Application Resp



Enter the value set Name: None value ESET

Format validation upper case only


Agin login into system administer




*Define  +Ctr+F11

2. Independent value set:-

In login into application developer responsibility

Application —–> Validation ——>Set

Enter values

VSN: – Independent values

+ Save

Format validation Maximize =25

Go to agin Application —–>



We have created

Name: Indep-Value

Click on Fined button

Value        description

India         India        Ind is my county

USA        USA        USA is other country

PAK         PAK         PAK is our beside country

Go to file switch responsibility— Concurent – Prog Name—Define

Ctrl F11 – Create 5 row Indepent –value EXT

3. Dependent Value set:-

Without creating independent value set, we can’t create dependent value set Application

—->Validation—–>Value sets

VSN: Dept-Value set

Value Validation type: – Dependent

Go to edit information button

Idep VS: Inept -value set

Desption: IND is my country



Select value set*

Name: Dept values

Independent Value : India

Click on find button Select UAE

Value            Value        description







Go to file switch to responsibility sys




Special: -It is used to for only one segment to display list of values for key flex fields

Range: – This is used for range of data

Translated independent: -It is used to display transactional language value that should be independently

Translated dependent: -It is used for transactional language values, that should be dependently

Table Values: – Select * from fnd-user where user-ID: User ID

Save: Tabl-valu ESETi.RMB

Switch resp: App.developer

Application —->Validation —–>set

Format type: Number name.Table-value xts

Validation type: table

Table name: FNR-user

Type: Number


Creation of value sets(Method):-

In Report wizard SQL statement is

Select * from fnd-user where used id: user-ID


My computer: D:/oracle/vispps/po/11.5.0/reports/us then paste

Q: -Developing Table value set by using

Multiple Table:-

Report wizard: Supplier details in the title

SQLst: Select vendor

Select Pv.Vendor_Name, PVS.vendor-file-code from

PO-vendors PV.PO-Vendors site-All Pvs

Where PV.vendors-ID=PVS.vendors_IDAND

PVVendor-Name =: vendor name

+save rep as multi-table-value set

Request group: -Collection of concurrent programs





Oracle Applications:-




{+Ability it will not compatible with other concurrent programs}

{When user ‘A’ makes it on incompatibility, in that case, we cannot submit it the concurrent program up to user-A concurrent program starts is completes normally


Independently concurrent program will be running in spite of incompatibility has assigned to this user, he can also make it on incompatibility

User A, User B, User C:-

Above all these users are submitting concurrent program we will make it on this process only at client location, not our IBM company

Table Name:-

This is used to display the list of values based on conditions here we can add additional columns also, but Alia name is mandatory for Additional column name

1.    Develop the Report using

Select * from fnd-user, where

User –ID = : P-user –ID;

2. Go to application developer responsibility

3. Application ——> Validation —–>Set

Table name: fnd –user

Value: user-ID

Where/ order by: Where row number<15 order by username disc

Additional columns: user-Name, username —->Ali as name

Creation –data date—–>Ali as name

By using the Multiple Table:-

1. Develop the report using

Select PV.Vendor-name, PVS.vender-site – code from PO-Vendor PV, PO-Vendor-sites –all pvs where Pv .vendor-ID AND PV. Vendor-name = P-vendor-Name—–>This is w have to give in token field while creating the parameter in concurrent program

2.Go to Application developer responsibility

Application —–>Validation —–>set

Table Name: PoVendore PV, PO-vendor-sits-all file

Value: Vendor-name

Type: char

Size: 45

Where/ode by where PV.vendor ID =PVS.vendorID = PVS.vsndorID

Additional:PVS.vendor-site-code vendor site code

Text ——>Click on

To test

It uses enters lower than low values from the data base values which display the error message based on range of data

Develop the repot using select * from fnd-user where user –ID

Between: P- from-id and : P-to-id

Transfer some values next-next finish save this file desktop batch2-normal apps then save move into us folder login into system administrator

Concurrent —–>Program —–>executable

Executable: Range-report

Short name: range-Report

Appli: Purchasing

Create executable after that can enter the defailts a concurrent window go to parameters

SEQ Parameter


select the range low

create another parameter for 2 user id

[2] yy-To-ID

Select the range is [high]


After that save then after that

*Security – Responsibility

*Attach the request group our request window

*After that our request in SRS window

Purchasing Oder(PO):-

Whenever we want to purchasing the materials from the suppliers, then we leave to go for applications called purchasing order here sales company from the supplier, for his business purpose

Purchase order flow:-




*Whenever we want to purchase the materials from the supplier then we will the raise the requisition to purchase the materials from the supplier

*After that we will request for quotation (RFQ) from the supplier

After that, we will receive quotations from the supplier in which we will select best quotation based on equation we will raise the purchase order to the supplier to purchase the materials

    After that supplier will send materials along with receipt to our sales company

1. Requisition:-

i. Internal Requisition

ii. Purchase requisition

2. RFQ:-

i. Bid

ii. Catlog

iii. Standard

3. Quotation


ii. Catlog

iii. standard

4. Purchase order

i. Standard Purchase order

ii. Planned purchase order

iii. Blanket purchase order

iv. Contract purchase order

5. Receipt

i. Direct delivery

ii. Standard

iii. Inspection required

6.i. AP interface(A/C payable)

ii. INV interface




In the company, responsibility name will be for inventory-Inventory super user HYD

For purchasing-Purchasing super used-Hyd

Attached the three responsibilities our to user which are mention below

1. Purchasing vision operation (USA)

2. Inventory vision operation (USA)

3. HRMS management

Item management:-

*Go to inventory vision operations USA responsibility

*Select the responsibility

*Item-Master items-vision operations

Note: -Develop the reports requisition related purchase order

Item [Milk-Packet]

Description [This is a health product][]—->

It gives error

Click on that

LDD[  ]

+Then save     Invoice vorn[]

Select * from mdl-system item-b where

Segment1 = ‘Milk Item’

Item name description selects the inventory called

Check the check box called inventory

Purchase [] after that save

After that go to fools menu

Organization assignment

Link B/W PO and Requisition:-

PO-Req-distribution-all distribution-ID


Link B/W quotation & Requisition

EX:- AU[Select * from mt1-system –item-1]

CH[where seg1 = Milk-Items]

{Go to switch resp —–>HRMS

Go to people ——>enter and maintain}

*We can get item from different organization which we have assigned organizations

* Select * from MH-System-item-bMSY, ORG-organization-definitions OOD where mst.organization-ID = 000D

* Organization-ID and segment1 =’Milk-item’

*If we want to know primary key and foreign key of the table we can identity and foreign key of the table we can identity in apps developer responsibility

Apps —-> database —->table

Press[F11] —-> give the table name and press Ctrl+ F11

as same as Employee creation parameter

*develop report using parameter

*appl server (rfd file move in to appl server)

*System administrator —>Concurrent




Next go to  —–> request group



Log into —–>switch responsibility—–>HRMS

People ——> enter and maintain

—->Select [new] button

[Last ——        Gender—    action.create employment

First——-        Person type formation   Buy

Title——        Social security      must be 9 digits

Birth date—–                            ]

Go to back end[tool]:

Select  *from pe-all-people-F where last –name = ‘Ravi’

Go to system administrator responsibility —>Quest the

Username [Ctrl+ F11] attach employee to:

Where person [swami]field is available

—->select * from per-all-people-FPDF,

FND-user file where PPF.Person-ID = FU employee-ID

And Last- name like ‘% Ravi’

Go to Purchasing, vision operation(USA)

—->Supplier base —>supplier

Supplier base —–>supplier

Supplier Name [Haritage –Foods]

+Save —–>automatically supplier number is generated is 20028

Select * from PO-Vendors where

vendor – name = Alesitage- foods

—–>After that Click on sites button

Site Name [Hyd- Heritage]

Currency [INDIA]

Address [SR Nagar]

City [Hyd] State [A.P]


—->Click on contacts top

Last [Swami] First[Santha] +save

This is supplier name

Select * from Po- vendors where vendor-name= ‘Heritage –foogs’

Select * from PO-vendor-sites –all where

Vendor-site- code= ‘ Hyd- heritage’

Select * from Po-vendor –confacts where

Last-Name = ‘ Swami’

*If don’t know press F4 to see the select

Headers all

Po-requisition-headers –all



Go To Purchase, vision operation (USA)

Requisitions —–>Requisitions

Go to lines tab select the item number 5632

Num type   Item     Category      Qty     Price

1       good Milk-Item   ISC-MPS       20       500

Note: – Item Num 5632 this is automatically system generated

Organization [Vision operations]

Source [Supplier]

Location [Atlanta]

Client on distributions automatically system generated then[Save & Close]

Select * from PO- Requisitions-Headers-all where

Segment 1 = ‘5632’

Select *  from PO- Requisition –lines –all-where

Requisition-Header-ID =’56569’;

Select * from Po-Req-Distributions-all where requisition-lime-ID =’60480’;

Whenever we want to purchase the material from the supplier they we raise requisition

We are requisition to purchase the materials from supplier




Internal Requisition: – Whenever we want to receive the materials within the organizations then we will raise the “Internal Requisition

Purchase Requisition: – Whenever we want to purchase the materials from the outside supplier then we will raise the purchase requisition

Requisition Details Report:-

Requirement: – This report is used to know requisition details based on creation date, raised from specific buyer

Tables: – PO-Requisition –Header-all

PO-Requisition-Lines –all

PO-Requisition- Distribution-all



Parameters: – Creation data from

Creation data to

Req Num, Authorization stats, currently, UNE, Total amount, buyer name


1.    When you enter from and to value based on parameters those records only should be displayed

2.    If you do not enter from and to value all re-use should be displayed

3.    If you enter from any, value should be displayed greater than from values

4.    If you enter to only, values should display less than to value

5.    We enter a default values should be displayed for each running time

[No Data Found]

Cancel the requisition:-

Go to requisition summary after that enter the requisition number to press the’ find’ button after that

Go to tool menu ‘Control’ select button cancel the requisition select after that Click on the ‘OK’ button

Documents: – We can identify all documents below statement

Select distinct document –Type – Code from PO-document –Types- All


*RFQ(Request for quotation)


Sub-documents for –Requisition:-

Select distinct document-subtype from PO-document-type-all




1. Bid

2. Standard

RFQ Quotation:-

After requisition approval, we will prepare request for quotation that we want to the supplied, after that we will receive different quotation from the supplier in that we will select the best quotation based on that we will purchase the item

Go to “RFQ & Quotations” ——>RFQ’s


Go to Type —–>Select the standard RFQ

Buyer —–>Stock man, me, pat

Select the line number -1



Rev -0

UCM –each


Enter the terms and conditions

Click on the terms button

[Payment terms: 45 net items

Freight terms: Due

FOB: Origin

Note to supplier: [            ]   ]

Select the supplier button







PO-Lines –Locations- All


[Select *from PO-headers-all where

Type-lookup-code = ‘RFQ’ and segment =’30’

Select –ship-via-lookup-code,



From PO-headers-All.Where type –lookup-code =” RFQ’ and segment time =30

Payment terms will be entered due to date and interest


Freight Terms: – While receiving the materials from the supplier in the presence of transformations, if any materials are materials are damaged or miss matched those details entered we agreement with the supplier

FOB: Foot on Board: – The Supplier the bear the transportation on buyer will bear the transportation changes while receiving the materials through transportation


After creation of RFQ which will send to the supplier, supplier will send different quotation in that we will insert into the system

We have 3 types of quotations

1. BID

2. Catalog

3. Standards

1. Bid Quotation: – Whenever we are going to purchase large amount of materials from the supplier  we will receive bid quotation here we know quantity & delivery date, it doesn’t  have price breaks

2. Catalog: – Whenever we want to purchase the materials from the supplier regularly with fixed quantity then we will go for catalog quotations it will have price breaks

3. Standard Quotation:-

Whenever we want to purchase the material from the supplier only once then we will go for standard quotation here we don’t know quantity & delivery date

RFQ and Quotations (process steps):-


*Select  * from PO-headers-all where type –lookup-code = ‘QUOTATION’  and segment 1 = 500 and Quotation- class-code = ‘BIL

*Here segment1 is Quotation number, It will be generated by system when we save the transaction

Note: -Requisition number, RFQ number, Quotation number, will be stored in segment column and type-lookup-code should be like requisition, RFQ, Quotation, from PO-headers-all tables

Procurement: – Whenever purchase from the supplier after that we will pay the amount that is called procurement

Blanket: – Amount agreed (EX:10,000) up to closing amount still we have o par-closing the material

Purchase order: -After creation of quotations we will raise purchase order to purchase the material from the supplier here we will enter header details lines details and distribution details

1.    Terms and conditions: -This is one-time procurement tp purchase the materials from the supplier with “Terms and conditions” and this is also agreement between supplier and sales company

2.    Planned purchase order: – This agreement between supplier and company to purchase the item on specific date here we will rely upon the quantity

3.    Blanket Purchase order: -This is agreement between supplier and company to purchase  the materials up to contract is closed as per before mentioning in agreement we have to create the standard purchase order

Blanket PO, Contract PO:-

STOP      PLPO       BLKTPO              CTPO

Terms and conditions                     yes          yes             yes                      yes

Goode & Services knew                yes           yes          yes                      NO

A/C ting distribution                          yes           yes          No                           No

Delivery schedule                            yes            yes          No                        No

Quantity                                              yes           yes           NO                     No

Pricing knows                                       yes        yes              maybe           NO

Encumbrance                                      yes        yes        NO           NO

Encumbrance releases                   yes        yes        yes        No

Frontend Navigation: – Purchase vision operations go to purchase orders

Enter the supplier name:

Site name:

Buyer name:

Go to lines tab- select the item no, and Rev, description, UMO-each enter Quantity, price, promise date, need by date.

[ Select  * from PO-headers – all where segment1 = 4419

Select * from PO-Lines- all

•    Select PHA type –lookup-code, PLA.quantity, PLA. Unit-Price, from PO-headers-all PHA, PO-lines all, PLA where PHA.PO-header-PD, PLA.PO-header-ID and PHA.segment1 =4419

Go to shipment enter the promise date need by date

Go to distributions and then save if we want to know all summary details of the purchase order

Go to Purchase order

Purchase order summary

Give the PO number Click on Find button.

(PO-Headers-all(or) PO-Lines –all)


PO-Lines –all

PO-Lines location –all

PO-distribution all

Select PHA.TyPE-Lookup-code,

PLA.Quantity, PLA>PRICE,

FR017 PO- Header-all PHA,

PO-Lines-All PLA

Where PHA.PO-header-ID

And PHA.segment-11=4419

Purchase order details

Develop the data modeling using

Headers data:-

Select PHA.PO-Header-ID

PHA.segment1 PO number,

PHA.type lookup-code Potype

HR1.Location-code ship to,

HR2.Location – code Bill To,

Trunc(Phe.ceation-date) Cdate,

PPF.Full-Name buyer,

PV.vendor-name supplier,

PVS.Vendor-site-code supplier-site,


Supplier contact,

Pha.authorization-status PO-status,


PHA.Fieght-terms-lookup-code, for sight,

PHA.Ship-via-lookup-code carrier,

PHA.FOB-lookup-code    FOB,

From PO-headers-all Pha,

HR-Locations HR1,

HR-Locations HR2,


PO-Vendors PV

PO-Vendors- sites –all PVS,

PO-Vendor-contacts PVC

AP-terms Ap

Where PHA.segments =’4419’















(PLA.Quantity * Pla. Unit- price)line total

From PO-line-all Pla

MH-System-item-B MSI

Where PLA.item –ID= MSI.Inventory-Item-id

AND PLA>Og-id= MST.orgenization-id

SHIPMENT’S DATAPo-line-Locations-all)

Select P11.PO-line-id



HR1.Location-code, ship to location,

OOD.Organization-code ship to org,


PO-Line –Locations –all, PLL

HR-Locations HRL,

Org-organization-definitions OOD

Where PLL.Ship to –location-ID =HR1. Location_ID

AND PLL.ship to-organization-ID = OOD.organization-ID






PPF.FULL-Name requestor name,

FromPO-distribution-all PDA,

PER-all People-F PPF

Where PDA.deliver-to-person-ID = PPF.persion

Layout model:-

PO Number :[F1]                Buyer:[F7]

Potype:[F2]                        supplier:[F8]

Shipto:[F3]                          Site:[F9]

Bill to:[F4]            Contract[F10]

Creation Date:[F5]        Status:[F11]

Payment terms[F6]        notable:[F11]


Carrier :[F1]        FOB:[F14]

Line items   Desc    Qty    Price   ship no      chip to    Loc Qty    Dist Qty     Req

F15            F16         F14  F19           F20         F21               F22           F23           F24

2nd   Query            3rd Query         4th Query





Planned Purchase order and

Blanket Purchase orders

Will release the quantity, those fails will store in PO-Releases-all Table.

When Releasing the quantity revision number will be changed from 1 —– Exto

Po-Revision all

Will be generated based on operation(USA)-resp


Receiving – receipts

*Enter the purchase order number

*Click on find button

[ These receipt details will become INV models]

*We have 3 types of receipts

1. Direct delivery receipt

2. Standard receipt

3. Inspection required




Run the std concurrent program

Payables transfer to general ledger ——>

Direct delivery (2 ways matching): Purchase order Invoice—–>

Standard recipes (3 ways matching): Purchase order receipt invoice

Inspection required: Purchase receipt inspection invoice

Matching level will store in PO-line-loc table

*Go to PO vision operations (USA) responsibility

[Go to backend]

Select * from PO-line-locations-all

Select distinct receipt-required –flag

From Po-line-locations-all

Receipt required flag            Inspection required flag

N                                                 N-2 Ways

Y                                                  N-3-ways

Y                                             Y-4way

*The receipt table memes


RCV-shipment –lines


Receipt typea\s will store in RV-outing-head as

Select * from RSV-routing –Headers

Select *routing-name from RCV-routing-head ones

——>Go to PO, vision operation(USA)

Open the purchase order from [press F11]

Give the PO-number[   ] press[Ctrl+ F11]

Select shipments button below the window

Click on more tab we can find out matrw approval  levels

If you know the PO-number how to find receipt no

Select receipt-Num-from rev shipment-headers

Where shipment –headers –id in(select shipment –line id from rcv-ship lines where shipment –line-id in(select PO-header-ID from PO-heads-an where segment1  = 1005))

Note:-[To find net segment1 go for PO-headers-all]

Note: -We can identify the purchase order status is open, closed, finally closed

Select closed-code from PO-headers –all where segment 1=’NOKIA’


Purchase Order:-

Purchase order will be created by passing requisition numbers(Purchase mission operations)—->Select the auto created ——>Click on Clear button By passing select the requisition No.——> Next click on” Find Button(Document type: Select RFQ) ——>Click on automatic buy on—->Click on clear button——>Automatic RFQ details will be created by the system and no also generated

Creation of Purchase order using Auto create method:-

Select auto create in menu —–>Click on Clear’ button—–>Enter the Requisition, number (228) —->Click on ‘Find’  button —–>Select document type :Stand PO —–>Click on automatic button —–>Click on create button —–>Automatically PO number generated

Require Purchase order Matching level Report:-

Requirement: – By passing the purchase order number we can identify what are matching levels either 2-way or 3-way or 4- way

Supplier NO       Supplier Name    Supplier Site       PONO POAmt      Currency           PO_Type lou code

Note: – PO number should be retiving from table value set and additional column is vendor site code

NO-Data Found

Total Purchase orders —>

Registration Application:-

Create or replace PO-Details (ERR but vachar2, Ret code carchar2, P1-Parameter1, P2-Parameter2)

Local variable declaration(Cursor, reforms, PL/EQL Tables, PL/ SQL, Records, rested table, arrays, global var cable, Publish variable, private variable, pragmas, Exception)

Begin{we can call procedures, functions, raise applications, error, select, insert, update, Delete, commit, rollback, Bulk collect, Bulk Bind, dynamic SQL(Inner executable) } Exception (Outer executable exception)

[ Select, insert, update, commit, rollback, user-defined, Pre-defined, non-predefined, exceptions(When others then)]


Update-can’t fire the “NO Data Found Statement


Registration parameters:-

In oracle applications, two parameters are mandatory

1.    ERROR Buf

2.    RET Code

1. Error Buf: – This parameter is used to display error msg

2Ret code: -This is used to know the status of concurrent program

0-    Normal

1-    Warning

2-    Error

FND-File: – Instead of DBMS-output will use FNE-file API to display log file and out put file, messages

Ex:- fnd-file-put-line(rnd-filr.output)

Fnd-fie-put line(fnd-filr.log)

Find out the errors:- (for procedures & Function)

Select  * from user-Errors where

Name = ‘Quotation_Data-transfer’

AND sequence = 1,2,3

Create or Replace parameter:-(Reebuf out varchar, retcode out varxha2, V-id in Number)as

Cursor C1 is select PHA segment, Quote No, Initcap (PHA.Quote-Type-lookup-code 11’-‘ 11

PHA.Type-lookup-code)quote type,


Um(PLS.UNIT-Pice) Quotient,

H1.Location-code SHIPTO,


PPF.FULL-NAME BUYER, from PO-headers-all

PHA, PO-Lines-All PLA

Hr-Locations H1,









Group by

PHA. Segment 1,



Text c(PHA.creation-date),




L-Count number (9) default );


Delete from temp-Quote;


For C2 in C1 loop

l-count;= l-count+1;

Insert into temp-quote(Quotent mo, Qeotetype, date, Quotent, shipto, billto,buyge)Values

(C2.Quoteno, C2.Quote type, C2.Cdate, C2.Quotent C2.ship.C2. billto, C2.buyer);

End loop;


FND-File.put-line(FND-File.output, No of records transferred into table’



When others then

FND-file.put-line(FND-file.log,’Error occurred during data insertion

End data-transfer-Quote)

Create-table temp-Quote(Quoteno varchar(20),

Quotetype type   “

Cdate            date

Quotent       varchar(20)

Ship to         “

Bill to    varchar(20)

1. Copy the procedure name go to executable window, given the procedure name where executable filename is there

—–>Executable method PL/SQL stored procedure

2. Go to concurrent program window, sill all the required fields and click on parameter button, create parameter for V-id

3. Attach the concurrent program to request group

4. Attach request group to responsibility, after that we’ve to submit our request in SRS window

By using procedures in Oracle Apps:-

Create or Replace procedure PO-data(Errbuf out varchar2 Set code Varchat2)as

Cursor C1 is select PHA.segment1 PONUM,

PPF.Full-Name Buyer,

HR1.Location-code ship to

HR2.Location –code Bill to

Pha.Currency-code C Code,

PV.Vendo-name supplier,



Contact fro

PO-headers-all PHA


HR_Locations HR1,

HR_Locations HR2,

PO-vendors PV,

PO-Vendors-sites-all PVS,

PO-Vendor-contact PVC where

PHA.TyPE-lookup-code =’STANDRD’

AND UPPER(PHA.Authorization-status) = ‘Approved’

AND PHA.Agent –ID = PPF.Person ID





Cursor C2 is select PHA.SEGMENT 1 ponum,


MSI.segment2  item,

MSI.escription item desc,


(Mc.segment1 //’,’// Mc.segment2) Category,

(Pla.Quantity * Pla.Unit-Price)line tota

From PO-headrs-all PHA,

PO-Lines-all PLA,

HTL-system-Item-B MSI,

HTL-Categories HC where

PHA.PO-header-Id =Pla.PO-header-Id

AND Phatypr-lookup-code =’standard’

AND Upper (Pha.Authorization-status)=’Approved’

AND MSI.Inventory –item–id =Pla.Item-id


AND PLA.Category-ID=Mc.Category-ID


For C1 loop

Insert into PO-temp-headers values

(X1.Ponum,X1.buyer,X2.shipto,X1.CCode, X1.Supplier, X1.file, X1.Contact);

End loop;


For X2 into C2 loop

Insert into Po-temp-lines values




X2.ITEM desc




End loop;



When others then

Fnd-File.Put-line(Fnd-file.long.Eenr occurred durating data insertion);


Syntax:- Before changing create PO-temp-headers, PO-temp-lines tables,

Create table PO-temp-headers

(PO num    Varchar2(20),

Buyer         Varchar2(20),

Ship to    Varchar2(20),

Bill to        Varchar2(20),

CCode            “

Supplier        “

Site                    “

Contact          “

Create table PO-Temp-Lines

(Ponum        varchar2(20)

Line no          “

Item no             “

Item             “

Item desc       “

DOM           “

Category      “

Line total      “

After submitting the concurrent program, we have to check weather data is transferred or not into PO-temp-headers and PO-temp-lines tables

Acknowledgement PO-PVT program:-

Select *from all_errors where


SQL * Loader:-

In Oracle applications, we will use SQL * Loder program to transfer the data from data files to staging table or temporary table to complete the inter face program





Data Specific value:-

We will receive data file from the client which is in ’CSV’ format(Comma separate value) we will keep this file specific path this path we will mention in control file

Ex:- InExcel sheet:-

Ramesh     10-Jun-90    10    245    1    120H

Rahul          12-Jun-86    10    246    2    130b

Raju          13-Aug-85    20    247    3    140D

Control File:-It will be rejected by the record file is used to value date the records as for client requirement





(E NAME, JDATE, Dept no, sal Emp no, comm., location)

Log File:-

We can identify how?

How many records are rejected and how many records are skipped

Registration of SQL * Loder form in Oracle Applications:-

1. Transfer the data file into specific path which we have mention in control file, transfer the controle file into

D: Oracle/ Vis Appl/PO/11.5.0/bin

Data file saved into ‘CSV’ format

2. Control file saved into ‘Ctrl’ format

3. Copy the control file name (CTL we will not copy ) go to Executable give the control file name where execution file name is there

4. Select executable method as[SQL * loader] attach the executable to the concurrent program attach the request group attach the

*Request responsibility

*After that we’ve to submit our requesting SRS window

Bad file:- While inserting the records in to staging table by using SQL * loader program those error records will be transferred into bad file, like data type mismatch, records data errors

Discard File:-

Conditionally failed record will be transferred in to discard file, which loading the data into multiple tables by using “when” command those errors records will be available into discard file

May be duplicate values for primary key etc…..

Note: -To see the bad and discard file name click

View log: -Button in SRS window and there will be the file names

Example for SQL  * Loader:-

Data File:- Decode-data.txt

Space for all —–>, Raj gopal, A, 25000,+1, Rahul ao, Mr.A,7230, B,Porna Chanea ao, A, 11500,B Sadra,A, 13000,C

Method ii: -By using above data file we can create sequence for specific, default data types, conversions functions, calculations

Create the table:-

Create table decode table (Emp no varchar2(20)

E name         Vacha2(20)

Dept no          “

Grade             “

Sal                   “

Comm             “

Jdate                 “

Location varchar2(20);

Ctrole File :- (Control file)

Load data

Infile C:\decord.txt

Truncate into table decode table

Fileds terminated by ‘,’

Trailing null columns

(Emp no “ val”,

Ename “ Init cap (Ename);

Deptx10 constant “10”,



Comm!” (: Sal-5000)”,

Jdate Sysdate;

Location ‘decode (: Location, ‘A’,’Hyd’,

‘B’, ‘BAN’

‘C’, ‘CHAN’,


Copy the format to the executable file name and select executable method as ‘SQL*Loader’, attach executable program to the concurrent program, attach to the current program to the request group attach request group to the respuser finally submit request to the SRS window


SQL * Loader using parameter

A                          B                            C              D               E    F            G

1. Praveen           10-jun-05        10                 24000    1    125     Hyd

2.  Santha           11-mar-04        10                 25000     2    145     BANG

3. Anil                13-july-06        20    12500    3    146    CHIN(Data file)


Control File:-[Parameter –program.Ctl]

Load data


Truncate into table emp32

Fields terminated by ‘,’

( Ename    Varchar2(20),

Jdate        dates

Dept no        Varchar2(20),

Sal        Varchar2(20),

Emp no        Varchar2(20)

Comm         varchar2(20),

Location     varchar2(20),

Create this table

*Copy the control futer name executable

*Attach executable to the concurrent program

*In concurrent program specify parameter(81) and data type as 100 character for passing file path as parameter to concurrent program

*Concurrent program attach to request group

*Attach request group to responsibility

How to inserting Multiple data files into one table:-

Data Filr1:-

1.”Mr.Rajan, Bharatnagar”,10, 10-jan-10,15000,1500,150, Hyd,CLRK

2. Hari,10, 10-Jan-80, 15000,1500,150, Hyd, Clrk

3.”Mr.Satish, kumar,10, 10-Jan-97

Data Filez2:

4.”Ramesh, Kumar”,               “        “

5.”Rajesh, Babu”,                     “        “

6. Kiran, Kumar,                       “        “

Control File:-






(Emp No,

E Name,





How load the data into slaging table by using data file into control file:-






Item desc,

Item cost,

Item date)

Begin data

AS54999, computer item,1200,10-Jan-1999

F22000,test item,1350,19-jan-2005

Create or replace multip files(Emp no varchar2(20),

They have 3 types of insertions variable

1. Insert

2. Truncate

3. Append

1. Inset: -By loading the data into table, the table should contain empty table

2. Truncate: -It will the existing records permanently and load the new records

3. Append: -New records added to the existing records

Loading Data into Multiple tables:-





ENAME        POSITION(6:10)



WHEN DEPT NO != ‘   ‘


DNAME        POSITION(13:19))


124        OPERATIONS     10        FINANCE

1             SCOTT                 20        SALES





(EMPNO        POSITION(1:5),

Ename            POSITION(6:15),

DEPTNO         POSITION(16:17),

SAL                  POSITION(18:22)

JDATE            POSITION(34:36),

LOCATION        POSITION(37:45))


124         operations        10          25000       15-jan-2002        120         hyd

56236    sysadmin             10           12500   26-jun-2001         1650       CHN

2 35        user                                       2015623 11-mar-1999    120    hyd

Transfer the control file into ‘bin’ folder

Attach control file to the executable

Attach executable to the concurrent program

Attach CC program to the request group

Attach request group to the responsibility

Attach to the responsibility to the SRS window

In load:-Create table position-table (Emp no var char2(20))


Comments (4)

  • Chandra

    For Oracle Apps Technical, Functional, SCM and HRMS training this is best training institute in Ameerpet.I wish you all the best.

    August 18, 2015 at 4:36 am
  • Sinam Rao

    Looking for Oracle Apps online training.I have done B.Sc.(Comp. Sci.) in 2014, I have two years of a gap after 10th and before 12th, no gap in graduation some company’s don’t allow me due to the gap, I want Institute, who can give me better placement and training.

    please give the content of the syllabus and duration of the course.

    December 19, 2015 at 12:30 pm
  • Satya

    Need online training for Oracle Apps Technical.Please provide me the details.

    Thanks and Regards,
    Satya Garre.

    January 8, 2016 at 10:33 am
  • kumar


    Need online Training for Oracle Apps Technical along with PL SQL basics, kindly let us know


    October 22, 2016 at 4:35 am

Leave a Reply

Your email address will not be published. Required fields are marked *

Protected by WP Anti Spam