My Oracle Support Banner

APMACR Program Fails due to Invalid Package FA_MASSADD_CREATE_PKG (error PLS-00302: component 'IMPORT_ALLOC_INV_LINES_AS_NEW' must be declared) (Doc ID 2051388.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, FA Addition

When attempting to run APMACR program fails due to invalid package FA_MASSADD_CREATE_PKG

ERROR
-----------------------

PACKAGE BODY 1 312 86 PLS-00302: component 'IMPORT_ALLOC_INV_LINES_AS_NEW' must be declared ERROR 302
PACKAGE BODY 2 312 59 PL/SQL: ORA-00904: "FA_CACHE_PKG"."FAZCBC_RECORD"."IMPORT_ALLOC_INV_LINES_AS_NEW": invalid identifier ERROR 0
PACKAGE BODY 3 301 7 PL/SQL: SQL Statement ignored ERROR 0
 spin-3-11176158651: I15: Not all distribution lines are coming over from AP to FA


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Attempt to run APMACR  (Mass Addition Create)  from Payables


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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.