Docgen Throws Error "java.lang.Exception: Scheduler DB insert Invoice JOb mapping - SQL Error" Even After Generating Invoice Report in BIP
Last updated on JUNE 11, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
On : 184.108.40.206.0 version, Invoicing integration with BIP(Business Intelligence Publisher)
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 :
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