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
ADVERTISEMENT
Mar 19, 2013
I have developed a custom application in APEX. I wants to deploy and make it as a web application so that it can be access through url.
View 1 Replies
View Related
Jun 15, 2012
I have a main application from which the user can go to different applications (through tabs).
I have authorization scheme set for the main application.
When I try to use these (main app) authorization schemes in the other sub applications, they doesn't work.
Is there any way we can globalize the authorization scheme in the main application so that they can be used by different apps ?Or share the main applications authorization schemes with the sub applications.
View 4 Replies
View Related
May 17, 2013
I am new to Apex. how to import one of oracles sample applications. I can see how to import a workspace but not an application. I have already set up a TEST workspace successfully.
View 1 Replies
View Related
Oct 21, 2013
using apex_util.prepare_url with translated applications:Why is checksum in translated application different from checksum in original application?Is there any way to control which checksum apex_url.prepare_url function will calculate?I have application in two languages English (en) and Slovene (sl). Link with English checksum would work if I set Application primary language to English and link with Slovene checksum would work if I set Application primary language to Slovene. Application language is derived from Application primary language. The real problem for me is sometimes I get “English” version of checksum when apex_url.prepare_url is called from “Slovene” version of application. As I mentioned before “English checksum” doesn’t work if Application primary language is set to Slovene.
View 12 Replies
View Related
Apr 17, 2013
Our apex currently has LDAP authentication scheme. We have many applications within the workspace. We are looking for a way to have one authentication scheme defined for all the applications so that user doesn't have to enter username/password for each application. How can I share my LDAP authentication scheme for multiple applications.
View 4 Replies
View Related
Sep 26, 2012
Is there any official document from Oracle which tells us how to export apex applications from command line instead of using the GUI from within apex ?
When I googled I saw some links from apex users who had written as how to export using ApexExport utilities, but since we are in windows environment, we are having hard time getting the class_path,java_home...etc setup properly. I guess its not just me most of them would have encountered it.
But I am looking for an official document from Oracle ? ( exporting Apex applications from command line in Windows Environment ).
View 4 Replies
View Related
Jul 11, 2013
we got more that 50 apex apps, Deploying it through apex console is becoming pain.we won't get sys or schema passwords. etc as databases are controlled by DBA's, We only get apex_public_user password, internal, workspace admin passwords.If there is any need of schema association for any applications/workspace, We login to internal workspace and map schema to workspace. I read couple of blogs which discussed about automating the deployments through sqlplusconnecting as sys or schema user, will not work for us. Want to know if there is anyway I can import deployments without logging into workspace. We already have workspaces and applications. The deployments will be for updating existing application or deploying new application in existing workspaces. Oracle Application Express 4.1.
View 1 Replies
View Related
Oct 30, 2013
Is it possible to apply a new created UI Defaults to an existing page or pages in the application.If so then how?
View 0 Replies
View Related
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
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
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
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
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
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
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
Jun 13, 2012
I've just patched a development oracle environment (RAC 11GR2) with temporary patch 8730312. I would like to do same thing on Production RAC. Is it necessary to test all applications on dev environment with this kind of patch before deploy it on Production ?
View 2 Replies
View Related
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
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
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
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
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
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
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
Jul 31, 2012
I have an error why trying to update the source of my interactive report the error is : 1 error has occurred
The report query needs a unique key to identify each row. The supplied key cannot be used for this query. Please edit the report attributes to define a unique key column. ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.
The SQL query is :
select l.code_lignebip, m.identifiant_mission, m.libelle_mission, SUM(b.nbr_jours),
SUM(c.nbr_jours_consome), c.nbr_jours_realise, c.nbr_jours_raf, c.nbr_jours_reestime, c.lundi, c.mardi, c.mercredi, c.jeudi, c.vendredi
FROM missions m, bip l, cra c, budgets b
[code]....
View 2 Replies
View Related
Sep 27, 2012
It's possible to copy cells in report like excel sheet , like this example ? URL....
View 0 Replies
View Related
May 10, 2013
I am having the table columns called
level1_name, level2_repemail, level2_name, level2_repemail, level3_name, level3_repemail,
using this columns i would like to create a report region as mentioned below.
------------------------------------------------------------------------------------------------------------------------------------------------------|
TITLE |
-----------------------------------------|---------------------------------------------------|--------------------------------------------------------|
Lvl 6 | Lvl 7 | Lvl 8 |
-------------|---------------------------|---------------------------------------------------|--------------------------------------------------------|
Name | Rep | Name Rep | Terr Name Rep |
-------------|---------------------------|-------------------|-------------------------------|--------------------------------------------------------|
AP | aaa@gmail.com | AAA | bbb@gmail.com | AAA bbb@gmail.com |
AP | aaa@gmail.com | BBB | bbb@gmail.com | BBB bbb@gmail.com |
AP | aaa@gmail.com | CCC | bbb@gmail.com | CCC bbb@gmail.com |
AP | aaa@gmail.com | DDD | bbb@gmail.com | DDD bbb@gmail.com |
-------------------------------------------------------------|-----------------------------------------------------------------------------------------|
how can i create this type of report.
I am using ORACLE 11G, and APEX 3.2 .
View 7 Replies
View Related
Oct 3, 2012
I have the release 4.1.1. I have this problem:
- i have a master-detail page
- in a detail there is a classic report
- some item of the row of report are the select list based on LOV
I need to get the value of item inside the select list.
View 1 Replies
View Related
Jan 8, 2013
i have multiple radio gropus(one group for each row) in my report. Each row can be identified either by my rownm or id. I am looping through my report rows once the page is submitted to get the values of each radio group but I am not able to make it work...
here is my code.
DECLARE
v_res number;
BEGIN
FOR i IN (SELECT q_id FROM svy_q)
LOOP
EXECUTE IMMEDIATE
[code]........
View 1 Replies
View Related
Jun 3, 2013
I'm having an issue pulling an ID from a report column.
I have a report based on the query:
select Inspection_Name, Activation_Status, Activate, Deactivate, Activation_Date, Inspection_Sector_Id from Inspections
where Event_Id = :P0_Event_IdThis report is based on a select list at the top of the page. The user selects an event from the select list and the report is populated.
The query for the select list is: select event_name, event_id
from Water_EventsSimple enough so far. Each row is identified by the Inspection_Sector_Id. I want to be able to turn each row under the 'Activate' and the 'Deactivate' columns into links. I have accomplished this by turning this field into a link. The link needs to navigate to a page that has that rows Inspection_Sector_Id, but am not sure how to grab that Id. I am navigating via URL on the link, i.e. f?p=application_id:page_id:session......
View 1 Replies
View Related
