ERPstuff - Oracle EBS Community

Hi, I've a report of multiple indicators,in this report i've matrix consists of two groups (then indicators name and the time dimention),my problem is that when i tried to draw chat of indicator's value with time dimention i couldn't see any field in this groups (within the matrix). I've db oracle 1...

Hi,
Thanks for your reply.
I want the unique values for each column separately. The output will be like this :

IND_TIME_YEAR: 2007, 2008
IND_TIME_MONTH: 1,2,3,7,8
CON_ID: 123,234,345
GVN_ID: 098,087

Regards,

Hi,
I've a report query and i want to get the distinct values of each column in this query, is there a way to do this?
I've oracle 10g and reports 6i.
Regards

Hi, I've tried to manage four list items relateed to each other the countries,states,cities,areas. when i change the value in the first list the second list should populated with values related to the first list and the third list should populated with values related to the second list and so on. Th...

Hi, I've a form which contains items. when i chaged a list in this form at runtime some items should appear and some shouldn't,My problem is to get ride of the space between items i redrawing the items and this operation takes time. Is there any way to do this whith out redrawing the items. I've ora...

Hi, I'm working on database oracle 10g and form developer 6i. I have LOV returns the first name and the last name of the employees.If I press f9 and write the first letter (S for example)it brings the employees whoes first name begin with S, what i want is that after writting the first letter i want...

Hi, I'm sorry, there was a mistake in the question. What i mean is that I've got a data set: Location Deptno Ename NEW YORK 10 MILLER NEW YORK 20 FORD CHICAGO 10 KING NEW YORK 30 JAMES CHICAGO 20 ADAMS The goal is to have 1 row only per Deptno Result set should look like for deptno=10: Location 10 2...

Hi, I need some help on how to do this: I've got a data set: Deptno Ename 10 MILLER 20 FORD 10 KING 30 JAMES 10 CLARK 20 ADAMS The goal is to have 1 row only per Deptno Result set should look like: Deptno Ename1 Ename2 Ename3 10 MILLER KING CLARK 20 FORD ADAMS 30 JAMES Any Ideas? Thanks

Hello I have oracle developer 6i and oracle database 10g. In the report I want to display the chart's bars or the lines in different colors depending on the values. For example employee in sales department whose salary over 1000 $ and have commission will display in red color while the employees who...

Hello - I have oracle database 10g. I want to draw an organizational chart include the hierarchy of the employees in table emp, but i don't want to draw the hierarchy as a tree in SQL. I want to draw it as a diagram. example: KING / | \ JONES BLAKE CLARK / \ | | SCOTT FORD ALLEN MILLER | | | ADAMS S...

hi
i'd like to know how can i merge two hierarchical trees together.
for instnace to query for each deparatment all its employees with considering to the employees hierarchicy.

HELLO....
I WOULD LIKE TO KNOW How to retrieve LONG RAW image from Oracle 10G database table and put it in a control item due to a specific employee number.
regards
nadia

i don't have porblem in lexical parameter. my problem is like this: in group1 i passed a lexical parameter but in group2 i have a tree with no data link to group1, for example group1 contains depts and group2 contains emps but there aren't any data link and i want to appear for each dept it's emps a...

Thanks for your attention,
i'm facing this problem in oracle reports.

hi
i have a problem and i need some help. i'm trying to change the value of a field at excution time ,the problem is that i have two queries without any link between them and i want to change data the second query due to the data in the first query.
with regards