opm_sla in opm
DESCRIPTION
OPM SLA SETUP REFERENCE DOCUMENTTRANSCRIPT
![Page 1: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/1.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
![Page 2: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/2.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
SLA in Process Manufacturing
Sathya Sundar / Saimani BalasubramanianOracle SSI
![Page 3: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/3.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Agenda
• SLA (Subledger accounting) - Overview and Structure• SLA – Key Concepts• Impact of SLA on OPM
• Convergence on SLA• MAC vs. SLA
• Oracle Process Manufacturing with SLA - The process
• Discrete vs. OPM - The SLA difference• Demo scenarios• Custom sources - An example• Q&A
![Page 4: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/4.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Agenda
• SLA (Subledger accounting) - Overview and Structure• SLA – Key Concepts• Impact of SLA on OPM
• Convergence on SLA• MAC vs. SLA
• Oracle Process Manufacturing with SLA - The process
• Discrete vs. OPM - The SLA difference• Demo scenarios• Custom sources - An example• Q&A
![Page 5: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/5.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
SLA - Overview
• Rule-based flexible accounting engine, toolset & repository supporting Oracle E-Business Suite modules
• Introduces a common data model and UI across subledgers, replaces various disparate 11i setups, providing single source of truth for financial and management analysis
• Retains the most granular level of detail in the subledger accounting model, with different summarization options in the General Ledger, allowing full auditability and reconciliation
![Page 6: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/6.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
• Subledger Architecture (SLA) replaces OPM Manufacturing Accounting Controller (MAC)• Financial Integration (FI) is obsolete since SLA takes care of data push to GL
SLA in OPM
![Page 7: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/7.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
The OPM-SLA Footprint
Cost Setup Calculate Cost Store Costs SLA Oracle GL
Oracle Inventory
Purchasing GMD, GMEOrder Management
![Page 8: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/8.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
A rule for a given event
Eg. Miscellaneous Receipt
Accounting Methods BuilderLedger (OPM US)
Subledger Accounting Method (Standard Accrual)
Application Accounting Definition (AAD for Process Manufacturing Financials)
Journal Line Types (JLT)
INV, IVA
Account Derivation Rules (ADR for INV
with Conditions)
Journal Entry Descriptions
Journal Line Definition (JLD for Miscellaneous Receipt)
Transaction Objects
Sources
Rules for all products
All rules for a product,
Eg. Process Mfg Financials
SLA- Structure
Event Classes and Event
Types
![Page 9: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/9.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Agenda
• SLA (Subledger accounting) - Overview and Structure• SLA – Key Concepts• Impact of SLA on OPM
• Convergence on SLA• MAC vs. SLA
• Oracle Process Manufacturing with SLA - The process
• Discrete vs. OPM - The SLA difference• Demo scenarios• Custom sources - An example• Q&A
![Page 10: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/10.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
SLA Event Model
Event Class
Event Type
Entity
![Page 11: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/11.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Sources
Displayed Name
Data Type
![Page 12: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/12.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Agenda
• SLA (Subledger accounting) - Overview and Structure• SLA – Key Concepts• Impact of SLA on OPM
• Convergence on SLA• MAC vs. SLA
• Oracle Process Manufacturing with SLA - The process
• Discrete vs. OPM - The SLA difference• Demo scenarios• Custom sources - An example• Q&A
![Page 13: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/13.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
• Concept of Subinventories and Locators• Valuation accounts originating from Subinventories• Create Immediate and Adjust Immediate replaced by Miscellaneous Issue and Receipt transaction• Adjustment account mandatory in all Miscellaneous Transactions• Move Immediate replaced by Subinventory Transfer
Convergence on SLA
![Page 14: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/14.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
• MAC - Acted as a subledger for all OPM transactions
• A single source of truth for accounting definitions in OPM
• Need for accounting units and accounts
• Need for Ledger Mappings
• Account derivation based on selection criteria
Manufacturing accounting
controller (MAC)• Unified repository of accounting
rules
• Process Manufacturing Financials is the Subledger for all OPM transactions
• No need for separate accounting units and accounts
• No need for Ledger mappings
• Account derivation based on flexible condition based rules
• Test Subledger update replaced by Create accounting-Draft
• Subledger Update replaced by Create accounting- Final mode
• Test Mapping replaced by Create accounting-Draft
Subledger Accounting (SLA)
MAC vs SLA
![Page 15: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/15.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
OPM example with MAC
Order Management
Shipping
Customer Returns(RMA)
Internal Order Shipments
Shipping
(OMSO)
SOURCE EVENT SUBEVENT
![Page 16: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/16.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
OPM example with SLA
Order Management
Shipping
Customer Returns(RMA)
Internal Order Shipments
Shipping
(OMSO)
EVENT ENTITY EVENT CLASSES EVENT TYPES
![Page 17: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/17.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Agenda
• SLA (Subledger accounting) - Overview and Structure• SLA – Key Concepts• Impact of SLA on OPM
• Convergence on SLA• MAC vs. SLA
• Oracle Process Manufacturing with SLA - The process
• Discrete vs. OPM - The SLA difference• Demo scenarios• Custom sources - An example• Q&A
![Page 18: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/18.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
OPM with SLA - The Process
Prelim Cost Update
Calculate Cost
Export to GL
OPM Accounting Preprocessor
Create Accounting (Draft Mode)
Final inventory close
Review Journal Entries
Final Cost Update
Incorrect journals?
Make changes
OPM Accounting Preprocessor
Create Accounting (Final Mode)
Yes
No
![Page 19: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/19.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Agenda
• SLA (Subledger accounting) - Overview and Structure• SLA – Key Concepts• Impact of SLA on OPM
• Convergence on SLA• MAC vs. SLA
• Oracle Process Manufacturing with SLA - The process
• Discrete vs. OPM - The SLA difference• Demo scenarios• Custom sources - An example• Q&A
![Page 20: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/20.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Discrete vs. OPM - The SLA difference
Discrete• All the seeded SLA entities
(SLAM,AAD,JLD,ADR) can be used
• SLA uses distributions created• Presence of ‘Transaction
Distribution GL account’ as rule ‘Source’
• Familiarity of entering accounting information for entities• WIP accounting class• Subinventory valuation
accounts
OPM• A custom SLA,AAD,JLD,ADR
is always needed• Seeded Source ‘Transaction
account not of use since Transaction account does not get derived
• All accounts need to be specified in the Custom ADR
![Page 21: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/21.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Agenda
• SLA (Subledger accounting) - Overview and Structure• SLA – Key Concepts• Impact of SLA on OPM
• Convergence on SLA• MAC vs. SLA
• Oracle Process Manufacturing with SLA - The process
• Discrete vs. OPM - The SLA difference• Demo scenarios• Custom sources - An example• Q&A
![Page 22: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/22.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Scenarios
• Category based accounting using SLA• Inventory Valuation accounts based on Subinventory
using SLA
![Page 23: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/23.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Attach the GL business class category to the Item
![Page 24: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/24.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Define a new custom ADR
• ADR created with owner ‘User’
• Output type can be an entire accounting flexfield or a specific segment in the accounting code combination
• Multiple conditions can be separated by ‘AND/OR’ logic
![Page 25: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/25.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Create a custom JLD
• JLD created with owner ‘User’
• JLDs are created for an Event class and Event type combination
• The journal line types are automatically displayed
• ADRs are associated to the JLTs
![Page 26: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/26.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Create a custom AAD
• AAD created with owner ‘User’
• Specific to a particular application
• Contains all event classes and event types
![Page 27: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/27.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Create a new SLAM (Subledger accounting method)
• SLAM created with owner ‘User’
• Specific to a ledger
• Contains AADs from all applications
![Page 28: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/28.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Perform a Miscellaneous Transaction
![Page 29: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/29.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Run OPM accounting preprocessor
![Page 30: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/30.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Run Create Accounting
![Page 31: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/31.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Output of create accounting- INV and IVA accounts derived from Category based rules
![Page 32: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/32.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Drill down Subledger entries
![Page 33: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/33.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Drill down to Draft sub ledger entries and T accounts
![Page 34: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/34.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Scenarios
• Category based accounting using SLA• Inventory Valuation accounts using Subinventory
using SLA
![Page 35: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/35.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Inventory valuation accounts using Subinventory
![Page 36: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/36.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Inventory valuation accounts using Subinventory
![Page 37: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/37.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Agenda
• SLA (Subledger accounting) - Overview and Structure• SLA – Key Concepts• Impact of SLA on OPM
• Convergence on SLA• MAC vs. SLA
• Oracle Process Manufacturing with SLA - The process
• Discrete vs. OPM - The SLA difference• Demo scenarios• Custom sources - An example• Q&A
![Page 38: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/38.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Custom Sources
• Extend the list of sources available to application accounting definitions
•Used to derive accounts based on non-standard sources
• PL/SQL function used to derive the source
• Return value can be a string, an accounting flexfield or a value set
![Page 39: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/39.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Create ADR (Account derivation rule)
![Page 40: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/40.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Create JLD(Journal lines definition)
![Page 41: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/41.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Create New AAD (Application accounting definition)
![Page 42: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/42.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Create a new SLAM (Subledger accounting method)
![Page 43: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/43.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Verify results
![Page 44: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/44.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
Business Enquiries
• For more information on SLA in OPM, consulting requests, sales and presales assistance
![Page 45: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/45.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.
AQ&Q U E S T I O N S
A N S W E R S
Q and A
![Page 46: OPM_SLA in OPM](https://reader035.vdocuments.us/reader035/viewer/2022081419/55cf9ade550346d033a3ccc6/html5/thumbnails/46.jpg)
Oracle InternalOracle SSI – Consulting. Beyond Boundaries.