Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, 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, Simple and Absolutely Free.

Thread Rating:
  • 27 Vote(s) - 3.07 Average
  • 1
  • 2
  • 3
  • 4
  • 5
:: Steps to Produce SLA for Payroll in R12 ::
#1
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: 173)
Reply
Thanks given by:
#2
Nice Job.
Reply
Thanks given by:
#3
(03-30-2013, 07: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: 109)
Opportunities are always there, You are just supposed to explore them.
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
Rainbow Steps to Configure a Virtual Machine for Apps Installation fanni339 1 2,059 09-03-2014, 10:18 PM
Last Post: Engkhaled60



Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!