How to Connect Item/Category to Task/Project via DataModel

User_I64QG

We are in the process up updating a report, one that provides Item and Category descriptions, in order to try and find the associated Task Number as could be found on a Requisitions Disbursement Line. We have been able to identify a fair number of tables around the item and category, linking these together. And we can find the Task and Project information to associate to the data we want. But creating a join between those is still an issue.

Specifically, the current report has Item and Category descriptions present, which we can use MSC_ITEMS, MSC_CATALOG_CATEGORIES, and MSC_ITEM_CATEGORIES to associate them together. The final value we want is the Project Element Number (or equivalent field) as we have found in PJF_PROJ_ELEMENTS_B. This can be mapped to via Task_ID and Project_ID. Our understanding is at least a Category should be associated to a Project, if not the Task itself. We have not been able to find any way to determine what Items/Categories are on what Task or Project.

Documentation found:

https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/24a/oedsc/invitemsubinventories-20298.html#invitemsubinventories-20298

and

https://docs.oracle.com/en/cloud/saas/project-management/24a/oedpp/pjcprjassetsall-19850.html#pjcprjassetsall-19850

has not provided a readily apparent link.

John Hung-Oracle

Hi, To better serve you, please post this question in the Reporting and Analytics for SCM forum since its specific to supply chain subject areas/use cases. Thank you.