UPG_BI AE Running Concurrently Performance Issue During Data Conversion 9.1 to 9.2.26

(Doc ID 2406239.1)

Last updated on JUNE 04, 2018

Applies to:

PeopleSoft Enterprise SCM Billing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 Image #26
PeopleTools: 8.54.29
Data Conversion

ACTUAL BEHAVIOR
---------------
Performance issue during the data conversion step AE UPG_BI Section: CURR_BSE step 01. Conversion is running for 12+ hours.

Do Select sql
===========
%SelectInit(BUSINESS_UNIT, INVOICE, BI_CURRENCY_CD, BASE_CURRENCY)
 SELECT DISTINCT BUSINESS_UNIT
 ,INVOICE
 ,BI_CURRENCY_CD
 ,BASE_CURRENCY
  FROM PS_BI_HDR
 WHERE EXISTS (
 SELECT 'X'
  FROM PS_BI_LINE_TAX
 WHERE PS_BI_LINE_TAX.BUSINESS_UNIT = PS_BI_HDR.BUSINESS_UNIT
  AND PS_BI_LINE_TAX.INVOICE = PS_BI_HDR.INVOICE)

SQL-- section
---------------------
UPDATE PS_BI_LINE_TAX
  SET BI_CURRENCY_CD = %Bind(BI_CURRENCY_CD), BASE_CURRENCY = %Bind(BASE_CURRENCY)
 WHERE BUSINESS_UNIT = %Bind(BUSINESS_UNIT)
  AND INVOICE = %Bind(INVOICE)


EXPECTED BEHAVIOR
-----------------------
Data conversion completes in a reasonable time frame.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit Data Conversion

 

Cause

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