&nbs...
Tuesday, October 14, 2014
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 Quotation
Step 5) Auto Create PO and Approve it
Step 6) Receipt
Step...
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.column_seq_num "Column Seq Number",
fdfcuv.end_user_column_name "Parameter Name",
fdfcuv.form_left_prompt...
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 Form Personalization
Method 1: Using parameter QUERY_ONLY=YES
Lets...
Important WF tables
WF_USER_ROLE_ASSIGNMENTS stores information about the direct and inherited assignments of users to roles in Oracle .
WF_USER_ROLES stores associations of users with the roles of which they are members.
WF_ROLES...
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','CUSTOMER',nvl(hpu.party_usage_code,hp.party_type)) party_type
from...
Important HRMS Tables
per_all_people_f
This table is used to store employee related data.
per_all_assignments_f
This table store employee assignment related information and connected to per_all_people_f...
Subscribe to:
Posts (Atom)