ORDS, SODA & JSON in the Database

Hello,

I am upgrading APEX Listener and getting below error while installation with ords.3.0.4.60.12.48 with APEX 4.2.2:

Error executing script: ords_schema_mapping.sql Error: ORA-00904: "A"."TENANT_ID": invalid identifier ORA-06512: at line 9

-- Create a view that joins APEX_POOL_CONFIG and POOL_CONFIG, indicating the type of mapping
declare
   l_hint_11g varchar2(100) := ' ';
begin
  if sys.dbms_db_version.VERSION = 11 then
     l_hint_11g := '/*+NO_NATIVE_FULL_OUTER_JOIN*/';
  end if;
   
-- Create a view that joins APEX_POOL_CONFIG and POOL_CONFIG, indicating the type of mapping
execute immediate
 ' create or replace view ORDS_METADATA.unified_pool_config as
   SELECT ' || l_hint_11g ||
  ' CASE
     WHEN o.workspace_identifier is not null and a.workspace_identifier is not null THEN ''BOTH''
     WHEN o.workspace_identifier is null and a.workspace_identifier is not null THEN ''APEX''
     WHEN a.workspace_identifier is null and o.workspace_identifier is not null THEN ''ORDS''
    END schema_type,
    NULL pool_name,
    NVL(o.workspace_identifier,a.workspace_identifier) workspace_identifier,
    NVL(o.type,a.type) type,
    NVL(o.uri,a.uri) uri,
    NVL(o.updated,a.updated) updated,
    a.tenant_id,
    o.enc_key,
    o.mac_key
   FROM ORDS_METADATA.pool_config o
    FULL JOIN ORDS_METADATA.apex_pool_config a
    ON o.workspace_identifier = a.workspace_identifier';
end;
/

Any thoughts?

Can you please suggest is it a bug?

I have extracted ords.war and found that there is no tenant_id column.

As per few above lines can I change "a.tenant_id" to "1 tenant_id" ?

Also I tried below manual installation command after changing but it is not working:

java -jar ords.war install advanced ords-scripts --scriptdir ./ords/scripts/

and I am getting below error:

--scriptdir is not a valid option

I can recreate .WAR file but wanted to know if this workaround will not cause any issues on Production.

Kind Regards,

Sohil Bhavsar.