Prorate is not implemented: Item Total Charge on Invoice and Qty Invoiced and Amount Invoiced on the PO line item are not updated (Doc ID 1541381.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.

Symptoms



When copying (F6/F4) from a Posted Invoice, the Prorate_Ind is set to 'Y' when it should be 'N':

Steps to Reproduce:

1. Pull up an Invoice in Posted status
2. F6-F4 to copy
3. New Invoice is created in ‘Created’ status
4. Check the prorate_ind field in SA_INVOICE via SQL Developer. It is set to ‘Y’
  
Since this field determines if the prorate procedure is called, it is never getting implemented since the application thinks proration has already been done. On a copied invoice where the Prorate_ind defaults to 'Y' upon creation, neither the Item Total Charge on the Invoice or the Qty Invoiced and Amount Invoiced on the PO line item are updated even after the invoice is Posted.

Cause

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