My Oracle Support Banner

R12: AP: APXPGSUB.fmx Did Not Generate Successfully After Patch 27211174 (Doc ID 2456275.1)

Last updated on FEBRUARY 13, 2020

Applies to:

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

Symptoms

On : 12.1.3 version, Patch Application Issues

While applying the patch 27211174 the APXPGSUB.fmx form did not generate successfully


ERROR
-----------------------
The following Oracle Forms objects did not generate successfully:

ap      forms/US        APXPGSUB.fmx


--
error for APXPGSUB.fmx generation as per worker log:

Compiling package body SUBMIT_PURGE...
Compilation error on package body SUBMIT_PURGE:
PL/SQL ERROR 905 at line 432, column 10
object APPS.FINANCIALS_PURGES_V is invalid
PL/SQL ERROR 0 at line 430, column 3
SQL Statement ignored

.....

Compiling package body SUBMIT_PURGE_CLIENT_PKG...
Compilation error on package body SUBMIT_PURGE_CLIENT_PKG:
PL/SQL ERROR 306 at line 6, column 3
wrong number or types of arguments in call to 'INSERT_ROW'
PL/SQL ERROR 0 at line 6, column 3
Statement ignored
PL/SQL ERROR 306 at line 82, column 3
wrong number or types of arguments in call to 'UPDATE_ROW'
PL/SQL ERROR 0 at line 82, column 3
Statement ignored
PL/SQL ERROR 306 at line 162, column 7
wrong number or types of arguments in call to 'LOCK_ROW'
PL/SQL ERROR 0 at line 162, column 7
Statement ignored


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 27211174

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot regenerate APXPGSUB.fmx  form due to the APPS.FINANCIALS_PURGES_V object is invalid .

Changes

 

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
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.