Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 11.5.9 and later
Information in this document applies to any platform.
MSRFWOR Refresh Collection Snapshots fails ORA-1653: unable to extend table on snapshot INV.MTL_SYS_ITEMS_SN and WIP.WIP_WREQ_OPRS_SN
The following errors are also in the ALERT file:
WIP.WIP_WREQ_OPRS_SN by 27309 in tablespace WIPD.
Verified the issue by the log file for MSRFWOR module: Refresh Collection Snapshots. A second snapshot with the same problem is also noted in another log file -
ORA-01653: unable to extend table INV.MTL_SYS_ITEMS_SN by 40964 in tablespace INVD
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms