Display BOM in Hierarchy Tree Structure
Overview Bill of materials (BOM) is a centralized source of information used to manufacture a product. It is a list of the items needed to create a product as well as the instructions on…
Read MoreDisplaying Multiple Columns in Popup LOV
Overview This document explains how to display multiple columns in Oracle Apex pop up LOV. The following steps are to be followed to display multiple columns in the LOV. Technologies and…
Read MoreData Loading in Oracle Apex
Overview This document explains how to load from XML file into table using Data loading facility in Oracle Apex 21.1.1. Technologies and Tools Used The following technology have been used…
Read MoreIntegrating Web History JavaScript API’s with Oracle Apex
1. Overview This Document is used to implement Incremental search on Interactive report and Interactive grid 2. Technologies and Tools Used The following technologies have been used to achieve this…
Read MoreHow Oracle Apex can transform your Enterprise Apps?
Oracle Application Express or Apex is a modernized and advanced web-oriented software development tool explicitly designed to run on the Oracle Database. It can support multiple database editions of Oracle…
Read MoreHow does End-to-End Process Automation work for TTK Healthcare?
Have you ever wondered about the process of how an order reaches you? It is not a simple process of click, ship, and delivery. Time-consuming and mundane processes involving multiple…
Read Moreora- 01017- Invalid username/password log on denied
Cause : Apps account locked. Solution : unlock the Apps account in system using below command Sql > Alter user apps account unlock;
Read MoreLife At Doyensys – Buchupalli Gayathri
We at Doyensys, believe in the fact that every employee possesses their own set of strength and efficiency. It is those values of our employees that has kept us growing…
Read MoreQuery to Get Employee Leave Details in Project
SELECT PAPF.EMPLOYEE_NUMBER, PAPF.FULL_NAME “EMPLOYEE NAME” , PT.DESCRIPTION “LEAVE DESC”, TO_DATE(trunc(ei.EXPENDITURE_ITEM_DATE),’DD-MON-YYYY’) “DATE”, EI.QUANTITY “LEAVE HOUR”, PEC.EXPENDITURE_COMMENT FROM pa_projects_all p, pa_tasks Pt, pa_expenditure_items_all ei, pa_expenditures_all x, pa_project_types_all pta, pa_transaction_sources tr, hr_all_organization_units_tl o1,…
Read MoreQuery to Get AP Expense Report Made By an Employee
SELECT GSOB.NAME “SOB Name”, AEH.INVOICE_NUM “Report Number”, AEH.TOTAL, AEH.DESCRIPTION, PPX.FULL_NAME, PPX.EMPLOYEE_NUMBER, decode(AEH.WORKFLOW_APPROVED_FLAG,’S’,’SAVED’,’I’,’IMPLICIT SAVE’,’R’,’MANAGER REJECTED’,’M’,’MANAGER APPROVED’,’P’,’PAYABLES APPROVED’,’A’,’AUTO APPROVED’,’W’,’WITHDRAWN’,’Y’,’APPROVED’,’IN PROGRESS’) Status, (SELECT APPS.AP_WEB_POLICY_UTILS.GET_LOOKUP_MEANING(‘EXPENSE REPORT STATUS’, DECODE(AI.CANCELLED_DATE, NULL, AEH.EXPENSE_STATUS_CODE, ‘CANCELLED’)) FROM APPS.AP_INVOICES_ALL AI…
Read More