EBI 9.2:BI_IVCEXT Process Failing At BI_IVCEXT.POPLGRNT.STEP02 For Grants Invoice (Doc ID 2220854.1)

Last updated on JANUARY 12, 2017

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On 9.2 version, when attempting to use Courtesy Copy Address tab to set the number of copies for an adjusted grants invoice, then running the Single Action Invoice job, the following error occurs:

ERROR
-----------------------
Process ABENDED at Step BI_IVCEXT.POPLGRNT.Step02 (SQL) -- RC = 805

REPLICATION STEPS
------------------------
The issue can be reproduced at will with the following steps:

  1. Add a proposal
  2. Submit the proposal
  3. Generate award
  4. The contract is created
  5. Activate the contract
  6. Go to project costing and add an ACT row
  7. BIL row was generated
  8. Run Incurred Interface
  9. Interface id previously created
  10. Run Billing Interface
  11. Set the invoice to ready
  12. Finalize the invoice
  13. The Bill has been invoiced
  14. Scenario 1: Use Copy Bill
  15. On the newly obtained bill use the Courtesy Copy Address functionality to increase the number of needed copies (ex. 3) then change the bill status to RDY
  16. Run Single Action invoice for above bill
  17. Scenario 2: Adjust Entire Bill
  18. Number of copies is 3 in the Courtesy Copy Addr tab
  19. Run Single Action invoice for this invoice too

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