0

How to find password of a User in Oracle Apps R12 - (Decrypting Password)

posted on , by Adarsh

 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 ...

0

Create and Drop Sequences in Oracle

posted on , by Adarsh

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  ...

0

Query to get concurrent program run details in oracle apps

posted on , by Adarsh

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 ...

0

P2P Accounting entries in Oracle

posted on , by Adarsh

 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: ...

0

Query to get details of XML/BI Publisher Template and Data Definition

posted on , by Adarsh

 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 ...

0

Query to find the output file name and path

posted on , by Adarsh

SELECT outfile_name output_file_pathFROM    fnd_concurrent_requestsWHERE    request_id = :p_request_ ...