EBI 9.1+: BI_IVCEXT Invoice Extract Process Is Extracting Country Name Japan for ADDr_ln1. (Doc ID 2110462.1)

Last updated on FEBRUARY 25, 2016

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.1 and later
Information in this document applies to any platform.

Goal

BI_IVCEXT is extracting country name Japan for ADDr_ln1.

Evaluate BI_EXTRACT_AET.COUNTRY
When = "NLD"
When = "BEL"
When = "DEU"
When = "FRA"
  BI_EXTRACT_AET.SQLTEXT = "UPDATE %Table(BI_ELINE_TAO) SET ADDR_LN1 = NVL(LTRIM(RTRIM(SHIP_CUST_NAME)), ' '), ADDR_LN2 = ' ', ADDR_LN3 = NVL(LTRIM(RTRIM(ADDRESS1)), ' '), ADDR_LN4 = NVL(LTRIM(RTRIM(ADDRESS2)), ' '), ADDR_LN5 = NVL(RTRIM(NVL(LTRIM(RTRIM(ADDRESS3)), ' ') %Concat ' ' %Concat NVL(LTRIM(RTRIM(NUM1)), ' ') %Concat ' ' %Concat NVL(LTRIM(RTRIM(NUM2)), ' ') %Concat ' ' %Concat NVL(LTRIM(RTRIM(HOUSE_TYPE)), ' ')),' '), ADDR_LN6 = NVL(LTRIM(RTRIM(ADDRESS4)), ' '), ADDR_LN7 = NVL(LTRIM(RTRIM(POSTAL)), ' ') %Concat ' ' %Concat NVL(LTRIM(RTRIM(CITY)), ' ') %Concat ' ' %Concat NVL(LTRIM(RTRIM(STATE)), ' '), ADDR_LN8 = NVL(LTRIM(RTRIM(COUNTRY_NAME)), ' ') WHERE PROCESS_INSTANCE = %ProcessInstance AND COUNTRY = %Bind(COUNTRY)";
  
When = "JPN"
  BI_EXTRACT_AET.SQLTEXT = "UPDATE %Table(BI_ELINE_TAO) SET ADDR_LN1 = NVL(LTRIM(RTRIM(COUNTRY_NAME)), ' '), ADDR_LN2 = NVL(LTRIM(RTRIM(POSTAL)), ' '), ADDR_LN3 = NVL(LTRIM(RTRIM(STATE_NAME)), ' ') %Concat ' ' %Concat NVL(LTRIM(RTRIM(CITY)), ' '), ADDR_LN4 = NVL(LTRIM(RTRIM(ADDRESS1)), ' '), ADDR_LN5 = NVL(LTRIM(RTRIM(ADDRESS2)), ' '), ADDR_LN6 = NVL(LTRIM(RTRIM(ADDRESS3)), ' '), ADDR_LN7 = NVL(LTRIM(RTRIM(SHIP_CUST_NAME)), ' '), ADDR_LN8 = ' ' WHERE PROCESS_INSTANCE = %ProcessInstance AND COUNTRY = %Bind(COUNTRY)";

 

Solution

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 hundreds of Community platforms