Different Behaviour While Creating Franchise Orders Via MFCS Screens Or Integration
(Doc ID 2963706.1)
Last updated on AUGUST 02, 2023
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.
PROD: Different behaviour while creating Franchise Orders via MFCS screens or Integration
While using the MFCS screens to create a Franchise Order, the same is created under "Franchise Order" transfer type in MFCS (both Transfer - tsfhead - and Franchise Order - wf_order_head - base tables are populated). This is expected behaviour.
However, using XTsf RIB integration to create the "same" Franchise Order (using the same data - e.g. locations and items), a transfer is created with "Intercompany" as its type. Apart from populating Transfer base tables, a Franchise Order is also created.
Steps To Recreate:
1. In MFCS, create a Franchise Order with the following details:
- customer: Customer (id #1)
- currency: GBP
- add the following detail:
- item: 210322750045902A019
- source: warehouse 111
- customer location: wholesale store test 10001
- requested quantity: 1
- need date: next available date in dropdown
- not after date: next available date in dropdown
Approve the Franchise Order.
2. Check if the details were added to Transfer and Franchise Order tables. The transfer created has 'FO' as tsf_type. You can check the data created:
- select * from tsfhead where tsf_no = '100000030004';
- select * from wf_order_head where wf_order_no = (select wf_order_no from tsfhead where tsf_no = '100000030004');
3. Using XTsf RIB interface, create a transfer with the same details provided in step #1.
4. Check if the details were added to Transfer and Franchise Order tables. The transfer created has 'IC' as tsf_type. You can check the data:
- select * from tsfhead where tsf_no = '100000036010';
- select * from wf_order_head where wf_order_no = (select wf_order_no from tsfhead where tsf_no = '100000036010');
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