Simplifying Oracle E Business Suite

Hello and Welcome to "Simplifying Oracle E Business Suite". This blog is dedicated to share Oracle Apps Knowledge related to Oracle apps E Business Suite's Order Management, Procurement, Inventory, WMS, Supplier Scheduling, OSP, Sys Admin, Useful SQL Queries etc

Useful Links

▼

▼

Tuesday, October 14, 2014

FND Concurrent Request Status Codes and Phase codes Meaning

Monday, July 28, 2014

Complete Oracle P2P cycle

Lets do a complete P2P Cycle Step 1 ) Create Item Step 2) Create Requisition and Approve it Step 3) Auto Create RFQ Step 4) Create Q...

Tuesday, July 22, 2014

SQL Query to find out Parameters and Value Sets associated with a Concurrent Program

SELECT fcpl.user_concurrent_program_name "Concurrent Program Name", fcp.concurrent_program_name "Short Name", fdfcuv...

Monday, July 21, 2014

How to make a Oracle form 'Query Only'

There are many ways in which we can make a form Query only. We are going to discuss two 1) Using parameter QUERY_ONLY=YES 2) using F...

Important WF tables

WF_USER_ROLE_ASSIGNMENTS stores information about the direct and inherited assignments of users to roles in Oracle . WF_USER_ROLES sto...

Friday, July 18, 2014

R12 SQL Query to differentiate Customer and Suppliers Data

select * from ( select hp.party_number,hp.party_name,hp.status,decode(nvl(hpu.party_usage_code,hp.party_type),'ORGANIZATION','...

Important HRMS Tables

per_all_people_f This table is used to store employee related data. per_all_assignments_f This table store employee assignmen...

View web version

About Me

Mandeep

View my complete profile

Powered by Blogger.