Slack

so you can use expressions in your AOP Template
27-Nov-2023 12:35:PM by: dgielis
{column == null ? ‘-’: column}
27-Nov-2023 12:35:PM by: dgielis
Is there any option available in AOP to replace Null in excel report download. I can not change sql of report.
27-Nov-2023 10:55:AM by: Hocco
Only the first header, but not the second.
22-Nov-2023 02:19:PM by: Eric Sacramento
Hi Eric, you should be able to repeat the first x rows in Word table
22-Nov-2023 01:27:PM by: Sunil Tandan
I don't think it's possible to do these two things that I mentioned (last week and yesterday) on AOP. :disappointed:
22-Nov-2023 01:26:PM by: Eric Sacramento
I am attempting to repeat the header when the table continues to the other page, but what I've tried so far is not working (all combinations). Do you have any tips? Thanks.
21-Nov-2023 07:02:PM by: Eric Sacramento
Is it possible to create two breaks on the top of the CATEGORY using this example from the AOP documentation? Or is it better to create another cursor? I am trying to do something like it, but it is not working. `{#element|break:"continent"}*{break[*0*]*.continent *}*` `{#element|break:"region"}` `*{break[*0*].region}*` `{#break}` `{product_name}` `{/break}` `{/element|break:"region"}` `{/element|break:"continent"}`
17-Nov-2023 03:19:PM by: Eric Sacramento
When using apex_web_service.make_request I get insufficient privileges. I feel like this can be for several reasons. I’ve found some documentation about setting up ACLs for connect and I did that. I’m concerned that the service I’m calling requires my apex service instance ip to be put in a whitelist. What is the safe/correct way to whitelist the oracle managed apex service instance? I assume its IP, if I can even get the current one, might change
16-Nov-2023 11:39:PM by: Jason Stortz
Hi Martin - there is a setting to specify the time-out for PDF conversion
16-Nov-2023 03:20:PM by: dgielis
Has anyone encountered problem with AOP 23.1.1. on premis outputing PDF? I loaded sample word template and when processing to PDF output, the process finishes with error ```The given request took more time than allowed. Please try again with a smaller request/data, or increase the request timeout on aop_config.jsonc.``` Output to Word works just fine. If i check Configuration PDF converter seams to be working: ```Checking for soffice headless server pdf converter. Libreoffice headless server pdf converter is available.``` soffice version: `LibreOffice 7.6.2.1 56f7684011345957bbf33a7ee678afaf4d2ba333`
16-Nov-2023 09:20:AM by: Martin Mirenic
Thanks that helps
08-Nov-2023 05:59:PM by: pritham9
Use := v(‘item’)
08-Nov-2023 05:44:PM by: dgielis
of course :smile:
08-Nov-2023 05:35:PM by: maxime_tremblay
And I can make it dynamic fetching it from page item values correct ?
08-Nov-2023 05:19:PM by: pritham9
Thanks that helps
08-Nov-2023 05:19:PM by: pritham9
aop_api_pkg.g_output_filename := ‘name’;
08-Nov-2023 05:19:PM by: dgielis
Use the global variable in init plsql
08-Nov-2023 05:18:PM by: dgielis
Yes
08-Nov-2023 05:18:PM by: dgielis
Hi. How can I change AOP document output file name?
08-Nov-2023 05:09:PM by: pritham9
I try to use the apex office edit sample app on our own server but when I start a new document the websockets kills the connection - anyone an idea?
07-Nov-2023 06:41:PM by: Andi Oberhauser
HIi, I'm using a docx template and would like to insert a carriage return in a table cell in the source sql. I want to split a returned field into 2 rows in the output of AOP if that make sense. So select blah ||chr(13)||more_text as a_column from a_table.
02-Nov-2023 04:52:AM by: Gary Perkins
Thx Maxime I will try after my vacation :relaxed:
27-Oct-2023 06:08:PM by: Andi Oberhauser
it looks like you don’T have the callback defined correctly you can have a look at the doc here: https://www.apexofficeedit.com/docs/apex/region-plugin-custom-attributes#custom-plsql-package-name
27-Oct-2023 01:10:PM by: maxime_tremblay
I installed the Sample App and set the configuration on our environment
27-Oct-2023 01:04:PM by: Andi Oberhauser
Hey Guys and Ladies - i want to try apex office edit on premise. But i always get this fail. Maybe somebody knows something?!
27-Oct-2023 01:03:PM by: Andi Oberhauser
Trying to create multi-page PDFs sourced from an interactive grid with a static id of igtest. The static application file template source is the same one I was able to generate a populated PDF (only 1 page though, different issue though) using a SQL cursor query. IG has same column names as PDF template fields. It returns one PDF page without data filled in. Attached are the settings for the IG.
10-Oct-2023 11:13:PM by: Joe Kerr
Creating populated PDFs with AOP DA + Static application file PDF template using the SQL query below (did not list all the fields for brevity). It populates and returns a single pdf page, but there are more than 20 (Note fetch first 20 rows only). Tried in development and Production AOP mode, same result. What is limiting the output to only 1 PDF page? ```Select 'file1' as "filename", cursor( Select Cursor( Select FORM_1099_ID As "form_1099_id" ,TAX_YEAR As "tax_year" ,VOIDED As "voided" ,CORRECTED As "corrected" ,PAYERS_NAME As "payers_name" ,PAYERS_NAME_LINE2 As "payers_name_line2" From VW_Form_1099_MISC Fetch first 20 rows only ) as "aop_pdf_form_data" from Dual) as "data" from dual;```
10-Oct-2023 08:10:PM by: Joe Kerr
Can you send the debug json in the AOP support portal- will be easier to help you
07-Oct-2023 09:25:PM by: dgielis
New to AOP. Uploaded fillable PDF IRS1099 template with fields named same as a view and SQL select. Using AOP DA with SQL to generate PDF per attached screenshot. AOP DA generates a fillable PDF with proper format, but no data. Tried defining view with quotes around column names and AOP DA select with quotes, didn't make a difference. Suggestions?
07-Oct-2023 06:44:PM by: Joe Kerr

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
L_a_u_r_a
18-Feb-2022 16:16
Is it possible to submit EBS request set from APEX and get the request id for each request?
Link
User_TFX19
18-Feb-2022 15:54
APEX_WEB_SERVICE and client certificates?
Link
User_6X3A4
18-Feb-2022 15:38
Multiple drop downs in a page
Link
Munaf Rafique
18-Feb-2022 14:42
Error in Callback URL at apex and the below is the debug from sqlplus . can you please Help ?
Link
SmithJohn45
18-Feb-2022 13:55
IG: Dynamic Action sometimes not Set Value but sometimes does?
Link
PJ
18-Feb-2022 12:45
APEX - apex.server.process pass clob to client
Link
fac586
18-Feb-2022 09:56
BUG: UT 21.2: Search Engine pagination misalignment
Link
User_O8O4V
18-Feb-2022 09:39
YYYYMMDD Validation
Link
gernot1
18-Feb-2022 08:44
workspace login using http header variable authentication
Link
User_8849S
18-Feb-2022 07:25
Apex web service REST call returning null
Link
SmithJohn45
18-Feb-2022 04:56
IG: selected value thru PopUp LOV should not appear in next row
Link
User_NF3HC
18-Feb-2022 03:10
Authentication failed for REST Enabled SQL service.
Link
partlycloudy
18-Feb-2022 02:43
Auto dismiss notification messages - All pages
Link
Joe R
17-Feb-2022 18:48
Deploying an Application with Subscribed Authorization Scheme's - 21.2.3
Link
srgarg-Oracle
17-Feb-2022 17:41
Set Value DA -> Submit DA -> Processing
Link
partlycloudy
17-Feb-2022 16:56
Region button - Update click target
Link
Geert01
17-Feb-2022 08:25
Badge List: Change the blue color when hovering over the card
Link
Brad Chriss
16-Feb-2022 18:50
Close Dialog event
Link
Suat GURSES
16-Feb-2022 12:24
Oracle APEX Interactive Grid -Master/Child Table Issue
Link
Sushmitha Sun
16-Feb-2022 09:18
How to remove the default notification that comes when a process is successful
Link
Ace1
14-Feb-2022 13:57
Interactive grid dynamic sum in a total row
Link
Suat GURSES
23-Dec-2021 08:07
APEX BUG
Link
CaribbeanUser
26-Nov-2021 20:23
Setting a Popup LOV column in an interactive grid doesn't show the display value
Link
Amico
26-Jul-2021 13:33
After update to Apex 21.1.2 refreshing interactive grid duplicates rows
Link
Javier P
27-Jun-2021 07:57
Duplicate records showed in a result set of an Interactive Grid
Link

News

X
    
 
ImageNewsFavoriteForward
Juergen Schuster  
The future of apex.world and why we wanted to shut it down
apex.world
Link
04-Dec-2023 07:54:55 by: Juergen Schuster
Lech Cieślik    Other
Member of the Month November: For 4 great blog posts!
Member of the Month
Link
07-Dec-2023 13:44:12 by: Maxime Tremblay
Monica Godoy    Other
Webinar: APEX on ADB
Cloud, Free Cloud, Webinar
Link
08-Dec-2023 09:48:28 by: Juergen Schuster
Jon Dixon  
External help texts
Help
Link
07-Dec-2023 16:29:54 by: Juergen Schuster
Anton Scheffer  Other
Multifactor-with-TOTP-Authenticator
Authentication, SSO
Link
07-Dec-2023 10:23:13 by: Juergen Schuster
Larry Ellison    Other
Video: Cloud World 23 - APEX statements
Videos
Link
03-Dec-2023 18:25:22 by: Juergen Schuster
Jon Dixon  
apex_string API
API
Link
01-Dec-2023 19:54:55 by: Juergen Schuster
Juergen Schuster  Other
New Job, Contract, USA, Virginia, Arlington
Jobs
Link
01-Dec-2023 15:05:44 by: Juergen Schuster
Farooq Ahamd  
New Plug-in: Multi Purpose Card
Plug-ins
Link
30-Nov-2023 01:24:51 by: Maxime Tremblay
Martin D'Souza    
How to customize Page Designer layout
Application Builder
Link
29-Nov-2023 17:06:24 by: Juergen Schuster
Martin D'Souza  
Which item has been changed
Items
Link
29-Nov-2023 17:04:46 by: Juergen Schuster
Jan Kvetina    Other
Do's and Dont's Global Page - Page 0
Items
Link
28-Nov-2023 10:18:33 by: Juergen Schuster
Marc Sewtz    Other
23.2 Patch Set Bundle 1 is out! (35895964)
APEX 23
Link
28-Nov-2023 10:10:30 by: Juergen Schuster
Martin D'Souza  Other
apex_string.split Performance Issues
API
Link
27-Nov-2023 14:12:37 by: Juergen Schuster
Plamen Mushkov  
Session Overrides
Session
Link
27-Nov-2023 07:17:45 by: Juergen Schuster
Matt Mulvaney  
Custom Domain for your Oracle 23c Free APEX in Docker
Docker, Installation
Link
21-Nov-2023 10:36:31 by: Juergen Schuster
Adrian Png  
Generative AI Using Latent Diffusion Models and NFC Tags
AI
Link
21-Nov-2023 08:41:40 by: Juergen Schuster
Chaitanya Koratamaddi  Other
Collaborative Development using Application Working Copies
APEX 23
Link
21-Nov-2023 03:57:55 by: Maxime Tremblay
Lech Cieślik  
Oracle APEX Map region and a few words about Layers
Map
Link
21-Nov-2023 03:57:35 by: Maxime Tremblay
Dimitri Gielis  Other
APEX Message Service (AMS)
Product
Link
17-Nov-2023 15:46:30 by: Maxime Tremblay
Marc Sewtz  Other
Office Hour: 23.2 Part 5 - This Thursday
APEX 23, Videos
Link
15-Nov-2023 18:07:21 by: Juergen Schuster
Shakeeb Rahman    Other
23.2 is out!
APEX 23
Link
15-Nov-2023 14:05:50 by: Juergen Schuster
Steve Muench  
23.2 Workflow
Workflow
Link
15-Nov-2023 14:01:39 by: Juergen Schuster
Rafal Grzegorczyk  
23.2 Working Copies
APEX 23, Versioning
Link
15-Nov-2023 13:27:51 by: Juergen Schuster
Farooq Ahamd  
New Plug-in: QR Contact Save
Plug-ins
Link
15-Nov-2023 01:51:07 by: Maxime Tremblay
Pretius Poland  
New Commercially Supported Plug-in: Pretius Button Builder
Plug-ins
Link
15-Nov-2023 01:48:07 by: Maxime Tremblay
Marc Sewtz    Other
23.2 available!
APEX 23
Link
14-Nov-2023 18:05:17 by: Maxime Tremblay
Lech Cieślik    
Map Features
Map
Link
13-Nov-2023 18:08:08 by: Juergen Schuster
Jan Kvetina  
Default Tab Handling
Region Display Selector, Tabs
Link
13-Nov-2023 09:26:32 by: Juergen Schuster
Plamen Mushkov  
Summarise YouTube videos with AI
AI, Videos
Link
13-Nov-2023 09:13:56 by: Juergen Schuster
Lech Cieślik  
Marking countries on the map
Map
Link
10-Nov-2023 13:54:51 by: Juergen Schuster
Philipp Hartenfeller  
LCT Testing Framework Version 23.2
Testing
Link
09-Nov-2023 11:01:49 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20