Modern JSON Reporting Without Changing BI Publisher

Can JSON-Relational Duality Views Be Used in BI Publisher Without Creating Them in BIP?

✅ Yes — with one important rule

You can use a JSON-Relational Duality View in BI Publisher without creating the view inside BI Publisher, because a duality view is a database object, not a BI Publisher artifact.

However, you cannot skip creating a BI Publisher Data Model.

How This Works Architecturally

Ownership

JSON-Relational Duality View
→ Created and maintained in Oracle Database (23ai / 26ai)
BI Publisher
→ Only queries the view using SQL
→ Does not define or manage JSON logic

What You Can Skip vs What Is Mandatory

❌ Not Required in BI Publisher

Creating JSON structures
Defining relational-to-JSON mappings
Building REST services
Writing transformation logic

All of this is handled inside the database view.

✅ Mandatory in BI Publisher

Data Model (always required)
SQL dataset that queries the duality view
Optional layout (RTF, Excel, CSV, etc.)

BI Publisher cannot run a report without a Data Model, even if the source is a duality view.

How BI Publisher Sees a Duality View

From BI Publisher’s perspective, a duality view behaves like any other database view.

Example:

SELECT *
FROM dept_emp_dv
WHERE JSON_VALUE(data, '$.deptName') = 'HR';

BI Publisher runs standard SQL
JSON processing occurs in the database
No JSON parser or special adapter is needed in BIP

Recommended Design Pattern

Oracle Database
 └── JSON-Relational Duality View
       ├── Relational projection
       └── JSON document projection

BI Publisher
 └── Data Model
       └── SQL query on the duality view
            └── Optional JSON_TABLE flattening

Best Practices for ERP & Reporting Use Cases

Keep JSON logic in the database
Use JSON_TABLE to flatten data before it reaches BIP
Keep BI Publisher focused on:
- Formatting
- Scheduling
- Bursting
- Delivery
Treat duality views as read-optimized reporting objects

This approach improves performance, simplifies maintenance, and keeps reporting layers lightweight.

Final Summary

Question	Answer
Use duality view without creating it in BIP?	✅ Yes
Is duality view owned by BIP?	❌ No
Is a BIP Data Model still required?	✅ Yes
Is JSON processing done in BIP?	❌ No