Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX 21.2 - data loading - lookup columns option missing - bug?

Mary RJan 30 2022 — edited Feb 1 2022

Hello
I am using the data loader feature in APEX 21.2 and feel am missing something really basic!
I have created my data definition via Shared Components and want to now add a lookup query on one of the columns. When I go to that column's Data Profile the top of the page implies this is possible ie it says "Configure attributes of a single Data Profile Column: Data columns have a Selector and contain values directly extracted from source data. SQL Expression, SQL Query or Lookup columns contain values derived from data columns using SQL expressions, SQL Queries or table lookups."
Whilst I see the Transformation option there doesn't seem to be anything that allows lookups or the ability for me to call my own functionality to change the values being uploaded as in older releases. This appears to be the case in my own hosted environment and also on aoex.oracle.com
Where do I find this functionality please or is it, as I suspect a bug in 21.2? The functionality worked fine in previous releases.
Thanks
Mary

Comments
Post Details
Added on Jan 30 2022
1 comment
893 views