Unable To Load Party Tax Profile Data Using FBDI - Getting Error: Error On Table ZX_PARTY_TAX_PROFILE_STG, Column SUPPLIER_FLAG. ORA-06553: PLS-306 (Doc ID 2056696.1)

Last updated on AUGUST 03, 2017

Applies to:

Oracle Fusion Tax Cloud Service - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Oracle Fusion Tax - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

When attempting to Load Party Tax Profiles, the following error occurs.

ERROR
-----------------------
value used for ROWS parameter changed from 64 to 21
Record 1: Rejected - Error on table ZX_PARTY_TAX_PROFILE_STG, column SUPPLIER_FLAG.
ORA-06553: PLS-306: wrong number or types of arguments in call to 'IS_SUPPLIER'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Download the template as per Note: 1981540.1
2. Populate the data and generate the .csv and .zip files.
3. Upload the .zip file to UCM Server using File Import and Export
3. In Scheduled Processes, submit the Load Interface file for Import with 'Party Tax Profile Import Process'


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms