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.


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.

<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,
from pa_po_projects_expend_v
where nvl(fnd_profile.value('PO_ENFORCE_PROJ_SECURITY'), 'N') = 'Y'
and :1 is null
select project_number,
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')


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.