Different Behaviour While Creating Franchise Orders Via MFCS Screens Or Integration (Doc ID 2963706.1)

Last updated on AUGUST 02, 2023

Applies to:

Symptoms

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');

Cause

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