Autocreate error APP-PO-14142: AUTOCREATE_DOCUMENTS:007: ORA-0000 (Doc ID 816836.1)

Last updated on FEBRUARY 12, 2016

Applies to:

Oracle Purchasing - Version: 12.0.4 and later   [Release: 12 and later ]
Information in this document applies to any platform.
***Checked for relevance on 20-Apr-2011***
FORM:POXBWVRP.FMB - AutoCreate Documents GUI

Symptoms

On 12.0.4:

When attempting to autocreate requisition into PO, the following error occurs:

APP-PO-14142: AUTOCREATE_DOCUMENTS:007: ORA-0000, normal successful completion.

It is also noted that package body PO_INTERFACE_S is invalid.

When trying to compile PO_INTERFACE_S, the following error is seen:

SQL> alter package PO_INTERFACE_S compile body;

Warning: Package Body altered with compilation errors.

SQL> sho error
Errors for PACKAGE BODY PO_INTERFACE_S:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3721/13 PL/SQL: Statement ignored
3721/13 PLS-00306: wrong number or types of arguments in call to
'GET_BREAK_PRICE'

Changes

Apply some product patches which supply the following files versions:

POXBWP1B.pls 120.65.12000000.14
POXSCS2B.pls 120.4.12000000.2

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