My Oracle Support Banner

Troubleshooting Issues with Shipments History and Bookings History Collections (Doc ID 2672871.1)

Last updated on OCTOBER 11, 2023

Applies to:

Oracle Demand Management 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 walks through the steps on how to Collect and Troubleshoot issues with Shipments History and Bookings History Collections.


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
 Introduction to Shipments and Bookings History
 Collecting History Data
 From Fusion Source
 From Legacy Systems or External Source
 Review Collected Data
 Frequently Asked Questions
 Can Planning History Measures be loaded in time dimensions other than Daily?
 What is the limitation to load data through FBDI for History Data?
 Why does Booking History Value and Shipment History Value does not show any data in Plan?
 Why is shipments history measure showing double the quantity uploaded via FBDI?
 Can OptionShipmentHistory.csv For New BOM Items Be Loaded Along With The Item.csv, BillofMaterials.csv, BillofMaterialComponent.csv Files?
 Why does ORDER_TYPE_FLAG show as null in MSC_MEASURE_DATA?
 How to collect open sales orders having request date/scheduled ship date in the future buckets?
 Troubleshooting Issues with History Collections
 Error: CUS_LVL_NAME is Invalid
 JBO-27035: Attribute InstanceCode is required. BO_LIST is null.. Exiting without submitting collectionsjobset
 ORA-01830: date format picture ends before converting entire input string
 Shipments History Uploaded via FBDI is missing.
 Shipment History gets duplicated when Aggregation Level for Key Customer Options is set to '1 - Retain and aggregate non-key customer sites'
 Error: TIM_LVL_NAME is invalid
 ORA-06512: at "FUSION.MSC_COLL_MEASURES", line 10423
 The value provided for the attribute CTO_LVL_MEMBER_NAME is invalid. The value provided for the attribute PRD_LVL_MEMBER_NAME is invalid. The value provided for the attribute DCS_LVL_MEMBER_NAME is invalid.
 A record already exists with the same combination of values for the key attributes ITEM_NAME, ORGANIZATION_CODE.
 ORA-01403: no data found, ORA-06512: at "FUSION.MSC_COLL_TRADING_PARTNERS"
 History is not collected for few days from Fusion Source.

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