My Oracle Support Banner

Update Purchase Order Bso Fails With FND.FND_GENERIC_MESSAGE When Project and Task Supplied on Distribution Level (Doc ID 2433727.1)

Last updated on AUGUST 15, 2018

Applies to:

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

Symptoms

When using BSO to update the Purchase Order, PO webservice and supplying a project/task at the distribution level, the service fails with FND.FND_GENERIC_MESSAGE.

ERROR
-----------------------
<ErrorMessage xmlns=""><Code>FND.FND_GENERIC_MESSAGE</Code><Type>Severe</Type><Text>oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM (select project_number,
  project_name,
  start_date,
  completion_date,
  project_id
from pa_po_projects_expend_v
where nvl(fnd_profile.value('PO_ENFORCE_PROJ_SECURITY'), 'N') = 'Y'
and :1 is null
union
select project_number,
  project_name,
  start_date,
  completion_date,
  project_id
from pa_po_projects_expend_v ppe
where nvl(fnd_profile.value('PO_ENFORCE_PROJ_SECURITY'), 'N') = 'Y'
and :2 is not null
and 'N' = (select nvl(item.comms_nl_trackable_flag, 'N')
  from mtl_system_items item
  where item.inventory_item_id = :3
  and item.organization_id = :4
  and item.enabled_flag = 'Y')

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!


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