My Oracle Support Banner

DBPATCH.LOG Errors When Applying 6.1 - "ERROR APPLYING preupdate7331920" and "ORA-01727: numeric precision specifier is out of range" (Doc ID 1053909.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Transportation Management - Version: 6.1
Information in this document applies to any platform.

Symptoms


When applying 6.1, the following error is encountered in the DB Patch logs.

ERROR APPLYING preupdate7331920
ORA-28112: failed to execute policy function

alter table ARCHIVE.SS_STATUS_HISTORY_DMP modify ( PARTITION_KEY NUMBER(, 0) NULL )
ORA-01727: numeric precision specifier is out of range (1 to 38)
alter table ARCHIVE.SHIPMENT_DMP modify ( TOTAL_DECLARED_VALUE NUMBER(, 0) NULL )
ORA-01727: numeric precision specifier is out of range (1 to 38)
alter table ARCHIVE.ORDER_RELEASE_DMP modify ( TOTAL_DECLARED_VALUE NUMBER(, 0) NULL )
ORA-01727: numeric precision specifier is out of range (1 to 38)

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
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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