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 OCTOBER 06, 2020
Applies to:Oracle Fusion Tax Cloud Service - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 1.0]
Oracle Fusion Tax - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 1.0]
Generic (Platform Independent)
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'
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