EAM: Create Accounting Lines (AM_AMAEDIST) Process Abended at Step AM_AMAEDIST.700150.Step01 (SQL) -- RC = 8601 (108,524) With Message - "Invalid column name 'RE_ACCT_AM_AET_SEL'". (Doc ID 2978410.1)

Process 145590 resumed after step AM_AMAEDIST.200170.Step58 (108,538)

File: E:\PT859P11B_2206290502-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1811 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'RE_ACCT_AM_AET_SEL'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
Failed SQL stmt: INSERT INTO PS_AM_RE_LSI_TAO5 (PROCESS_INSTANCE, REC_SOURCE, BUSINESS_UNIT, BUSINESS_UNIT_GL, ASSET_ID, BOOK, CF_SEQNO, TRANS_TYPE, COST_TYPE, DISTRIBUTION_TYPE, TXN_KEY, LS_KEY, AMND_NBR, TERM_ID, TXN_GRP, PRORATION_RATE, CURRENCY_CD, MERCHANDISE_AMT, LS_TXN_SRC_ID, CAPITALIZE_SW, CATEGORY, TXN_KEY_1, IDC_PRORATION_RATE) SELECT DISTINCT 145590, 'A', A.BUSINESS_UNIT, A.BUSINESS_UNIT_GL, A.ASSET_ID, A.BOOK, A.CF_SEQNO, ' ', A.COST_TYPE, A.DISTRIBUTION_TYPE, B.LS_KEY, B.LS_KEY, 0, 0, ' ', B.PRORATION_RATE, A.CURRENCY_CD, 0, 0, ' ', A.CATEGORY, 0, B.IDC_PRORATION_RATE FROM PS_AM_DST_DL_TMP5 A,PS_RE_LS_PPTY B,PS_LEASE C, PS_RE_LS D WHERE A.PROCESS_INSTANCE=XXXXX AND A.BUSINESS_UNIT=B.BUSINESS_UNIT_AM AND A.ASSET_ID=B.ASSET_ID AND A.BUSINESS_UNIT=C.BUSINESS_UNIT AND A.ASSET_ID=C.ASSET_ID AND ((C.LEASE_TYPE='C' AND 'N' <> 'Y') OR 'N' = 'Y') AND A.DISTRIBUTION_TYPE IN ('LO','RE','LN','LR') AND B.ISNEW_FLAG = 'N' AND B.LS_KEY = D.LS_KEY AND D.LEASE_OBLG = '1' AND EXISTS ( SELECT 'X' FROM PS_RE_BUS_UNIT LA_BU WHERE LA_BU.BUSINESS_UNIT = D.BUSINESS_UNIT AND RE_ACCT_AM_AET_SEL = 'N')

Process XXXXXX ABENDED at Step AM_AMAEDIST.700150.Step01 (SQL) -- RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s