SALMAINT Fails with ORA-14083 Error when You Use Gregorian Calendar and Do Not Populate WEEK_DATA
(Doc ID 2705589.1)
Last updated on SEPTEMBER 01, 2020
Applies to:Oracle Retail Merchandising System - Version 16.0.3 to 16.0.3 [Release 16.0]
Information in this document applies to any platform.
The SALMAINT.PC (Stock Ledger Table Maintenance) with POST options throws ORA-14083 error when you configure the System withe Gregorian (Normal) calendar and do not populate the WEEK_DATA table.
The SALMAINT should be smart enough to check the calendar type, and if it is Gregorian, SALMAINT should not try to process WEEK_DATA. Furthermore, you should not need partitions on an empty table.
Steps to Reproduce
1. Use Gregorian Calendar.
2. Do not populate the WEEK_DATA table.
3. Run the SALMAINT batch with the POST option.
4. Notice the error:
"salmaint~20200720122053~week_data~RMS16.WEEK_DATA~-14083~ORA-14083: cannot drop the only partition of a partitioned table~Execute ALTER DROP".
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