Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 58 Vote(s) - 3.22 Average
  • 1
  • 2
  • 3
  • 4
  • 5
:: Steps to Produce SLA for Payroll in R12 ::
03-30-2013, 08:20 PM,
#1
:: Steps to Produce SLA for Payroll in R12 ::
Issue: Unable to drill down payroll transactions from GL to Payroll module

Solution:

Items:-
(1) Formula:
AMB = JLD (= JLT + ADR + JED) + AAD + SLAM + Mapping Sets

Notes:
AMB = Accounting Methods Builder
AAD = Assign JLD to each event classes
SLAM = Sub-Ledger Accounting Method
JLD = Journal Line Definition; Assign ADR to each JLT
JLT = Journal Line Type; Creation of Debit and Credit information for each Event
Classes
ADR = Accounting Definition Rules; To establish rule for CCID @ transaction level
JED = Journal Entry Description; Define Journal Header/Line Description

(2) Events Classes:
o Payroll Cost
o Payment Cost
o Estimated Cost
o Reversal Estimated Cost

a) JLD (Journal Line Definition):
Step # 1: Create JLT for each of the above Event Classes i.e Debit and
Credit Side
Step # 2: Create ADR for Dr/Cr of each Event Classes (Choose
Assignment Payroll Name in Source)
Step # 3: Assign ADR to each JLT in JLD

b) AAD (Application Accounting Definition):
Step # 4: Assign JLD to Event Classes

c) SLAM (Sub-Ledger Accounting Method):
Step # 5: Create SLAM and assign AAD to this SLAM

d) General Ledger:
Step # 6: Create Ledger from Accounting Setups in ASM (Accounting
Setup Manager) and assign to SLAM

Processes to run Payroll SLA:

Step # 1: Payroll Run
Step # 2 : Prepayment
Step # 3: Costing
Step # 4: Transfer to SLA from HRMS Responsibility
Step # 5: Run Create Accounting program from Global/Payroll Responsibility
Step # 6: Review or Post Payroll Batch in GL


Attached Files
.pdf   Steps to Produce SLA for Payroll in R12.pdf (Size: 291.45 KB / Downloads: 186)
Reply
09-21-2013, 10:21 PM,
#2
RE: :: Steps to Produce SLA for Payroll in R12 ::
Nice Job.
Reply
04-13-2014, 10:14 PM,
#3
RE: :: Steps to Produce SLA for Payroll in R12 ::
(03-30-2013, 08:20 PM)Ehsan.Jawaid01 Wrote: There is one more document on same topic that I got from Metalink.


Issue: Unable to drill down payroll transactions from GL to Payroll module

Solution:

Items:-
(1) Formula:
AMB = JLD (= JLT + ADR + JED) + AAD + SLAM + Mapping Sets

Notes:
AMB = Accounting Methods Builder
AAD = Assign JLD to each event classes
SLAM = Sub-Ledger Accounting Method
JLD = Journal Line Definition; Assign ADR to each JLT
JLT = Journal Line Type; Creation of Debit and Credit information for each Event
Classes
ADR = Accounting Definition Rules; To establish rule for CCID @ transaction level
JED = Journal Entry Description; Define Journal Header/Line Description

(2) Events Classes:
o Payroll Cost
o Payment Cost
o Estimated Cost
o Reversal Estimated Cost

a) JLD (Journal Line Definition):
Step # 1: Create JLT for each of the above Event Classes i.e Debit and
Credit Side
Step # 2: Create ADR for Dr/Cr of each Event Classes (Choose
Assignment Payroll Name in Source)
Step # 3: Assign ADR to each JLT in JLD

b) AAD (Application Accounting Definition):
Step # 4: Assign JLD to Event Classes

c) SLAM (Sub-Ledger Accounting Method):
Step # 5: Create SLAM and assign AAD to this SLAM

d) General Ledger:
Step # 6: Create Ledger from Accounting Setups in ASM (Accounting
Setup Manager) and assign to SLAM

Processes to run Payroll SLA:

Step # 1: Payroll Run
Step # 2 : Prepayment
Step # 3: Costing
Step # 4: Transfer to SLA from HRMS Responsibility
Step # 5: Run Create Accounting program from Global/Payroll Responsibility
Step # 6: Review or Post Payroll Batch in GL


Attached Files
.pdf   Payroll_SLA_White_Paper.pdf (Size: 1.17 MB / Downloads: 116)
Opportunities are always there, You are just supposed to explore them.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Oracle EBS R12 Financials Configurations Summary Presentation M Irfan 1 15,120 01-02-2023, 06:50 AM
Last Post: leo.chen
  Oracle R12 i-Procurement step-by-step setup document admin 3 40,855 04-05-2022, 10:48 PM
Last Post: Kashif Manzoor
  Oracle Financials - Data Flow From SLA to GL admin 9 97,041 11-17-2021, 05:53 AM
Last Post: kmorad
  Functionality/Features difference between R12 and 11i admin 7 44,120 12-02-2019, 11:38 PM
Last Post: kau2802
  Beginners Resources for Oracle e Business Suite R12 Learning Kashif Manzoor 2 20,260 07-18-2017, 09:26 PM
Last Post: admin
  Oracle Financials Document for R12.0.4 mandar3036 0 9,122 11-19-2015, 11:55 PM
Last Post: mandar3036
  Overview of Oracle iProcurement (EBS R12) Mark Donald 1 11,191 09-03-2015, 07:06 PM
Last Post: Kashif Manzoor
  Oracle R12 Cycle Counting Chandak Badri 0 10,750 08-19-2015, 05:41 PM
Last Post: Chandak Badri
  Oracle R12- ABC Analysis Chandak Badri 0 8,384 08-17-2015, 07:02 PM
Last Post: Chandak Badri
  Oracle R12 Upgrade Impact Assessment admin 0 5,646 08-15-2015, 07:57 AM
Last Post: admin



Users browsing this thread: 1 Guest(s)