My Oracle Support Banner

Supplier Open Interface Import (APXSUIMP) Errors: REP-1419 On Portuguese Supplier (Doc ID 344174.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Financials for EMEA - Version 11.5.10.0 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
APXSUIMP - Supplier Open Interface Import
appvapis.pls
appvapib.pls

Symptoms

The Supplier Open Interface program (APXSUIMP) ends in error when try to import portuguese
customers with taxpayer ID information .
The error in the log file is:
« REP-1419: 'beforereport': PL/SQL program aborted. »
« Program exited with status 1 »

If customer try to import without inserting the taxpayer ID the import ends without any error.

Steps to reproduce:
1. In a system with portuguese localizations installed and setup
2. Insert a customer information via SQL*plus NOT including taxpayer ID information (NUM_1099=null):
--
INSERT INTO AP_SUPPLIERS_INT
(VENDOR_INTERFACE_ID,SEGMENT1,VENDOR_NAME,NUM_1099,VENDOR_TYPE_LOOKUP_CODE)
VALUES (<VENDOR_INTERFACE_ID>,'<SEGMENT1>','<VENDOR_NAME>',null,'VENDOR');
--
commit;
--
3. Via Application, run the Supplier Open Interface Program... It finishies successfully

4.
Insert a customer information via SQL*plus including taxpayer ID information (for example: NUM_1099='1234567'):
--
INSERT INTO AP_SUPPLIERS_INT
(VENDOR_INTERFACE_ID,SEGMENT1,VENDOR_NAME,NUM_1099,VENDOR_TYPE_LOOKUP_CODE)
VALUES (<VENDOR_INTERFACE_ID>,'<SEGMENT1>','<VENDOR_NAME>','1234567','VENDOR');
--
commit;
--

5. Via Application, run the Supplier Open Interface Program... It finishes with the mentioned ERROR



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
References


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