APEX
Discussion List
-
Getting ORA-43912 whilst trying to create a page as a copy on Apex using 23aiSummary: I've created a new 23ai Apex instance and imported three applications from an Apex instance running on 21c. When trying to copy a page between two of these appl…Martin Bocutt-Oracle 81 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database -
APEX REST BASED LOV Don't show all valuesSummary: APEX REST BASED LOV Don't show all values Content (please ensure you mask any confidential information): Hi, I have created a Rest Data Source Based LOV and it …
-
Advantage of ORDS service call in vbcs and cons of OIC call in vbcsHi experts advantage of ORDS api over OIC calls in vbcs . suppose ORDS being called in OIC for VBCS services what is the disadvantage its better approach or not? what is… -
ORA-65114 / Usage in container is too high / Problem: Cannot shrink Data Tablespace !Hi, The current situation on my Always Free tenant/Autonomous Transaction Processing DB: jofodb/jofodb1: SQL> select round(sum(bytes/1024/1024/1024),2) Size_gb from dba_… -
APEX Report with SQL using WITH clause function gives error.Summary: Below query works fine in APEX SQL Workshop, but gives error (ORA-32034: unsupported use of WITH clause) when creating an APEX Interactive report. with FUNCTION…
-
I keep getting an error to upgrade. Is there a fix for itSummary: I was on a free trial period, and I want to upgrade, but when attempting to upgrade it tells me that it fails due to the below: I have checked the address of my…
-
Using Apex with ATP for Building Web AppHi Team, We are assessing Oracle Apex(comes with ATP DB) as a platform to build Web App/extension to Oracle Cloud ERP. There would be around 10 extensions to be built an…
-
Oracle APEX 503 service unavailableSummary: Service Unavailable HTTP Status Code: 503 Request ID: 0ee5370a491db4c7f7674c355fbd8502 Request Timestamp: 2024-01-12T13:59:18.785698Z The connection pool named:…
-
Unable to import APEX Application including backup filesSummary: I have a newly created OCI account for our school and I cannot import an APEX application from a different workspace. Content (please ensure you mask any confid…
-
Connect MYSQL Database in APEXSummary: I have a requirement to connect with external MYSQL database and bring the data to Oracle Database Cloud. Content (please ensure you mask any confidential infor…
-
SQL developer web with Multiple TabsSummary: When using SQL developer WEB upon a ADB, only one tab of SQL code is allowed; my organization needs possibility to have multiple tabs to launch queries in paral… -
Trouble with Build Analytic Applications using APEX and Analytic Views Live LabSummary: Content (required): When trying to login as MOVIESTREAM user, I get this error. This is under Lab 3 Task 1 of the "Build Analytic Applications using APEX and An… -
Unable to clone a databaseSummary: I'm working with an autonomous database (Apex type) in the Free Tier. I only have one database and I'm trying to clone to a new DB for testing. On the clone pag…
-
How to solve this error of Oracle apex- 1403-no data found - rest data sourceSummary: Hi Experts, we are trying to upload file into OCI Object storage from Apex, so we created web credentials, rest data source and pages for uploading file. when u…
-
Continuous Autonomous Database Stopping Issue (Always Free Tier)Hello Oracle community, I'm facing an issue with my Autonomous Database using the Always Free tier. The database keeps stopping continuously, and I'm unable to restart i…
-
I can't find my database and apex applications anymore. How can I recover Cloud error?Summary: I search for my database in my tenant but I get an error from the cloud. Content (required): After login I try to click to open my database on cloud from cloud …
-
How export schema tables if DB has an APEX workload type?Summary: If DB has an APEX workload type datapump can't be used. Content (required): I read several documents about datapump that is the main way to export data from a s…
-
503 service unavailable errors after creating ATPSummary After creating a new ATP, I try and go to SqlDeveloper for Web or Apex I get a 593 service unavailable error.Content This is the error details after I have creat…
-
My autonomous database won't start after period of inactivitySummary: The Autonomous Database operation failed due to an unknown error. Refer to JobId 292ca36f-bab7-40c5-9fa0-791e97599e24 and WorkRequestId f6156a76-cfa3-4c49-9ded-…
-
Connect to ATP Database from ExcelSummary: Want to connect to ATP Database from Excel Content (required): Hi, Found below note to connect to ATP DB from Excel, but we don't find option to download 'Add-i…
-
ATP in private subnet, how to allow access of APEX & ORDSSummary: Hi Team, We are planning to provision ATP for a client and private subnet, so it will have a private endpoint. so how to do access APEX, ORDS and database actio…
-
I've hit an Apex bug with creating Interactive Grids after 23.1 upgradeSummary: After upgrading to Apex 23.1 I've hit a known APEX issue due to the trigger wwv_flow_ig_reports_t1 being disabled. Content (required): To enable progress this t…Martin Bocutt-Oracle 61 views 2 comments 0 points Most recent by Martin Bocutt-Oracle Autonomous Database
-
How to troubleshoot performance for Apex ApplicationSummary: Hi, We have an Apex application working perfectly on an instance. Now we created another standalone environment with Database 12.2 and Apex 21.1 installed. Appl…
-
Im having issue starting my database after it was inactivated when I was on holiday.Summary: Content (required): I am getting below error. Is it possible to recover this database, or do I have to work on new one? An unexpected error has occurred: Autono…Bartosz Kasprzak 61 views 6 comments 0 points Most recent by Satishbabu Gunukula Autonomous Database
-
Using Custom RTF Template in Apex ReportingHi , We are trying to use custom RTF layout in Apex Reporting Queries , But getting the below report while using Native Printing option. If we need to use custom RTF lay… -
Unable to access one of Oracle ADW's user apart from ADMINSummary: Content (required): Hi team, I am unable to access APEX or any Database Actions, using one of customized user's login credentials. It is displaying an error , s…Ankan Chanda 571 views 4 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database
-
Failing when trying to create an Always Free Autonomous DatabaseSummary: I have logged into my OCI dashboard. I select to create an Autonomous Database. It fails. Content (required): Login to OCI Console From the menu, select Oracle …
-
APEX how to enable dev & instance admin auth via oracle identity cloud serviceSummary: Content (required): I'm running the apex instance on ADW. I can't figure the correct configuration for setting up developer and instance admin login via OICS. I…
-
Production Live with Free Tier ATPSummary: Hi Team, Has anyone gone LIVE in production with Free Tier ATP. Do you see any challenge with that. Our data volume is less and 20 GB is enough. So just looking…
-
All APEX Links given by App Builder, to start an App, are suddenly wrong (400 Bad request)Summary: Wrong URL generated from the App Builder in APEX. It adds the workspace name before the /r/ Content (required): Suddenly the link to run any of my developed app…