APEX
Discussion List
-
Time Zone Date in APEX ApplicationSummary: when query about current time zone in SQL Workshope of oracle Apex by : select CURRENT_TIMESTAMP from dual; Apex Application Setting when set default value by :… -
how can you download apex patch images folderSummary: If you are using APEX in OCI free autonomous database with cutomer maintained ORDS vm frontend. How do you get a copy of the apex images folder for the point re…
-
Serial APEX WorkflowSummary: How to build serial approval in Apex workflow Specially if there is near 6 to 7 levels of approvers Content (please ensure you mask any confidential information…
-
Add attachement when create task definationSummary: Is it possible to add attachement when create task defination in oracle apex work flow Content (please ensure you mask any confidential information): Version (i…
-
Oracle EPM as Data Source for APEXHas anyone successfully configured an Oracle EPM application as a REST Data Source for APEX? Any tips or advice would be much appreciated… I see SaaS as a data source ty… -
Ajax call returned server error ORA-01840: input value not long enough for date formatSummary: today i am getting the following error when passing a page item value (date picker) from one page to another page. It has never happened before. It is a strange…
-
TEST performance of an APEX aplicationWe need to observe the performance of an ORACLE APEX application. Metrics like: • Largest Contentful Paint (LCP) • First Contentful Paint (FCP) • Cumulative Layout Shift… -
How we can convert big data file into single vector chunkIs there any way to convert complete CLOB data into single vector chunk. if yes which function we can use to convert. Currently i am using TO_VECTOR(VECTOR_EMBEDDING(doc…
-
Is the OCI in Johannesburg down? I get this Apex errorSummary: I have a issue that all my Apex apps dont work on the Johannesburg South Africa cluster If you click on this link you will see that Apex has an issue. Oracle AP…
-
APEX_MAILSummary: Hi, Trying to use apex_mail from Apex running on ATP in the Free tier of the Oracle Cloud and I think I got all the setup done correctly : Note: There was the n…
-
How can I apply dynamic filters based on user roles and departments in Select AI?How can I apply dynamic filters based on user roles and departments in Select AI? When we create profile on the data (like Sales Data) so it contain all data from differ…
-
403 Error when Uploading ZIP Files in Oracle APEX on OCI Integrated with Oracle ERPI'm experiencing an issue with my Oracle APEX application, which is integrated with Oracle ERP and deployed on OCI (Oracle Cloud Infrastructure). It’s important to note …Jesus Zevallos 16 views 2 comments 0 points Most recent by Avishek Mazumdar-Oracle Autonomous Database -
Apex not working after update, invalid packagesSummary: Apex is not working after its update . I cant even see Apex instance, i can use database. I see 2 invalid packages bodies APEX_240100.WWV_FLOW_CGI APEX_240100.W…
-
Uncommited Multipart Uploads - Storage BucketHi Team, We have uploaded files from onpremise linux server to OCI object storage bucket using below commands. sample :. oci os object bulk-upload --namespace-name axqui…
-
Why are my newly created 23ai databases going straight from "Provisioning" to "Unavailable" ?Summary: I can't migrate my 21c DB to 23ai simply because I can't create and start a 23ai DB. Content (please ensure you mask any confidential information): I'm trying t…
-
It is possible recover / restore from last backup AlwaysFree 21c databaseSummary: Hello everyone, I know, OCI has informed that the AlwaysFree 21c databases will be removed. But TBH, I have found in my mailbox just one e-mail about it. But ok…
-
Inporting application from an Autonmous database to another on OCIHi, I am on alway free database unsing APEX database. I wouldlike to import application from one database to another. What are the steps involved ? Best regards. -
The Autonomous Database operation failed due to an unknown error.Summary: Good morning, My OCI Autonomous Database is currently in a STOPPED state and will now not restart. When trying to restart, it takes around 20 minutes and then g…
-
Issues running Oracle Apex on ATPSummary Apex shows blank page when trying to access via tools menuContent Hi,I have an Autonomous Transaction Processing Database instance set up on the Oracle cloud. Th…
-
How to replace new line character in one of the value in CSV during DBMS_CLOUD.COPY_DATA call?Summary: This DBMS_CLOUD.COPY_DATA API is failing during importing data from Object storage to ATP that is having a new line characters in one if its value. We are tryin…
-
ATP in Private subnet, how to access database action (sql developer web) and Apex over internetSummary: Hi Team, We have an ATP provisioned in private subnet, how can we access the APEX and Database Action over internet, any pointer to that would be helpful? Thank…
-
IP address of public ADWSummary: Hi, We wish to connect to a compute instance (ODI MP) from ADW via Apex. For this ADW, network type is set to 'Allow secure access from anywhere', so there's no…Debadrita Ghosh-Oracle 21 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database -
How to Migrate Autonomous Database with Workload type: APEXSummary: I am following This does not work for Autonomous Database with Workload type: APEX As Oracle Doesn't allow external connection Content (please ensure you mask a…
-
AI Assistant button not visibleHi, I have upgraded to APEX 24.1 on OCI. I cannot see the button AI Assistant in the SQL code editor. The bottom page of APEX shows relase 24.1 is installed :
-
invalid credentials.I am using Always Free AD on the free OCI. I have installed Oracle. But when I try to connect to APEX on the cloud, I get an error message "invalid credentials." How to …Christian Pitet 2 11 views 13 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
English language on Interactive reports options instead of frenchHi, I am using APEX 24.1 on OCI. The interactive Report button is "Actions" and the Actions are in english. And the systems messages "Row updated" for example, are in En…Christian Pitet 2 21 views 12 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
ORA-12530, TNS:listener: rate limit reachedSummary: How do I trouble shoot this error ? Content (please ensure you mask any confidential information): I observe this error in following configuration Automomous da… -
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 78 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…