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 and later
Information in this document applies to any platform.


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

On executing 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 :


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.


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 hundreds of Community platforms