Application Express :: Error When Refreshing Report - Widget Failure?

Jan 24, 2013

I 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]...

View 4 Replies


ADVERTISEMENT

Application Express :: Error When Refreshing Report Region / ORA-20876 - Stop APEX Engine

Mar 26, 2013

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.

View 3 Replies View Related

Application Express :: Refreshing Dev Workspace From Prod

Nov 7, 2013

I support an APEX app that has one workspace for Development and one for the live Production application.  When I originally created the Dev instance I was able to copy tables and data by granting select privileges between the two workspaces (I did this one table at a time). 

The development workspace data needs to be refreshed from production since it's been a long time since the initial refresh and is very out of date. I would like to do a couple things:

1) execute SQL to compare the tables in the two workspaces to ensure they're structurally identical
2) execute SQL to truncate Dev tables and refresh from Prod Is there a way to do this? 

View 3 Replies View Related

Application Express :: Fetch Row With / Without Refreshing Whole Page?

May 29, 2013

I would like to create a process that allows me to move from record to record without refreshing a whole page. Specifically, I'd like to use a tree object that allows the user to select items and then have the details for that item show up on the right side of the page. Is there a way to do this without doing a complete page refresh?

So far I've tried two different on-demand processes:

- first I created an "Automatic Row Fetch", but I read on the board that this actually won't work as an on-demand process;

- I also tried a PL/SQL process that sets the various variables (e.g. ":P7_NAME") based on a query. This updated the session state, but it didn't refresh the fields on the page. Is there a way to trigger this refresh?

View 0 Replies View Related

Application Express :: IR Report Value From Function Error

Apr 11, 2013

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]........  

View 8 Replies View Related

Application Express :: Refreshing Tabular Form On Closing Modal Page?

Nov 14, 2013

I am not able to refresh tabular form region on close of the modal page. 

View 6 Replies View Related

Application Express :: Refreshing Main Page After Closing Skillbuilder Popup?

Aug 17, 2012

I need to refresh my main page after closing the popup page displayed by skillbuilder plugin

apex 4.1.0/Oracle 11g Ent.

View 9 Replies View Related

Application Express :: Proxy Error When Downloading Report (IR) In CSV Format

Aug 22, 2012

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.

View 6 Replies View Related

Application Express :: Saving Private Interactive Report Overwrites The Primary Report

Dec 10, 2012

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".

View 1 Replies View Related

Application Express :: Create Items Context Help Editable Report Or Report And Form App

May 9, 2013

How do I create Items context help editable report or report & form app?

what is its table?

View 2 Replies View Related

Application Express :: Re-execute Single SQL Report On Multi-Report Page

Oct 25, 2013

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 Related

Application Express :: Report Not Initially Sorted As Defined By Report Attributes Sort Sequence

Nov 1, 2012

I 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?

View 4 Replies View Related

Application Express :: Test Report Button On Report Queries?

Jul 20, 2012

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!

View 0 Replies View Related

Application Express :: Interactive Report Functionality For Classic Report?

Jun 27, 2012

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 Related

Application Express :: Classic Report - Logo In PDF Report

Apr 12, 2013

I 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 Related

SQL & PL/SQL :: Error While Refreshing A Writable Materialized View?

May 3, 2010

Am getting an error while trying to refresh a Writeable Materialized view using the following statement -

exec dbms_mview.refresh('schema_name.MV_name','C')

Error:-
ORA-02448: constraint does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2429
ORA-06512: at line 1

The Primary Key Constraint on the base table/MV is deferrable, the base table and the MV are in different schemas and the user trying to refresh the MV has an explicit grant on "ALTER ANY MATERILIZED VIEW" and "SELECT ANY TABLE" through a role.

Its refreshing successfully when I make the PK constraint (Base Table, MV) NOT DEFERRABLE (or) when I explicitly grant "SELECT ANY TABLE" to the user trying to refresh the MV.

View 5 Replies View Related

Reports & Discoverer :: Raise Report Failure

Jul 26, 2010

In forms when we need to make the form not to validate we will give the command, raise form_trigger_failure like that if i need to make a report not to validate further what is the command to give?

View 3 Replies View Related

Application Express :: Set Value From Report

Nov 8, 2012

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 ?

View 2 Replies View Related

Application Express :: Login Error 7621 - Determine Workspace For Application?

Jul 5, 2013

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?? 

View 1 Replies View Related

Application Express :: Editing A Row In Report

Jun 17, 2012

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 Related

Application Express :: Message Box With Report?

Nov 1, 2012

I 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 Related

Application Express :: Report ID For Different Applications

Jul 12, 2013

I 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)

View 2 Replies View Related

Application Express :: Copy One Row To Another In Report

Jun 6, 2013

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.

View 2 Replies View Related

Application Express :: How To Add Row Number To IR Report

Oct 19, 2013

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#

View 2 Replies View Related

Application Express :: JSON Error When Trying To Redirect To Another Page In Same Application?

Jul 23, 2013

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. 

View 2 Replies View Related

Application Express :: Error Importing Existing Application Into Production?

Aug 6, 2012

version 4.0.2.00.07

I had an error importing an application into Production that was exported from Development. The application exists and I was trying to replace it.

The error I received was:

ORA-20001: GET_BLOCK Error. ORA-20001: Execution of the statement was unsuccessful.
ORA-20001: Error creating dynamic action sub-action name=&quot;NATIVE_JAVASCRIPT_CODE&quot; id=&quot;9503820976918886&quot;
ORA-02291: integrity constraint (APEX_040000.WWV_FLOW_PAGE_DA_A_AR_FK) violated - parent key not found<pre>
begin wwv_flow_api.create_page_da_event ( p_id =&gt; 9504132415918888 + wwv_flow_api.g_id_offset ,p_flow_id =&gt; wwv_flow.g_flow_id ,p_page_id =&gtI

opened the SQL that was created from the export utility and this is where it errored:

begin
wwv_flow_api.create_page_da_event (
  p_id => 9503820976918886 + wwv_flow_api.g_id_offset
,p_flow_id => wwv_flow.g_flow_id
,p_page_id => 6
,p_name => 'Add tooltip to Numeric filter operators'
,p_event_sequence => 40

[code]....

Unless I'm not understanding this error it means that it can find the ACTION part that is attached to the WHAT part of this Dynamic Action? The Dynamic Action does work when the application is run (in Development)also, there are 3 others that are similar to this one. The export was created by the export utility in the Application Builder.

If I export only the page and import that into Production the import is successful and the page runs correctly. This is error is happening only when I try to import the entire Application.There are many other changes made which is why I was trying to do an Application export/import instead of individual pages.

View 3 Replies View Related

Application Express :: Raise Application Error On Dynamic Action

Jul 18, 2013

I am using Apex 4.2. On a click of button a Dynamic Action is written, which calls a DB Package. The DB package has exception handlers and also the package has two output parametersError Code and Error MsgSo in my code(Dynamic Code) i make a call to the package and checks the value for Erroc Code.

Begin Package call......  If v_error_code <> '0' Then    Raise SC_Error;  End if;Exception   When SC_Error Then    RAise_Application_error(v_err_code, v_err_msg);End;

But when i run the page and I click I get an Internal exception errorOutput from Debug -- I am not sure what the Cell in Red colour means, because the package is returning a correct message (before the red line).AJAX call returned server error ORA-20003:

Customer has already been matched for Execute PL/SQL Code.4......is_internal_error: true4......apex_error_code: APEX.AJAX_ SERVER_ ERROR4.. ora_ sqlcode: -200034......ora_sqlerrm: ORA-20003: Customer has already been matched4......error_backtrace: ORA-06512: at line 41 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 973 ORA-06512: at "SYS.WWV_DBMS_SQL", line 999 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 830 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN_UTIL", line 2304 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_ACTION_NATIVE", line 442 4......component.type: APEX_APPLICATION_PAGE_DA_ACTS4......component.id: 231852037977562094......component.name: NATIVE_EXECUTE_PLSQL_CODE4.

Execute Error Handling Callout defined on Page or Application Level4...Execute Statement: begin declare l_error wwv_flow_error_api.t_error; begin l_error := wwv_flow_error_api.g_error; wwv_flow_error_api.g_error_result := apx_error_utils.handleerror ( p_error => l_error ); end; end;4......Values changed by callout:4..

An unexpected internal application error has occurred. Please get in contact with your system administrator and provide reference# for further investigation. 4..display_location: ON_ERROR_PAGE4Stop APEX Engine detected4Final commit4-1 - 59

View 4 Replies View Related

Application Express :: Error - (no Authentication Configured For Application)?

Aug 21, 2013

We just upgraded from Application Express 4.0.2.00.07 to Application Express 4.2.2.00.11. We are using one common application to authenticate and redirect to other applications.

We use the following code:  

wwv_flow_custom_auth_std.login(      P_UNAME       => :P101_USERNAME,      P_PASSWORD    => :P101_PASSWORD,      P_SESSION_ID  => v('APP_SESSION'),      P_FLOW_PAGE   => '2000:1'         ); 

We start to get the following authentication error after the upgrade. There is no authentication configured for this application.

ORA-1403: no data found This is the same code we used from htmldb 2.x through Apex 4.0.2.00.07.

View 0 Replies View Related

Application Express :: 4.2 - Packaged Application Installation Error

Nov 9, 2012

URL....The upgade from 4.0 to 4.2 went fine, existing applications work, Builder works fine. But none of the packaged applications install, all of them fail with that error. Is there some post-upgrade step to complete to get this to work?

Also, it doesn't appear like we can select the application id when installing these applications! Our environment has a convention, of sorts, for application ids. Is there a way to over-ride the app id?

View 14 Replies View Related

Application Express :: Updateable Interactive Report

Sep 27, 2012

Apex 3.2

confirm whether I am right about this.

We have an interactive report (working report), which is updateable.

The user has created his own version of the report, with less columns.

Now when he changes a value it does not save.

Am I right to say that if one of the columns he has removed from the report is a required parameter for the update code, then the report will not save.

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved