BI Publisher (MOSC)

MOSC Banner

Error during bursting process

edited Jan 10, 2019 4:40PM in BI Publisher (MOSC) 6 commentsAnswered ✓

Hi,

I have a requirement where in I need to fetch details of payments based on operating unit and payment year,

In the data template, I have 2 payments P_ORG_ID and P_PAYMENT_YEAR.

The report fetches data as expected.

When I added code for bursting, I get the following error:

====================================================

XDO Data Engine Version No: 5.6.3

Resp: 50718

Org ID : 81

Request ID: 34084616

All Parameters: P_ORG_ID=82:P_PAYMENT_YEAR=2018

Data Template Code: XXPQ_AP_UNACCOUNTED_PAYMENTS

Data Template Application Short Name: XXPQCUSAPP

Debug Flag: N

{P_PAYMENT_YEAR=2018, P_ORG_ID=82}

Calling XDO Data Engine...

[083018_150122235][][EXCEPTION] SQLException encounter while executing data trigger....

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