EBI 9.2: $0 Invoice Amount Rows Are Not Picked Up For LOC Draw (Doc ID 2384985.1)

Last updated on SEPTEMBER 01, 2021

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.