My Oracle Support Banner

Docgen Throws Error "java.lang.Exception: Scheduler DB insert Invoice JOb mapping - SQL Error" Even After Generating Invoice Report in BIP (Doc ID 2401933.1)

Last updated on JUNE 11, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 7.5.0.20.0 version, Invoicing integration with BIP(Business Intelligence Publisher)

ACTUAL BEHAVIOR
---------------
On executing docgen.sh utility, after the invoice pdf was generated successfully in the configured ftp folder, it is expected that the table XMLP_INVOICE_JOB will have an entry with the completed job id and the corresponding invoice poid. But this was not happening and the following error was seen in the docgen log file even though the job status was a SUCCESS :

 

EXPECTED BEHAVIOR
---------------
There should be no error in the docgen log and the table XMLP_INVOICE_JOB should be updated with details of the completed job id.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.