Purpose

To process invoice Summary Errors

A parameter form is not required for this job, however Message Box (6636) states: No parameters exist for this job. Do you wish to schedule the job to run as soon as possible?

INTJ0065 comprises of a procedure that processes summary errors that may be generated when INTJ0060 is run.

This job runs independently, but accesses invoices and other records created by INTJ0021 and INTJ0060. The records accessed have been marked as in ERROR, in I_INVOICE_SUMMARY by an external process. If an invoice is identified as in ERROR, in the I_INVOICE_SUMMARY transfer process, INTJ0065 deletes records associated with the debt which originated the problem invoice, to the point before the first invoice was generated.

The context for this job is described in the overview.

Run Details

INTJ0065 can only run in batch mode, through the Job Control & Scheduling Subsystem.

Job Conflict

This job has been set up with conflict records preventing it running concurrently with INTJ0020, INTJ0021, INTJ0022, INTJ0023, INTJ0024 and INTJ0060. Nor can several instances of INTJ0065 run simultaneously.

Timing

INTJ0065 is run when records have been marked as being in ERROR, in I_INVOICE_SUMMARY by an external process.

Checking on the Job Run

Always check the run log in form JBSF5301, to see that the job ran successfully. Custom built messages in the log indicate the outcomes for each component of the job.

Process Invoice summary errors

This module processes records in I_INVOICE_SUMMARY with a transfer_status of ERROR. The module follows the following steps to resolve the error:

• Identify the I_INVOICE_SUMMARY records in error
• Write details of the related invoices to the I_INVOICE_HIST table (combines both the I_INVOICE and I_INVOICE_TRANS tables)
• Write the details of the related invoice payment of the I_INVOICE_PAYMENT_HIST table (combines I_INVOICE_PAYMENT, FEE_ASS and I_INVOICE_SUMMARY tables)
• Write student_todo and and student_todo_ref records of s_student_todo_type of INT_FININV to allow the debt to be reprocessed by the next COFI invoice run
• Set ccm_pair_ind to N for I_INVOICE CIN records with most recent previous iis.sequence number and ccm_pair_ind of Y
• Delete in order the associated table entries for the records associated with the error and all successor records:
  • FEE_ASS_EXTERNAL_REFERENCE
  • I_FEE_PAY_REF
  • FEE_ASS
  • I_INVOICE_PAYMENT
  • I_INVOICE_TRANS
  • I_INVOICE
  • I_INVOICE_ADJUSTMENT
  • I_INVOICE_SUMMARY
• Call the discounts procedure to recalculate the discounts (if a discount previously existed)
• Update the I_INVOICE_SUMMARY record a:
  • transfer_status of DELETED
  • logical_delete_dt of sysdate
  • sum_review_ind of Y
  • transfer_message of 'DO NOT EXPORT DELTED DATA'

When INTJ0021 is run subsequent to INTJ0065 being run, a new I_INVOICE_ADJUSTMENT records is created for invoices that were physically deleted as a result of INTJ0065. Associated I_INVOICE and I_INVOICE_TRANS records are also created.

Prior to INTJ0021 being run an attempt should be made to identify the error in the system which led to the invoice summary being found in error by the external finance system.

Rules/Notes:

INTJ0065 will not run if the record in error relates to a refund (in cases where refunds are configured to be summarised).

Only records associated with the error and their successor records are deleted with this process. Unconnected invoices which have not been summarised yet or have a transfer_status of SUMMARISED are left intact.

The I_INVOICE_HIST table contains the full set of columns from the I_INVOICE and I_INVOICE_TRANS tables.