My Oracle Support Banner

Hz_format_pub.format_address Throwing Parse Error (Doc ID 2770648.1)

Last updated on APRIL 22, 2021

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Customers Module

When attempting to run hz_format_pub.format_address after upgrading to 19 C RDBMS, the following error occurs.

ERROR
-----------------------
PARSE ERROR


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

DECLARE
  lv_style_format_code hz_style_fmt_locales.style_format_code%TYPE;
  lt_formatted_address_tbl hz_format_pub.string_tbl_type;
  lv_return_status VARCHAR2 (2);
  ln_msg_count NUMBER;
  lv_msg_data VARCHAR2 (4000);
  lv_formatted_address VARCHAR2 (4000);
  ln_formatted_lines_cnt NUMBER;
  iv_line_break_char VARCHAR2 (100) := CHR(10);
  l_territory_short_name
  fnd_territories_tl.territory_short_name%TYPE;
  l_territory_code fnd_territories_tl.territory_code%TYPE;
  l_addr hz_locations.address1%type;

BEGIN

  hz_format_pub.format_address (
  p_style_code => 'POSTAL_ADDR',
  p_style_format_code => 'POSTAL_ADDR_N_EUR',
  p_line_break => iv_line_break_char,
  p_space_replace =>NULL,
  p_address_line_1 =>'OSLO AS',
  p_address_line_2 =>'Test 3',
  p_address_line_3 =>'Test 6',
  p_address_line_4 =>null,
  p_city =>'OSLO 6',
  p_state =>null,
  p_postal_code =>'0668',
  p_country =>'NO', -- passing either country code (NO) or name (Norway) has the same effect - PARSE ERROR
  x_return_status =>lv_return_status,
  x_msg_count =>ln_msg_count,
  x_msg_data =>lv_msg_data,
  x_formatted_address =>lv_formatted_address,
  x_formatted_lines_cnt =>ln_formatted_lines_cnt,
  x_formatted_address_tbl =>lt_formatted_address_tbl);

  
dbms_output.put_line('lv_formatted_address:'||lv_formatted_address);

END;
/

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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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