RMS Dat Files Are Generated With Invalid Characters (Doc ID 2914685.1)

Last updated on DECEMBER 12, 2022

Applies to:

Goal

We're encountering invalid characters for VATCN.
VAT|FULL|1040|***MASKED*** (CH)|VATCN|13% ????[??????]|19-DEC-2013|17
VAT|FULL|1040|***MASKED*** (CH)|VATCN|13% ????[??????]|01-APR-2019|13

Steps:

1. Verify data in VAT_* tables.
select * from VAT_CODES;
VAT_CODE VAT_CODE_DESC INCL_NIC_IND
S Standard N
E Exempt N
C Composite N
Z Zero Vat N

select * from VAT_CODE_RATES;
VAT_CODE ACTIVE_DATE VAT_RATE CREATE_DATE CREATE_ID
S 16-05-0020 10 16-05-0020 RMS01
E 16-05-0020 0 16-05-0020 RMS01
C 16-05-0020 12 16-05-0020 RMS01

select * from VAT_REGION;
VAT_REGION VAT_REGION_NAME VAT_REGION_TYPE ACQUISITION_VAT_IND REVERSE_VAT_THRESHOLD VAT_CALC_TYPE
1000 Vat Region 1000 E N S

2. Run export_vat.ksh with full option and observe the output file.

VAT|FULL|1000|Vat Region 1000|C|Composite|16-MAY-0020|12
VAT|FULL|1000|Vat Region 1000|E|Exempt|16-MAY-0020|0
VAT|FULL|1000|Vat Region 1000|S|Standard|16-MAY-0020|10

3. Insert a new VAT entry (or modify one existing) to contain foreign characters (CN).
insert into VAT_CODES values ('VATCN','13% 试*MASKED***','N');
insert into VAT_CODE_RATES values ('VATCN','16-05-0020','13','16-05-0020','RMS01');

select * from VAT_CODES;
VAT_CODE VAT_CODE_DESC INCL_NIC_IND
S Standard N
E Exempt N
C Composite N
Z Zero Vat N
VATCN 13% 试*MASKED*** N

select * from VAT_CODE_RATES;
VAT_CODE ACTIVE_DATE VAT_RATE CREATE_DATE CREATE_ID
S 16-05-0020 10 16-05-0020 RMS01
E 16-05-0020 0 16-05-0020 RMS01
C 16-05-0020 12 16-05-0020 RMS01
VATCN 16-05-0020 13 16-05-0020 RMS01

4. Run export_vat.ksh with full option and observe the output file.
VAT|FULL|1000|Vat Region 1000|C|Composite|16-MAY-0020|12
VAT|FULL|1000|Vat Region 1000|E|Exempt|16-MAY-0020|0
VAT|FULL|1000|Vat Region 1000|S|Standard|16-MAY-0020|10
VAT|FULL|1000|Vat Region 1000|VATCN|13% ???? [????]|16-MAY-0020|13

Solution

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