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 and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 29 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: 180)
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: 114)
Opportunities are always there, You are just supposed to explore them.
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Beginners Resources for Oracle e Business Suite R12 Learning Kashif Manzoor 0 1,214 02-04-2017, 10:07 PM
Last Post: Kashif Manzoor
  Oracle Financials Document for R12.0.4 mandar3036 0 2,614 11-19-2015, 10:55 PM
Last Post: mandar3036
  Overview of Oracle iProcurement (EBS R12) Mark Donald 1 4,162 09-03-2015, 06:06 PM
Last Post: Kashif Manzoor
  Oracle R12 i-Procurement step-by-step setup document admin 0 3,749 09-03-2015, 06:02 PM
Last Post: admin
  Oracle R12 Cycle Counting Chandak Badri 0 2,761 08-19-2015, 04:41 PM
Last Post: Chandak Badri
  Oracle R12- ABC Analysis Chandak Badri 0 2,282 08-17-2015, 06:02 PM
Last Post: Chandak Badri
  Oracle R12 Upgrade Impact Assessment admin 0 1,693 08-15-2015, 06:57 AM
Last Post: admin
  Oracle Financials - Data Flow From SLA to GL admin 1 34,084 08-13-2015, 04:53 PM
Last Post: Kashif Manzoor
  Oracle EBS R12 Financials Configurations Summary Presentation M Irfan 0 1,476 06-10-2015, 04:00 AM
Last Post: M Irfan
  Oracle EBS R12 Financials Configurations Summary M Irfan 0 1,009 06-10-2015, 03:53 AM
Last Post: M Irfan



Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!