My Oracle Support Banner

ELA: RE_AM_ACCTG Process Going No Success In MSS DB When AM_DPCLOSE Runs (Doc ID 2389143.1)

Last updated on AUGUST 06, 2018

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, PI # 15. 2.4 Lease Maintenance

PeopleSoft FSCM 9.2 - Lease Management - SQL Error in RE_AM_ACCTG



ERROR
-----------------------

%InsertSelect(RE_INTCAS_TAO, AM_RE_LSI_TAO A, TXN_GRP = CASE WHEN A.DISTRIBUTION_TYPE = 'LO' THEN CASE WHEN A.TRANS_TYPE = 'PLP' THEN 'A' ELSE '8' END WHEN A.DISTRIBUTION_TYPE = 'RE' THEN 'C' WHEN A.DISTRIBUTION_TYPE = 'LN' THEN 'D' ELSE CASE WHEN A.TRANS_TYPE = 'PLP' THEN 'B' ELSE '9' END END, CA_RULE_KEY1 = '1' , CA_RULE_KEY4 = A.DISTRIBUTION_TYPE, CA_RULE_KEY5 = A.REC_SOURCE %Concat A.TXN_KEY, CA_RULE_KEY6 = A.LS_KEY, TXN_ITEM = CASE WHEN A.DISTRIBUTION_TYPE = 'LO' THEN CASE WHEN A.TRANS_TYPE = 'PLP' THEN '18' ELSE '16' END WHEN A.DISTRIBUTION_TYPE = 'RE' THEN '20' WHEN A.DISTRIBUTION_TYPE = 'LN' THEN '21' ELSE CASE WHEN A.TRANS_TYPE = 'PLP' THEN '19' ELSE '17' END END, CA_RULE_KEY11 = A.TRANS_TYPE, CA_RULE_KEY12 = A.REC_SOURCE, CA_RULE_KEY13 = A.TXN_KEY, AMOUNT = A.MERCHANDISE_AMT, TXN_DEST = '1', CA_RULE_KEY14 = A.DISTRIBUTION_TYPE, CA_RULE_KEY15 = %NumtoChar(A.CF_SEQNO), CA_RULE_KEY16 = A.ASSET_ID, AMND_NBR = %COALESCE(B.AMND_NBR, A.AMND_NBR), BUSINESS_UNIT = C.BUSINESS_UNIT)
  FROM %Table(AM_RE_LSI_TAO) A LEFT OUTER JOIN PS_RE_LS_TRM_SCHED B ON (A.TXN_KEY_1 = B.TERM_SCHED_ID) INNER JOIN PS_RE_LS C ON (C.LS_KEY = A.LS_KEY)
 WHERE A.PROCESS_INSTANCE = %ProcessInstance
  AND A.REC_SOURCE = 'A'



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an asset
 2. Calculate depreciation
 3. Review depreciation information
 4. Create accounting entries
 5. Review financial entries
 6. Close depreciation
 7. Verify that AM_DPCLSOE going to No Success

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run close process and unable to close books.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.