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 MoreApps 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 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 MoreDECLARE 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 MoreAPI 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