ERPstuff - Oracle EBS Community

i want to find days between two dates

example

p_from_date = '2009/01/01 HH24:MI:SS'

p_to_date = '2009/12/09 HH24:MI:SS'

How i find exact days between these two dates.

Respected All, How to do call this report in Developer Suite 10g.This is built in 6i. I want to do this in Developer Suite 10g; declare d_where varchar2(5000); pl_id paramlist; MX integer; begin GO_BLOCK('EMP'); First_Record; If Not (:System.Last_Record = 'TRUE' And :SYSTEM.CURSOR_VALUE IS NULL) The...

Thanks Ahmad Bilal

I got what i needed.

And i also mind your suggestion.


Thanks again

I have developed a new report and i want to give access to a single user
Can i have to create new responsibility and assign that report to it, or some other way

Thanks

I have developed a new report and i want to give access to all users of AP to use this report.

How can i do that?

Thanks for your suggestion.

But to do that i need some help because without knowing nothing how can i prepare documentation for any module.




Thanks again??????????????

Dear All,
I am new in Oracle Apps. I am doing hard work to learn. Please give some link of Technical Reference Document or Book on Order Management or Purchasing Module.I would be very thankful to you

Dear Bilal,
Thanks a lot. Sorry for too much discussion on a little topic.
But i was confused.Now i have tried like that.I have done it very well and have found my results according to my requirements.
Now i have no confusion.


Again i am very thankful to you

Please check it out.I am doing like that i have master form name DTEST that contains Dept Table Columns. Second form is DTEST1 that contains Emp Table Columns and is in tabular form.I have a button on DTEST form and when_button_pressed trigger i have written this code Declare CURSOR C IS SELECT * FR...

No confusion Thanks a lot.

My requirement is that Master form is based on Dept Table and Detail form is based on Emp Table.I have two seperate forms one for Master and other for Detail.When i execute query on Master form suppose on executing query deptno 10 is displayed .When i click button to call Detail Form information sho...

I have created two forms one is master and other is detail .I have called detail form from master from .I want to create relationship between both forms.
Please make me solution.

Thanks

i am using Foms6i.There i want to run my forms through forms server
i want to configure forms server of 6i


i think now it would be clear

Sorry for creating confusion.Ya i am talking about DS6i . Installing DS6i
you can install application server 6i like Report Builder and Form Builder.
i want to configure that one.