Running Docgen Job To Generate Invoices And Send Them Via Email (Doc ID 2990015.1)

Last updated on DECEMBER 13, 2023

Applies to:

Goal

When running docgen job to generate invoices and send them via email, the following happens:

1. When the docgen script is run with input parameters for start and end date (ex. ./docgen.sh -start 08/01/2023 -end 08/10/2023) all e-mails are sent via one report job created on Business Intelligence Publisher (BIP).

2. When the script is run with xml file with accounts as input parameter (ex. ./docgen.sh -accts_list InvoiceList.xml -start 08/01/2023 -end 08/10/2023) each e-mail is sent via one job.
So, if we have an xml file that contains 500 accounts, 500 report jobs will be created with one email sent each.
Is it possible to run the docgen script with the input parameter InvoiceList.xml but to create only one job? We will have hundreds of thousands of accounts in one segment, it’s not OK to generate that many BIP email jobs. The persons handling this cannot monitor the process and also the system itself will have a hard time running 100k jobs.

 
[QUESTION]

How can one get only one job per docgen run, whatever the parameters are? Is it possible to open up pin_inv_doc_gen for modifying, ie to apply the filter somewhere inside docgen account fetching process?

Solution

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