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 MoreIntroduction:-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 MoreIntroduction: 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 MoreIntroduction: 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 MoreIntroduction: 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 MoreIntroduction: 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 MoreIntroduction: 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 MoreIntroduction: 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 MoreIntroduction: In this article we will see how to determine the version of Berkeley Database in Oracle Unified Directory (OUD). Ways to determine the version: There are 3 known ways…
Read MoreIntroduction: Connections via the listener to an instance that is in RESTRICTED status or in NO MOUNT status may fail with TNS-12526, TNS-12527 or TNS-12528 even when supplying the credentials…
Read More