Application Express :: Database Monitor Module Missing In 4.2.2?
Jul 4, 2013When login as a administrator, am unable to find the above in SQL Workshop / Utilities. it's not drop from 4.2.2 , very useful functions.
View 2 Replies
ADVERTISEMENT
Application Express :: Packaged Application Is Missing Tables
Dec 5, 2012We installed the packaged application P-Track in a schema called cpd in Apex version 4.2.0.00.27. When running it, the error below occurs. Essentially it appears that some of the tables are missing as the package does not compile due to tables not being found. We had no trouble running other sample packaged apps. I would really like to look at P-Track. Any problem with installing P-Track?
The following error has occurred while executing the error handling callback:
ORA-04063: package body "CPD.EBA_PROJ_FW" has errors ORA-06508: PL/SQL: could not find program unit being called: "CPD.EBA_PROJ_FW" ORA-04063: package body "CPD.EBA_PROJ_STAT_UI" has errors ORA-06508: PL/SQL: could not find program unit being called: "CPD.EBA_PROJ_STAT_UI"
Technical Info (only visible for developers)
is_internal_error: true
apex_error_code: APEX.AUTHORIZATION.UNHANDLED_ERROR
ora_sqlcode: -4063
ora_sqlerrm: ORA-04063: package body "CPD.EBA_PROJ_STAT_UI" has errors ORA-06508: PL/SQL: could not find program unit being called: "CPD.EBA_PROJ_STAT_UI"
component.type: APEX_APPLICATION_AUTHORIZATION
[Code]....
Application Express :: Attachment In Team Development Missing In 4.2?
Mar 14, 2013I was waiting for the attachment in Teamdevelopment as stated in APEX 4.2 new Features:
Support for attachments within Team Development 1007 EA2 Allow file attachments for bugs, todo, and features.but I can not find the functionality?
Application Express :: Interactive Report Subscription - Missing Search Functionality?
Oct 11, 2012when receiving the output of a report subscription in Apex 4.1.1, the search Box is missing, only the Text string 'Suche:' is displayed.If i download the report as Email or html, the search box is there and usable.
Maybe i'm wrong, but this was not under Apex 4.0.2.
Application Express :: Part Of Screen Is Missing For Dashboard In IE And Google Chrome
Mar 7, 2013When I see the apex dashboard in the IE or google chrome, part of screen goes missing.Last part of dashboard doesn't come but it works fine in Mozilla Firefox.What should I do? Is there some settings I need to do in IE.I am using the IE version 9.0 for 64 bit.
View 0 Replies View RelatedApplication Express :: Edit Bar And Save Report From Actions Menu Is Missing
Jun 21, 2013We have recently did upgrade from 4.1 to 4.2 with listener 2.0. The edit bar (to edit the page) and Save Report option from Actions Menu ( Interactive Report) are missing, is it a bug?
View 3 Replies View RelatedApplication Express :: Apex_web_service.make_rest_request Wrapper Missing Header Parameters
Sep 13, 2012APEX 4.1.1.00.23/Oracle 11g
When attempting to use apex_web_service.make_rest_request, I found that it doesnt work with one of my web services because the service requires header parameters. The wrapper apex_web_service.make_rest_request is missing the two header parameters (p_http_headers, p_http_hdr_values) that are in the internal package wwv_flow_web_services.make_rest_request. I have tried passing the values into the two available p_parm_name and p_parm_value parameters, but it doesnt work. They have to be in the header.
It does work within APEX application when it allows me to add a header parm, but I am trying to schedule it nightly as a job from the DB.
Will it hurt anything for me to use the wwv_flow_web_services.make_rest_request?
How To Monitor Oracle Application R12
Jul 16, 2011How can I monitor Oracle Apps R12 on Linux RHEL5. Application and database status.
View 2 Replies View RelatedHow To Monitor Space Of Database In RAC And NON-RAC
Nov 17, 2012I need to monitor the Database daily, so i need to check whether the size of the DB is increasing @ a slow rate or rather than that. I need to do it in RAC & NON-RAC.
View 3 Replies View RelatedReal Application Clusters :: Monitor Incident Or Regular Health Checkup Under Grid And Oracle User?
Apr 15, 2013I am new in RAC scenario though i have some system to look after. I want to know, like single instance there is alert log,trace log where we should investigate to check if there is any problem. For RAC system which are the logs that i can find the monitor the incident or regular health checkup under grid and oracle user?
View 3 Replies View RelatedApplication Express :: Copy Team Development From Database To Another Database?
Feb 11, 2013How can I copy Team Development from database to another database
View 3 Replies View RelatedApplication Express :: Database Authentication Via Database Link?
Jun 26, 2013Is it possible to use Database authentication in APEX through database link, and how?Also is it posible to read roles from users through database link?
View 3 Replies View RelatedNo Module Requiring Data Collection
Dec 1, 2010I am getting the below output when I tried to take the "Payables" RDA from command-line (Application RDA is failing to collect) I am getting the below output.
appldev@devpi:/home/appldev>cd $IZU_TOP/bin
appldev@devpi:/d02/appldev/apps/apps_st/appl/izu/12.0.0/bin>./rda.sh -vdCRP -e APPL_SHORT='SQLAP' ACT
Collecting diagnostic data ...
No module requiring data collection
Generating the reports ...
No pending report
[code]....
why it is saying that "No module requiring data collection"?
Forms :: How To Call Canvas From Module A To B
Mar 29, 2013How to call the canvas from FORM A to FORM B . Form A contains canvas 'can_test'
Form B contains canvas 'can_sub'
I want to call 'can_test' from 'can_sub'
How to achieve this one?
Application Express :: How To Connect Second Database From Another One
Apr 5, 2013 how can I connect a second database from another one?
Ex.My APEX application in a database instance DEVELOPER and I want to connect with tables in DEVELOPER_B instance.
Application Express :: Upgrade Failed In Database From 10g To 11g
Jul 30, 2012When we upgraded the database from 10g to 11g, Apex upgrade failed. Due to the failure, I removed the old schema and did a fresh install of Apex 4.1. It is working but we lost the applications from previous Apex.
What is the best strategy when you need both database and Apex upgrades? We are a Linux workshop, setting up Apex in Oracle Fusion Middleware 11g environment.
Application Express :: Installation On Oracle11gXE Database
Aug 27, 2012I tried installing application express on oracle11gxe database.I running the scripts apexins and I got an error message SP2-0024: Nothing to change.
View 1 Replies View RelatedApplication Express :: Adding Users To A Database?
Nov 7, 2013I have an application that I am adding users to as end users. How do I assign them to a particular application? I am using Apex 4.1, Oracle 11g.
View 10 Replies View RelatedPerformance Tuning :: SQL Ordered By Elapsed Time And SQL Module?
Feb 24, 2013Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
2,423 1 3,919 0.62 1.83 gt49gg0fnc5x8 srv_dr@ahs (TNS V1-V3) UPDATE /*+ CCL<OENDB_FILE...
2,227 14 1 2227.16 1.68 bggfx8a04prj9 SQL*Plus select * from (select n.source...
.........
On [SQL ordered by Elapsed Time], [SQL Module] shows an indication that a SQL was executed by which process (i.e. srv_dr@ahs)outside of SQL*PLUS.If [SQL Modeule] shows as [SQL*Plus], does it mean the query was run in SQL*PLUS manually or directly?I have the SQL ID. How do I find out who, how, and exactly what time it was run?
Application Express :: Creating Procedure Using Database Package
Oct 23, 2012I have created a procedure within a database package, but when I want to create a form based on procedure but I can't call it. I think that I have to use prefix, I am a beginner in database and I don't know how to do this.
View 4 Replies View RelatedApplication Express :: How To Retrieve Item Help Text From Database
May 23, 2013I would like to let the customer edit the item help text. Is it possible to retrieve item help text from my own custom database table based via a PLSQL function call or something similar?
View 4 Replies View RelatedApplication Express :: Importing CSV Files To Database Backend
Dec 15, 2012There is a report that is generated everyday in the .csv file format that i would want to load into the database. I want to completely automate this process. I don't want to use the load function available in APEX. I use APEX 3.2 Version.
What i mean by automation is that i will create the CSV file and automatically move to a location from which APEX can access the data. I would then write a procedure to fetch the content directly from CSV file and write to the database. What i need is the location from which APEX can access data directly ?
Application Express :: 4.2 New Database Sessions Per Report Region?
Nov 22, 2012Does version 4.2 create a new db session for each report run on a page?
The reason I ask is we have a page with 4 report regions, each querying a global temporary table that is populated in a 'Before Regions' page process. The first report displays the correct data, but the others return 'No Data Found' and it is because the Global Temporary Table has been cleared out following the first report. This did not happen in 4.1.
I know we should be using Apex Collections, and we will in future, but time is at a premium to get this live
Application Express :: Validate Database Column Using Validations Tab?
Sep 11, 2012I'm trying to validate a database column using the validations tab in APEX, the data entered will always be in 'A0000' format but i cannot work out how to set up the validation correctly
View 2 Replies View RelatedApplication Express :: Conditional Read Only That Saves To Database?
Nov 27, 2012I have an item that does not save to the database.it is conditional read only based on the value in another column, when it is not read only it displays as a Select list.. then whatever is chosen triggers a dynamic action that sets other items.so setting it as a display only is not an option.
after upgrading from 4.0 to apex 4.2 this gives error: Session state protection violation: This may be caused by manual alteration of protected page...
the only workaround I have found is to set the Read Only to none, then create a dynamic action that conditionally sets the field to disabled..This works, but my problem with it is that it looks different than the read only..read only was Black Text and no textbox..disabled is a text box with greyed out text that is hard to read for some of the users..
Enterprise Search :: Supported SES11g security Module With WCC11g
May 24, 2013My customer is using latest SES11g with WCC11g, the WCC11g has ACL security module, in SES document, it mentioned only security group and account module in WCC is supported when using SES, but somebody tested SES did work with WCC with ACL security module, is there any document in SES mentioned this is a supported feature?
View 0 Replies View RelatedSQL & PL/SQL :: Missing Values In Database?
Nov 22, 2012i´ve got a table with colomns (time, value) ... for example:
time value
10:00 10
11:00 20
12:00 25
13:00 28
15:00 31
17:00 38
you can see, that the row 14:00 and 17:00 are missing. How i can create the missing values? The value should be the value from the last point. The result should be this:
time value
10:00 10
11:00 20
12:00 25
13:00 28
14:00 28
15:00 31
16:00 31
17:00 38
How can i do this ?
Application Express :: Login User With Database Credential - Seen As APEX_PUBLIC_USER
Mar 29, 2013I'm using Application Express 4.2.1.00.08
In the application, the authentication method used is the DB one, so the user (schema) must exist on the DB. This works fine.
For instance, I'm login as SCOTT
Creating the following query select upper(user) from dualshows that the real logged user is APEX_PUBLIC_USER and npot SCOTT.
How to create a connection with another "real" username ?
Application Express :: Database Link Slows Down The Response Time
Jul 11, 2013I have a question regarding db link. I have a query that uses a database link, i speed it up by adding the DRIVING_SITE hint and it worked when executed from
sql*plus or pl/sql developer.
It returns results in 3 seconds or even less. However, when i put this query back into the APEX application, specifically into an interactive report page -- it runs for 3 mins!
Application Express :: Using A Variable Database Link For Interactive Report
Nov 5, 2013I have a requirement where users will select an instance (db link) from an apex LOV and the data in an interactive report will query based on the db link selected. I can use a db link in an interactive report query but only if I provide the exact name of the link. If I do something link select * from foo@:P12_ DBLINK it doesn't work. It seems my only option is to use something like apex_collection.create_collection_from_query and then I can build my query with dynamic sql and use a variable for the dblink name. Then I just create an IRR based on my collection. Does that sound like that correct approach and/or am I missing anything?
View 8 Replies View Related
