PO_RECVPUSH Process Abended With Error-"ORA-01407: cannot update ("SYSADM"."PS_INTFC_PRE_AM"."SALETX_AMT") to NULL" When Purchase Order has Split Distributions With a $0 Sales Tax.
(Doc ID 3036713.1)
Last updated on JULY 26, 2024
Applies to:
PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
PO_RECVPUSH Abends with below error message when when related Purchase Order(PO) has split distributions and one of the distributions has $0 Sales Tax.
Error: ORA-01407: cannot update ("SYSADM"."PS_INTFC_PRE_AM"."SALETX_AMT") to NULL
This issue can be reproduced at will by following below steps:
1.Create a PO with a line with: PO Qty = 1 and Price = $6.80. Total Merchandise Amount = 6.80 . Navigation : Purchasing > Purchase Orders > Add/Update POs
2.PO Line is Sales tax applicable
3.PO Line should have Split distribution and one of the split distributions should have a calculated Sales Tax = $0.
4.All PO Distribution lines should have an AM Business Unit and Profile id .
5.Create an AM related PO Receipt and Save. Receipt Qty same as PO Qty = 1. You can leave the ‘Interface Receipt’ checkbox unchecked . Navigation : Purchasing > Receipts > Add/Update Receipts.
6.Run process PO_RECVPUSH . Navigation : Purchasing > Receipts > Process Receipts page.
Changes
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 |
Changes |
Cause |
Solution |
References |