Billing Interface Process Completes in Warning with “0411 Missing Bill by Field(s) Value” Interface Error When FROM_DT and TO_DT Fields Are Added to Bill by ID and Are Not Populated (Doc ID 3030156.1)

Last updated on JUNE 25, 2024

Applies to:

Symptoms

Billing Interface process completes in warning when FROM_DT and TO_DT fields are added to Bill by ID but not populated. Before PUM Image 50 the  interface error was not thrown.

Steps to reproduce the issue

1. Navigate to Set Up Financials/Supply Chain > Product Related > Billing > Setup > Bill-by Identifier;
2. Add FROM_DT and TO_DT fields to Bill by ID;
3. Create a contract (Customer Contracts > Create and Amend > Define Contract General Info);
4. Add an amount-based line;
5. Associate a milestone billing plan to the contract line;
6. Open the billing plan and create some events. Put an event on Ready;
7. Activate the contract;
8. Navigate to  Customer Contracts > Schedule and Process Billing > Process Other Billing Methods and run CA_BI_INTFC;
9. Run Billing Interface (Billing > Interface Transactions > Process Billing Interface).

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.