UPGRADE ORACLE APEX FROM 5.0.X TO 18.1
Current Setup : Apex Version : Oracle Apex 5.0 Webserver : ORDS Running on Apache Tomcat 9 DB Version : Oracle 12.2 • Step 1: Download Apex 18.1 from Oracle…
Read MoreAfter Upgrade to 12C utlrp got hang
We were performing database upgrade from oracle 11g to oracle 12c with Oracle Apps 12.1.3. We faced an issue where database upgrade took < 30 mins. However, it made huge…
Read MoreSQL Query to get Catalog and Non Catalog Po’s in Oracle apps
Introduction: Using the below SQL script we can get the Catalog and Non Catalog Po’s details from country wise. Script: SELECT TO_CHAR(TO_DATE(p.creation_date,’DD-MON-RRRR’), ‘Q’)AS MY_QTR ,TO_CHAR(P.CREATION_DATE,’RRRR’) POYear ,P.SEGMENT1 “PO Number” ,PL.LINE_NUM…
Read MoreQuery to get Bill Code details
Introduction:-This query will provide complete Bill Code and GL String details from Back end Code:- SELECT MSIB.SEGMENT1 Catalog_Item, MSIB.INVENTORY_ITEM_STATUS_CODE STATUS, MSIB.DESCRIPTION item_description,msib.PRIMARY_UNIT_OF_MEASURE UOM,IGC.SEGMENT5 “Account Segment”, (IGC.SEGMENT1||’.’||IGC.SEGMENT2||’.’||IGC.SEGMENT3||’.’||IGC.SEGMENT4||’.’||IGC.SEGMENT5||’.’||IGC.SEGMENT6||’.’||IGC.SEGMENT7||’.’||IGC.SEGMENT8||’.’||IGC.SEGMENT9)”GLC”, gl_flexfields_pkg.get_concat_description (igc.chart_of_accounts_id, igc.code_combination_id )”Code…
Read MoreQuery to get asset details in oracle apps r12
Introduction: This query will provide the complete asset details in oracle apps. We can use this query to develop the custom fixed assets reports in oracle apps and can extract…
Read MoreSQL Query to get CVR rule details from Oracle EBS R12
Introduction: A cross-validation rule defines whether a value of a particular segment can be combined with specific values of other segments.The same details we can fetch using the below code.…
Read MoreQuery to get Requisition without PO
Introduction: This script will provide all Requisitions Details from backend for without Po’s. Script: SELECT (SELECT NVL (short_code, NAME) FROM apps.hr_operating_units WHERE organization_id = r.org_id) org_code, r.segment1 “Req number”, r.authorization_status…
Read MoreCreate a new Request Group using API in Oracle apps
Introduction: Through the below script, we can create a new Request Group from back end. Script: BEGIN FND_PROGRAM.REQUEST_GROUP (REQUEST_GROUP => ‘System Administrator Reports’, APPLICATION => ‘CUSTOM’, CODE => ‘Run Collection…
Read MoreScript To Check The Techstack Component Versions in Unix/Linux Environment
Introduction: In this article, we will find the versions of Technology stack components like Forms, iAS, Framework, JDK, OJSP, Database, etc On Application Tier in Linux: Establish the needed environment…
Read MoreUser Notification Preference Updated to DISABLED in Workflow
Introduction: User’s notification preferences are being disabled in WF_LOCAL_ROLES table and the administrator is receiving email notification such as following: To SYSADMIN Sent 10-Nov-2011 14:25:32 ID 5208 What happens and…
Read More