My Oracle Support Banner

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

Last updated on APRIL 26, 2011

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0 and later   [Release: 7.4.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.

 

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.