load_tax_supplier Or Item Description Do Not Accept Latin Characters (Doc ID 1233899.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When using load_config_item_types tool, when using latin characters the descriptions are loaded empty in the database.

Example are: config_tax_supplier and config_item_types etc

Snippet of the xml:

<?xml version="1.0" encoding="UTF-8" ?>

<TaxSupplierConfiguration
xmlns="http://www.portal.com/PortalXMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.portal.com/PortalXMLSchema
xsd/pin_tax_supplier.xsd">
<TaxSupplierElement>
<Name>TVA Reunion</Name>
<Description>xxx Tax Supplier Reunion</Description>
<Address>R�union;RE;97600;FR</Address>
<NexusInfo>RE</NexusInfo>
<RegulatedFlag>0</RegulatedFlag>
<DefaultFlag>1</DefaultFlag>
<VATInfo>
<CanonCountry>FR</CanonCountry>
<VATCertificate>vat_cert_FR</VATCertificate>
</VATInfo>
</TaxSupplierElement>

In config_taxs_t after loading we get the below record:

obj_id0 rec_id name Description address nexusinfo regulated_info default_flag
-----------------------------------------------------------------------------
13301 1 TVA Reunion xxx Tax Supplier Reunion NuLL RE 0 1

Just highlighting the special character again in xml:

>>�<<<

For normal characters the address inserts fine.