My Oracle Support Banner

Unable To Compile Certain Assets Forms Following a Platform Migration (Doc ID 2996427.1)

Last updated on JANUARY 11, 2024

Applies to:

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

Symptoms

Following a platform migration, the forms compiilation log indicates that certain forms will not compile for the ESA (Latin American Spanish) versions:

FAXLSDET.fmb
FAXLPEAP.fmb

These forms are both associated with the Lease functionality within Oracle Assets.

Compilation errors display as in the patch log file:

Compiling package body FA_LEASE_TABLES...
Compilation error on package body FA_LEASE_TABLES:
PL/SQL ERROR 306 at line 41, column 4
wrong number or types of arguments in call to 'INSERT_ROW'
PL/SQL ERROR 0 at line 41, column 4
Statement ignored
PL/SQL ERROR 306 at line 86, column 12
wrong number or types of arguments in call to 'PAYMENTS_ITEMIZE'
PL/SQL ERROR 0 at line 86, column 5
Statement ignored
PL/SQL ERROR 306 at line 109, column 4
wrong number or types of arguments in call to 'LOCK_ROW'
PL/SQL ERROR 0 at line 109, column 4
Statement ignored
PL/SQL ERROR 306 at line 162, column 4
wrong number or types of arguments in call to 'UPDATE_ROW'
PL/SQL ERROR 0 at line 162, column 4
Statement ignored
PL/SQL ERROR 306 at line 210, column 12
wrong number or types of arguments in call to 'PAYMENTS_ITEMIZE'
PL/SQL ERROR 0 at line 210, column 5
Statement ignored

 

Steps to Reproduce:

1)  Migrate the application from one platform to another (details of how to do this are not discussed here)

2)  Compile forms on new platform:

Have the DBA run adadmin.
Choose following menu options:


from AD Administration Main Menu, select 1. Generate Applications Files menu
from Generate Applications Files menu, select 2. Generate form files

Changes

 A platform migration has been completed.  Some preliminary patching may have been completed, but no Assets specific patches need be applied for this to occur.

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


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