Issue with Mass Change definition
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,