Publication for custom database fails..
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
0