Oracle Multi-org - Ar And Om Data Structure Changes
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Oracle Multi-org - Ar And Om Data Structure Changes as PDF for free.
More details
- Words: 1,181
- Pages: 12
Oracle Multi-Org - AR and OM Data Structure Changes Team:
Technology
Creation Date:
1 July 2009
Created By:
Brendan Furey
Last Updated: Control:
19272441.doc
Version:
1.0
Introduction.......................................................................................................... ........2 Customer Model (TCA)............................................................................................. ...3 Entity Relationship Diagrams.................................................................... ............3 Record Duplication........................................................................................ ........4 Oracle Applications Modules................................................................... ....................6 Entity Relationship Diagrams.................................................................... ............6 Multi-Org Setup............................................................................................ .........7 Transactional Entities.......................................................................... ........................8 AR Invoices.................................................................................................. .........8 AR Receipts...................................................................................... ....................9 OM Transactions............................................................................... ..................10 Entity Listing...................................................................................... ........................11 Org Setup Required............................................................................................. 11 Transactional Org-Striped Entities..................................................................... ..11 Org Setup Not Required.................................................................................. ....12
Introduction
1
Introduction Companies sometimes implement Oracle AR and OM using a single operating unit, and later add additional operating iunits. This document outlines at a high level the structural data changes required in setting up new operating units, using an upgrade from one to four operating units as an example. It does not attempt to detail the actual functional setup steps required. The first section deals with the structural data changes in the Oracle customer model, with diagrams representing the entities and relationships concerned. The setup required here involves duplicating certain of the entities across the new operating units, and we distinguish between those entities that require duplication across the new operating units and those that don’t.The second section deals with the setup required in the various Oracle modules, such as AR and OM, where the setup generally involves creating parallel records in the new operating units, with different values for certain attributes, such as accounting fields. The final section tabulates all the entities depicted, noting the Oracle table names and the type of method used for setup where applicable. This document may help to identify custom reports and programs that need modifying for the new data structures.
Introduction
2
Customer Model (TCA) Entity Relationship Diagrams Oracle TCA ERD Relation
Object
Subject
Party
Org Contact
Customer
Relation
Contact
Party
Account Relation
Contact Point
Account
Contact
General
Respons’y
Role
Site
AR Operating Unit
Site Use OU Entity
Customer
Contact Party Site
Location
Introduction
3
Operating Units ERD Non-OU Entity
OU1
OU2
OU3
OU4
Operating Unit Entity
AR Operating Unit
ERD Key The entities are formatted according to three types:
Non-Org Entity
Entity Type Non-Org Entity Org-Striped Entity Org-Linked Entity
Org-Striped Entity
Org-Linked Entity
Notes Global entity requiring no setup across new AR operating units Org-striped requiring setup across new AR operating units Global entity, but referencing an org-striped entity, and therefore also requiring setup across new AR operating units
AR and OM Operating Units Note that, generally, the new operating units may already exist, but without setup for order and invoice processing. In the example considered three new AR operating units OU2, OU3, OU4 will be implemented for AR by this set up, while only two OU2, OU3 (so it is thought) will be implemented for OM, since OU4 will not need to take orders.
Record Duplication Customer Conversion The records corresponding to the entities in the AR Operating Unit Entity will be copied from the existing records for OU1 to new records for: •
OU2 Introduction
4
•
OU3
•
OU4
No other records need be copied, so that customers, addresses, and contact details will remain global. Customer Synchronisation Changes to addresses and site contact details may be made in any operating unit, and will be visible in all. Changes to Operating Unit entity records will be synchronised across the operating units by means of database triggers that propagate the changes.
Introduction
5
Oracle Applications Modules Entity Relationship Diagrams Responsibilities User Responsibility
User
Responsibility Warehouse
Warehouse
AR System Parameters Hold Authorisation
Responsibility
Operating Unit
OM/AR
Responsibility Profile Value
Operating Unit
Other
Other
Responsibility Exclusion
Hold
OM System Parameters
OE Transaction Types OM Transaction Type Order Numbering
Order Type Numbering
Order
Default
Line Type Flow
Workflow
Line
Remit To Addresses
Account Site
Party Site
Location
Remit To Address
Remit To Country
Introduction
6
Other Org-Striped/Linked Entities Distribution Set
Account Default
Receipt Class
Distribution Set Line
Account Default Segment
Receipt Method Account
AR Transaction Type
Batch Source
Receivables Activity
Receipt Source
Tax Code
Lockbox
Standard Memo Line
Multi-Org Setup The org-striped and org-linked entities will be set up across the new operating units by a mixture of manual and automated methods, summarised in the last section.
Introduction
7
Transactional Entities AR Invoices
Location
Customer
Party
Country
AR Region
Party Site
Batch Source
Customer Site
Ship To
Bill To
Remit To
Remit To Assignment
Batch
Invoice
Distribution
External
Receivables
Remit To
AR Operating Unit
Bill To
Transaction
Ship To
Internal
Line
Customer Site Use
Invoice Line
Adjustment
Payment Schedule
Non-Tax
Tax
Item
Warehouse (Params)
Operating Unit Entity
Term Line
Term
Introduction
8
AR Receipts Receipt Application
Receipt
Receipt History
Payer
Bill To AR Invoice
Receivables Distribution
Customer Account
Bank Account
AR Batch
GL Account
Introduction
9
OM Transactions Customer Ship To
Bill To
Sold To
Customer Site Order Ship To
Order Header
Order
Bill To Line
Line
OM Transaction Type
OM Hold
Invoice Header
OE Operating Unit
Order Line Bill To
Line Invoice Line
Ship To
OE System Parameters
Tax Customer Site Use
Operating Unit Entity
Item
Warehouse
Delivery Detail
Delivery Assignment
Delivery
Introduction
10
Entity Listing Org Setup Required Linked/ Striped
Entity
Table Name
Responsbiility
HZ_ROLE_RESPONSIBILITY
Site Contact Role
HZ_CUST_ACCOUNT_ROLES
Site
HZ_CUST_ACCT_SITES
Site Use
HZ_CUST_SITE_USES
Responsibility
FND_RESPONSIBILITY
Responsibility Exclusion
FND_RESP_FUNCTIONS
User Responsibility
FND_USER_RESP_GROUPS
Profile Value/OU Resp
FND_PROFILE_OPTION_VALUES
Setup Type
# per OU
(none)
0
Program
385,493
Oracle Screen
TCA Linked
124,683 Striped
Customers
194,627
FND 45 Linked
FNDLOAD
682
Responsibility
34,762
User
45
Profile Options
2
Document Sequence Assign Document Sequence Hold Authorisation OM System Parameters
OM Order Numbering
Hold Authorisation
FND_DOCUMENT_SEQUENCES FND_DOC_SEQUENCE_ASSIGNM ENTS OE_HOLD_AUTHORIZATIONS
OE System Parameters
OE_SYSTEM_PARAMETERS
Order Type Numbering
OE Transaction Types/Order OE Transaction Types/Line Line Type Flow
Linked
Manual
4 Linked
18+ Manual
OE_TRANSACTION_TYPES
1 4
Striped
11
OE_WORKFLOW_ASSIGNMENTS
16
OM Transaction Types
Linked
Manual (or program)
226
Striped
Manual
5,866*
Banks
RA_CUST_TRX_TYPES
10
Transaction Types
Batch Source
RA_BATCH_SOURCES
9
Batch Sources
Distribution Set
AR_DISTRIBUTION_SETS
5
Distribution Set Line
AR_DISTRIBUTION_SET_LINES
5
Receivables Activity
10
Receivables Activities
2
Receipt Classes
Receipt Source
AR_RECEIVABLES_TRX AR_RECEIPT_METHOD_ACCOUN TS AR_BATCH_SOURCES
4
Receipt Sources
Tax Code
AR_VAT_TAX
2
Tax Codes
Lockbox
AR_LOCKBOXES
3
Standard Memo Lines
AR_MEMO_LINES
Lockboxes Standard Memo Lines
Remit-To Address
HZ_CUST_ACCT_SITES
Warehouse Responsibility
ORG_ACCESS
Bank Account
AP_BANK_ACCOUNTS
Organization Access
AP AR AR Transaction Type
Receipt Method Account
HZ_PARTY_SITES HZ_LOCATIONS Remit-To Country
RA_REMIT_TOS
Striped Manual
1
Distribution Sets
1 1 No
1
Striped
Remit-To Addresses
15
Transactional Org-Striped Entities Entity
Table Name
Oracle Screen AR
Introduction
11
Adjustment
AR_ADJUSTMENTS
Payment Schedule
AR_PAYMENT_SCHEDULES
Invoice
RA_CUSTOMER_TRX
Invoice Line
RA_CUSTOMER_TRX_LINES
Distribution
RA_CUST_TRX_LINE_GL_DIST
Batch
RA_BATCHES
Receipt
AR_CASH_RECEIPTS
Receipt Application
AR_RECEIVABLE_APPLICATIONS
Receipt History
AR_CASH_RECEIPT_HISTORY
Order Header
OM OE_ORDER_HEADERS
Order Line
OE_ORDER_LINES
OM Hold
OE_ORDER_HOLDS
Transactions
Orders
Org Setup Not Required Entity
Table Name
Oracle Screen
Operating Unit
HR HR_ALL_ORGANIZATION_UNITS
Organizations
Account
TCA HZ_CUST_ACCOUNTS
Account Relation
HZ_CUST_ACCT_RELATE_ALL
Contact Point
HZ_CONTACT_POINTS
Location
HZ_LOCATIONS
Org Contact
HZ_ORG_CONTACTS
Party
HZ_PARTIES
Party Relation
HZ_RELATIONSHIPS
Party Site
HZ_PARTY_SITES
User
FND_USER
Customers
FND Users INV Item
MTL_SYSTEM_ITEMS_B
Items
Warehouse
MTL_PARAMETERS
Organisations
Hold
OE_HOLD_DEFINITIONS
OM Holds
AR Receipt Class
AR_RECEIPT_CLASSES
Term
RA_TERMS_B
Term Line
RA_TERMS_LINES
Delivery Detail
WSH WSH_DELIVERY_DETAILS
Delivery Assignment
WSH_DELIVERY_ASSIGNMENTS
Delivery
WSH_NEW_DELIVERIES
Receipt Classes Payment Terms
Shipping Transactions
WF Workflow
WF_ITEM_TYPES
(Workflow Builder)
Introduction
12
Technology
Creation Date:
1 July 2009
Created By:
Brendan Furey
Last Updated: Control:
19272441.doc
Version:
1.0
Introduction.......................................................................................................... ........2 Customer Model (TCA)............................................................................................. ...3 Entity Relationship Diagrams.................................................................... ............3 Record Duplication........................................................................................ ........4 Oracle Applications Modules................................................................... ....................6 Entity Relationship Diagrams.................................................................... ............6 Multi-Org Setup............................................................................................ .........7 Transactional Entities.......................................................................... ........................8 AR Invoices.................................................................................................. .........8 AR Receipts...................................................................................... ....................9 OM Transactions............................................................................... ..................10 Entity Listing...................................................................................... ........................11 Org Setup Required............................................................................................. 11 Transactional Org-Striped Entities..................................................................... ..11 Org Setup Not Required.................................................................................. ....12
Introduction
1
Introduction Companies sometimes implement Oracle AR and OM using a single operating unit, and later add additional operating iunits. This document outlines at a high level the structural data changes required in setting up new operating units, using an upgrade from one to four operating units as an example. It does not attempt to detail the actual functional setup steps required. The first section deals with the structural data changes in the Oracle customer model, with diagrams representing the entities and relationships concerned. The setup required here involves duplicating certain of the entities across the new operating units, and we distinguish between those entities that require duplication across the new operating units and those that don’t.The second section deals with the setup required in the various Oracle modules, such as AR and OM, where the setup generally involves creating parallel records in the new operating units, with different values for certain attributes, such as accounting fields. The final section tabulates all the entities depicted, noting the Oracle table names and the type of method used for setup where applicable. This document may help to identify custom reports and programs that need modifying for the new data structures.
Introduction
2
Customer Model (TCA) Entity Relationship Diagrams Oracle TCA ERD Relation
Object
Subject
Party
Org Contact
Customer
Relation
Contact
Party
Account Relation
Contact Point
Account
Contact
General
Respons’y
Role
Site
AR Operating Unit
Site Use OU Entity
Customer
Contact Party Site
Location
Introduction
3
Operating Units ERD Non-OU Entity
OU1
OU2
OU3
OU4
Operating Unit Entity
AR Operating Unit
ERD Key The entities are formatted according to three types:
Non-Org Entity
Entity Type Non-Org Entity Org-Striped Entity Org-Linked Entity
Org-Striped Entity
Org-Linked Entity
Notes Global entity requiring no setup across new AR operating units Org-striped requiring setup across new AR operating units Global entity, but referencing an org-striped entity, and therefore also requiring setup across new AR operating units
AR and OM Operating Units Note that, generally, the new operating units may already exist, but without setup for order and invoice processing. In the example considered three new AR operating units OU2, OU3, OU4 will be implemented for AR by this set up, while only two OU2, OU3 (so it is thought) will be implemented for OM, since OU4 will not need to take orders.
Record Duplication Customer Conversion The records corresponding to the entities in the AR Operating Unit Entity will be copied from the existing records for OU1 to new records for: •
OU2 Introduction
4
•
OU3
•
OU4
No other records need be copied, so that customers, addresses, and contact details will remain global. Customer Synchronisation Changes to addresses and site contact details may be made in any operating unit, and will be visible in all. Changes to Operating Unit entity records will be synchronised across the operating units by means of database triggers that propagate the changes.
Introduction
5
Oracle Applications Modules Entity Relationship Diagrams Responsibilities User Responsibility
User
Responsibility Warehouse
Warehouse
AR System Parameters Hold Authorisation
Responsibility
Operating Unit
OM/AR
Responsibility Profile Value
Operating Unit
Other
Other
Responsibility Exclusion
Hold
OM System Parameters
OE Transaction Types OM Transaction Type Order Numbering
Order Type Numbering
Order
Default
Line Type Flow
Workflow
Line
Remit To Addresses
Account Site
Party Site
Location
Remit To Address
Remit To Country
Introduction
6
Other Org-Striped/Linked Entities Distribution Set
Account Default
Receipt Class
Distribution Set Line
Account Default Segment
Receipt Method Account
AR Transaction Type
Batch Source
Receivables Activity
Receipt Source
Tax Code
Lockbox
Standard Memo Line
Multi-Org Setup The org-striped and org-linked entities will be set up across the new operating units by a mixture of manual and automated methods, summarised in the last section.
Introduction
7
Transactional Entities AR Invoices
Location
Customer
Party
Country
AR Region
Party Site
Batch Source
Customer Site
Ship To
Bill To
Remit To
Remit To Assignment
Batch
Invoice
Distribution
External
Receivables
Remit To
AR Operating Unit
Bill To
Transaction
Ship To
Internal
Line
Customer Site Use
Invoice Line
Adjustment
Payment Schedule
Non-Tax
Tax
Item
Warehouse (Params)
Operating Unit Entity
Term Line
Term
Introduction
8
AR Receipts Receipt Application
Receipt
Receipt History
Payer
Bill To AR Invoice
Receivables Distribution
Customer Account
Bank Account
AR Batch
GL Account
Introduction
9
OM Transactions Customer Ship To
Bill To
Sold To
Customer Site Order Ship To
Order Header
Order
Bill To Line
Line
OM Transaction Type
OM Hold
Invoice Header
OE Operating Unit
Order Line Bill To
Line Invoice Line
Ship To
OE System Parameters
Tax Customer Site Use
Operating Unit Entity
Item
Warehouse
Delivery Detail
Delivery Assignment
Delivery
Introduction
10
Entity Listing Org Setup Required Linked/ Striped
Entity
Table Name
Responsbiility
HZ_ROLE_RESPONSIBILITY
Site Contact Role
HZ_CUST_ACCOUNT_ROLES
Site
HZ_CUST_ACCT_SITES
Site Use
HZ_CUST_SITE_USES
Responsibility
FND_RESPONSIBILITY
Responsibility Exclusion
FND_RESP_FUNCTIONS
User Responsibility
FND_USER_RESP_GROUPS
Profile Value/OU Resp
FND_PROFILE_OPTION_VALUES
Setup Type
# per OU
(none)
0
Program
385,493
Oracle Screen
TCA Linked
124,683 Striped
Customers
194,627
FND 45 Linked
FNDLOAD
682
Responsibility
34,762
User
45
Profile Options
2
Document Sequence Assign Document Sequence Hold Authorisation OM System Parameters
OM Order Numbering
Hold Authorisation
FND_DOCUMENT_SEQUENCES FND_DOC_SEQUENCE_ASSIGNM ENTS OE_HOLD_AUTHORIZATIONS
OE System Parameters
OE_SYSTEM_PARAMETERS
Order Type Numbering
OE Transaction Types/Order OE Transaction Types/Line Line Type Flow
Linked
Manual
4 Linked
18+ Manual
OE_TRANSACTION_TYPES
1 4
Striped
11
OE_WORKFLOW_ASSIGNMENTS
16
OM Transaction Types
Linked
Manual (or program)
226
Striped
Manual
5,866*
Banks
RA_CUST_TRX_TYPES
10
Transaction Types
Batch Source
RA_BATCH_SOURCES
9
Batch Sources
Distribution Set
AR_DISTRIBUTION_SETS
5
Distribution Set Line
AR_DISTRIBUTION_SET_LINES
5
Receivables Activity
10
Receivables Activities
2
Receipt Classes
Receipt Source
AR_RECEIVABLES_TRX AR_RECEIPT_METHOD_ACCOUN TS AR_BATCH_SOURCES
4
Receipt Sources
Tax Code
AR_VAT_TAX
2
Tax Codes
Lockbox
AR_LOCKBOXES
3
Standard Memo Lines
AR_MEMO_LINES
Lockboxes Standard Memo Lines
Remit-To Address
HZ_CUST_ACCT_SITES
Warehouse Responsibility
ORG_ACCESS
Bank Account
AP_BANK_ACCOUNTS
Organization Access
AP AR AR Transaction Type
Receipt Method Account
HZ_PARTY_SITES HZ_LOCATIONS Remit-To Country
RA_REMIT_TOS
Striped Manual
1
Distribution Sets
1 1 No
1
Striped
Remit-To Addresses
15
Transactional Org-Striped Entities Entity
Table Name
Oracle Screen AR
Introduction
11
Adjustment
AR_ADJUSTMENTS
Payment Schedule
AR_PAYMENT_SCHEDULES
Invoice
RA_CUSTOMER_TRX
Invoice Line
RA_CUSTOMER_TRX_LINES
Distribution
RA_CUST_TRX_LINE_GL_DIST
Batch
RA_BATCHES
Receipt
AR_CASH_RECEIPTS
Receipt Application
AR_RECEIVABLE_APPLICATIONS
Receipt History
AR_CASH_RECEIPT_HISTORY
Order Header
OM OE_ORDER_HEADERS
Order Line
OE_ORDER_LINES
OM Hold
OE_ORDER_HOLDS
Transactions
Orders
Org Setup Not Required Entity
Table Name
Oracle Screen
Operating Unit
HR HR_ALL_ORGANIZATION_UNITS
Organizations
Account
TCA HZ_CUST_ACCOUNTS
Account Relation
HZ_CUST_ACCT_RELATE_ALL
Contact Point
HZ_CONTACT_POINTS
Location
HZ_LOCATIONS
Org Contact
HZ_ORG_CONTACTS
Party
HZ_PARTIES
Party Relation
HZ_RELATIONSHIPS
Party Site
HZ_PARTY_SITES
User
FND_USER
Customers
FND Users INV Item
MTL_SYSTEM_ITEMS_B
Items
Warehouse
MTL_PARAMETERS
Organisations
Hold
OE_HOLD_DEFINITIONS
OM Holds
AR Receipt Class
AR_RECEIPT_CLASSES
Term
RA_TERMS_B
Term Line
RA_TERMS_LINES
Delivery Detail
WSH WSH_DELIVERY_DETAILS
Delivery Assignment
WSH_DELIVERY_ASSIGNMENTS
Delivery
WSH_NEW_DELIVERIES
Receipt Classes Payment Terms
Shipping Transactions
WF Workflow
WF_ITEM_TYPES
(Workflow Builder)
Introduction
12
Related Documents
Multiorg
June 2020 2
Programming And Data Structure
June 2020 5
Data Structure And Alogorithm
November 2019 12
Data Structure
June 2020 17
Data Structure
November 2019 33More Documents from ""
Oracle Forms Generic Utp
May 2020 10
A Structured Approach To Sql Query Design
May 2020 9
