PC_INTEREST Interest Calculation Process Selects The Current-Effective Row From PS_PROJECT_STATUS Regardless Of The Transaction Dates. (Doc ID 2264657.1)

Last updated on MAY 10, 2017

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The PC Interest Calculation process, PC_INTEREST, always selects the current-effective dated row from the PROJ_STATUS table ignoring the transaction date on the project transaction in the PROJ_RESOURCE table. PC_INTEREST should be applying the current effective date based on the Transaction Date ( or accounting date) on the PROJ_RESOURCE table. Due to this issue, interest may not be calculated correctly.

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

  1. Create a project and select the 'Allow Interest Calculation' on the Project Definition page.
  2. Add an activity.
  3. Add a project status row for the start of the project with an interest calculation factor of 1.0.
  4. Add a second project status row with a later effective date (that is not future-dated) and an interest calculation factor of 0.0.
  5. Add two cost transactions to the activity with dates that should be covered by the different status row dates.
  6. Run PC_INTEREST - no interest is calculated at all

 

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