My Oracle Support Banner

Troubleshooting issues with Requisitions and Purchase Order Data Collections (Doc ID 2701442.1)

Last updated on AUGUST 30, 2023

Applies to:

Oracle Demand Management Cloud Service - Version and later
Oracle Supply Planning Cloud Service - Version and later
Oracle Sales and Operations Planning Cloud Service - Version and later
Oracle Fusion Planning Central Cloud Service - Version and later
Information in this document applies to any platform.


 This Document provides information about troubleshooting Issues Related to Requisitions and Purchase Orders Data Collections


 Functionality described on this document is applicable to Fusion Supply Chain Planning Applications


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
 Frequently Asked Questions
 Why is Purchase Order Number Loaded/Collected with Extra Fields?
 Why are Expense Type Purchase Orders not getting collected?
 Why is the purchase order in status "pending approval" not collected in planning?
 Common Issues
 After importing purchase order and purchase requisition data, the logs don't show the correct numbers of rows and logs indicate errors in the data.
 ORA-12801: error signaled in parallel query server
 ORA-01400: cannot insert NULL into ("FUSION"."MSC_SUPPLIES"."ORGANIZATION_ID")
 POPR should not be loaded via CSV for Fusion Org in case Purchasing product area is not enabled for respective org.

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