Order Invoicing Fails With:- The primary salesperson ID {PRIMARY_SALESREP_ID is invalid. (Doc ID 2274737.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Receivables Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

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

The primary salesperson ID {PRIMARY_SALESREP_ID is invalid.
You must provide sales credit assignments for this transaction because the system option Require salesperson is enabled.


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 - The primary salesperson ID {PRIMARY_SALESREP_ID is invalid. 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

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms