EBI 9.2: $0 Invoice Amount Rows Are Not Picked Up For LOC Draw

(Doc ID 2384985.1)

Last updated on APRIL 11, 2018

Applies to:

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

Symptoms

When running Letter of Credit, $0 invoice amount invoices are included, but the report of BILDAR01 from the job is not formatted correctly and does not display all data.


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

  1. Create a contract;
  2. Click on Add Contract lines. Search for the product Grants%, check it and add it to contract;
  3. Go to Lines tab and open the Contract Terms;
  4. Select a PC unit, rate set and project and an activity;
  5. Go to Billing Options page and select Letter of Credit;
  6. Fill in Loc Doc ID;
  7. Select Letter of Credit ID;
  8. Activate the contract;
  9. Add a cost transaction - add and process transaction;
  10. Amount is fill in as 0.00 USD and when click on the transaction detail link;
  11. The BI Distribution Status has to be 'N¿. Press Process Transactions Open the process monitor and wait for the PC_WRAPPER to complete;
  12. The BIL row has been created. The BI Distribution Status will be changed from N to 'P' (Priced);
  13. Run the Incurred Billing under Customer Contracts/ Schedule and Process Billing/ Process As Incurred Billing- process Name CA_BI_INTFC by filling in Business Unit and Contract field;
  14. Open the message log. An interface ID has been created;
  15. Run the Billing Interface using the previous created interface ID
  16. Approve the worksheet under Billing/ Manage Billing Worksheet/ Letter of Credit Summary - click on Worksheet link Upon selecting the Contract- click on Approve Now button;
  17. Bill got created with Pretax Amount and Invoice Amount fields not populated - under Billing/ Manage Billing Worksheet/ Letter of Credit Summary / Review Contract/ Project Bills page;
  18. Invoice can be found under Standard Billing page having 0.00 USD amount under Standard Billing page (status is RDY);
  19. If running Letter of Summary- Message is received that no report will be generated when total draw amount is 0- Issue replicated- $0.00 Invoice amounts are not included for processing;
  20. If going to workaround suggested under navigation path Billing > Generate  Invoices > Non-Consolidated > Letter of Credit - select Letter of Credit ID the Letter of Credit ID created previously;
  21. Process runs with success;
  22. But even though BILDAR01 runs with success, the report generated for BILDAR01 in the job is not formatted correctly and does not display all data.

       - the report generated for BILDAR01 in the job is not formatted correctly and does not display all data when it is submitted from the navigation suggested.
         (BILDAR01 includes $0 invoice amount for processing, but the report does not pull up header and other details (pulls only the $0 invoice amount value)).

Changes

 

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