BI Publisher - DML / DDL Operations not allowed (OBIEE/BIP 12c v 12.2.1.3)
Hi all.
I used to have a report, doing a simple insert into a table and returning its data, working fine on OBIEE/BI Publisher 11g.
Once migrated to OBIEE/BI Publisher 12c (version 12.2.1.3) I started receiving the error below (see data model Engine Log)
Just for clarification.
Is this really not allowed anymore in BI Publisher Report? Calling PL/SQL Code that performs DML or is there a setting somewhere that I need to change?
Try to search for DM14_DML_DDL_KEYWORD on help and nothing.
Engine Log
<?xml version="1.0" encoding="UTF-8"?><!--Generated by Oracle BI Publisher 12.2.1.3.0 -Dataengine, datamodel:_Exp.xdm -->