gis_configuration_getty

8/7/2019 GIS_Configuration_Getty

1/22

EFStOPEnterprise Financial and Sales Order Processing

Global Intercompany SystemConfiguration Document

Version 2.44/18/11 23:14 a4/p4

This document contains trade secrets and proprietary information of GettyImages, Inc. No use or disclosure of the information contained herein ispermitted without the prior written consent of Getty Images, Inc.


2/22

EFStOPGL Configuration Document

Table of Contents

TABLE OF CONTENTS...................................................................................................................................2

REVISION HISTORY..............................................................................................................................................2Document Version.....................................................................................................................................2Date...........................................................................................................................................................2Person.......................................................................................................................................................2Notes.........................................................................................................................................................2

GLOBAL INTERCOMPANY SYSTEM CONFIGURATION SCOPE.................................................... ............4

APPLICATION FEATURESTOBE IMPLEMENTEDIN PHASE 2.............................................................................................4APPLICATION FEATURES NOT TOBE IMPLEMENTEDIN PHASE 2................................................................................... .4

GIS RESPONSIBILITIES CONFIGURATION........................................................................................ .........5

GIS RESPONSIBILITIES.........................................................................................................................................5

SUBSIDIARY CONFIGURATION.....................................................................................................................7

INTERCOMPANY PROFILE OPTIONS................................................................................................ .........10

INTERCOMPANY TRANSACTION TYPES...................................................................................................11

INTERCOMPANY REV SPLIT..................................................................................................................................11

INTERCOMPANY CLEARING ACCOUNTS..................................................................................................12

AUTO-ACCOUNTING RULES................................................................................................................. ......13

SENDER..........................................................................................................................................................16RECEIVER.......................................................................................................................................................17

CROSS-VALIDATION RULES.......................................................................................................................20

DOCUMENT SEQUENCING..........................................................................................................................21

OWNERSHIP PERCENTAGES......................................................................................................................22

Revision History

Document

Version

Date Person Notes

1.0 March 27, 2001 Jodi Weigand Update Template Format

2.0 June 13, 2001 BrianChristenson

Add additional information and changescreen shots

2.1 September 12, 2001 Jodi Weigand Updated for change in inter-companyaccounts

2.2 September 19, 2001 Jodi Weigand Updated. Pointing Getty Images Inc. toUS SOB instead of Inc. SOB. Addedrules to intercompany segment for thereceiver distribution.

2.3 September 24, 2001 BrianChristenson

Clean-up and added new cross validationrule requirement.

56134765.doc Page 2 of 22 last printed 4/18/2011 23:14 A4/P4


3/22


2.4 December 13, 2001 Jodi Weigand Added Austria, Switzerland, Ireland,Belgium, Netherlands, Spain, Sweden,Denmark.



4/22


Global Intercompany System Configuration Scope

Application Features to be Implemented in Phase 2

Feature Description Getty Comment

AutoAccounting Rules Create AutoAccounting rules toautomatically create the Sender Clearing,Receiver Distribution and Receiver Clearingaccount combinations.

Application Features NOT to be Implemented in Phase 2

The following major features of the Oracle General Ledger application will NOT be implemented:

Feature Description Comment

Recurring Entries



5/22


GIS RESPONSIBILITIES CONFIGURATION

GIS Responsibilities

NAVIGATION SYSADMIN: RESPONSIBILITIES.DEFINE

In order to access configuration forms, the GIS Super User responsibility will be set up for each subsidiary.In addition, there will also need to be a GIS User responsibility for each subsidiary created. Each subsidiaryis associated with one balancing segment. There can be multiple subsidiaries per set of books.

The responsibilities that will be setup for 10/6 are as follows:

GIS SuperUser USA GIS User USAGIS SuperUser Seattle GIS User SeattleGIS SuperUser Photographers GIS User PhotographersGIS SuperUser Inc GIS User IncGIS SuperUser UK GIS User UK

GIS SuperUser FRA GIS User FRAGIS SuperUser DEU GIS User DEUGIS SuperUser Canada GIS User Canada



6/22


The screen above and below display the sub-menus and functions to be excluded from each specificresponsibility.



7/22


SUBSIDIARY CONFIGURATIONNAVIGATION GIS ADMIN: SETUP.INTERCOMPANY.SUBSIDIARIES

Getty Images will need at least one subsidiary for each legal entity that will perform inter-company

accounting. A subsidiary is associated with one balancing segment value or Company. There will be eightsubsidiaries created initially US, Seattle, Photographers, Inc, Canada, UK, France and Germany.

A subsidiary with parent privileges can review and approve transactions for any subsidiary. If this box is notcheck, the subsidiary can only review and approve its own transactions. The US and Inc subsidiaries will begiven the parent privileges. Only subsidiaries with parent privileges can run the program to delete oldapproved and transferred inter-company transactions.

Access Partner Lines allows a subsidiary to view its own as well as the Receivers transaction lines.

The following table identifies the appropriate configurations for each of the subsidiaries created in theOctober 2001 Oracle application rollout project. In future releases similar entries will need to be created fornew subsidiaries.



8/22


Subsidiary Description Book-Interco& Local

Currency Company

Parent

AutoApprove &Partnerlines

Getty ImagesUS Getty Images USA Inc. Getty ImagesUSA USD 315 Yes Yes

Getty ImagesUK

Getty Images UK Ltd. Getty ImagesUK

GBP 110 No Yes

Getty ImagesFrance

Getty Images France SA Getty ImagesFrance

EUR 130 No Yes

Getty ImagesGermany

Getty Images DeutchlandGmbh.

Getty ImagesDeutchland

EUR 120 No Yes

Getty ImagesInc

Getty Images Inc. Getty ImagesUSA

USD 005 Yes Yes

Getty ImagesPhotographer

Getty ImagesPhotographers Inc.

Getty ImagesUSA

USD 320 No Yes

Getty Images

Seattle

Getty Images Seattle Inc. Getty Images

USA

USD 310 No Yes

Getty ImagesCanada

Getty Images Canada Inc. Getty ImagesCanada

CAD 350 No Yes

Getty ImagesAustria

Getty Images Austria Getty ImagesAustria

EUR 200 No Yes

Getty ImagesSwitzerland

Getty Images Switzerland Getty ImagesSwitzerland

CHE 190 No Yes

Getty ImagesIreland

Getty Images Ireland Getty ImagesIreland

EUR 210 No Yes

Getty ImagesBelgium

Getty Images Belgium Getty ImagesBelgium

EUR 160 No Yes

Getty ImagesNetherlands

Getty Images Netherlands Getty ImagesNetherlands

EUR 140 No Yes

Getty ImagesSpain

Getty Images Spain Getty ImagesSpain

EUR 150 No Yes

Getty ImagesSweden

Getty Images Sweden Getty ImagesSweden

SEK 180 No Yes

Getty ImagesDenmark

Getty Images Denmark Getty ImagesDenmark

DNK 170 No Yes

The following displays what the user would see if they tried to run the Delete Intercompany Transactionsprogram from a subsidiary responsibility not having parent level privileges.



9/22




10/22


INTERCOMPANY PROFILE OPTIONS

NAVIGATION SYSADMIN: PROFILE.SYSTEM

All the responsibilities will be tied to appropriate subsidiaries based on a profile option the Intercompany:Subsidiary profile option depicted here. This step can not be completed until all the responsibilities havebeen created in the Oracle applications. The pop up screen will appear as a validation to insure you selectfrom only existing subsidiary values.



11/22


INTERCOMPANY TRANSACTION TYPES

Intercompany Rev Split

NAVIGATION GIS ADMIN: SETUP.INTERCOMPANY.TRANSACTION TYPES

Transaction types are required before you can enter intercompany transactions in GIS. Allow Auto-Approvecheck box allows transactions of this type to be approved automatically if the subsidiary also allows auto-approval. The Allow Interest Accrual, Allow Invoicing, and VAT Taxable options are not yet available.

Three transaction types will be configured initially, Inter-company Rev Split to be used exclusively for Inter-company Revenue transactions, Long Term to be used for the rare long term inter-company transaction,and Other to be used for all other inter-company transactions.

Transaction types are shared among all the subsidiaries so only need to be setup once.



12/22


INTERCOMPANY CLEARING ACCOUNTS

NAVIGATION GIS USER: SETUP.INTERCOMPANY.CLEARING ACCOUNTS

Intercompany clearing accounts must be set up for each subsidiary.



13/22


AUTO-ACCOUNTING RULES

NAVIGATION GIS USER: SETUP.INTERCOMPANY.AUTOACCOUNTING RULES

Auto-accounting rules will generate complete intercompany accounting lines automatically. For theIntercompany Rev Split transaction type, we will be automatically creating the Sender Clearing, ReceiverDistribution and Receiver Clearing accounting combinations.



14/22


15/22


The above screens provide a visual image of the Sender Clearing, Receiver Clearing and ReceiverDistribution rules of the Account segment for the Intercompany Revenue Split transaction type. A moredetailed table version of these rules follows, which include the other transaction types. In addition, a listingthe Receiver Distribution rules of the Intercompany segment for ALL the transaction types is provided.



16/22


Sender

Sender Clearing rules for the ACCOUNT segment will look as follows.

Transaction Type Sender Sender Segment Value

Intercompany Rev Split Getty Images UK 17255Intercompany Rev Split Getty Images France 17255

Intercompany Rev Split Getty Images Germany 17255

Intercompany Rev Split Getty Images US 17255

Other Getty Images US 11985

Other Getty Images Seattle 11985

Other Getty Images Photographer 11985

Other Getty Images Inc 11985

Other Getty Images UK 11985

Other Getty Images France 11985

Other Getty Images Germany 11985

Other Getty Images Canada 11985

Long Term Getty Images US 17260

Long Term Getty Images Seattle 17260

Long Term Getty Images Photographer 17260

Long Term Getty Images Inc 17260

Long Term Getty Images UK 17260

Long Term Getty Images France 17260

Long Term Getty Images Germany 17260

Long Term Getty Images Canada 17260

ADD FOR 2/1

Other Getty Images Austria 11985

Other Getty Images Switzerland 11985

Other Getty Images Ireland 11985

Other Getty Images Belgium 11985

Other Getty Images Netherlands 11985Other Getty Images Spain 11985

Other Getty Images Sweden 11985

Other Getty Images Denmark 11985

Long Term Getty Images Austria 17260

Long Term Getty Images Switzerland 17260

Long Term Getty Images Ireland 17260

Long Term Getty Images Belgium 17260

Long Term Getty Images Netherlands 17260

Long Term Getty Images Spain 17260

Long Term Getty Images Sweden 17260

Long Term Getty Images Denmark 17260



17/22


Receiver

Receiver Distribution rules for the ACCOUNT segment will look as follows.

Transaction Type Sender Receiver Sender SegmentValue

Receiver SegmentValue

Intercompany RevSplit

Getty Images US All Others 45011 55011


Getty Images UK All Others 45011 55011


Getty ImagesFrance

All Others 45011 55011


Getty ImagesGermany

All Others 45011 55011

Receiver Distribution rules for the INTERCOMPANY segmentwill look as follows.


ReceiverSegmentValue

Intercompany Rev Split Getty Images US Getty Images UK 110 315

Intercompany Rev Split Getty Images US Getty Images France 130 315

Intercompany Rev Split Getty Images US Getty Images Germany 120 315

Intercompany Rev Split Getty Images US Getty Images Canada 350 315

Intercompany Rev Split Getty Images UK Getty Images France 130 110

Intercompany Rev Split Getty Images UK Getty Images Germany 120 110

Intercompany Rev Split Getty Images UK Getty Images US 315 110

Intercompany Rev Split Getty Images UK Getty Images Canada 350 110Intercompany Rev Split Getty Images France Getty Images UK 110 130

Intercompany Rev Split Getty Images France Getty Images Germany 120 130

Intercompany Rev Split Getty Images France Getty Images US 315 130

Intercompany Rev Split Getty Images France Getty Images Canada 350 130

Intercompany Rev Split Getty ImagesGermany

Getty Images UK 110 120


Getty Images France 130 120


Getty Images US 315 120


Getty Images Canada 350 120

Other All Other All Other 000 000Long Term All Other All Other 000 000

ADD FOR 2/1

Intercompany Rev Split Getty Images US Getty Images Austria 200 315

Intercompany Rev Split Getty Images US Getty Images Switzerland 190 315

Intercompany Rev Split Getty Images US Getty Images Ireland 210 315

Intercompany Rev Split Getty Images US Getty Images Belgium 160 315

Intercompany Rev Split Getty Images US Getty Images Netherlands 140 315

Intercompany Rev Split Getty Images US Getty Images Spain 150 315

Intercompany Rev Split Getty Images US Getty Images Sweden 180 315

Intercompany Rev Split Getty Images US Getty Images Denmark 170 315



18/22


Intercompany Rev Split Getty Images UK Getty Images Austria 200 110

Intercompany Rev Split Getty Images UK Getty Images Switzerland 190 110

Intercompany Rev Split Getty Images UK Getty Images Ireland 210 110

Intercompany Rev Split Getty Images UK Getty Images Belgium 160 110

Intercompany Rev Split Getty Images UK Getty Images Netherlands 140 110

Intercompany Rev Split Getty Images UK Getty Images Spain 150 110

Intercompany Rev Split Getty Images UK Getty Images Sweden 180 110Intercompany Rev Split Getty Images UK Getty Images Denmark 170 110

Intercompany Rev Split Getty Images France Getty Images Austria 200 130

Intercompany Rev Split Getty Images France Getty Images Switzerland 190 130

Intercompany Rev Split Getty Images France Getty Images Ireland 210 130

Intercompany Rev Split Getty Images France Getty Images Belgium 160 130

Intercompany Rev Split Getty Images France Getty Images Netherlands 140 130

Intercompany Rev Split Getty Images France Getty Images Spain 150 130

Intercompany Rev Split Getty Images France Getty Images Sweden 180 130

Intercompany Rev Split Getty Images France Getty Images Denmark 170 130


Getty Images Austria 200 120

Intercompany Rev Split Getty Images

Germany

Getty Images Switzerland 190 120


Getty Images Ireland 210 120


Getty Images Belgium 160 120


Getty Images Netherlands 140 120


Getty Images Spain 150 120


Getty Images Sweden 180 120


Getty Images Denmark 170 120

Important Note: You need to remember when new trading (image selling) subsidiaries are created inOracle, you MUST create a separate rule for the subsidiary as a Receiver to each image owning Sendersubsidiary for the Intercompany Rev Split transaction type. If you this isnt done, the ICA process will fail.

Receiver Clearing rules for the ACCOUNT segment will look as follows.


ReceiverSegmentValue

Intercompany Rev

Split

Getty Images UK All Others 17255 29001


Getty Images France All Others 17255 29001


Getty Images Germany All Others 17255 29001


Getty Images US All Others 17255 29001

Other Getty Images US All Others 11985 20501

Other Getty Images Seattle All Others 11985 20501

Other Getty Images Photographer All Others 11985 20501

Other Getty Images Inc All Others 11985 20501

Other Getty Images UK All Others 11985 20501



19/22


Other Getty Images France All Others 11985 20501

Other Getty Images Germany All Others 11985 20501

Other Getty Images Canada All Others 11985 20501

Long Term Getty Images US All Others 17260 29002

Long Term Getty Images Seattle All Others 17260 29002

Long Term Getty Images Photographer All Others 17260 29002

Long Term Getty Images Inc All Others 17260 29002Long Term Getty Images UK All Others 17260 29002

Long Term Getty Images France All Others 17260 29002

Long Term Getty Images Germany All Others 17260 29002

Long Term Getty Images Canada All Others 17260 29002

ADD FOR 2/1

Other Getty Images Austria All Others 11985 20501

Other Getty Images Switzerland All Others 11985 20501

Other Getty Images Ireland All Others 11985 20501

Other Getty Images Belgium All Others 11985 20501

Other Getty Images Netherlands All Others 11985 20501

Other Getty Images Spain All Others 11985 20501

Other Getty Images Sweden All Others 11985 20501

Other Getty Images Denmark All Others 11985 20501Long Term Getty Images Austria All Others 17260 29002

Long Term Getty Images Switzerland All Others 17260 29002

Long Term Getty Images Ireland All Others 17260 29002

Long Term Getty Images Belgium All Others 17260 29002

Long Term Getty Images Netherlands All Others 17260 29002

Long Term Getty Images Spain All Others 17260 29002

Long Term Getty Images Sweden All Others 17260 29002

Long Term Getty Images Denmark All Others 17260 29002



20/22


CROSS-VALIDATION RULESNAVIGATION GL USER: SETUP.FINANCIAL.FLEXFIELDS.KEY.RULES

Sales and Cost of Sales figures would be misrepresented if a Brand were attached to Intercompany sales

and cost of sales transactions. Therefore, the cross validation rules need to be modified to allow for ONLY a000 - NULL Brand value to be assigned to all Intercompany sales and cost of sales transactions. Rule GL03will need to be modified as displayed below.

An additional rule will need to be created to limit the brand available for Intercompany Sales and COGS.



21/22


DOCUMENT SEQUENCINGNAVIGATION GLSUPER USER: SETUP.FINANCIAL.SEQUENCE.ASSIGN

A document sequence needs to be setup for intercompany transfers for each set of books.

For 2/1 Add Austria, Switzerland, Ireland, Belgium, Netherlands, Spain, Sweden, Denmark



22/22


OWNERSHIP PERCENTAGES

GIS SUPERUSER: ICA REVENUE SPLIT

Enter the Intercompany revenue split records as follows, if they dont already exist in the table.

gis_configuration_getty

Documents