PRC: Generate Draft Invoices For A Range Of Projects "Error Trying To Reduce Billed Amount In funding record" (Doc ID 2192660.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Invoices

PRC: Generate Draft Invoices for a Range of Projects "Error trying to reduce billed amount in..."

PRC: Generate Draft Invoices for a Range of Projects is showing error log "Error trying to reduce billed amount in funding record" in the log file when submitted with following parameters:
Parameters Passed From Program : CONCESSION, 45020, 2, , , , 50, , , , , , , , , , , , , , , SUMMARY
All of the Concurrent program parameters have been enable and want to generate Credit Memo programmatically by replicating the job submitted upon pressing "Credit" button from the UI ( Invoice Review Screen).
When Credit button is used from UI with 'Apply Concession' option , Parameters Passed to this program are : CONCESSION, 45020, 4, , , , 50, , , , , , , , , , , , , , , SUMMARY. The Credit memo is created successfully.
But when the program is directly submitted from the Request Workbench, it create a Credit Memo but the invoice amount is NULL even though we passed a credit amount of 50.
LOG FILE OF PRC: Generate Draft Invoices for a Range of Projects

..entering paiiig +---------------------------------------------------------------------------+
Projects: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

PAIGEN module: PRC: Generate Draft Invoices for a Range of Projects
+---------------------------------------------------------------------------+

Current system time is 11-SEP-2016 21:28:54

+---------------------------------------------------------------------------+

...Setting Sets Of Books...2061...Leaving paiiig
...Cancel/ concession for this invoice
...Concession
 Org Id - 1: CONCESSION

  I am here CONCESSION . .
 Doing round off
  round_off_ITC - 50
  round_off_IPC - 0
  round_off_PFC - 0
  round_off_PC - 0
  round_off_FC - 0Entering paiupf()
Error trying to reduce billed amount in funding record
 Entering pairbi.Current system time is 11-SEP-2016 21:28:54
...About to call Approval/Release Extn Driver
....Calling Place : CONCESSION Project_ID : 33004Current system time is 11-SEP-2016 21:28:54

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