Can Not Use Standard PO Manage Tax Function (Doc ID 2039455.1)

Last updated on AUGUST 17, 2015

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Purchase Order

When attempting to manage tax on po,
the following error occurs.

Error Details

  Error Page
  Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT
  'ADVANCE', to_number(null),
  'DELIVERY', to_number(null),
  location.shipment_num) shipment_num
  ,location.quantity*location.price_override amount
  ,SUM(nvl(dist.nonrecoverable_tax, 0)) nonrecoverable_tax
  ,SUM(nvl(dist.recoverable_tax, 0)) recoverable_tax
  --Query will return null if now rows are found
  FROM po_distributions_all dist
  --Encumbrance conditions
  (dist.line_location_id = location.line_location_id
  AND dist.encumbered_flag = 'Y'
  AND NVL(dist.prevent_encumbrance_flag, 'N') = 'N'
AND NVL(dist.amount_changed_flag,'N') = 'N'
  ) -- End of inner select

The issue can be reproduced at will with the following steps:
1.In Purchasing Responsibility>Purchase Orders>Purchase Orders
Create PO then click Actions>Manage Tax


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