Wednesday, 3 July 2024

Package Getting Hung While Compiling

›
get the locked objects: SELECT s.sid,       s.serial#,        l.lock_type,        l.mode_held,        l.mode_requested,        l.lock_id1   ...
Thursday, 7 December 2023

Oracle Objects Being Accessed by Programs/Users

›
Objects Being Accessed: select client_identifier,program,state,object,module, action,s.*  from gv$session s , gv$access a  where status=...
Wednesday, 2 February 2022

DB Lock in the Oracle Objects

›
 SELECT object_name, machine, s.sid, s.serial#, s.* FROM gv$locked_object l, dba_objects o, gv$session s   WHERE l.object_id = o.object_id A...
Tuesday, 6 April 2021

Flexfields server-side validation package report error. virtual_value_set() exception : ORA-06502: PLSQL numeric or value error: number precision too large column#x

›
First of all we need to understand that this issue is coming from a seeded package. i.e. fnd_flex_server1 In this package you can search wit...
Sunday, 21 February 2021

Check Rollback Blocks Post Concurrent Request is Cancelled

›
  SELECT inst_id,          usn,          state,          undoblockstotal                     "Total",          undoblocksdone     ...
Wednesday, 28 October 2020

End Date a Responsibility For an FND User(Backend Script)

›
 DECLARE     v_user_name             VARCHAR2 (100) := 'ROHAN_RAJPUT';     v_responsibility_name   VARCHAR2 (100) := 'AR XX Supe...
Friday, 11 September 2020

ORA-04061: existing state of has been invalidated ORA-04061: existing state of package body "package name" has been invalidated

›
Ideally this error comes when the package in question is Invalid but sometime we see this error even if our package is Valid. Instead of get...