Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.1.3 : APPS.AR_DEBIT_AUTHORIZATION_API_PUB not compiled

edited Sep 8, 2014 7:55AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 5 commentsAnswered ✓

hello,

PPS.AR_DEBIT_AUTHORIZATION_API_PUB not compiled

We cannot compile a package, the error is that on a view we doesn't have a column.
The column hr_legal_entities.vat_registration_number doesn't exists.

We have SEPA instaled.



1- The version for AR_DEBIT_AUTHORIZATION_API_PUB is:

SQL> select text from user_source where name='AR_DEBIT_AUTHORIZATION_API_PUB';

TEXT

-----------------------------------------------------------------------------

/* $Header: ARXPMANS.pls 115.0.15104.4 2013/03/29 14:05:10 vpotti noship $ */

/* $Header: ARXPMANB.pls 115.0.15104.8 2013/06/18 10:43:32 vpotti noship $ */

2- I send you the errors

LINE    TEXT

5    PLS-00302: el componente 'VAT_REGISTRATION_NUMBER' se debe declarar

4    PL/SQL: Item ignored

556    PLS-00320: la declaración de tipo de esta expresión está incompleta o tiene un formato incorrecto

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center