BI Publisher (MOSC)

MOSC Banner

Simple query with Beforereport trigger won't complete normally and won't post-process.

edited Jan 23, 2020 4:46PM in BI Publisher (MOSC) 19 commentsAnswered ✓

Oracle Apps 12.1.3

BI Publisher is terminating in the Concurrent Manager with an error, but there's no error message, it's producing a valid XML file, and the resulting file won't merge with the Excel Template I've defined for it when I click on output.  I can take the resulting file, load it as the preview file, and it will preview.

I have custom PL/SQL package which is using a beforetrigger to populate a custom table (based on an approach I saw in CSTRITRV_XML -- Intransit Inventory) , then prints off data in the custom table for the given concurrent request id via the Data Def XML query.  The beforetrigger works in PL/SQL Developer test script, but from the concurrent manager, the application is erroring out with no message and the OPP manager isn't being called to process the output.  I believe that the error being generated is preventing the OPP manager from picking it up.  A valid file is being

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