0

Query to fetch purchase requisition and purchase order details in oracle apps r12

posted on , by Adarsh

 SELECT hou.name ou_name, prh.segment1 requisition_num, prh.creation_date, prh.created_by, poh.agent_id, poh.po_header_id, poh.segment1 po_num, ppx.full_name Requestor_Name, prh.description Req_Description, auth_status.displayed_field authorization_status, prh.org_id, prh.note_to_authorizer, req_type.displayed_field type_lookup_code, prl.catalog_type, prl.blanket_po_header_id, ...

Read More
0

Query to Find Scheduled Concurrent Programs List

posted on , by Adarsh

 SELECT fcr.request_id ,   fcpt.user_concurrent_program_name   || NVL2(fcr.description, ' ('   || fcr.description   || ')', NULL) conc_prog ,   fu.user_name requestor ,   fu.description requested_by ,   fu.email_address ,   frt.responsibility_name requested_by_resp ,   TRIM(fl.meaning) STATUS ,   fcr.phase_code ,   fcr.status_code ,   fcr.argument_text "PARAMETERS" ,   TO_CHAR(fcr.request_date, 'DD-MON-YYYY HH24:MI:SS') ...

Read More
0

SQL Query to Find Lock Sessions in Oracle Apps R12

posted on , by Adarsh

SELECT s.inst_id,NVL (s.username, 'Internal') "User Name",m.SID,s.serial#,p.spid "DB OS Process",m.TYPE,DECODE (m.lmode,0, 'None',1, 'Null',2, 'Row Share',3, 'Row Excl.',4, 'Share',5, 'S/Row Excl.',6, 'Exclusive',lmode, LTRIM (TO_CHAR (lmode, '990'))) "Lock Type",DECODE (m.request,0, 'None',1, 'Null',2, 'Row Share',3, 'Row Excl.',4, 'Share',5, 'S/Row Excl.',6, 'Exclusive',request, LTRIM (TO_CHAR (m.request, '990'))) "Lock Request",DECODE (command,0, 'None',DECODE (m.id2,0, dusr.username || '.' ...

Read More
0

Query to find item Category in oracle apps r12

posted on , by Adarsh

Here below is the detail sql query to find the item category value in oracle apps.select MSB.segment1 ITEM_CODE,  MSB.DESCRIPTION ITEM_DESCRIPTION,     MCST.category_set_name,       MCK.CONCATENATED_SEGMENTS CATEGORY  from apps.mtl_system_items_b MSB,       apps.mtl_categories_kfv MCK,       apps.mtl_item_categories MIC,        apps.mtl_category_sets_tl ...

Read More
0

Oracle HRMS – Create Employee API

posted on , by Adarsh

hr_employee_api.create_employee API is used to create new employee with other important information as per the requirement. hr_employee_api.create_employee (p_hire_date                      => TO_DATE (’12-AUG-2023′), p_business_group_id=>fnd_profile.value_specific(‘PER_BUSINESS_GROUP_ID’) p_last_name                      => ‘ P_EMP_LAST_NAME ...

Read More
0

Oracle HR – Script for Adding phone details for Employees

posted on , by Adarsh

 The requirement was to add phone details ( Work phone number, work mobile number) a list of employees. We have implemented this using hr_phone_api Process Steps: 1. Create a temp table CREATE TABLE load_phone_tempASSELECT parent_id,phone_number work_phone,phone_number mobile_phone  FROM per_phones WHERE 1=2; 2.Load data from excel workbook to temp table using sql loader. Sample control file below. LOAD DATA INFILE * REPLACE INTO TABLE load_phone_temp FIELDS TERMINATED BY "," ...

Read More