Order Invoicing Fails With:- Enter quota sales credit percentages that equal 100 for this line.

Last updated on JUNE 07, 2017

Applies to:

Symptoms

Orders are stuck with Status - AWAITING_BILLING, the AutoInvoice process raises the following errors:

NOTE: Sales Credits have been entered on the Order Header

Enter quota sales credit percentages that equal 100 for this line.

The original system bill-to customer ID {ORIG_SYSTEM_BILL_CUSTOMER_ID is invalid.
The ship-to customer identifier {SHIP_TO_PARTY_ID is invalid.
The ship-to party contact identifier {SHIP_TO_PARTY_CONTACT_ID is invalid. The party contact either does not exist or is not associated to the ship-to party.
The original system bill-to customer address ID {ORIG_SYSTEM_BILL_ADDRESS_ID is invalid.
The ship-to party site identifier {SHIP_TO_PARTY_SITE_ID is invalid. The party site either does not exist or is not associated to the ship-to party.

NOTE: The issue reported lies with the error - Enter quota sales credit percentages that equal 100 for this line. The GL_DATE and TRX_DATE are not set on the interface lines table which then results in the other errors. These errors should be resolved once the primary salescredit error is resolved

NOTE: The errors can be seen by running the following SQL

NOTE: Executing SQL using BI in a Cloud Environment is described in - Fusion Applications BI Publisher : How Can I Use BI Publisher to Run SQL Against the Fusion Applications Database ? (Doc ID 1910762.1)

Cause