Templat Component High Level

e: Design
Owner: Unified Quality System
Author: SSDM/Analysis &
Design

Federated Inventory 3.0

Low Level Design: EDH.docx

Document Summary
Federated Inventory 3.0: Low Level Design: SupervisionE
Document Name DH

Project Reference Federated Inventory 3.0

Document
757660631.docx.docx Version: V1.3
Reference

Prepared By E. LE NEPVOU Date: 17/07/2019

© Copyright: France Telecom Group Orange Restricted Page 1 of 37

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

Change History

Version Change Changed By Change Summary

Date
V1.0 19/07/2019 E. LE NEPVOU G3R8C3 Initialization of document

V1.1 08/08/2019 B.RADJI G3R8C3 Review

V1.2 25/06/2020 D. LE FLOHIC G4R1C3 update

V1.3 29/09/2020 S.COLLONGUES G4R2C3 [BOOST DIGITAL] Enriched View Pivot S4-
CMS_FEI

V1.4 03/12/2020 Y.HURET [G4R3C1][FEI-10790][BOOST DIGITAL] Reinit

usage view

V2.0 21/04/2021 S. [G4R4C3][FEI-16845] [ASPROe] Reinit - Numeris

COLLONGUES usage

V3.0 04/06/2021 L.KLIKAN [SQUAD] FEI-17748 [FINV][SIEMENS]:

Improvment of CIBASE externalRef management
- Data exposition

V4.0 06/12/2021 S. [G4R6C3] FEI-17517 [FINV][RACE]: Management

COLLONGUES of customer IO - EDH exposition

V5.0 28/06/2022 P.COUTADEUR [G4R8C1] FEI-19608 [COMPANYREF] replace

CORE INT for NRT mode (customer and
billingaccount)

V6.0 16/08/2022 N.MBOUGUENG [G4R8C3] FEI-16372 [EDH] Request to expose

SIMO new information in EDH

V6.1 03/03/2023 A.ROSSIGNOL [G5R1C3][FEI21865][DNT]: edge

IS_is_delegated_IS exposition- P0 DNT

© Copyright: France Telecom Group 757660631.docx Page 2 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

© Copyright: France Telecom Group 757660631.docx Page 3 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

Distribution and sign-off

The RACI methodology has been used to identify the following as document
receivers, according to need:
 R = responsible for document content
 A = accountable for document content
 C = consulted on the document content
 I = kept informed on the document content

Name Title Department Sign-off

RACI date
e-mail
Cédric Le GALL Federated Inventory IT OBS IT A
project manager

Benoit LEDONNE / Federated Inventory IT OBS IT A

Yann SOULABAILLE project manager

Eric LAUNAY Product Owner OBS IT A

Bilikissou RADJI Functional Leader OBS IT R

Eric LE NEPVOU Functional Leader OBS IT R

Yoan HURET Team dev OBS IT R

Thierry LE CORRE Team dev OBS IT R

© Copyright: France Telecom Group 757660631.docx Page 4 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

Table of Contents
1 INTRODUCTION...........................................................................................................5
1.1 PURPOSE....................................................................................................................... 5
1.2 REFERENCE DOCUMENTS............................................................................................... 5
2 COMPONENT DETAILED SCHEMA..........................................................................6
3 REQUIREMENTS...........................................................................................................8
4 FUNCTIONAL DESCRIPTION OF PROCESS................................................................10
4.1 EXTRACTION................................................................................................................ 10
4.2 PREPARATION.............................................................................................................. 11
4.2.1 “FINV-Inventory” Enrichment data..................................................................12
4.2.2 “FINV-Relationships” Enrichment data............................................................19
4.2.3 “FINV_INSTALLEDOFFER” Enrichment data...................................................20
4.3 USAGE......................................................................................................................... 21
4.3.1 “FINV_Commercial_Inventory_init_bvpn” Usage data........................................21
4.3.2 “FINV_Commercial_Inventory_init_Numeris” Usage data..................................24
4.4 REINIT......................................................................................................................... 27
4.4.1 Process...............................................................................................................27
4.4.2 Rules...................................................................................................................28
APPENDIX A - GLOSSARY.............................................................................................29

© Copyright: France Telecom Group 757660631.docx Page 5 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

1 INTRODUCTION
1.1 PURPOSE
This document provides a functional and a technical description of the process to
transfer, enrich and usage of Federated Inventory data in EDH.

1.2 REFERENCE DOCUMENTS

# Document Title Link or Location

1 contracts_G0R0C0.zip BUILD/<<Version>>/02-Functional
documents/FEIDIGITAL/01- Interface contracts/05 -
EDH
2 IC revenue BUILD/<<Version>>/02-Functional
Assurance.docx documents/FEIDIGITAL/01- Interface contracts/05 -
EDH
2 EDH_Graphs.pptx BUILD/<<Version>>/02-Functional documents/05-EDH
3 Finv_EDH_view_Catalog BUILD/<<Version>>/02-Functional documents/05-EDH
.xlsx
4 Vertices state for FINV BUILD/<<Version>>/02-Functional
tree traversals documents/FEIDIGITAL/
v1.2.pptx
5 EDH- BUILD/<<Version>>/02-Functional documents/05-EDH/
EnrichmentContract- 02-Enrichment Contracts
V7.3-OBSIT-
FINV(FEI)v1.4.xlsm

© Copyright: France Telecom Group 757660631.docx Page 6 of 37

Orange Restricted

Orange Restricted
2 COMPONENT DETAILED SCHEMA

© Copyright: France Telecom Group Orange Restricted Page 7 of 37

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

© Copyright: France Telecom Group 757660631.docx Page 8 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

© Copyright: France Telecom Group 757660631.docx Page 9 of 37

Orange Restricted

Orange Restricted
3 REQUIREMENTS
REF. REQUIREMENT
Usage Data
One usage data file is generated with data way FINV_Commercial_Inventory_init_bvpn containing
EDH-US001-MR001
filtered and formatted data for reinit use
One usage data file is generated with data way FINV_Commercial_Inventory_init_numeris containing
EDH-US001-MR002
filtered and formatted data for reinit use
With a jsonlinear configuration file provided by FINV, EDH team create the reinit JSON file from
EDH-US001-MR003
dedicated usage views and provide them to partners
Enrichment Data
REQ-EDH-ENR-001 One enriched data file is generated with data way FINV-Inventory_beneficiary
REQ-EDH-ENR-002 One enriched data file is generated with data way FINV-Inventory_billing
REQ-EDH-ENR-003 One enriched data file is generated with data way FINV-Inventory_contracting
Enriched data file FINV-Inventory_all is UNION of FINV-Inventory_beneficiary, FINV-Inventory_billing
REQ-EDH-ENR-004
and FINV-Inventory_contracting
REQ-EDH-ENR-005 One enriched data file is generated with data way FINV_Relationships_installed_offer
REQ-EDH-ENR-006 One enriched data file is generated with data way FINV_Relationships_installed_resource
REQ-EDH-ENR-007 One enriched data file is generated with data way FINV_Relationships_installed_service
One enriched data file is generated presenting a pivot view bringing together FINV_INVENTORY_ALL
REQ-EDH-ENR-008
datas with S4CMS perimeters: FINV_INVENTORY_ALL_S4CMS

© Copyright: France Telecom Group Orange Restricted Page 10 of 37

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

REQ-EDH-ENR-009 The data enriched in the customer table will appear in the FINV-Inventory_all file

The data enriched in the customer table will appear in the FINV-Inventory_beneficiary file
REQ-EDH-ENR-010

REQ-EDH-ENR-011 The data enriched in the customer table will appear in the FINV-Inventory_billing file

REQ-EDH-ENR-012 The data enriched in the customer table will appear in the FINV-Inventory_contracting file

Data Extraction
REQ-EDH-EXT-001 Vertices and Edges from Database can be extracted in JSON files
REQ-EDH-EXT-002 JSON files must be transferable to EDH server
Prepared Data
REQ-EDH-PRE-001 JSON files from FINV must be prepared for integration in EDH
REQ-EDH-PRE-002 For each @class Vertex or Edges, only fields defined in IC must be present in prepared files
REQ-EDH-PRE-003 Customer data must be exposed by EDH Team

© Copyright: France Telecom Group 757660631.docx Page 11 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

4 FUNCTIONAL DESCRIPTION OF PROCESS

4.1 EXTRACTION

Data are extracted from Federated Inventory to be sent to EDH.

CODRU NAMERU RULE DESCRIPTION

¤EDH-EXT001- Extracted data format All Vertices and Edges are extracted from OrientDb in JSON
MR001¤ format. One JSON file per @class
¤EDH-EXT001- Data formatting The JSON files are formatted before being sent to the EDH:
MR002¤ - The records are written on multiple lines in order to be
able to parallelize the ingestion in the EDH
- The field that are Embedded Set in OrientDB are
formatted in order to be re-write as String
¤EDH-EXT001- Excluded fields Following fields are not extracted for all Vertices and Edges:
MR003¤ - finvDateSynchro
- fileCode
Following fields are not extracted for all Vertices:
- @version
- @class
- list of ‘in’ Edges
- list of ‘out’ Edges

© Copyright: France Telecom Group 757660631.docx Page 12 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

¤EDH-EXT001- JSON export to EDH The json exported from OrientDB are sent to the EDH using
MR006¤ Flow. The name of the flow is FINV2EDH
A new VTOM job TRF_EDH1 has been created for files
transfer.

4.2 PREPARATION

After receiving data in JSON format, EDH will prepare them to be integrated before enrichment.

© Copyright: France Telecom Group 757660631.docx Page 13 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

¤EDH- PRE001-MR001¤ Interface contract Only the field defined in the interface contract will be
available in the prepared data. All others fields that are in the
json, but not in the contract are ignored.

After preparation, data are enriched depending on required Usage specified in [2] EDH_Graphs.pptx and [5] EDH-
EnrichmentContract-V7.3-OBSIT-FINV(FEI)v1.4.xlsm.

4.2.1 “FINV-Inventory” Enrichment data

4.2.1.1 FINV_INVENTORY_BENEFICIARY, FINV_INVENTORY_BILLING, FINV_INVENTORY_CONTRACTING

CODRU NAMERU RULE DESCRIPTION

¤EDH-ENR001- Data join model Enriched data are calculated from prepared data with a LEFT OUTER JOIN
MR001¤ request, depending on Enrichment Contract (cf [2]) and data ways (cf [3])
FINV_INVENTORY_BENEFICIARY

© Copyright: France Telecom Group 757660631.docx Page 14 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

© Copyright: France Telecom Group 757660631.docx Page 15 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

FINV_INVENTORY_BILLING

© Copyright: France Telecom Group 757660631.docx Page 16 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

© Copyright: France Telecom Group 757660631.docx Page 17 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

FINV_INVENTORY_CONTRACTING

© Copyright: France Telecom Group 757660631.docx Page 18 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

© Copyright: France Telecom Group 757660631.docx Page 19 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

¤EDH-ENR002- Filters application Apply filters defined in document (cf [3])

MR002¤
¤EDH-ENR003- “SiteOrigin” field calculation For each line calculated in enriched data, a “SiteOrigin” column is added and
MR003¤ contains information related to the data path used to retrieve Site
informations.

The possible values are:

1. “InstalledOffer” : correspond to a line with site retrieved from

InstalledOffer

© Copyright: France Telecom Group 757660631.docx Page 20 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

2. “InstalledService”: correspond to a line with site retrieved from

InstalledService

© Copyright: France Telecom Group 757660631.docx Page 21 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

3. Empty value: correspond to a line without site information

CODRU NAMERU
RULE DESCRIPTION
¤EDH-ENR004- Attributes exposed on EDH
Attribute (salesRegionLabel, salesCluster and SalesCountry) must be
MR004¤
exposed through EDH on prepared data (through Customer) and
enriched data (through finv_inventory_all, finv_inventory_beneficiary,
finv_inventory_billing, finv_inventory_contracting

© Copyright: France Telecom Group 757660631.docx Page 22 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

4.2.1.2 FINV_INVENTORY_ALL
CODRU NAMERU RULE DESCRIPTION
¤EDH-ENR005- Data join model Enriched data are calculated from prepared data with a LEFT OUTER JOIN
MR001¤ request, depending on Enrichment Contract (cf [2]) and data ways (cf [3])
¤EDH-ENR006- “GraphOrigin” field calculation For each line calculated in enriched data, a “GraphOrigin” column is added
MR002¤ and contains information related to the data path.

The possible values are:

1. “Beneficiary_Party” for each line coming from

FINV_INVENTORY_BENEFICIARY
2. “Billing_Party” for each line coming from FINV_INVENTORY_BILLING
3. “Contracting_Party" for each line coming from
FINV_INVENTORY_CONTRACTING
¤EDH-ENR007- Attributes exposed on EDH Attribute (salesRegionLabel, salesCluster and SalesCountry) must be exposed
© Copyright: France Telecom Group 757660631.docx Page 23 of 37
Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

MR001¤ through EDH on prepared data (through Customer) and enriched data
(through finv_inventory_all, finv_inventory_beneficiary, finv_inventory_billing,
finv_inventory_contracting

4.2.1.3 FINV_INVENTORY_ALL_S4CMS
CODRU NAMERU RULE DESCRIPTION
¤EDH-ENR008- S4CMS perimeter criteria Extract from S4CMS preparedData from perimeters_criteria and
MR001¤ extraction perimeters_inheritance views the criterias defining the perimeter criterias and
their dependencies:
- ID
- ICO1
- IDENT
- SIREN
- SATIN_ACCOUNT
- SATIN_SUBACCOUNT
- OFFER
- ID_PARENT
¤EDH-ENR008- S4CMS datas and FINV datas join Enriched data FINV_INVENTORY_ALL_S4CMS is created with an inner join

© Copyright: France Telecom Group 757660631.docx Page 24 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

MR002¤ between perimeter criterias extracted from S4CMS and FINV_INVENTORY_ALL
with following matches:

peri
met
SATIN_A SATIN_SUBACC
er ICO1 IDENT SIREN OFFER
CCOUNT OUNT
crite
ria

inve
ntor
Customer.int Customer.e Customer. BillingAc InstalledOffer.bill MarketingOffer.s
y
lCustomerId nterpriseId siren_duns count.uId ingSubAccount econdaryOfferId
crite
ria

¤EDH-ENR008- S4CMS perimeter information Add perimeters informations from S4CMS with an inner join between
MR003¤ addition FINV_INVENTORY_ALL_S4CMS and:

S4CMS COLUMN
S4CMS VIEW FROM FROM LABEL

perimeters_nomenclature IDTCMS perimeter id

perimeters_nomenclature NOMPERIM perimeter name

perimeters_nomenclature STATUTPERIM perimeter status

perimeters_nomenclature DATCREPERIM perimeter creationDate

© Copyright: France Telecom Group 757660631.docx Page 25 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

perimeters_nomenclature DATHSTPERIM perimeter usageStopDate

perimeters_nomenclature DATMODPERIM perimeter modification Date

perimeters_nomenclature IDTCMSPARENT parent perimeter id

perimeters_externallabel EXTLBL perimeter external Label

perimeters_subscription SUBALIAS perimeter subscription Alias

¤EDH-ENR008- ExternalRefs Attribute externalRefs (id and origin) must be present on all enriched views
MR003¤

4.2.2 “FINV-Relationships” Enrichment data

CODRU NAMERU RULE DESCRIPTION
¤EDH-ENR001- Data join model Enriched data are calculated from prepared data with a INNER JOIN request,
MR001¤ depending on Enrichment Contract (cf [2]) and data ways (cf [3])
¤EDH-ENR002- Filters application Apply filters defined in document (cf [3])

© Copyright: France Telecom Group 757660631.docx Page 26 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

MR002¤
¤EDH-ENR003- Relationship calculation For each line calculated in enriched data, the “relationShip” column contains
MR002¤ the reference to the edge.

The possible values are:

- For installedOffer:
o Relies_on
o Is_composed_of
o Derives_as
- For installedService:
o Is_linked_to
o Is_delegated
- For installedResource:
o Is_cascaded_by
o Is_composed_of
o Is_connected_to
o Is_divided_into
o Is_loadbalanced_by

4.2.3 “FINV_INSTALLEDOFFER” Enrichment data

CODRU NAMERU RULE DESCRIPTION

¤EDH-ENR001- Data join model Enriched data are calculated from prepared data, below the way how to build

© Copyright: France Telecom Group 757660631.docx Page 27 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

MR001¤ the view

¤EDH-ENR002- Filters application Apply filters defined in document (cf [3])

MR002¤

© Copyright: France Telecom Group 757660631.docx Page 28 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

4.3 USAGE

4.3.1 “FINV_Commercial_Inventory_init_bvpn” Usage data

Data are available in EDH depending on Usage.

CODRU NAMERU RULE DESCRIPTION

¤EDH-US001-MR001¤ S4CMS datas and FINV This usage view is created from the PIVOT FINV-s4CMS and
datas join FINV_RELATIONSHIPS_INSTALLED_OFFER. It carry the informations obtained
© Copyright: France Telecom Group 757660631.docx Page 29 of 37
Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

from the pivot view and every installedOffer in relation with the main
installedOffer

¤EDH-US001-MR002¤ Relationship calculation An additionnal column ‘relationship_direction’ to express the direction of the
union.

Ex: if installedOffer_uid is found in installedOffer_uid_in, then direction ='in'.

if installedOffer_uid is found in installedOffer_uid_out, then direction ='out'

¤EDH-US001-MR003¤ IdType valorisation An additionnal column ‘s4cms_idType’ is valorised with the value 'CMS'
¤EDH-US001-MR004¤ Filter objects columns Every column corresponding to the following objects : installedResource,
ResourceSpec, PerimeterCriteria, CustomerPerimeter,
User,Filter,Role,ResourceCost,CustomerOrder, is absent from this usage view

¤EDH-US001-MR005¤ Filter perimeters lines Every line with a perimeter that has no subscription to PARCWEB
( s4cms_subscription != 'PARC' and s4cms_statutperim !='ENABLED' ) is
absent from this usage view

¤EDH-US001-MR006¤ Filter status lines Every line where the installedoffer_standardstatus is not 'Active' or is not
'Created' is absent from this usage view

¤EDH-US001-MR007¤ Filter offer lines This usage view will filter every line where the offerSpecification_uId is not
present in ["ALLSERV004","5-ALLSERV002","5-ALLSERV005","5-
ALLSERV001","5-ALLSERP006","5-ALLSERP007","5-BVPNSOLMIP","5-
© Copyright: France Telecom Group 757660631.docx Page 30 of 37
Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

BIZVPNSOL","5-CORPORCTS","5-CORPORCT","5-CORPORBDS","5-
CORPSVIRTS","5-CORPSRFT","5-CORPSRCTS","5-
CORPORCTFT","CORPSVIRT","5-CORPSRCT","5-CORPORFTS","5-
CORPORFT","5-CORPSRCTFT","5-CORPORBD","5-CORPORCTMP","5-
CORPSRFTS","5-CORPORBDFT","5-CORPORCTSP","5-INTRAMOB","5-
INTRASMALL","5-INTRACORPO","5-PASSCORPO","5-
PASSMALL","PASSMOBILE","5-SMALLRCTFT","5-SMALLHYRFT","5-
SMALLRBD","5-SMALLRFT","5-SMALLRFTS","5-SMALLHYRCT","5-
SMALLRCT","5-VISIO","5-SMACINT001","5-CORLINT001","5-
SMALINT001","5-CORCINT001"]

¤EDH-US001-MR008 Role formatted creation Partner needs a specific customer role format.
New attribute Role_tmf is created :
graphOrigin Role_tmf
Beneficiary_Party Beneficiary
Contracting_Party Contracting Party
Billing_Party Holder

4.3.2 “FINV_Commercial_Inventory_init_Numeris” Usage data

© Copyright: France Telecom Group 757660631.docx Page 31 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

Data are available in EDH depending on Usage.

CODRU NAMERU RULE DESCRIPTION

¤EDH-US001-MR001¤ S4CMS datas and FINV This usage view is created from the PIVOT FINV-s4CMS and
datas join FINV_RELATIONSHIPS_INSTALLED_OFFER. It carry the informations obtained
from the pivot view and every installedOffer in relation with the main
installedOffer

© Copyright: France Telecom Group 757660631.docx Page 32 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

¤EDH-US001-MR002¤ Relationship calculation An additionnal column ‘relationship_direction’ to express the direction of the
union.

Ex: if installedOffer_uid is found in installedOffer_uid_in, then direction ='in'.

if installedOffer_uid is found in installedOffer_uid_out, then direction ='out'

¤EDH-US001-MR003¤ IdType valorisation An additionnal column ‘s4cms_idType’ is valorised with the value 'CMS'
¤EDH-US001-MR004¤ Filter objects columns Every column corresponding to the following objects : installedResource,
ResourceSpec, PerimeterCriteria, CustomerPerimeter,
User,Filter,Role,ResourceCost,CustomerOrder, is absent from this usage view

¤EDH-US001-MR005¤ Filter perimeters lines Every line with a perimeter that has no subscription to PARCWEB
( s4cms_subscription != 'PARC' and s4cms_statutperim !='ENABLED' ) is
absent from this usage view

¤EDH-US001-MR006¤ Filter status lines Every line where the installedoffer_standardstatus is not 'Active' or is not
'Created' is absent from this usage view

¤EDH-US001-MR007¤ Filter offer lines This usage view will filter every line where the offerSpecification_uId is not
present in ['90-GPTPRDCOM','90-NUB','90-NUDUO','90-NUMACCRPV','90-
NUMJGNIP','90-NUP','90-SDA']

¤EDH-US001-MR008 Role formatted creation Partner needs a specific customer role format.
New attribute Role_tmf is created :
© Copyright: France Telecom Group 757660631.docx Page 33 of 37
Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

graphOrigin Role_tmf
Beneficiary_Party Beneficiary
Contracting_Party Contracting Party
Billing_Party Holder

4.4 REINIT
All the products contained in FINV concerning a specific offer are sent to partners via EDH.
Reinit is available for :
- BVPN offers
- Numeris offers

4.4.1 Process

© Copyright: France Telecom Group 757660631.docx Page 34 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

1) Federated Inventory provides json linear configuration file to EDH

2) EDH execute jsonlinear tool on defined usage view with json linear file configuration to obtain json reinit file
3) EDH provides json reinit file to FLOW
4) FLOW provides json reinit file to partners

4.4.2 Rules
CODRU NAMERU RULE DESCRIPTION
¤EDH-RE001-MR001¤ Json construction Federated Inventory provides to EDH a jsonLinear configuration files describing expected json format.
The usage view is translated to json.

© Copyright: France Telecom Group 757660631.docx Page 35 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

CODRU NAMERU RULE DESCRIPTION

The json productEvent created using the data in the usage view match the productEvent sent by FINV
with legacy push reinit.

© Copyright: France Telecom Group 757660631.docx Page 36 of 37

Orange Restricted

Orange Restricted
 Federated Inventory 3.0: Low Level Design: Supervision

Appendix A - Glossary

Acronym Description

© Copyright: France Telecom Group 757660631.docx Page 37 of 37

Orange Restricted

Orange Restricted