Import Auto Invoice Program Ending With Error The original system bill-to customer ID {ORIG_SYSTEM_BILL_CUSTOMER_ID is invalid. (Doc ID 2326022.1)

Last updated on JUNE 02, 2024

Applies to:

Symptoms

When attempting to Import Auto-Invoice
the following error occurs.

ERROR
-----------------------
1 The original system bill-to customer ID {ORIG_SYSTEM_BILL_CUSTOMER_ID is invalid. (AutoInvoice import process error: {NULL.)
2 The original system bill-to customer address ID {ORIG_SYSTEM_BILL_ADDRESS_ID is invalid. (AutoInvoice import process error: {NULL.)
3 The original system bill-to customer ID {ORIG_SYSTEM_BILL_CUSTOMER_ID is invalid. (AutoInvoice import process error: {NULL.)
4 The original system bill-to customer address ID {ORIG_SYSTEM_BILL_ADDRESS_ID is invalid. (AutoInvoice import process error: {NULL.)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Download AutoInvoiceImportTemplate.xlsm
2. Fill the necessary field. and Login to the Application
3. Go to Scheduling Processes
4. Run Auto Invoice - Import AutoInvoice Program,
select the File form the Data Import.
monitor the job for completion
5. Reviewed logs and observed the error described appears


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Users cannot perform the Importing Auto-Invoice

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.