I have been following through the Lab/Tutorial
Oracle Apex: Build a started online shopping app
The instructions have been super clear BUT
Just as I think I am going to complete my shopping app and have a nice products page with images I get an error.
It is at the end of Lab 8 when I run
The error message is shown below.
Help would be much appreciated :)
Column DEPARTMENT_ID , referenced by facet P1_DEPARTMENT_ID , is not available or unauthorized.
Contact your application administrator.
Technical Info (only available for developers)
- is_internal_error: true
- apex_error_code: APEX.FS.COLUMN_UNAUTHORIZED
- component.type: APEX_APPLICATION_PAGE_REGIONS
- component.id: 24507908638513292009
- component.name: Search
- error_backtrace:----- PL/SQL Call Stack ----- object line object handle number name 0x569ca32b88 1055 package body APEX_240200.WWV_FLOW_ERROR.INTERNAL_GET_ERROR 0x569ca32b88 1124 package body APEX_240200.WWV_FLOW_ERROR.INTERNAL_ADD_ERROR 0x569ca32b88 1608 package body APEX_240200.WWV_FLOW_ERROR.RAISE_INTERNAL_ERROR 0x565c7c4bb8 3488 package body APEX_240200.WWV_FLOW_FACETED_SEARCH.GET_FR_ATTRIBUTES 0x565c7c4bb8 4262 package body APEX_240200.WWV_FLOW_FACETED_SEARCH.RENDER 0x567bd9a248 2701 package body APEX_240200.WWV_FLOW_REGION_NATIVE.RENDER_REGION 0x569d050648 3710 package body APEX_240200.WWV_FLOW_PLUGIN.RENDER_REGION 0x565ca55660 1118 package body APEX_240200.WWV_FLOW_DISP_PAGE_PLUGS.DISPLAY_REGION_BODY 0x565ca55660 1636 package body APEX_240200.WWV_FLOW_DISP_PAGE_PLUGS.RENDER_REGION 0x55fc996798 1912 package body APEX_240200.WWV_FLOW_PAGE.RENDER_COMPONENTS 0x55fc996798 2005 package body APEX_240200.WWV_FLOW_PAGE.RENDER_PAGE_SLOT 0x55fc996798 2797 package body APEX_240200.WWV_FLOW_PAGE.HANDLE_COMMON_PLACEHOLDERS 0x55fc996798 3067 package body APEX_240200.WWV_FLOW_PAGE.EMIT_BODY 0x55fc996798 3262 package body APEX_240200.WWV_FLOW_PAGE.RENDER 0x567c4de3e8 3393 package body APEX_240200.WWV_FLOW.SHOW 0x567c4de3e8 5542 package body APEX_240200.WWV_FLOW.RESOLVE_FRIENDLY_URL 0x567c4de3e8 5606 package body APEX_240200.WWV_FLOW.ROUTE_FRIENDLY_URL 0x565c9897a8 6 anonymous block
// I have tried in the SQL workshop taking a look. All 3 SQL statements below give results as expected. No errors
SELECT p.PRODUCT_NAME, d.DEPARTMENT
FROM PRODUCTS p J
OIN DEPARTMENT_LOOKUP d ON p.DEPARTMENT_ID = d.DEPARTMENT_ID
ORDER BY d.DEPARTMENT, p.PRODUCT_NAME;
///
SELECT product_id,
product\_name,
unit\_price,
product\_details,
product\_image,
image\_mime\_type,
image\_filename,
image\_charset,
image\_last\_updated,
color\_id,
department\_id,
clothing\_id,
d.description,
b.brand
FROM products p,
json\_table (p.product\_details, '$' columns ( description varchar2(4000) path '$.description') ) d,
json\_table (p.product\_details, '$' columns ( brand varchar2(4000) path '$.brand') ) b
WHERE product_id = 25
//
SELECT "PRODUCT_ID",
"PRODUCT\_NAME",
"UNIT\_PRICE",
"PRODUCT\_DETAILS",
"PRODUCT\_IMAGE",
"IMAGE\_MIME\_TYPE",
"IMAGE\_FILENAME",
"IMAGE\_CHARSET",
"IMAGE\_LAST\_UPDATED",
"COLOR\_ID",
(
SELECT l1."COLOR"
FROM "COLOR\_LOOKUP" l1
WHERE l1."COLOR\_ID" = m."COLOR\_ID") "COLOR\_ID\_L$1",
"DEPARTMENT\_ID",
(
SELECT l2."DEPARTMENT"
FROM "DEPARTMENT\_LOOKUP" l2
WHERE l2."DEPARTMENT\_ID" = m."DEPARTMENT\_ID") "DEPARTMENT\_ID\_L$2",
"CLOTHING\_ID",
(
SELECT l3."CLOTHING"
FROM "CLOTHING\_LOOKUP" l3
WHERE l3."CLOTHING\_ID" = m."CLOTHING\_ID") "CLOTHING\_ID\_L$3",
b.brand
FROM "PRODUCTS" m,
json\_table (m.product\_details, '$' columns ( brand varchar2(4000) path '$.brand') ) b