My Oracle Support Banner

Planned PO Erred With: POAPPRV PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO ORA-01403 (Doc ID 1474136.1)

Last updated on APRIL 04, 2025

Applies to:

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

Symptoms

On 12.1.3:

Email notifications failed for Planned Purchase Order with the following error:

PL/SQL procedure: PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO
Error: ORA-01403: no data found "

the fnd log file shows:
==================
wf.plsql.wf_engine_util.function_call.actfunc_callout End executing PLSQL procedure - PO_REQAPPROVAL_INIT1.FAX_DOC_YES_NO [End time 534766891] [Time taken - .05 secs]
wf.plsql.wf_engine_util.function_call.actfunc_callout Start executing PLSQL procedure - PO_REQAPPROVAL_INIT1.EMAIL_DOC_YES_NO [Start time 534766906]
po.plsql.PO_DOC_STYLE_PVT.get_style_display_nameBEGIN Start of subprogram.
po.plsql.PO_DOC_STYLE_PVT.get_style_display_nameBEGIN p_doc_id = 547148
po.plsql.PO_DOC_STYLE_PVT.get_style_display_nameBEGIN p_language = US
po.plsql.PO_DOC_STYLE_PVT.get_style_display_name10.EXCEPTION 100ORA-01403: dados não encontrados;SQLERRM = ORA-01403: dados não encontrados

Changes

 Upgrade from 11.5.10.2 to 12.1.3.

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.