EAM: After PUM 46 Upgrade, Calculate Depreciation Process Abends. AM_DEPR_CALC ABENDED at Step AM_DEPR_DATE.911021.Step20 (Action PeopleCode) -- RC = 4. Related AMDPCALC.sqr Errored With Message - "(SQR 4707) No Value Found For Substitution Variable" (Doc ID 2931742.1)

Last updated on AUGUST 07, 2023

Applies to:

Symptoms

After PUM 46 upgrade, Calculate Depreciation Process abends. AM_DEPR_CALC Abended at Step AM_DEPR_DATE.911021.Step20 (Action PeopleCode) -- RC = 4. Related AMDPCALC.sqr errored with message - "(SQR 4707) No Value Found For Substitution Variable"

Replication Steps:

1. After upgrading to PUM 46, the new amcharts.sqc was generated and copied to the folder location where delivered application SQRs are stored. (Generating amcharts.sqc is part of one of the upgrade steps per the user. Please review <Document:2243761.1> EAM: How to generate AMCHARTS.sqc. As noted, the ambuilds.sqr process is run to generate amcharts.sqc. Navigation: Set Up Financials/Supply Chain Common Definitions Design ChartFields Configure Update AM ChartField SQC).
2. Create an Asset. (Navigation: Asset Management > Asset Transactions > Owned Assets > Express Add - Add a new Asset.
3. Run Asset Management > Depreciation >Processing > Calculate Depreciation process. The AM_DEPR_CALC process gets called and the process abends with the error message above. The error can be seen in the message log/trace This AM_DEPR_CALC AE process calls the AMDPCALC SQR process and the AMDPCALC process error out as well and the error can be seen in the out file.

Sample Demo screenshots

Changes

 After PUM 46 upgrade. Not a SQL server specific issue. This can happen for other databases as well. 

Cause

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