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:

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.

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

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