My Oracle Support Banner

SAEXPDW_EXPORT_ADHOC_JOB Fails While Executing SA_EXPDW_BI_SQL.PROCESS_EXPORT (Doc ID 3080159.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 25.0 and later
Information in this document applies to any platform.

Symptoms

On: MFCS/ReSA 25.0.101.0 version

The SAEXPORT_SALES_TO_DW.KSH job is consistently aborting following manual adjustments to sales data made via the user interface.


Steps to Reproduce
-----------------------
1. Log in to Sales Audit
2. Search for a transaction for the day that has already been exported.
3. Adjust any discount or tax amounts.
4. Wait for the batch SAEXPDW_EXPORT_ADHOC_JOB to run again.

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


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