PUM image 21 - Running AMPI1000.SQR return with (SQR 4707) No Value Found For Substitution Variable: {select-charts-rncntl1} {SELECT-CHARTS-RNCNTL1},

(Doc ID 2227343.1)

Last updated on JANUARY 26, 2017

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Physical Inventory

AMPI1000.SQR goes to error on Image 21

Physical Inventory process fails on job AMPI1000.SQR. Attached are the steps to replicate the error in demo environment. We are on PT8.54.09 Image 21.


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

Error in include file "/apps/psoft/app/fm/sqr/amrnctlc.sqc" on line 67:
  (SQR 4707) No value found for substitution variable: {select-charts-rncntl1}
{SELECT-CHARTS-RNCNTL1},

Error in include file "/apps/psoft/app/fm/sqr/amrnctlc.sqc" on line 68:
  (SQR 4707) No value found for substitution variable: {select-charts-rncntl2}
{SELECT-CHARTS-RNCNTL2},

Error in include file "/apps/psoft/app/fm/sqr/amrnctlc.sqc" on line 69:
  (SQR 4707) No value found for substitution variable: {select-charts-rncntl3}
{SELECT-CHARTS-RNCNTL3},

Error in include file "/apps/psoft/app/fm/sqr/amrnctlc.sqc" on line 70:
  (SQR 4707) No value found for substitution variable: {select-charts-rncntl4}
{SELECT-CHARTS-RNCNTL4},
(SQR 5528) ORACLE OCIStmtExecute error 936 in cursor 34:
  ORA-00936: missing expression
SQL: SELECT RUN_CNTL_AM.LANGUAGE_CD, RUN_CNTL_AM.PI_ID,
  RUN_CNTL_AM.MATCH_STATUS, RUN_CNTL_AM.PI_ERROR_SW, RUN_CNTL_AM.FILENAME,
  {SELECT-CHARTS-RNCNTL1}, {SELECT-CHARTS-RNCNTL2},
  {SELECT-CHARTS-RNCNTL3}, {SELECT-CHARTS-RNCNTL4}, RUN_CNTL_AM.LOCATION,
  RUN_CNTL_AM.RUN_TYPE FROM PS_RUN_CNTL_AM RUN_CNTL_AM WHERE
  RUN_CNTL_AM.OPRID = :1 AND RUN_CNTL_AM.RUN_CNTL_ID = :2

Error in include file "/apps/psoft/app/fm/sqr/amrnctlc.sqc" on line 126:
  (SQR 3716) Error in SQL statement.

(SQR 4407) Referenced variables not defined:

  &run_cntl_am.deptid

Errors were found in the program file.

SQR for PeopleSoft: Program Aborting.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Asset ManagementPhysical InventoryLoad/Match/Reconcile PI Info
2. Select Delete and run the AMPI1000


Changes

 

Cause

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 hundreds of Community platforms