To achieve this you need to create a small package and run a query : Package Specification : CREATE OR REPLACE PACKAGE get_user_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2; END get_user_pwd; / Package Body: CREATE OR REPLACE PACKAGE BODY get_user_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE ...
In Oracle, you can create an autonumber field using sequences. A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.Syntax :The syntax to create a sequence in Oracle:CREATE SEQUENCE Sequence_Name MINVALUE value MAXVALUE value START WITH value INCREMENT BY value CACHE value;Example :CREATE SEQUENCE XX_PO_SEQ MINVALUE 1 START WITH 1 ...
Query to get concurrent program run details in oracle apps
SELECT DISTINCT c.USER_CONCURRENT_PROGRAM_NAME, round(((sysdate-a.actual_start_date)*24*60*60/60),2) AS Process_time, a.request_id,a.parent_request_id, a.request_date, a.actual_start_date, a.actual_completion_date, (a.actual_completion_date-a.request_date)*24*60*60 AS end_to_end, (a.actual_start_date-a.request_date)*24*60*60 AS lag_time, d.user_name, a.phase_code, a.status_code, a.argument_text, a.priorityFROM apps.fnd_concurrent_requests ...
In Oracle purchasing 3 different events occur1. Enter Purchase Order: No accounting takes place2. Enter a Receipt: For Inventory, Asset and Expense Items: Dr: Inventory Receiving A/c Cr: Accrual A/c3.Receiving Transaction: Based on type of item here accounting entry differs Inventory Item: Dr: ...
Query to get details of XML/BI Publisher Template and Data Definition
SELECT XDDV.data_source_code "Data Definition Code", XDDV.data_source_name "Data Definition", XDDV.description "Data Definition Description", XTB.template_code "Template Code", XTT.template_name "Template Name", XTT.description "Template ...
Query to find the output file name and path
SELECT outfile_name output_file_pathFROM fnd_concurrent_requestsWHERE request_id = :p_request_ ...