BI Publisher (MOSC)

MOSC Banner

How to use lexical parameter in reportTrigger on EBS?

edited Mar 25, 2020 5:00AM in BI Publisher (MOSC) 13 commentsAnswered

Hi BIP Guru, could you kindly take a look at my following problem?

My BIP report is giving the following error at runtime:

...

Calling XDO Data Engine...

[030920_023216813][][EXCEPTION] SQLException encounter while executing data trigger....

java.sql.SQLException: ORA-06550: line 4, column 12:

PLS-00103: Encountered the symbol ";" when expecting one of the following:

  ( - + case mod new not null <an identifier>

  <a double-quoted delimited-identifier> <a bind variable>

  continue avg count current exists max min prior sql stddev

  sum variance execute forall merge time timestamp interval

  date <a string literal with character set specification>

  <a number> <a single-quoted SQL string> pipe

  <an alternatively-quoted string literal with character set specification>

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