My Oracle Support Banner

Load_Tax_Supplier Does Not Store The First Address (Doc ID 1274744.1)

Last updated on MARCH 26, 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

The BRM load_tax_supplier utility does not store the first address.

Steps to Reproduce
================

Load the sample file provided and check the CONFIG_TAXS_T table : the address is empty for the first line unlike the second line although it was filled in for both entries in the xmll file.

obj_id0 rec_id name        Description              address       nexusinfo
-----------------------------------------------------------------------------
regulated_info default_flag
---------------------------
13301   1      <NAME> <ADDR> NuLL                RE
0              1
13301   2      <NAME> <ADDR>;97400;FR MA
0              0


Snippet of the XML
==================

<?xml version="1.0" encoding="UTF-8" ?>
<!--
Copyright (c) 2006 Oracle. All rights reserved.

This material is the confidential property of Oracle Corporation or its
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><NAME></Name>
<Description>SRR Tax Supplier Reunion</Description>
<Address><ADDR></Address>
<NexusInfo>RE</NexusInfo>
<RegulatedFlag>0</RegulatedFlag>
<DefaultFlag>1</DefaultFlag>
<VATInfo>
<CanonCountry>FR</CanonCountry>
<VATCertificate>vat_cert_FR</VATCertificate>
</VATInfo>
</TaxSupplierElement>
<TaxSupplierElement>
<Name><NAME></Name>
<Description><NAME></Description>
<Address><ADDR></Address>
<NexusInfo>MA</NexusInfo>
<RegulatedFlag>0</RegulatedFlag>
<DefaultFlag>0</DefaultFlag>
<VATInfo>
<CanonCountry>FR</CanonCountry>
<VATCertificate>vat_cert_FR</VATCertificate>
</VATInfo>
</TaxSupplierElement>
</TaxSupplierConfiguration>

For the normal characters the address field value will works fine and inserted into the table.

The problem was with the special character or latin character  (e.g., ç or ã)
<Address>R�<ADDR></Address>



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.