EBI 9.2: CUSTOMER_PO_LINE Is Not Getting Copied From INTFC_BI Table to INTFC_BI_CMP Table When the Interface Id Has Multiple Lines and Some Has the Field Populated and Some Don’t. (Doc ID 3037217.1)

Last updated on JULY 24, 2024

Applies to:

Symptoms

CUSTOMER_PO_LINE is not getting copied from INTFC_BI table to INTFC_BI_CMP table when the interface id has multiple Lines and some has the field populated and some don't.

If the interface table has the field populated it should get copied to the interface completion table and bill as well.

Replication:
-----------------------
1. Create two orders and populate CUSTOMER_PO_LINE field in one order and do not populate in other. ( Order management > Quotes and Orders > Create or update Sales order)
2. Run OM_BILL to send these orders to Billing. ( Order management > Quotes and Orders > Create OM Billing Entries > Process OM Billing)
3. Check INTFC_BI the interface id for both orders should be same with different lines and CUSTOMER_PO_LINE should be populate for one line and not for other.
4. Run BIIF0001 check INTFC_BI_CMP table for interface lines have blank CUSTOMER_PO_LINE. ( Billing > Interface Transaction > Process interface transactions)

 
Replication

Cause

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