Docgen 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 MARCH 24, 2023

Applies to:

Symptoms

On executing docgen.sh utility, after the invoice pdf generated successfully in the configured ftp folder, it is expected that the table XMLP_INVOICE_JOB should 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:

Changes

Cause

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