Objects In Documentation Not Available In APEX SQL Workshop Schema
(Doc ID 2976403.1)
Last updated on SEPTEMBER 25, 2023
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 22.1 to 23.2 [Release 22.1 to 23.2]Information in this document applies to any platform.
Symptoms
Objects in documentation not available in APEX SQL Workshop schema
Some objects (synonyms to tables) that are listed in documentation of SIOCS v22.1 are not available via APEX SQL Workshop
Can see in the guide there are entries for the following that are missing from select * from all_objects where owner = 'SIM01' and upper(object_type) in ('TABLE','TABLE PARTITION', 'VIEW') order by object_name;
ACTIVITY_HISTORY
ACTIVITY_LOCK
BARCODE_ATTRIBUTE
BARCODE_CARTON_ADMIN
BARCODE_PROCESSOR
BATCH_JOB
BATCH_SCHEDULE
EXPECTED BEHAVIOR
------------------------
Access to all documented tables via APEX SQL Workshop should be possible.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |