How to restrict the absence type list of values in Oracle Self-Service Human Resources.
Q: How to restrict the absence type list of values in Oracle Self-Service Human Resources. Q: Steps to restrict Absence
Continue readingCategory: Impratant Queries
Oracle SSHR Absence Transactions, Selfservice transactions – where did my data go?
When Oracle build Self Service they treated it as a new front-end of the system. To be able to use
Continue readingQuery to get Absence Detail Employee wise
Query to get Absence Detail Employee wise. Approved Absence details. SELECT papf.EMPLOYEE_NUMBER,papf.FULL_NAME,pat.NAME absence_type, paa.date_start leave_start_date, paa.date_end leave_end_date, paa.absence_days, paa.abs_information_category, paa.abs_information2,
Continue readingOracle HR and Payroll Related Queries
Oracle EBS/Apps R12. ( Oracle HR / Payroll ) Important Queries Note: All following queries are customized and may not
Continue readingQuery to find out info from PR to PO
Oracle EBS R12 Query to find out info from PR to PO select distinct u.description “Requestor”, porh.segment1 as “Req Number”,
Continue readingQuery to find out PR and PO linked
Oracle EBS R12 Query to find out PR and PO linked (Find PO information Against PR) select req.segment1,req.DESCRIPTION req_,req.APPROVED_DATE,po.segment1,po.CREATION_DATE,po.APPROVED_FLAG from po_headers_all
Continue readingOracle EBS R12 Administrator and Concurrent Related
Oracle EBS R12 Administrator and Concurrent Related Query to Find Responsibilities assigned to particular user. SELECT b.responsibility_name NAME FROM apps.fnd_user_resp_groups
Continue readingSCM Queries
Oracle EBS R12 Purchasing, Inventory, Order Management Qureies To Find Duplicate Item Category Code SELECT category_set_name, category_concat_segments, COUNT (*) FROM
Continue readingFormula Details
Oracle Apss R12 OPM (Oracle Process manufacturing) Formula Base Tables and Detail of Products and Ingredients select a.FORMULA_ID,a.formula_no,a.FORMULA_DESC1,b.INVENTORY_ITEM_ID,c.description,b.organization_id,decode(b.line_type,-1,’Ingredient’,’Product’) Type from
Continue readingQuantity of Ingredients and Products
Oracle Apps R12. OPM Query to Find out Quantity of Products and Ingredients of all Batches in particular Month.
Continue readingConvert Number into Words
Convert Number into Words select ename,sal,to_char(to_date(sal,’J’), ‘JSP’) as converted_form from scott.emp ENAME SAL CONVERTED_FORM SMITH 800 EIGHT HUNDRED ALLEN 1600
Continue readingOracle R11, R12 Important Queries
Oracle R11, R12 Important Queries (Concurrent , Inventory, Purchaing , HR, Payrol , OPM) To Find Duplicate Item Category Code
Continue reading
Recent Comments