My Oracle Support Banner

PO_LN_SHIP_SUT Tax Calculation Issue (Doc ID 2026499.1)

Last updated on FEBRUARY 05, 2019

Applies to:

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


PO Tax Calculation issue . When PO is copied from requisition, system insert wrong data in PO Tax tables.

There was no Tax code on Requisition but system insert tax amount equal to line amount in tax tables with any percentage. when we update this PO Tax amount is reset to zero.

The issue can be reproduced at will with the following steps:
1)-Navigate to Purchasing > Requisition > Add/Update Requisition and create a requisition for item 10023 and Supplier SCM0000001
2)-Save and Budget Check the PO
3)-Navigate to Purchasing > Purchase orders > Stage/Source Requests > Requisition Selection
Select No to create PO. Save the Page. Requisition has gone to Staging table.
4)-Navigate to Purchasing > Purchase orders > Stage Source Requests > PO Calculation > Run PO_CALC
5)- Navigate to Purchasing > Purchase orders > Stage Source Requests > PO Creation
6)-Lets Check the PO created. Sales tax is getting calculated correctly as 640 which is 4 % of merchandise amount.
7)-Lets run the query using the Table PO_LN_SHIP_SUT in query manager. Check the Sales and Use tax . It is showing as 1600 instead of 640.
This is the issue reported by customer.
8)-lets go back to PO and Approve and Budget check the PO. Click Calculate button under the Account Summary page
9)-Lets re-run the same query in query manager now using Table PO_LN_SHIP_SUT


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

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