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.

Symptoms

On : 12.1.3 version, Purchase Order

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

ERROR
-----------------------
Error Details
  Logout

  Error Page
  Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT
  location.line_location_id
  ,location.po_header_id
  ,location.po_line_id
  ,decode(location.payment_type,
  'ADVANCE', to_number(null),
  'DELIVERY', to_number(null),
  location.shipment_num) shipment_num
  ,location.ship_to_location_id
  ,location.quantity*location.price_override amount
  ,line.line_num
  ,line.item_description
  ,SUM(nvl(dist.nonrecoverable_tax, 0)) nonrecoverable_tax
  ,SUM(nvl(dist.recoverable_tax, 0)) recoverable_tax
  ,location.description
  ,DECODE(
  --Query will return null if now rows are found
  (SELECT 'NONUPDATABLE' FROM DUAL
  WHERE EXISTS
  (SELECT 'Y'
  FROM po_distributions_all dist
  WHERE
  --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
  OR


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


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