Asset Lifecycle Management - PSFT (MOSC)

MOSC Banner

Issue with Mass Change definition

edited Jul 9, 2016 5:01AM in Asset Lifecycle Management - PSFT (MOSC) 3 commentsAnswered

Hi,

Currently we have upgraded from 9.1 to 9.2 image 11.

We were looking for archiving asset data and we see that mass change has been changed in 9.2. When we tried to create mass definitions  we observed that in 9.1 we had "AM Specific Fields" tab which used to store additional parameters for AM that has been removed in 9.2.

however, when we try to generate SQL, SQL generated for archive open items its as below:

INSERT INTO PS_OPEN_TRANS_ARCH (ACCOUNTING_DT, ARCHIVE_DT, ARCHIVE_ID, ASSET_ID, BOOK, BUSINESS_UNIT, CALC_DEPR_STATUS, CALC_DIST_STATUS, CALC_REPT_STATUS, CONVENTION, DTTM_STAMP, EFFDT, GROUP_ASSET_ID, MAX_DTTM_STAMP, MEM_IN_SERVICE_DT, MIN_DTTM_STAMP, OPEN_TRANS_ID, OPRID, PROCESS_INSTANCE, REQUEST_ID, SUM_GROUP_STATUS, TRANSFER_ASSET_ID, TRANSFER_BOOK, TRANSFER_BU, TRANS_DT, TRANS_IN_OUT, TRANS_TYPE)  SELECT OPEN_TRANS.ACCOUNTING_DT, MC_DEFN.ARCHIVE_DT, MC_DEFN.ARCHIVE_ID, OPEN_TRANS.ASSET_ID, OPEN_TRANS.BOOK, OPEN_TRANS.BUSINESS_UNIT, OPEN_TRANS.CALC_DEPR_STATUS, OPEN_TRANS.CALC_DIST_STATUS, OPEN_TRANS.CALC_REPT_STATUS, OPEN_TRANS.CONVENTION, OPEN_TRANS.DTTM_STAMP, OPEN_TRANS.EFFDT, OPEN_TRANS.GROUP_ASSET_ID, OPEN_TRANS.MAX_DTTM_STAMP, OPEN_TRANS.MEM_IN_SERVICE_DT, OPEN_TRANS.MIN_DTTM_STAMP, OPEN_TRANS.OPEN_TRANS_ID, OPEN_TRANS.OPRID, OPEN_TRANS.PROCESS_INSTANCE, OPEN_TRANS.REQUEST_ID, OPEN_TRANS.SUM_GROUP_STATUS, OPEN_TRANS.TRANSFER_ASSET_ID, OPEN_TRANS.TRANSFER_BOOK, OPEN_TRANS.TRANSFER_BU, OPEN_TRANS.TRANS_DT, OPEN_TRANS.TRANS_IN_OUT, OPEN_TRANS.TRANS_TYPE FROM PS_MC_DEFN MC_DEFN, 

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