PO_LN_SHIP_SUT Tax Calculation Issue (Doc ID 2026499.1)

Last updated on AUGUST 16, 2016

Applies to:

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

Symptoms

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.



STEPS
-----------------------
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

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