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
Last updated on AUGUST 03, 2017
Applies to:Oracle Fusion Tax Cloud Service - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 1.0]
Oracle Fusion Tax - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 1.0]
Information in this document applies to any platform.
When attempting to Load Party Tax Profiles, the following error occurs.
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'
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'
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