Introduction: This script will help to extract the price adjustment not populated in order lines for the Customer have the Accrual in Trade Management Script: 1. Modifiers Exist For Customer,…
Read MoreBelow are the major Golden gate files and their locations. Reports (.rpt) /u01/doyen/goldengate/ogg/dirrpt Parameters (.prm) /u01/doyen/goldengate/ogg/dirprm Replicat Checkpoints (.cpr) /u01/doyen/goldengate/ogg/dirchk Extract Checkpoints (.cpe) /u01/doyen/goldengate/ogg/dirchk Process Status (.pcs) /u01/doyen/goldengate/ogg/dirpcs SQL Scripts…
Read MoreHere are the differences between data dictionary views and V$ views, in Oracle. Data Dictionary Views : 1. Data will not be lost even after the instance is shutdown .…
Read MoreSELECT DISTINCT glp.period_num, glp.period_name, glp.period_set_name, sts.start_date, sts.end_date, sts.closing_status, gsob.set_of_books_id, sts.set_of_books_id sts_sob_id, plcy.legal_entity_id, glp.period_year FROM gl_periods glp, gl_period_statuses sts, gl_sets_of_books gsob, gmf_fiscal_policies plcy WHERE glp.period_set_name = gsob.period_set_name AND glp.period_type = gsob.accounted_period_type…
Read More1. Remove Oracle OLAP API: *************************** @?/olap/admin/olapidrp.plb @?/olap/admin/catnoxoq.sql @?/rdbms/admin/utlrp.sql select comp_id, comp_name, version, status from dba_registry where COMP_ID=’XOQ’; SELECT object_name,object_type,owner FROM dba_objects WHERE status = ‘INVALID’; alter public synonym DBMS_CUBE_ADVISE…
Read More1. Remove Oracle Text: *********************** @?/ctx/admin/catnoctx.sql drop procedure sys.validate_context; select comp_id, comp_name, version, status from dba_registry where COMP_ID=’CONTEXT’; SELECT object_name FROM dba_objects WHERE status = ‘INVALID’; 2. Remove OLAP Analytic…
Read MoreWorking wit ORADEBUG utility for uploading SR to check on slowness:- ************************************************************************ connect / as sysdba Find OSPID using the below query:- select p.PID,p.SPID,s.SID, s.SQL_EXEC_START, s.SQL_EXEC_ID, a.sql_text from v$process p,v$session…
Read Moreselect Item_code ,Item_description ,round(Cost_in_Curr_Period,2)Cost_in_Curr_Period ,round(Cost_in_Comparison_Period,2)Cost_in_Comparison_Period ,round((Cost_in_Comparison_Period-Cost_in_Curr_Period),2)Cost_Varaice ,decode(Cost_in_Comparison_Period,0,0,(round(((Cost_in_Comparison_Period-Cost_in_Curr_Period)/Cost_in_Comparison_Period),2)*100)) Cost_Varaice_prec ,ORGANIZATION_CODE ,Current_period ,Comp_period from(select msi.SEGMENT1 Item_code ,msi.DESCRIPTION Item_description ,nvl(cst.ACCTG_COST,0) Cost_in_Curr_Period ,nvl((select cst1.ACCTG_COST from gl_item_cst cst1 ,gmf_period_statuses gps1 where 1=1 and cst1.INVENTORY_ITEM_ID=cst.INVENTORY_ITEM_ID and…
Read MoreFor all large-sized organizations, month-end close is a crucial process. The management expects the finance department to publish the results at the earliest possible. However, the department has a dependency…
Read More