Error While Personalizing Edit Single Line Requisition Page (EditSingleLineRN) Through Functional Administrator or Setting Personalization (Doc ID 3047409.1)

Last updated on SEPTEMBER 18, 2024

Applies to:

Symptoms

While personalizing below iProcurement Edit Single Line Requisition Page (EditSingleLineRN) using Functional Administrator responsibility.

ERROR

Complete Error Message:
Error PageException Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoRequisitionHeaderEO.PROGRAM_UPDATE_DATE, PoRequisitionHeaderEO.INTERFACE_SOURCE_CODE, PoRequisitionHeaderEO.INTERFACE_SOURCE_LINE_ID, PoRequisitionHeaderEO.CLOSED_CODE, PoRequisitionHeaderEO.ORG_ID, PoRequisitionHeaderEO.DESCRIPTION,

....
## Detail 0 ##java.sql.SQLException: Missing IN or OUT parameter at index:: 1at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)

The issue can be reproduced at will with the following steps:
1. Profile FND: Enable Personalization Workbench to No
FND: Personalization Region Link Enabled to Yes
2. Clear the cache

3. Go to iProcurement responsibility > View Cart and Checkout
4. Click Edit
6. Select Line and click Update
7. Click link Personalize Stack Layout
8. Click Personalization Workbench
9. Error is shown

Error happens also from the steps:
1. Set profiles as below:
FND: Enable Personalization Workbench is Yes
FND: Personalization Region Link Enabled is No
2. Go to Functional Administrator responsibility > Personalization
3. Enter in Document Path: /oracle/apps/icx/por/req/webui/EditSingleLineRN -> Click Go
4. Click Personalize pencil
5. Click Personalization Workbench button
6. Error is shown

Changes

Cause

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