Value Chain Planning - EBS (MOSC)

MOSC Banner

Running request "Create APS Partitions" for ebs R121.3, errors out with: ORA-02149: Specified partit

edited Feb 20, 2013 4:39AM in Value Chain Planning - EBS (MOSC) 3 commentsAnswered
We are on AIX 6.1, EBS 12.1.3, Oracle Database 11.2.0.3, Distributed VCP setup.The issue being reported in Source EBS Instance.
We have seperate EBS install for ASCP only.

Running the Conncurrent Request  "Create APS Partitions"  
Plan partition count = 0
Instance partition count = 1
ERRORS Out Immediately:
------------------------------------
**Ends**19-FEB-2013 10:28:26
-2149:ORA-02149: Specified partition does not exist
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
l_share_partition := N
plan count := 8
j := 1
plan_ids := 4001
table := MSC_ATP_SUMMARY_SD
partition_name : ATP_SUMMARY_SD_4001
Plan partition for plan 4001 already exists

Query output for :
----------------------------
select table_name,
       partition_name
from   all_tab_partitions
where  table_name like 'MSC_NET_RES_INST%'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center