Showing posts with label Reports. Show all posts
Showing posts with label Reports. Show all posts

How to Find all RTF Report Details Query

›
SELECT   a.user_concurrent_program_name AS user_concurrent_program_name,          va.execution_file_name short_name,          va.executa...

How to Generate a Trace file in Oracle Reports

›
Trace enable RDF Report function BeforeReport return boolean is   CURSOR c_program_id(p_request_id IN NUMBER) IS SELECT concurrent_progr...

How to add a new concurrent program with Custom Request Group through script

›
DECLARE BEGIN FND_PROGRAM.ADD_TO_GROUP    (     PROGRAM_SHORT_NAME  =>'CONA_CREDITORS_LEDGERS'    ,PROGRAM_APPLICATION =...

How to Find Request Group and Application for Concurrent Programs

›
SELECT FAT.APPLICATION_NAME,FRG.REQUEST_GROUP_NAME,FCP.CONCURRENT_PROGRAM_NAME PROGRAM_SHORT_NAME,FCP.ENABLED_FLAG ,(SELECT USER_CONCURRE...

How to Registration PL SQL Stored Procedure Report in Oracle apps

›
STEP 1: Create PROCEDURE CREATE OR REPLACE PROCEDURE APPS.XX_ITEM_REPORT (    errbuf             OUT      VARCHAR2,    retcode        ...

How to eliminate particular rows in RTF

›
<?for-each:G_ICODE?><?if: CF_OPENING_QTY !=0 and RECEIPT_QTY !=0 and ISSUE_QTY !=0?> <?CF_OPENING_QTY?> <?RECEIPT_QTY?...

How to Convert Number to Word in Oracle Report Builder

›
function CF_11Formula return Char is    NumberIN float:=round(:CF_1,2);      InvalidNumberFormatModel                     EXCEPTION;      PR...

How many concurrent program or request will be runing ?

›
SELECT r.request_id, u.user_name requestor, pt.user_concurrent_program_name,        r.phase_code, r.status_code, r.priority_request_id, r.p...

Oracle Reports Builder Query

›
1.      What is a Lexical Parameter? Lexical parameters are used to substitute multiple values at runtime and are identified by a precedi...