My Oracle Support Banner

Java.sql.SQLSyntaxErrorException: ORA-00904: PPR.REQUESTER_ID: Invalid Identifier (Doc ID 2718507.1)

Last updated on MARCH 19, 2024

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to create requisitions in iProcurement, the following error occurs.


Error

java.sql.SQLSyntaxErrorException: ORA-00904: "PPR"."REQUESTER_ID": invalid identifier



Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. Add items to the cart
2. Try to checkout




The error can also appear in the database alert.log file and the OACORE Server log file.


>> Here is an example from the database alert log file:

bxxxxx1(3):WARNING: too many parse errors, count=3374 SQL hash=0x4cf736a7
bxxxxxx1(3):PARSE ERROR: ospid=11156, error=904 for statement:
2022-08-12T17:15:48.972416-04:00
bxxxxxx1(3):SELECT ppr.need_by_date,ppr.deliver_to_location_id,ppl.destination, ppr.requester_id
FROM po_proc_plan_header pph,
 po_proc_plan_line ppl,
 po_proc_plan_period_req ppr,
 po_proc_plan_schedule_links ppsl
WHERE pph.proc_plan_id          = ppl.proc_plan_id
AND ppl.proc_plan_line_id(+)    = ppr.proc_plan_line_id
AND ppr.proc_plan_period_req_id = ppsl.proc_plan_period_req_id(+)
AND ppsl.requisition_line_id    = :1
bxxxxxx1(3):Additional information: hd=0x1feb4d570 phd=0x20ec0a518 flg=0x100476 cisid=114 sid=114 ciuid=114 uid=114 sqlid=f4xf5ax6gfdp7
bxxxxxx1(3):...Current username=AXXX (apps schema name)
bxxxxxx1(3):...Application: e:ICXC:wf:POWFRQAG Action: ICXC/REQUISITIONER


>> Here is an example from the OACORE server log file:

<Jan 30, 2023 1:01:20 PM EST> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
java.sql.SQLSyntaxErrorException: ORA-00904: "PPR"."REQUESTER_ID": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.prepareReqLinesForDisplay(CheckoutSummarySvrCmd.java:588)
at oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.prepareReqSummaryVOForDisplay(CheckoutSummarySvrCmd.java:486)
at oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.prepareForDisplay(CheckoutSummarySvrCmd.java:309)
at oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.executeMethodByName(CheckoutSummarySvrCmd.java:161)
at oracle.apps.icx.por.req.server.CheckoutInfoBaseSvrCmd.execute(CheckoutInfoBaseSvrCmd.java:163)
at oracle.apps.icx.por.common.server.PorBaseAMImpl.executeServerCommand(PorBaseAMImpl.java:122)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
..
..

 

 

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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