EBS R12 Period Close Advisor: Purchasing

EBS R12 Period Close Advisor: Purchasing [ID 1359462.1]

 

NOTE:1358356.1 - Recommended Patches for Purchase Order and Requisition Processing

NOTE:335.1 - Period Close Advisor: E-Business Suite (EBS)

NOTE:1107953.1 - R12 Accrual Balance Mismatch Between Accrual Reconciliation Report and GL - Troubleshooting

NOTE:1113712.1 - R12 FAQ: Accrual Accounting - On Line Accruals and Period End Accruals

NOTE:1117353.1 - R12: Discrepancies with Accrual Reconciliation Report - Troubleshooting

NOTE:1279848.1 - R12: Discrepancies With Period End Accruals - Troubleshooting

NOTE:429105.1 - Impact of R12 Design in Procure To Pay Accounting Flow

NOTE:467584.1 - R11 What Are The Basic Steps Of The Purchasing Receipt Accrual Period-End Process?

NOTE:555547.1 - How To Change The Seeded Default Journal Category from "Receiving" to" Accrual"?

NOTE:558421.1 - How To Diagnose Issues With Create Accounting Process For Procure To Pay Cycle In R12

NOTE:563100.1 - Brief Overview of Receipt Accounting

NOTE:67108.1 - Procurement (Purchasing) Product Documentation

NOTE:732172.1 - R12.0.6+ : Purchasing Purchasing Setup Test

NOTE:873399.1 - R12 Receipt Accrual Period end process - Duplicate accrual reversal entries created

NOTE:961285.1 - R12: Period-End Procedures for Oracle Financials E-Business Suite

EBS R12 Period Close Advisor: Receivables

EBS R12 Period Close Advisor: Receivables  [ID 1359460.1]

NOTE:734495.1 - How to add 'Transfer Journal Entries to General Ledger' Concurrent Program to Receivables Reports Group?

NOTE:737453.1 - Receipts Report: Receipt Register Report Known Issues And Patches

NOTE:1233033.1 - Incomplete Transactions in Subledger Period Close Exception Report (XLAPEXRPT) are Preventing You From Closing AR Period

NOTE:1318577.1 - R12: Comprehensive Listing of Errors and Solutions for Payables Payment Reports

NOTE:1320546.1 - Information Center: Overview of the Transactions Workbench in Oracle Receivables (AR) 11.5 and later

NOTE:1326337.1 - Third Party Balances Report Issue: Report Is Not Picking Up All Transactions

NOTE:1358497.1 - Oracle Receivables Lockbox: Known Issues and Patches

NOTE:1362278.1 - Information Center: Overview of the Receipts Workbench in Oracle Receivables (AR) 11.5 and later

NOTE:1370198.1 - Information Center: Month End Processing in Oracle Receivables (AR)

NOTE:793257.1 - R12: Which Transactions Are Printed On the Unposted Items Report

NOTE:951527.1 - XLATPRPT - Third Party Balances Report Retrieves No Data For Receivables

NOTE:1433375.1 - Information Center: R12 Critical, Rollup and Recommended Patches for Oracle Receivables (AR)

NOTE:335.1 - Period Close Advisor: E-Business Suite (EBS)

NOTE:732188.1 - R12.0.6+ : Oracle Receivables Adjustment Data Setup Test

NOTE:1137414.1 - Information Center: Overview of AutoInvoice in Oracle Receivables (AR) 11.5 and later

NOTE:1150295.1 - R12: Third Party Balances Report Is Missing Some Items Even The Setup Has Been Done For Control Accounts

NOTE:1177045.1 - Why Transaction Register Report Does Not Reflect Amount For Revenue Account.

NOTE:749679.1 - AR: What Are The Recommended Patches For AR-GL Posting, Reconciliation and Data Integrity Issues.

NOTE:732193.1 - R12.0.6+ : Oracle Receivables General Setup Test

NOTE:793598.1 - R12: How to Use the Subledger Period Close Exceptions Report for Period Close Activity?

NOTE:1075485.1 - Oracle Receivables Lockbox: Frequently Asked Questions (FAQ)

NOTE:954704.1 - EBS: R12.1 Oracle Financials Recommended Patch Collection (RPC)

NOTE:732201.1 - R12.0.6+ : Oracle Receivables Receipt Data Setup Test

NOTE:732203.1 - R12.0.6+ : Oracle Receivables Transaction Data Setup Test

SQL Query to Link GL Journal and SLA Tables for 'Misc Receipts','Receipts' and 'Reconciled Payments'

SELECT  ada.line_id, jh.je_category Category,

  jh.period_name Period_Name,

  NULL Invoice_No_or_Memo_No,

  nvl(jl.entered_dr,0)-nvl(jl.entered_cr,0) Amount_journal,

  NVL(xal.entered_dr,0)-NVL(xal.entered_cr,0) Amount_Xla,

  NVL(ada.amount_dr,0)-NVL(ada.amount_cr,0) Amount_Receivables,

  DECODE(jh.ledger_id,2027,'USD',2029,'EUR',2023,'USD') Currency_Code,

   xdl.source_distribution_type,

  jh.ledger_id Book

FROM gl_je_headers jh,

  gl_je_lines jl,

  gl_code_combinations gcc,

  gl_import_references gir,

  xla_ae_lines xal,

  XLA_DISTRIBUTION_LINKS xdl,

  xla_ae_headers xah,

  AR_DISTRIBUTIONS_ALL ada

WHERE 1                    =1

AND jh.je_header_id        =jl.je_header_id

AND jl.code_combination_id =gcc.code_combination_id

AND gir.je_header_id       =jh.je_header_id

AND gir.je_line_num        =jl.je_line_num

AND gir.gl_sl_link_id      =xal.gl_sl_link_id

and xah.ae_header_id=xal.ae_header_id

and xal.application_id = xdl.application_id

and xah.ae_header_id = xdl.ae_header_id

and xal.ae_line_num = xdl.ae_line_num

and xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

and xdl.source_distribution_id_num_1 = ada.line_id

AND gcc.code_combination_id=46032

and jh.period_name like '13-Jun'

and jh.je_category in ('Misc Receipts','Receipts')

and abs(nvl(jl.entered_dr,0)-nvl(jl.entered_cr,0))<> abs(NVL(ada.amount_dr,0)-NVL(ada.amount_cr,0))

and abs(NVL(xal.entered_dr,0)-NVL(xal.entered_cr,0)) <> abs(NVL(ada.amount_dr,0)-NVL(ada.amount_cr,0))

and jh.ledger_id = '2029';

SELECT  jh.name,jh.je_category Category,

  jh.period_name Period_Name,

  NULL Invoice_No_or_Memo_No,

  abs(nvl(jl.entered_dr,0)-nvl(jl.entered_cr,0)) Amount_journal,

  abs (NVL(xal.accounted_dr,0)-NVL(xal.accounted_cr,0)) Amount_Xla,

  abs(sum(aphd.amount)) amount_payment,

    DECODE(jh.ledger_id,2027,'USD',2029,'EUR',2023,'USD') Currency_Code,

   xdl.source_distribution_type,

  jh.ledger_id Book

FROM gl_je_headers jh,

  gl_je_lines jl,

  gl_code_combinations gcc,

  gl_import_references gir,

  xla_ae_lines xal,

  XLA_DISTRIBUTION_LINKS xdl,

  xla_ae_headers xah,

  AP_PAYMENT_HIST_DISTS aphd

WHERE 1                    =1

AND jh.je_header_id        =jl.je_header_id

AND jl.code_combination_id =gcc.code_combination_id

AND gir.je_header_id       =jh.je_header_id

AND gir.je_line_num        =jl.je_line_num

AND gir.gl_sl_link_id      =xal.gl_sl_link_id

and xah.ae_header_id=xal.ae_header_id

and xal.application_id = xdl.application_id

and xah.ae_header_id = xdl.ae_header_id

and xal.ae_line_num = xdl.ae_line_num

AND gcc.code_combination_id=46032

and xdl.source_distribution_type = 'AP_PMT_DIST'

and xdl.source_distribution_id_num_1 = aphd.payment_hist_dist_id

and jh.je_category in ('Reconciled Payments')

and jh.ledger_id ='2029'

and jh.period_name like '13-Jun'

--and abs (nvl(jl.entered_dr,0)-nvl(jl.entered_cr,0))  <> abs(sum(aphd.amount) )

--and NVL(xal.accounted_dr,0)-NVL(xal.accounted_cr,0) <> abs(sum(aphd.amount)),

 group by  jh.name,jh.je_category,

  jh.period_name,

   nvl(jl.entered_dr,0)-nvl(jl.entered_cr,0),

  NVL(xal.accounted_dr,0)-NVL(xal.accounted_cr,0),

     DECODE(jh.ledger_id,2027,'USD',2029,'EUR',2023,'USD'),

   xdl.source_distribution_type,

  jh.ledger_id

  having --abs (nvl(jl.entered_dr,0)-nvl(jl.entered_cr,0))  <> abs(sum(aphd.amount) );

abs( NVL(xal.accounted_dr,0)-NVL(xal.accounted_cr,0)) <> abs(sum(aphd.amount));

Updating an Appraisal Template

Updating an Appraisal Template

This topic discusses information related to updating appraisal templates.

After publishing a performance-management plan, can I make changes to the appraisal template, for example, add or change the Objectives and Competencies Templates?

You can update an appraisal template included in a performance-management plan, provided that the appraisal cycle has not started in your enterprise. You can modify the appraisal template and republish the performance management plan for the changes to take effect. If your plan includes appraisals, ensure you run the Mass Appraisal Creation concurrent process so that the latest appraisal template is available

When can I delete or update an appraisal template?

It is advisable to update or delete an appraisal template ideally before the appraisal cycle begins in your enterprise. If you make any changes to the template after even one appraisal is created, the evaluation process that your enterprise follows will be impacted. For example, you use an appraisal template 'Annual Appraisal Template-2010' to assess the competency and objective ratings of workers. Later, you change the Competency template in the appraisal template: Annual Appraisal Template-2010'. You will find that the competencies in the completed appraisals of workers who used the appraisal template 'Annual Appraisal Template-2010' , are impacted.

I have created an appraisal template and the template is associated with the appraisal process. Can I delete the appraisal template?

You cannot delete an appraisal template that is associated with the appraisal process. The Delete button appears as read-only.

Can I update an appraisal template that is associated with an appraisal process?

You can update an appraisal template that is associated with an appraisal process. However, certain restrictions apply to the changes that you can make to the template. If an appraisal template is used to create at least one appraisal and then if you change either appraisee or main appraiser questionnaire template, then all the appraisals that are created become incomplete. The questionnaires section will be missing in the appraisals. So, you cannot change the questionnaire template after appraisal template is used to create an appraisal. It is advisable to update an appraisal template ideally before the appraisal cycle begins in your enterprise. If you make any changes to the template after even one appraisal is created, the appraisal process that your enterprise follows may be impacted.