Posts

How to Remove a Session Lock or Kill a Blocking Session

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...
Post a Comment
Read more

Credit Memo REST API not working or working partially solution

Image
  /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.  
Post a Comment
Read more

RTF function for QR code in report ( works only with Oracle Fusion )

Image
RTF function for QR code in report  ( works only with Oracle Fusion ) syntax : <?qrcode: fieldname; size; UTF-8?> Example : <?qrcode: PHOTOB64; 100; UTF-8?> ---------------------------------------------------------------------------------------------------------------------- For document for QR code in EBS click following link http://rehmansql.blogspot.com/2024/06/qr-code-generate-from-oracle-plsql.html
Post a Comment
Read more

Excel Report Output Extra cells and new row Issue Solution

Image
Use This XDOFX function in Loyout template to solve the Issue <?xdofx:replace(replace(field_name, CHR(13), ' '), CHR(10), ' ')?> example : <?xdofx:replace(replace(po_description , CHR(13), ' '), CHR(10), ' ')?>
Post a Comment
Read more

EBS R12 Query to GET Username and Password

-- 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...
Post a Comment
Read more

Customer transaction AR Invoice Creation Inbound OIC Integration

Image
  AIM customer transaction Creation  Inbound Using OIC deployment Instructions   Integration Required Files Link Author: MD Abdul Rehman Creation Date: JUNE 05, 2025 Last Updated: Version: 1.0 Title, Subject, Last Updated Date, Reference Number , and Version are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents.  When you change any of these values, be careful not to accidentally delete the bookmark.  You can make bookmarks visible by selecting Tools->Options…View and checking the Bookmarks option in the Show region. Approvals: <Approver 1> <Approver 2> To add additional approval lines, press [Tab] from the last cell in the table above. Copy Number _____ You can delete any elements of this cover page that you do not need for your document.  For example, Copy Number is only required if this is a controlled document and you need to track each copy that you distribute. Document Con...
Post a Comment
Read more