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 NOVEMBER 21, 2016

Applies to:

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

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"

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