Unable To Search Item In Catalog (Purchase Requisition)
(Doc ID 2478558.1)
Last updated on JULY 05, 2020
Applies to:Oracle Fusion Self Service Procurement Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.
Unable to search Item in Catalog (Purchase Requisition)
Customer is unable to search specific Items which are there in BPA in the catalog area of (Purchase Requisition). There are similar Items of same category which they are able to search.
BPA is active, Item is Active, Item is assigned to IO, other searched Items are having the same category, able to see the Browsing category name which is defined in the Local Catalog (category name assigned to local catalog).
For the agreements created, below query can be executed to find if records are missing
FROM fusion.po_headers_all poh, fusion.po_lines_all pol
WHERE poh.po_header_id = pol.po_header_id
AND poh.type_lookup_code = 'BLANKET'
AND poh.DOCUMENT_STATUS = 'OPEN'
AND pol.po_line_id NOT IN ( SELECT po_line_id FROM
fusion.po_attribute_values_tlp tlp WHERE tlp.po_header_id = pol.po_header_id)
order by poh.segment1 desc;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document