Reason for getting ORA-14400 Error While Creating Orders in OSM
edited Jul 19, 2012 3:05AM in Order and Service Management (Communications Industry) (MOSC) 2 commentsAnswered
Cause
The order_seq_id reached the partition limit.
The value of the next_range_partition_boundary in the OM_PARAMETER table gives the partition
limit. This value was less then max order_seq_id value.
Solution
To implement the solution, please execute the following steps:
1. Use
Oracle
Scriptor to open:
OMS_HOME\Database\OMS\maintenance\partitions\new_part.sql
input parameters and Parse and Run
2. Run SQL command:
select PARTITION_NAME from user_tab_partitions where TABLE_NAME='OM_ORDER_HEADER';
<br/>
<br/>PARTITION_NAME
<br/>P_000000000001000000
<br/>
3. Run SQL command:
select max(order_seq_id) from om_order_header;
<br/>
<br/>MAX(ORDER_SEQ_ID)
<br/>999999
<br/>
0