Yearly Archives: 2021

TNS-01151: Missing listener name, APPS_XXX, in LISTENER.ORA

Problem Description: In Apps R12.1.3 cloning perl adcfgclone.pl appsTier configuration successfully completed and all the services started except listener service. when starting listener service listener process exists with status 1.…

Read More

Apps listener fails to start on cloned instance with TNS-12533

Apps listener fails to start on cloned R12.1.3 instance with the following error. Cause: This error occurs when a host names in the tcp.invited_nodes list is invalid Solution: Remove invalid…

Read More

Life 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 More

Query 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 More

Query 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

Query Project with Revenue Amount Along with Event Details

BEGIN 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 More

Query Project Unbilled Amount

SELECT 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 More

Query Project Agreement with Project Details.

SELECT 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

API to Check the Available credit On a Sales Order.

DECLARE l_header_id NUMBER; l_calling_action VARCHAR2 (200); l_msg_index NUMBER; l_error_message VARCHAR2 (2000); x_msg_count NUMBER; x_msg_data VARCHAR2 (200); x_result_out VARCHAR2 (200); x_return_status VARCHAR2 (200); BEGIN l_header_id := 885421; l_calling_action := ‘BOOKING’; x_msg_count…

Read More

API TO CANCEL PO invoice

API TO CANCEL PO invoice AP_CANCEL_PKG.IS_INVOICE_CANCELLABLE: —- CREATE OR REPLACE PROCEDURE XXDOYEN_INV_CANCELLABLE (p_inv_id IN NUMBER) is v_boolean BOOLEAN; v_error_code VARCHAR2(100); v_debug_info VARCHAR2(1000); begin v_boolean :=AP_CANCEL_PKG.IS_INVOICE_CANCELLABLE( P_invoice_id => p_inv_id, P_error_code =>…

Read More