My Oracle Support Banner

EBI9.2: The Fields LAST_UPDATE_DTTM And LAST_MAINT_OPRID On The BI_SPECIALIST Table Does Not Get Updated (Doc ID 2343688.1)

Last updated on DECEMBER 28, 2017

Applies to:

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

Symptoms

When a new effective dated row is created for the Billing Specialist, LAST_UPDATE_DTTM and LAST_MAINT_OPRID fields on the BI_SPECIALIST table don't get updated with Date & Time when the change was made and the OPRID that made the change.

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

  1. Go to Set up Financials/ Supply Chain/ Product Related/ Billing/ Setup/ Billing Specialist (Billing Specialist is ACE and Effective Date is as 01/01/1900);
  2. Go to Reporting Tools/ Query/ Query Manager - under Run tab - see that Effective date is displayed as 01/01/1900;
  3. Go one more time to Set up Financials/ Supply Chain/ Product Related/ Billing/ Setup/ Billing Specialist and add a new Effective Date as of 05/12/2017, so that selected Billing Specialist to have two active Effective Date fields (01/01/1900 and 05/12/2017);
  4. Go and check Reporting Tolls/ Query/ Query Manager - under Run tab - see two registrations with different Effective dates displayed as 01/01/1900 and 05/12/2017;
  5. Login with a different user - Go and add a new Effective date to another existent billing specialist (add also 05/15/2017 besides the existent one 05/ 12/2017);
  6. Check again to Reporting Tools/ Query/ Query Manager - under Run tab and see that for the second billing specialist is displayed only the most recent Effective date 05/15/2017.

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
References


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