My Oracle Support Banner

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" ?>
<!--
Copyright (c) 2006 Oracle. All rights reserved.

licensors and may be used, reproduced, stored or transmitted only in
accordance with a valid Oracle license or sublicense agreement.
-->
<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.

 

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.