Field Service - EBS (MOSC)

MOSC Banner

Publication for custom database fails..

edited Jul 27, 2012 1:29PM in Field Service - EBS (MOSC) 3 commentsAnswered
We ran the  Installation manager scripts for  MFS Laptop (CSL)  in order to publish the custom database but it failed with errors as per the installation mgr logs.


While analyzing the logs, we found publication for many tables had failed with similar errors as below.


Example below (R12.1.3):-
Create INQ query  create or replace view MOBILEADMIN.CFM$CSP_REQUIREMENT_LINES as select REQUIREMENT_LINE_ID,REQUIREMENT_HEADER_ID,INVENTORY_ITEM_ID,UOM_CODE,REQUIRED_QUANTITY,SHIP_COMPLETE_FLAG,LIKELIHOOD,REVISION,SOURCE_ORGANIZATION_ID,SOURCE_SUBINVENTORY,ORDERED_QUANTITY,ORDER_LINE_ID,RESERVATION_ID,LOCAL_RESERVATION_ID,ORDER_BY_DATE,ARRIVAL_DATE,ITEM_SCRATCHPAD,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CLID$$CS,DMLTYPE$$,SEQNO$$,TRANID$$,VERSION$$ from CSL.CSL_CSP_REQUIREMENT_LNS_INQ

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