Passing a value for date parameter from Oracle Forms to BIP

Advertisement

Hi
I have created a report with the following SQL query:
select
d_tables.d_seq,
to_date(d_tables.d_created) creation_date,
d_tables.d_created_by created_by,
d_tables.d_pk,
d_tables.table_name,
d_tables.comments
from
d_tables, d_applications
where
d_tables.d_ppk = d_applications.d_pk
and to_date(d_tables.d_created) >= nvl(:P_CRE_DATE_FROM, to_date(d_tables.d_created))
and to_date(d_tables.d_created) <= nvl(:P_CRE_DATE_TO, to_date(d_tables.d_created))
The parameters P_CRE_DATE_FROM and P_CRE_DATE_TO have been set up as date in BI Publisher with format dd-MMM-yyyy
The report works fine when launched in BI Publisher.
I want to call this report from Oracle Forms and I'm trying to pass the values for both the parameters. However, the report does not generate output based on values passed.
Does it have to do with datatype? Does anyone know a solution for this?
Kind regards,
Aparna

Advertisement

Thanks for your suggestion. I am already referring to the whitepaper and have integrated Forms with BI Publisher. The parameter passing is working fine for a varchar2 type of parameter. However, for a date type, there seems to be some problem.

October 11, 2015

Passing a value for date parameter from Oracle Forms to BIP

Hi I have created a report with the following SQL query: select d_tables.d_seq, to_date(d_tables.d_created) creation_date, d_tables.d_created_by created_by, d_tables.d_pk, d_tables.table_name, d_tables.comments from d_tables, d_applications where d_t

Sending Date parameter  from the form to Report

Dear Friend Hi everybody, I am sending the date parameter to my report through a form ,and my date format in the form and in the report as follow : DD/MM/YYYY but when I enter the date as 18/1/2004 the system pass this value as follow : 18-JAN-04 but

How do I set a NULL value for the parameter field

Hi I've another question. I'm going to set single values for parameter fields. // e.g. set today for StartDate parameter field fc.setCurrentValue("", "StartDate", new Date()); It should be possible to set a NULL value for date paramete

How to pass a date parameter from report builder query designer to oracle database

i'm using report builder 3.0 connected to oracle database. i'm trying to pass a date parameter in the query with no success, i don't know the exact syntax. I've tried : SELECT * FROM igeneral.GCL_CLAIMS where CREATED_BY IN (:CREATED_BY) AND CLAIM_YEA

Passing date parameter from forms to report

Hi, I'm using forms and reports 6i. I want to pass one date parameter from forms to reports. Using Add_Parameter(pl_id,'P_FROM_DATE',TEXT_PARAMETER,:FROM_DT); giving me error REP-0091- Invalid value for parameter 'P_FROM_DATE' This i think is because

How to make a subscription use the default value for a parameter

Hi everyone, I need to use the CreateSubscription method and have this new subscription use a default value for certain parameter. How can I do this?Hi Marianne, I have to create the subscription programatically, which is different from what you ment

How to invoke crystal reports from Oracle forms 11g R2 along with passing p

How to invoke crystal reports from Oracle forms 11g R2 along with passing parameter to it. how to pass parameters to crystal report, please help.how to pass parameters to crystal report, please help.This would entirely depend on crystal reports and y

Can't pass parameter from HTML form of multipart/form-dta type to JSP

I am using request.getParameter(passed variable name) to pass data from HTML form to JSP with no problem. WHen I try to pass data from HTML form of multipart/form-dta type to JSP as following: < form enctype="multipart/form-data" name="t

Getting an error while activating a planning area "Enter values for planning horizon From and planning horizon To for the storage time profile level"

Dear S&OP community, I am getting following error while creating a planning ares in a newly installed sandbox. "Enter values for planning horizon From and planning horizon To for the storage time profile level". This what I did... 1) Created

Developed VI for data input from a Serial RS485 S. Himmelstein 700 Series Signal Conditioner

Has any one developed a VI for data input from a serial RS485 connection with S. Himmelstein 700 series signal conditioner. Multiple displays and channels. Labview 2009Hi  I am using the same vi which you have suggested and i have selected proper com

Call an executable file from oracle forms 6i

Hello , i want to call a local .exe file from oracle forms 6i passing along a couple of parameters in the command line . Can anyone help me out here ? thanks C. Edited by: user539712 on Jan 21, 2011 11:55 AM Edited by: user539712 on Jan 21, 2011 11:5

Calling Java Script to open a Map (Like Google Map) from Oracle Forms 10g

Hello, We are on Oracle EBS rel 12, Forms 10g. We have a requirement of calling a Custom Map application (Like Google Maps) from Oracle Forms 10g. When the user enters the address like town, city, country etc and clicks on a button there should be a

Calling web service from oracle forms 10g

Problem Description: I'm following the steps as per the doc: http://www.oracle.com/technology/products/forms/htdocs/10gr2/howto/webservicefromforms/ws_10_1_3_from_forms.html to create a java stub to call external web service and then use java importe

Converting a business application from Oracle Forms 4.5 to Oracle Forms 6i

Which is the best configuration management tool I can use for converting a business application from Oracle Forms 4.5 to Oracle Forms 6i ? Thanks SiniStrictly speaking we only certify the upgrade from 6i to 9i, however, the technical details of going

Calling Crystal Reports from Oracle Forms 10G

Hi everyone, I am trying to call a crystal report from Oracle Forms 10G. I have a button on my Form which when clicked calls a Crystal Report which the uaser then wants to save as a PDf file. Can someone please send me the code to do this and also th

Migrating from Oracle forms 4.5 to 9i

Please tell me if i can directly migrate from forms 4.5 to 9i? If i migrate first to 6 and then to 9i when do i web enable my form? What are the steps should i follow for migration from Oracle forms 4.5 to 9i?Strictly speaking we only certify the upg

Migration from Oracle Forms to HTML DB ?

Dear all, is there a tool allowing to migrate from Oracle Forms to HTML DB ? Thanks. Best Regards. Marcello.Hello. Thanks for your response. Here is the motivation. We have still applications developped with Oracle Forms 6i (old version no more suppo

Calling web service from oracle forms fails with ORA_JAVA.JAVA_ERROR

Problem Description: I'm following the steps as per the doc: http://www.oracle.com/technology/products/forms/htdocs/10gr2/howto/webservicefromforms/ws_10_1_3_from_forms.html to create a java stub to call external web service and then use java importe

Calling Report From Oracle Forms

Hi I am calling this one report from oracle forms, I am using global temporary table to run that report. I am first inserting data into the temporary table through oracle form and then i am calling report in that form to view the data in that tempora

Calling crystal reports 11 from oracle forms 10g

Could you provide me step by step a solution on how I can call crystal reports 11 from oracle forms 10g application.Hi, Use web.show_document for calling the reports. Check out forms online help for syntax and example of web.show_document. -ArunRead