Script to Bounce EBS Middletier in EBS 12.2
In an earlier version of EBS (R12 and 11i) – restarting middle-tier services is quite simple though application running in multiple nodes. Starting from EBS 12.2, OACORE, FORMS and OAFM…
Read MoreQuery to find the HSN Summary
Introduction: This report will display the HSN summary details. SELECT ‘HSN Summary’ inv_type ,hsn_data.supp_gstin s_gstin ,hsn_data.period inv_period ,hsn_data.item_nm item_name ,hsn_data.hsn_sac hsn_sac_code ,hsn_data.uom_code trx_uom_code ,SUM(hsn_data.trx_line_qty) trx_line_quantity ,SUM(hsn_data.taxable_amt) taxable_amount ,hsn_data.SGST_RT SGST_RATE ,SUM(hsn_data.SGST_AMT)…
Read MoreJournal Entry Report for Audit purpose
Introduction This will displays the journal entry details SELECT DISTINCT –LEG_ENT.COUNTRY, (select DISTINCT HRL.COUNTRY from apps.XLE_ENTITY_PROFILES LEP, apps.XLE_REGISTRATIONS REG, apps.HR_LOCATIONS_ALL HRL, apps.gl_ledgers gl, apps.HR_OPERATING_UNITS HRO where LEP.TRANSACTING_ENTITY_FLAG = ‘Y’ and…
Read MoreScript to collect all the required information for understanding the Concurrent Processing workload on a system
REM HEADER REM $Header: cp_analyzer.sql v1.01 MCOSTA $ REM REM MODIFICATION LOG: REM REM MCOSTA REM REM Consolidated script to diagnose the current status and footprint of Concurrent Processing on…
Read MoreQuery to generate Baseline Script for a SQL_ID in Oracle Database
Please use the below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format…
Read MoreSteps to Export and Import AWR Stats
Please find the steps to export and import AWR stats. Exporting AWR snapshot data:- ***************************** SQL> @?/rdbms/admin/awrextr.sql AWR EXTRACT **************************************************** This script will extract the AWR data for a range of snapshots into a dump file. The script…
Read MoreSteps to Backup and Restore Java Classes and Privileges only in Oracle Database
The following SQL script, when run as user SYS, will generate an ordered script to recreate all the java grants, and java policies, assigned to users. It does not generate…
Read MoreFunction to find the audit time take for the expenses
Introduction: This will displays the Audit time taken for expenses CREATE OR REPLACE FUNCTION TIME_TAKEN(P_REPORT_HEADER_ID IN NUMBER,P_AUDIT_COMPLETE_DATE IN VARCHAR2,P_CLAIM_APPROVED_DATE IN VARCHAR2) RETURN VARCHAR2 IS LS_AUDIT_TAKEN VARCHAR2(100):=0; BEGIN SELECT SUM((TO_DATE(B.CASE_TIME,’DD-MON-YYYY HH24:MI:SS’)-TO_DATE(B.End_Dated_time,’DD-MON-YYYY…
Read MoreQuery to extract AP unpaid invoices details
Introduction: This will displays all the unpaid invoices details select hrou.name Operating_Unit, api.invoice_num Invoice_Number, decode(aid.MATCH_STATUS_FLAG, ‘A’,’Validated’, null, ‘Never Validated’, ‘N’, ‘Never Validated’, ‘T’,’Validated’, ‘S’,’Needs Revalidation’, aid.MATCH_STATUS_FLAG) Invoice_Status, api.invoice_date Invoice_Date, aps.segment1…
Read MoreAP Paid invoices details
Introduction: The will displays all the Paid invoices details . Select “Operating Unit” ,”Invoice Number” ,”Invoice Date” ,”Supplier Number” ,”Supplier Name” ,”Supplier Site” ,”Supplier Pay Terms” ,”Supplier Payment Method” ,”Supplier…
Read More