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 MoreOracle 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 MoreHave 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 MoreCause : Apps account locked. Solution : unlock the Apps account in system using below command Sql > Alter user apps account unlock;
Read MoreWe 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 MoreSELECT 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 MoreSELECT 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 MoreBEGIN mo_global.set_policy_context(‘S’,84); END; SELECT project_number, project_name, :p_gl_period MONTH, ou.NAME org_name, (SELECT revenue_amount FROM pa_events_v pae WHERE pae.event_id = pee.event_id AND UPPER (event_type) = UPPER (‘Revenue’)) rev_amt, NULL inter_crev_amt, NVL ((SELECT…
Read MoreSELECT TO_CHAR(TRUNC(PE.CREATION_DATE),’MON-YYYY’) MONTH, (SELECT NAME FROM HR_ORGANIZATION_UNITS WHERE organization_id =ppa.carrying_out_organization_id ) Business_unit, PPA.SEGMENT1 PROJECT_NUMBER, PPA.NAME PROJECT_NAME, PPC.CUSTOMER_NAME CUSTOMER_NAME, XX_GET_AGREEMENT_NUM(ppa.project_id) AGREEMENT_NUMBER, (CASE WHEN ppc.customer_id in (22222,33333,44444,55555) THEN ‘Internal’ ELSE ‘External’ END)…
Read MoreSELECT d.customer_id, ppc.customer_name, d.agreement_type, d.description agreement_desc, d.CUSTOMER_ORDER_NUMBER, AGREEMENT_NUM,TRUNC(D.CREATION_DATE) AGGREMENT__DATE, TRUNC(D.LAST_UPDATE_DATE) AGREMENT_LAST_UPDATE_DATE, SEGMENT1 PROJECT_NUMBER, c.project_type, LONG_NAME PROJECT_LONG_NAME, ALLOCATED_AMOUNT, TRUNC(PPF.CREATION_DATE) funding_creation_date, TRUNC(PPF.LAST_UPDATE_DATE) funding_last_update_date, PPF.FUNDING_CURRENCY_CODE, PPF.PROJECT_CURRENCY_CODE, PPF.PROJFUNC_CURRENCY_CODE, PPF.PROJFUNC_ALLOCATED_AMOUNT, submit_baseline_flag FROM pa_project_fundings PPF, pa_projects_all…
Read More