Data management portal constructor in database?

Question

Oracle

Given:
Online store (in fact, everything is more complicated, but to understand the essence of the issue, it will do).
50 tables with all sorts of relationships (mostly one-to-many).
Customers, Sub-customers (affiliate network), Suppliers, Goods, Purchases (+Returns, +Replacements), Prices of different suppliers, Exchange rates, Supply schemes, etc. etc.

Now all this works through third-party software, into which all sales are uploaded ... reports are generated there and from where everything falls into 1C.
The task is to replace this intermediate link. Those. you need some kind of constructor that you can enter, create the necessary pages (sections) with uploaded data from the necessary tables (pulling up human-readable names from, say, other reference tables, etc.), create the necessary forms for adding / editing records to the database .

Now as a DB uses Oracle. We think to stay on it (the lion's share of the logic is implemented as Stored Procedures and Triggers), but as "Plan B" - Postgres. Question in the interface.
We will rewrite the business logic - no problem. Now the task is to analyze possible options for the organization. The client portal is implemented (handwritten) - we need a back office (now also handwritten).
We can write ourselves. But for starters, we would like to implement a new scheme of work through the constructor (that’s why we refuse the current software - the developer stupidly refused to rework), and after that we will rewrite it “into a clean copy”.

Looking at Oracle WebCenter Portal 12c:
www.oracle.com/technetwork/middleware/webcenter/po...
...Oracle has so many products that it's dizzying...maybe there's something more suitable and we just overlooked it?

By and large, windows like those of 1C with “tables” are just that. List of orders... by clicking on an order, a small window opens on top with all the information about the order and the possibility of editing... further, by clicking on the counterparty, a window with the counterparty, etc.
+ authorization and roles. Who, what can watch/edit/add...
= perfect.

Do I want a lot? Or are there similar "constructors"? Web or desktop, it doesn't matter. Connecting directly to the database is no problem.

PS. We will do all the unloading in 1C ourselves (already done) - we need a visualizer and editor ...

Answer 1

MS Access