When Sales Tax is Included on the Purchase Order, PO_LINE_DISTRIB - MONETARY_AMOUNT and MONETARY_AMT_BSE Values are Not Equal Causing Incorrect Commitment Control Data. (Doc ID 1460977.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

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

Symptoms

The data on PO_LINE_DISTRIB is not correct when Sales Tax is included on the PO.  The issue can be seen with a query of PO_LINE_DISTRIB. Compare the values of MONETARY_AMOUNT and MONETARY_AMT_BSE. The tax amount is not included in the MONETARY_AMT_BSE field.

When this transaction is then budget checked, this further causes issue with the data on KK_ACTIVITY_LOG and KK_LIQUIDATION.  The FOREIGN_AMOUNT and MONETARY_AMOUNT values are not equal.



Steps to recreate the issue:

  1. Create a purchase order that has Sales Tax.
  2. Query PO_LINE_DISTRIB and compare the MONETARY_AMOUNT and MONETARY_AMT_BSE values.
  3. If this transaction is budget checked. The MONETARY_AMOUNT on KK_ACTIVITY_LOG and KK_LIQUIDATION are incorrect
  4. The FOREIGN_AMOUNT does not equal the MONETARY_AMOUNT on KK_ACTIVITY_LOG and KK_LIQUIDATION

 

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