Technology Stack - EBS (MOSC)

MOSC Banner

Issues using move_qt_pkg package for ebs r12.1.3

edited Aug 20, 2021 11:53AM in Technology Stack - EBS (MOSC) 4 commentsAnswered ✓

Hello Experts,

OS platform - OEL 5.11

EBS version - 12.1.3

DB version - 12.1.0.2

As part of moving some queue tables to reclaim space from APPS_TS_QUEUES, I am facing below error -

11:39:35 SQL> exec move_qt_pkg.move_queue_table('ASO','ASO_ORDER_FEEDBACK_T','APPS_TS_QUEUES','APPS_TS_QUEUES')

BEGIN move_qt_pkg.move_queue_table('ASO','ASO_ORDER_FEEDBACK_T','APPS_TS_QUEUES','APPS_TS_QUEUES'); END;

*

ERROR at line 1:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "APPS.MOVE_QT_PKG", line 226

ORA-06512: at "APPS.MOVE_QT_PKG", line 105

ORA-06512: at line 1

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