Information Template Form errors where MO: Operating Unit is not setup at Site Level (Doc ID 1935228.1)

Last updated on OCTOBER 14, 2014

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Misc Issues

Information template errors when open using a responsibility where MO: Operating Unit is not setup at site level.

ERROR
-----------------------
APP-PO-14142: get_po_parameters-10: ORA-1403: no data found
Cause: A SQL error has occured in get_po_parameters.
The SQL error is ORA-1403: no data found.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Do not set the profile MO: Operating Unit at Site level.
2. Open the Information Templates form. Error occurs.

According to following note this issue has been fixed in the file version POXSTIFT.fmb 120.1.12000000.2.

Note 878682.1: Error APP-PO-14142 Get_po_parameters-10 ORA-1403 no data found in Information Templates Form

However same issue is occurring again in the file version POXSTIFT.fmb 120.1.12000000.6.

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