How to enable debug log in Oracle apps EBS
--Run the below query before running test case and note down the sequence number
SELECT MAX(LOG_SEQUENCE) before_seq
FROM FND_LOG_MESSAGES;
--Run your test case
--Run the below query after running ...All Posts
Query to find and remove Oracle database locks
-- Use below query to find locked objects
select
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine
from
v$locked_object a ,
v$session b,
dba_objects c
where
b.sid ...PL SQL full form
PL SQL full formpl full form in sqlpl and sql full formfull form pl sql PL SQL full form-PL/SQL stands for Procedural Language/Structured Query Langua...
Oracle Apps Procure To Pay Cycle (P2P Cycle)
Oracle Apps Procure To Pay Cycle (P2P Cycle)p2p cycle in oracle appsp2p cycle in oracle apps r12p2p cycle in oracle apps r12 techno functionaloracle e...
Oracle Apps Order Management Tables
Oracle Apps Order Management Tablesorder management tables in oracle apps r12oracle order management tablesom tables in oracle apps r12Oracle EBS Orde...
How to add AME role and responsibility to user
How to add AME role and responsibility to user in oracle appsAdd AME responsibilityAME setup in oracle apps r12AME workflow in oracle appsapproval man...
How to get JioFi Battery Low Notification on Windows
How to get JioFi Battery Low Notification on WindowsGet JioFi Battery NotificationJioFi battery notifierJiofi Low Battery Notification for windows/ Wi...
Oracle form attached to which responsibility
SELECT function_id,USER_FUNCTION_NAME, FUNCTION_NAME, form_name
FROM fnd_form_functions_vl fff, fnd_form ff
WHERE fff.form_id = ff.form_id
and form_name='OEXOEORD'Query to get workflow details
SELECT *
FROM (SELECT workflowitemeo.item_type,
workflowitemeo.item_key,
workflowitemeo.root_activity,
activityeo.display_name process_name,
...Oracle SQL PLSQL Interview Questions
Oracle SQL PLSQL Interview Questionsinterview questions for oracle apps technicalpractice sql for interviewbasic interview questions in sqlexercise sq...
Query to find serial number material transactions details
-- For serial controlled and non-lot controlled items
SELECT mmt.transaction_id,
msn.serial_number,
mmt.inventory_item_id,
(SELECT segment1
FROM mtl_system_items_b
...SQL query to get MIME type for file extension
SELECT :file_extension file_extension,
DECODE (
:file_extension,
'.aac', 'audio/aac',
'.abw', 'application/x-abiword',
'.arc', 'application/octet-stream'...