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:

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

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