FA: SCM: OM: Invoicing Fails With: Enter quota sales credit percentages that equal 100 for this line. (Doc ID 2274730.1)

Last updated on JUNE 26, 2020

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

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