BI Publisher (MOSC)

MOSC Banner

Missing Expression Error after migrating from Publisher 10g to Publisher 11g

edited Jul 16, 2014 7:13AM in BI Publisher (MOSC) 1 commentAnswered ✓

Hi all,

This query for a report was working fine in Publisher 10g.  It also works in SQLPlus, SQLDeveloper, etc.

When I try to edit the dataset in Publisher 11g, I get the missing expression error.

Any ideas? What does it not like?  Case Stmt, Subquery,  Something has changed in Publisher. 

SELECT

A.IMPORT_RID ,

CASE WHEN (SELECT COUNT(1) FROM IMP_VALIDATION_RESULT WHERE IMPORT_RID =(:p_IMPORT_RID)) > 100 THEN A.IMPORT_FILE_NAME || ' (ONLY FIRST 100 ERRORS SHOWN)' ELSE A.IMPORT_FILE_NAME END AS IMPORT_FILE_NAME,

A.IMPORT_FILE_EXTENSION ,

A.IMPORT_FILE_TYPE ,

A.USER_RID ,

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