Clarification Needed: Catalog vs Non-Catalog Item Retrieval Using requisitionProductDetails API and
In Oracle Fusion Cloud SCM, I’m working with both the requisitionProductDetails API and the itemsV2 API to fetch item information related to purchase requisitions.
The requisitionProductDetails API returns detailed line-level data — including both catalog and non-catalog items — from the POR_REQUISITION_LINES_ALL table. However, when I try to use fields such as ItemDescription from this API to query the itemsV2 API (especially for catalog items), the itemsV2 API often returns no results.
I need clarity on the following:
- Why does this happen?
Why does the itemsV2 API fail to return catalog items even when I use values (like ItemDescription) directly from the requisitionProductDetails API?