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 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 MoreWe are living in a time where automation takes over the human workforce to simplify the process. Many businesses have started to adapt to this culture and are aware of…
Read More1. Overview This document talks about the steps to working with Oracle nested tables.Nested table is awesome feature of Oracle. You can create table inside a table, Which means one column can…
Read More1. Login to Oracle Enter User Name and Password and Click – Login SELECT System Administrator Responsibility and Press OK Button GO to Requests : Select -> Set Enter Request…
Read MoreUser reported that they are getting differences in GL and AR for particular accounts. we noticed that the user is comparing with the custom reports like AR ageing and GL…
Read MoreProactively support team has identified an issue with duplicate party id. Support team has worked with oracle to get a fix for the same.01_sop-cm_ora_gdf_01-data-fix-spain-and-poland
Read More