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 11.13.17.05.0 and laterOracle Sales and Operations Planning Cloud Service - Version 11.13.17.05.0 and later
Oracle Fusion Planning Central Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.
Purpose
This document walks through the steps on how to Collect and Troubleshoot issues with Shipments History and Bookings History Collections.
Details
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
| Purpose |
| Details |
| 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 |
| 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. |
| References |