I'm getting the error below when downloading IR report in csv format. I'm getting that whenever the records is more than 108,000. Is there a limit in records to download? Is there a resolution.
I am using apex 4.1, EXCEL 2010.
While I try to download a file using the below code; an HTTP 404 error is coming although the proc is being called and the parameter is correctly being passed.
create or replace procedure download_myfile1(p_id in number)
as
v_mime varchar2(255);
v_length number;
[code]...
It shows a POP up window by which u can save or opens the file. But no pop up displayed in this case.
I'm trying to create a web service via the WSDL wizard (Apex 4.0.2). We are behind a firewall and connect to the internet via a proxy server. The proxy server requires authentication with a username and password. How to include the username and password in defining the Proxy Server in the Application Definition page or optionally in the alternate location in the Manual Web Service wizard page?
I assume the base definition for the proxy server is [http://]host[:port][]
i have ir report and one column value coming from function,when open the IR report its giving error..
IR report code
SELECT CS_ID ,CS_NAME, Util_func(PASS_ID) as "ALERT_DAYS" from "CSD_MASTERS" Function code
FUNCTION Util_func(PASS_ID NUMBER) RETURN number
IS
ALERT_DAYS NUMBER:=0;
BEGIN
[code]........
This time i am downloading the Oracle 11g and then the Oracle APEX...(they are not in one package...right ? i mean they both have to download separately)i really new in oracle / PL/SQL. I'm not a programmer but i interest about database programming.For now i still use Ms. Access to develop an aplication and i really suprised i found this Oracle APEX because it an RAD tool too same as Access but more powerfull i think.
View 2 Replies View RelatedI am trying to refresh a report with dynamic action. And getting the following errors:
{"dialog":{"uv":true,"row":[{"V":"Widget Failure
ORA-20876: Stop APEX Engine,
classic_report"}]}}
I have identified the problematic part. I have a multi-select select list and my query goes like this:
select o.order_id, s.salesrep_name
from ml_orders o, ml_order_salesrep_mapping m
where m.order_id(+) = o.order_Id
and case when :P22_SALESREP is null then 1
[code]...
I'm using Apex 4.2. On click of a button, I refresh 2 Standard Region Reports with a Dynamic Action. This dynamic action has been working without problems for WEEKS and all of a sudden i'm getting the ORA-20876: Stop APEX Engine error when I click the button.
In the dynamic action, I removed the refresh of the second report and now the error does not occur. If I add the second refresh action back in, it throws the above error. I've even tried making the second report identical to the first and the refresh action fails. why this is failing on the second refresh action since the second report & region is IDENTICAL to the first report now.
Having this issue in Apex 4.1.1 and 4.2 (haven't tried it in versions prior to 4.1.1 yet). So I got my standard IR, and trying to create a private report with control breaks, aggregations.
Once I save it as a private report, It applies the same on my primary report.
It's no big issue as I can flip back to Primary report and delete the control breaks, aggregations but is some kind of bug? Ideally it shouldn't modify my primary report unless I try to save it as "Default Report Setting".
How do I create Items context help editable report or report & form app?
what is its table?
I have a Page containing 3 reports and I was wondering if it is possible to re-execute only one of the these reports using a button or preferably a Select List which allows me to choose which of the 3 reports I wish to 'refresh/re-execute'. I may be totally wrong here but I assumed that choosing the option to submit a Page will cause all regions to refresh i.e. re-execute the SQL queries they are 'based on'.
View 6 Replies View RelatedI have a Report Region with Type SQL Query and Source "SELECT * FROM <table>" where <table> has a primary key from a sequence. Under Report Attributes, I have Report Column "ST_NM" with Show and Sort checked and having a Sort Sequence of "1". I assume this is to set the iniital display sequence but regardless, the report rows display in Primary key order initially.
To try it: [URL]
1) How do I set the initial display sequence to be other than the primary key sequence?
What is the code/javascript/url behind the test report button on report queries component?
We are having DSN problems using the print url given on the report query. The URL works for some of our developers and not for others.
The test report button on the report query appears to work for everyone but I do not know what is behind the "Test Report" button. If I could recreate the test report button on our page this would be GREAT!
I have to implement IR report search functionality (*when ever we click on column header it will display all the values in that particular column , once we click on particular value , the report will filter based on that particular value * ) in classic report .
View 8 Replies View RelatedI have created a classic report in Apex. Have enabled the print PDF link on the report for the business users to download it in a PDF format. Is is possible to put a logo in a downloaded PDF from the report?
View 0 Replies View RelatedApex 4.2 I have an interactive report.I use the sum attribute on the column and break formatting option to create a report total on one columnReport Sum Label Total:Break Columns No BreaksHow to I format the total text and value in to red
View 16 Replies View RelatedApex 3.2 I have a field called P14_START_DATE.The display as type is Date Picker (DD.MM.YYYY). Now if the user uses the pop up calendar, the field is populated with eg 07.12.2013. I have 2 standard validations, not null and item specified is a valid date. If the user decides to type in the date, they can use a different format, eg 07/12/2013, which I do not want to happen.How can I validate the field, so they get an error if they do not use format dd.mm.yyyy.
View 2 Replies View RelatedMy environment settings:
Oracle Database 11.2.0.3.0 64 bits
Weblogic 10.3.5
APEX 4.2.2.00.11
When I try to access the development environment of the apex or any other screen, this error occurs intermittently.These errors (ORA-01821: date format not recognized) and (ORA-02063: preceding line from) are related to existing dblink's.
Parameters from apex database:
SQL> select * from nls_instance_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_SORT SPANISH
NLS_DATE_LANGUAGE AMERICAN
[code]....
Parameters from dblink database:
SQL> SELECT * from NLS_instance_PARAMETERS;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_SORT SPANISH
NLS_DATE_LANGUAGE
[code]....
Is there no format mask for Percent sign. My customer is creating a Computed field and wants to have the percent sign added to the result. (like a dollar sign). I saw some posts about adding jQuery..??? Is this going to be added to the APEX code some day?
Just like the Money format, FML999G999G999G999G990D00, where did FML come from? it translates to a dollar sign. Isn't there something that could translate to a percent sign
990D000PCT 75.328%
How can i apply currency format to the select list values queried from database tables. The data is stored in database in number format. The user wants to see 1000 separator commas in the list item values.
View 2 Replies View RelatedIn Apex 4.2 Jquery mobile list view how can you apply html format for the phone# field to make it dial with a touch. For example, I see how to do a list view of the 'DEMO_CUSTOMER' sample data, but I cannot figure out how to format the phone # fields so that they will dial on touch. I know the HTML tags to use and I know how to use it in a standard report, but I can't figure out list view.
View 3 Replies View RelatedBy default number that "starts" with a leading zero with decimals - zero is removed. 0.49 => .49
I'm adding for e.g. the mask "FM990D0999". 0.49 => 0.49
Ok this is fixed.But if I have an integer without decimal. 1 => 1.0
If I change the mask to FM990D9999 1=> 1.
I would like to have a zero leading when it's 0.49 but also no decimal when it's an integer => 1
APEX 4.0 with 11g
i have text item :P1_ADMISSION_DATE .i want to validate that item if user does not enter valid date forrmat then display me error.
Date Format is 'DD-MON-YYYY'
i have try with PL/SQL Expression in Validation
My validation code
:P1_ADMISSION_DATE=TO_CHAR(SYSDATE,'DD-MON-YYYY');How can i validate :P1_ADMISSION_DATE to enter valid date format by user.
I have tow report master - detail
select
"ID",
"NAME"
from #OWNER#.COUNTRYSELECT c.id
, c.country_id
, c.name
FROM city c
WHERE c.country_id = :P2_country_id
ORDER BY c.ID DESCP2_country_id it's a hidden item
i create dynamic action event click ,
type item (P2_country_id) ,
condition equal to country_id
true action refresh region (city report)
i want when click on row in country report , set values that related with city , how can i do that ?
APEX 4.0 Sometimes, I am getting the below error when I tried to logging into APEX workspace (after giving workspace name, User name and password), Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.
ErrorERR-7621 Could not determine workspace for application (:) on application accept. I found some threads related to this but in different way not exactly when I am getting this error.
After 2 or 3 times, this error will not come and I can able to logging into workspace What is the cause for this issue??
I have a problem when I want to edit a row in a report. I have created a form with report, and now when I click on the edit icon on the report page, it navigates me to the form page but without the row data .
View 6 Replies View RelatedI created a report and in this report there is a likeable colummn and when its been cliked I need its show a message box containing a text that cames from field on a tables in my database.
View 1 Replies View RelatedI have a javascript code, which refreshes a report on a page.The problem is, that the report ID is hard coded. If I import this page to a different application, the report won't be refreshed anymore.
Following code is used:
[...]var v_get = new htmldb_Get(null, $v('pFlowId'), 'APPLICATION_PROCESS=AP_RECALC', 0);v_get.addParam('x01', Segment);v_Return = v_get.get(); $a_report('734879922768742332', '1', '5000', '5000');[...]
Is there a possibility to change the '734879922768742332' to a variable, constant or static id (which does not cause a endless loop)
I am using APEX 4.2, DB 11.2
I have a Classic Report with Link item and Copy item and the other columns from the table. Copy item should appear in each record like the edit item link. When copy item is clicked the current row should be copied and a new duplicate row should be visible in the report.
The PL/SQL process written for this Copy item works fine (when executed alone).... but when Copy item is clicked, the PL/SQL process is not getting triggered.
PL/SQL process in not conditional.
I would like to display a leading row number to my IR. I cannot use rownum as I would like to allow users to sort queries.
Use something like:SELECT '#ROWNUM#' However I am not getting a number displaed only: #ROWNUM#
I'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button. The dynamic action sets two values in a table and then I would like to redirect to another page. Setting the values works fine. The code is below:
declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information, CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data"
how to redirect to a page from within PL/SQL . None of them result in success.