Home » Applications » Oracle Fusion Apps & E-Business Suite » need help
need help [message #254164] Thu, 26 July 2007 01:05 Go to next message
preetinair
Messages: 10
Registered: November 2006
Junior Member
hi this is preeti iam new to apps and i want some information pls hlep


I have got some doubts in reports
1. what is the major diff b/w lexical and bind reference
2. In a report how to create multiple layouts.give me instructions to proceed
3.I have a report and I have to write a query in such away that if I pass parameter a one report should display and if i pas b the another report should display if it is possible how can we writhe query
4. what r user_exits in apps and where do we write in reports
icon3.gif  Re: need help [message #254187 is a reply to message #254164] Thu, 26 July 2007 02:09 Go to previous message
Arun1203
Messages: 78
Registered: September 2006
Location: Gaborone,Botswana
Member

Hi,

Some of the answers for your questions are as follows:

1. Differences Between Lexical and Bind References:


BIND VARIABLE :
-- Are used to replace a single value in sql, pl/sql
-- Bind Variables may be used to replace expressions in select, where, group, order by, having, connect by, start with cause of queries.
-- Bind reference may not be referenced in FROM clause (or) in place of reserved words or clauses.

LEXICAL REFERENCE:

-- You can use lexical reference to replace the clauses appearing AFTER select,from, group by, having, connect by, start with.
-- You can’t make lexical reference in a pl/sql statements.

2. User Exits

A user exit is a program that you write and then link into the Report Builder executable or user exit DLL files. You build user exits when you want to pass control from Report Builder to a program you have written, which performs some function, and then returns control to Report Builder.

You can write the following types of user exits:
* ORACLE Pre-compiler user exits
* OCI (ORACLE Call Interface) user exits
* Non-ORACLE user exits
You can also write a user exit that combines both the ORACLE Pre-compiler interface and the OCI. User exits can perform the following tasks:
* Perform complex data manipulation
* Pass data to Report Builder from operating system text files
* Manipulate LONG RAW data
* Support PL/SQL blocks
* Control real time devices, such as a printer or a robot

Example on User Exits

A small example on User Exits.

Let us say you want to print flex field information in one of your apps reports.

Then you use the following user exit to print the flex field information.

FND FLEXSQL

The syntax of using this user exist is as follows:

SRW.User_Exit(‘FND FLEXSQL
APPL_Short_Name=”GL”
Code=”GL#”
NUM=”:P_Struct_Num”
Output=”:P_FlexData”
Mode=”Select”
Display=”All” ‘);


Best Regards & Thanks,
Arun Reddy Cool ,
arunapps@gmail.com,
------------------------------------------
Oracle Apps Techno Functional Consultant,
Mobile:0026771287234,
Botswana

[Updated on: Thu, 26 July 2007 02:10]

Report message to a moderator

Previous Topic: Oracle bolt-ons
Next Topic: Parent/Child request
Goto Forum:
  


Current Time: Fri Dec 09 19:28:25 CST 2016

Total time taken to generate the page: 0.09306 seconds