Oracle Blogs

Oracle R12: How to Remove a Session Lock or Kill a Blocking Session When working with Oracle R12 , you may encounter situations where a database session blocks other users or processes. In such cases, you can identify the blocking session and terminate it if necessary. Step 1: Identify the Blocking Session Run the following SQL query to find the SID and SERIAL# of the blocking session. SELECT blocking_session, sid, serial#, event FROM v$session WHERE blocking_session IS NOT NULL; Sample Output BLOCKING_SESSION SID SERIAL# EVENT 125 240 56789 enq: TX - row lock contention Note: Record the SID and SERIAL# values from the output. These values are required to terminate the session. Step 2: Kill the Blocking Session Replace sid and serial# with the values returned by the previous query. ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE; Example ALTER SYSTEM KILL SESSION '240,56789' IMMEDIATE; The IMMEDIATE option requests Oracle to terminate th...

  /fscmRestApi/resources/11.13.18.05/receivablesCreditMemos/ If this REST API does not GET all the credit memo ... follow below steps. You can use GET operations to process standard credit memos. To use the Receivables Credit Memos REST resource for processing standard credit memos, you must enable the AR_STD_CM_REST lookup code. Here’s how to enable AR_STD_CM_REST : In the Setup and Maintenance work area, go to the Manage Receivables Lookups task. Query for the lookup type AR_FEATURES . Under AR_FEATURES , create the lookup code AR_STD_CM_REST and enable it.  

-- APPS SCHEMA --DROP PACKAGE get_pwd; only use if some different object exist with same CREATE OR REPLACE PACKAGE get_pwd AUTHID CURRENT_USER IS FUNCTION decrypt(key IN VARCHAR2, value IN VARCHAR2 ) return VARCHAR2; end get_pwd; / CREATE OR REPLACE PACKAGE BODY get_pwd AS FUNCTION decrypt_java(key IN VARCHAR2, value IN VARCHAR2 ) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt (java.lang.String,java.lang.String) return java.lang.String'; FUNCTION decrypt(key IN VARCHAR2, value IN VARCHAR2 ) return VARCHAR2 AS BEGIN IF user = 'APPSVIEWER' -- Schema from where password should not be shown THEN RETURN NULL; ELSE RETURN (decrypt_java(KEY,VALUE)); END IF; END; END get_pwd; / --GET username...

QUERY TO GET ALL INVENTORY ORGANIZATIONS IN OPERATING UNITS SELECT  LGR.NAME "Ledger"           ,   XLE.NAME "Legal Entity"           ,   HOU1.NAME "Operating Unit"        ,   HOU.NAME "Inventory Organization" ,   hou.organization_id,   MP.ORGANIZATION_CODE "Organization Code"    FROM HR_ALL_ORGANIZATION_UNITS HOU ,   HR_ORGANIZATION_INFORMATION HOI1    ,   HR_ORGANIZATION_INFORMATION HOI2    ,   MTL_PARAMETERS MP                   ,   GL_LEDGERS LGR                      ,   XLE_ENTITY_PROFILES XLE             ...

AIM : Update a field based on other fields or any other logic using server scripts  Groovy script  Groovyscript In this doc shows thw same using a exmple to SUPPLY CHAIN EXECUTION > QUALITY MANAGEMENT > QUALITY ISSUE In picture Based on yellow field we need to fill the green field Step 1 : Create a sandbox and enter into Applicaiton Composer Step 2 : Application Composer > ERP SCM cloud > Quality Issue > Server Scripts > Field Trigger script : if (QualityTypeName == "Non-Conformance - Work in Process") {     setAttribute("Workflow", 300000031016276) } else if (QualityTypeName == "Non-Conformance - Receiving") {     setAttribute("Workflow", 300000031016275) } you can find this workflow ids using report or using GET rest api /fscmRestApi/resources/11.13.18.05/qualityIssues/ Click save and close and publish the sand box.

DOCUMENTATION ON SANDBOX PERSONALIZATION Prepared by VAMSI GOVATHOTI ROLE: ORACLE APPS TECHNICAL CONSULTANT Contents A) What is a Sandbox? 2 B) Purpose of Sandboxes 2 C) Key Features 2 D) Why Use Sandboxes? 2 1. How to Customize (Enable or Disable) the Fields/Components in the Sandbox 6 2. How to Enable Direct Access from User Interface (UI) to the Desired Destination using an URL 9 3. How to Create “Role Based Access control” to particular Fields / Components 13 4. ‘More Tasks’ Tab to be renamed to 'Create' on Purchase Requisitions page. 18 5. By using Application Composer making field required in sand box 23 6. Personalization by using application composer 27 A) By using Application Composer creating new field in sand box 27 B) Creating of currency field with fixed choice list 32 C) Creating of currency field with dynamic choice list. 36 7. Creating a button in sand box 40 8. Creating a global function for runtime mess...