Symptom
For 3PL Requests, you get an unexpected sequence for the IDs generated by the system, which is not consecutive.
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to Third-Party Logistics work center.
- Select 3PL Requests view.
- Execute the query.
- Order by Creation Date.
- Notice that the system generates the 3PL Request IDs not in sequence, as an example ID 2 is generated first and then the system created the ID 1.
Cause
The documents which are legally required to follow a strict sequence in their Document ID will follow them, such as Invoices.
For these documents where the IDs have to follow a sequence, the buffering is disabled. However, this has an adverse impact on the performance, hence for all the other objects have buffer setting maintained.
Other documents like Warehouse Order, request, Delivery Proposals, Outbound Delivery, Tasks, have document numbers which are assigned from a cache of sequence for each of the documents and the number from this cache might skip occasionally when there are any connection errors or interruptions.
Resolution
System is working as designed since the number range buffer setting is a central configuration and it cannot be changed.
Keywords
3PL, order, TPOP , KBA , 3pl , tpop , order , AP-SLP , Site Logistics Processing , How To