BI Publisher (MOSC)

MOSC Banner

BI Publisher - DML / DDL Operations not allowed (OBIEE/BIP 12c v 12.2.1.3)

edited Dec 8, 2017 1:22PM in BI Publisher (MOSC) 8 commentsAnswered ✓

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 -->

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center