Import Standard Purchase Orders Failed with Error:FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception (Doc ID 2206230.1)

Last updated on AUGUST 06, 2024

Applies to:

Symptoms

When attempting to run program "Import Standard Purchase Orders", the following error occurs.

ERROR
-----------------------
Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_PDOI_GRP", line 398
ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Purchasing responsibility.

2.Run program "Import Standard Purchase Orders", then get below error in the request log file:
ORACLE error 6510 in FDPSTP
Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_PDOI_GRP", line 398
ORA-06512: at line 1

3. In the FND debug log file, get below error:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_HEADERS_DRAFT_PVT", line 381
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_HEADERS_DRAFT_PKG", line 1560
ORA-28132: The MERGE INTO syntax does not support the security policy.

4.In the trace file, see below error details:

MERGE INTO PO_HEADERS_ALL PH USING...
ORA-28132: The MERGE INTO syntax does not support the security policy.in Package po.plsql.PO_HEADERS_DRAFT_PKG.Procedure merge_changes.0;
SQLERRM = ORA-28132:The MERGE INTO syntax does not support the security policy."
po.plsql.PO_HEADERS_DRAFT_PKG..merge_changes.0.EXCEPTION"

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.