Review EBS product's new releases & features, troubleshooting tips & tricks, best practices, upcoming webcasts
Recent Posts
HR and Benefits
R12.1 HRMS RUP13 and R12.2 HRMS RUP14 Patches Have Been Released for HCM Clients
Announcing the release of 12.1.x version - R12.1 HRMS RUP13 and 12.2.x version - R12.2 HRMS RUP14 Patches.
Announcing the release of 12.1.x version - R12.1 HRMS RUP13 and 12.2.x version - R12.2 HRMS RUP14 Patches.
Receivables
Introducing the NEW EBS Loans Analyzer
A new analyzer has just been released and included in the latest E-Business Suite (EBS) tools! The NEW EBS Loans Analyzer (Doc ID 2652176.1) includes the following information: Loan Data Loan Accounting Loan Setup Setup and Environment The EBS Oracle Loans Analyzer scans your Loans footprint, configuration, environment, and transactional data. For areas of concern, the output will provide recommendations to prevent future issues and point to existing solutions for uncovered problems. Most existing solutions can be implemented without logging a Service Request. Review your instance specific output from the analyzer now! Simply run the analyzer as a SQL script or as a concurrent request. Like all EBS Analyzers, the EBS Loans Analyzer is available via its own MOS document, Doc ID 2652176.1, the EBS Analyzer Index, Doc ID 1545562.1, and will be available in the June 2020 Analyzer Bundle Menu Tool, Doc ID 1939637.1. Please visit My Oracle Community thread or the analyzer feedback, with any comments or suggestions to be incorporated into the EBS Oracle Loans Analyzer. We look forward to continual update and improvement of this analyzer based on your feedback.
A new analyzer has just been released and included in the latest E-Business Suite (EBS) tools! The NEW EBS Loans Analyzer (Doc ID 2652176.1) includes the following information: Loan Data Loan Accounting Lo...
HR and Benefits
Phase IV Patches for the 2019 Employer Shared Responsibility Reporting Under the Affordable Care Act
Announcement: 2019 Employer Shared Responsibility Reporting Under the Affordable Care Act - Phase IV Patch has been Released
Announcement: 2019 Employer Shared Responsibility Reporting Under the Affordable Care Act - Phase IV Patch has been Released
General Ledger
Why Standard Reconciliation Reports Do Not Balance To The General Ledger When Using Multi-Fund Accounting
If you are using Multi-Fund Accounting and trying to balance the Receivable Module with the General Ledger, your reports may not balance as expected. Definitely check if the mandatory profile Option "AR: ACTIVATE MULTI FUND ACCOUNTING EXTRACT" is set. See this document for more information on the profile option. (Doc ID 1503451.1) One of the issues that can occur: The standard Reports such as AR Reconciliation Report and the associated Registers and Journals (example: Transaction Register, Transaction Journal) and Aging - 7 Buckets by Account Report are not balancing with the amounts that are existing in the General Ledger. Review: Process to follow for Fund Level Reconciliation between AR and GL in R12 (Doc ID 2030905.1) The Multi-Fund Accounts Receivable (MFAR) Aging Report Does Not Balance To AR Reconciliation Report (Doc ID 1558026.1) Another issue that can occur: The Journal Entries Report is not displaying information in the actual Subledger (SLA) journals Review: AR: JOURNAL ENTRIES REPORT SHOW AR ACCOUNTS AND INSTEAD OF SLA ACCOUNTS (Doc ID 2547495.1)
If you are using Multi-Fund Accounting and trying to balance the Receivable Module with the General Ledger, your reports may not balance as expected. Definitely check if the mandatory profile Option...
Receivables
Do You Need to Have Certain Attributes Mandatory When Applying a Receipt Refund?
Are you unable to have 'Party Bank Account' Attribute set as a mandatory field when creating a Receipt Refund? When entering a receipt Responsibility: Receivables Navigation: Receipts > Receipt The Refund Attributes that are mandatory are usually the Customer Name, Customer Number, Refund Payment Method and Customer Address, but Party Bank Account does not. You need to have: a) Refund Attribute 'Party Bank Account' Attribute Mandatory and b) to have these Refund Attributes only applicable to Type: Refunds How the Refund application currently behaves: To have the Party Bank Account Attributed display as mandatory, review: Need To Have 'Party Bank Account' Attribute Only Applicable To Refunds (Doc ID 2672308.1) How the form will respond after following the steps in Doc ID 2672308.1:
Are you unable to have 'Party Bank Account' Attribute set as a mandatory field when creating a Receipt Refund? When entering a receipt Responsibility: ReceivablesNavigation: Receipts > Receipt The...
Payroll
Announcement: Release 12.1 & 12.2 Patches for the New South African SARS Codes Introduced by BRS V19.0 - 19.3
Customer communication for Patch that delivers the new South African SARS codes introduced by BRS V19.0 TO 19.3
Customer communication for Patch that delivers the new South African SARS codes introduced by BRS V19.0 TO 19.3
Receivables
Just Released: The EBS Receivables Transaction Features Setup Analyzer
Introducing the EBS Transaction Features Setup Analyzer For those of you that use Balance Forward Billing (BFB), e-Commerce Gateway (EDI) or Late Charges in Oracle Receivables we have delivered an analyzer that will make working in these functional areas easier. This new analyzer will replace all diagnostic / data collection scripts for Balance Forward Billing, e-Commerce Gateway as it pertains to the 810 Invoice Outbound and 812 Credit Memo Outbound as well as Late Charges. The EBS Transaction Features Setup Analyzer includes: Balance Forward Billing (BFB) e-Commerce Gateway (EDI) Late Charges Recommended actions and best practices View our three different sample outputs (BFB, EDI and Late Charges) in EBS Receivables Transaction Features Setup Analyzer 2652087.1 Like all of our EBS Analyzers the EBS Transaction Features Setup Analyzer is available on MOS DocID 2652087.1, the EBS Analyzer Index, DocID 1545562.1, and will be available in the May 2020 Analyzer Bundle Menu Tool, DocID 193937.1. Don't forget to provide your Feedback on the Analyzer via DocID 2652087.1 or directly in the Analyzer - EBS (MOSC) community thread. Looking forward to your feedback.
Introducing the EBS Transaction Features Setup Analyzer For those of you that use Balance Forward Billing (BFB), e-Commerce Gateway (EDI) or Late Charges in Oracle Receivables we have delivered an...
Oracle EBS News
Count on Oracle Applications Unlimited—Now Available Through at Least 2031
Oracle’s Commitment for Applications Unlimited—Extended through at Least 2031 We listen carefully when our customers share their business needs and we recognize that your Oracle on-premise applications are critical to your success. We are committed to helping you succeed. Applications and Support—an Unbeatable Combination To demonstrate our ongoing commitment to your business, we are announcing an extension through at least 2031 for our Oracle Applications Unlimited Products: Oracle E-Business Suite, JD Edwards EnterpriseOne, PeopleSoft, and Siebel CRM. Doing so provides you with more than a decade of ongoing product development, new features, and innovations on the Continuous Innovation releases and continued Oracle Premier Support. Hyperion Joins the Applications Unlimited Products In addition to this extension, we are also announcing the newest product to join Applications Unlimited—Hyperion. This means Hyperion will also be available on premise through at least 2031 on its Continuous Innovation release and receive ongoing new features and Oracle Premier Support. As an Oracle Applications Unlimited customer, we are here to help support your company’s plans. Your long-term business strategy guides your company to success—underpinning that success are the Oracle products and trusted support you depend on to run your business. Applications Unlimited Resources Oracle Applications Unlimited Oracle Applications Unlimited and Oracle Premier Support (PDF) Lifetime Support for your Oracle Applications Unlimited Products Oracle Premier Support Oracle E-Business Suite (PDF) Hyperion JD Edwards EnterpriseOne PeopleSoft Siebel CRM
Oracle’s Commitment for Applications Unlimited—Extended through at Least 2031 We listen carefully when our customers share their business needs and we recognize that your Oracle on-premise...
Property Manager
Lease Options – An Overview
Prior to IFRS enhancement in property manager, though we did have an option to capture the options that a tenant or landlord can exercise during the lease life, it did not have any impact on any of the calculations. However post IFRS enhancement, the options tab has been enhanced and users can capture the options, which are certain to be exercised from a tenant’s perspective during Termination, Purchase, Renewal or Residual options etc and the same will be included in the ROU / Liability calculations. Like normal payment terms even for options we can enable compliance related check boxes like ROU / Liability/ report from Inception / Inter Company check boxes can be checked even at options level. As options has a financial impact going forward, we need to keep in mind that Options can be added only via Amendment going forward Options can also be extended / terminated via amendment and system will recalculate the ROU / Liability balances due to Options Amendment / termination. All calculations during amendment of Options like ROU,Liability, etc including lease expense will start from Amendment start date Schedule and items program will not be triggered when only an option is added / amended. But if a schedule and items program is triggered as a part of Payment term amendment for a lease which has options, the program output has been enhanced to capture the options details as well Options will also be part of period end accrual balances and Interest Expense and amortization expense will be derived for Liability and ROU considering option amounts. Amortizations and interest expense for options are calculated till option termination date. The amortizations/interest are not restricted to the lease termination date. For more information on this enhanced option functionality, refer document 2432815.1
Prior to IFRS enhancement in property manager, though we did have an option to capture the options that a tenant or landlord can exercise during the lease life, it did not have any impact on any of...
Fixed Assets
How To Improve Create Accounting - Assets Performance
In Oracle fixed assets, depreciation and create accounting programs are two programs which touches each and every asset and often leads to performance issues. However there are many tips / setups which can help us to improve the create accounting performance. Following are few suggestions which might help to reduce the overall run time for Create Accounting process : 1. Make sure below profiles are already set FA: Batch size : 10000 FA: Number of Parallel Requests : 10 2. Ensure you run 'Gather Statistics' for the FA, XLA & XDO Schema on a regular basis. 3. Ensure debug profiles like 'FA: Print Debug' / 'FND: Debug Log Enabled' are NOT set to 'Yes'. 4. Make use of 'Process Category' parameter to restrict the number of events getting processed in each run. 5. Performance can be improved by using parallel work that will increase the performance as work is split on a worker for each available processor. To do that: A) Set the 'No of Processors' in the Update System Options to a higher number; This can be set up to number of processor minus one. To achieve this: Navigate to: GL responsibility > Accounting Setup Manager Query for your ledger and click on update subledger accounting options. For your application, click on Update System Options. Here, you can enable parallel option, that will spawn multiple child programs. B) Make sure concurrent manager has appropriate settings to launch that many concurrent manager requests in parallel. C) Also, you can change the 'unit size' and 'number of events' of that event class to be picked by one processor at a time. Along with the above steps, create accounting can be run only for one 'Process Category' at a time. Say there are 3 different 'Process Category': EC1 = 100000 events EC2 = 500000 events EC3 = 300000 events In this case, it can be set like: number of units = 5 and number of events per class = 10000 Then create accounting should be run separately for EC1 and EC2 and EC3. This way, it will launch 3 separate Create Accounting sessions and each create accounting will launch 5 Create Accounting programs. 6. Run Create Accounting process with Report option set to 'No Report'. Refer to: Doc ID 1967177.1 - How To Improve Create Accounting - Assets Performance
In Oracle fixed assets, depreciation and create accounting programs are two programs which touches each and every asset and often leads to performance issues. However there are many tips / setups...
Oracle Financials for India (India Localizations)
Just Released: EBS GST Period Close Analyzer
What We Are Announcing: EBS GST (Goods and Services Tax) Team is excited to announce the inital release of the GST Period Close Analyzer. The GST Period Close Analyzer is another example of a tool that EBS Support offers to assist with functionality across EBS Products. Our goal in developing this analyzer is to provide a one-stop ship to help you will all GST Period Close issues in Order to Cash, Payables, Inventory, Purchasing and more. Get the analyzer from the following note in My Oracle Support (MOS): Doc ID 2611916.1 EBS GST Period CLose Analyzer Overview: Often times users are stuck with some unprocessed transactions (e.g. unaccounted tax liability or recovery entries etc...) which might affect the period closure process for any Business. In order to facilitate and help the users in a smooth period closure from EBS-GST standpoint, a new tool has been released by Oracle Support. Benefits: The tool can be used extensively by any EBS GST users to reconcile any stuck tax records or any potential data corruption cases which might impact any month/year end period close activities. This can be run on regular basis or can be scheduled periodically per business needs. Sample Output:
What We Are Announcing: EBS GST (Goods and Services Tax) Team is excited to announce the inital release of the GST Period Close Analyzer. The GST Period Close Analyzer is another example of a tool...
Inventory
The New Idea Implemented – Public API for Item Transaction Defaults – Now Available on 12.2!
A new public API (INV_CREATE_ITM_SUBLOC_DEF_PUB) is now available that inserts the item transaction defaults for subinventory (MTL_ITEM_SUB_DEFAULTS) as well as locator (MTL_ITEM_LOC_DEFAULTS).
A new public API (INV_CREATE_ITM_SUBLOC_DEF_PUB) is now available that inserts the item transaction defaults for subinventory (MTL_ITEM_SUB_DEFAULTS) as well as locator (MTL_ITEM_LOC_DEFAULTS).
Inventory
Logistics Webcasts - Free Training from Oracle Support - for Real!
With Contributing Author : Vishnu Vemulapalli Are you taking advantage of free learning opportunities provided by Oracle support? The best things in life are free. Same way, we are delivering Oracle Advisor Webcasts with some of the best topics that help your day-to-day practical usage of Oracle E-business Suite. Oracle Support has a robust webcast program that delivers tens of webcasts every year for different products. In Logistics space, we carefully select the topics to address the most frequent critical issues faced by our customers and also focus on new features/functionalities. In March 2020, we are presenting below webcast on new features New Features in Inventory - 12.2.9 - Webcast on March 18th, 2020. In this webcast, we will cover new enhancements included in release 12.2.9 related to back-ordering material and moving back to source location automatically, canceling unshipped lines and cycle count approval using new AME integration. We will also show a quick demo covering the features, some troubleshooting tips, and references to help you familiarize yourself with these new features. See below community post for registration details https://community.oracle.com/thread/4316176 In February, we have presented Inventory/Receiving performance issues. In this webcast, we have covered common performance concerns, most common techniques to troubleshoot, and a demonstration. This demonstration focusses on creating a trace and reviewing results to diagnose the performance issue. We also reviewed known issues and suggestions for improving performance in your system. You can see the recording of this webcast in the below document ADVISOR WEBCAST RECORDING: Inventory/Receiving Performance Issues - Webcast Held On February 19th 2020 (Doc ID 2629104.1) We hope that you are interested in joining us for this free training. Please check the following document for all logistics webcasts schedule & past webcast recordings E-Business Suite Manufacturing Advisor Webcast Recordings and Archived Recordings (Doc ID 1455888.1) You can also see all E-Business Suite webcast related information here Advisor Webcasts: Current Schedule and Archived Recordings (Doc ID 740966.1)
With Contributing Author : Vishnu Vemulapalli Are you taking advantage of free learning opportunities provided by Oracle support? The best things in life are free. Same way, we are delivering Oracle...
Payroll
Released! 12.1 and 12.2 Patches for the ZA Pay Budget Speech Amendments - 2020/2021
12.1 and 12.2 patches for the ZA Pay Budget Speech Amendments have been released and available on My Oracle Support.
12.1 and 12.2 patches for the ZA Pay Budget Speech Amendments have been released and available on My Oracle Support.
General Ledger
New Whitepaper Released: Revaluation in EBS General Ledger
International and local Accounting Regulations require companies to keep an updated record for the value of all open balances represented in foreign currency. Transactions to be settled in foreign currencies are subject to risks referring to potential changes in the exchange rates. For this purpose in General Ledger users run Revaluation process which maintains up-to-date equivalent for the balances in functional currency. This new Whitepaper includes information about the process in Release 12, including the following: Business considerations Process and Flow Definitions, prerequisites, formulas used Impact over other features available Reports Technical details Known issues Download this one today from: REVALUATION in EBS General Ledger R12 - Whitepaper (Doc ID 2641526.1) We invite you to share your feedback and suggestions with us through the mentioned document.
International and local Accounting Regulations require companies to keep an updated record for the value of all open balances represented in foreign currency. Transactions to be settled in foreign...
Oracle EBS News
Action Required: Upgrade Your Analyzers to the Latest Version
All EBS Analyzers have been upgraded to ensure that the latest enhancements and improvements have been incorporated. The versions of Analyzers uploaded to the service request (SR) will be validated to ensure that you are using the minimum version essential to obtaining these improvements. If you upload a lower version for review, you will see a message in the service request asking you to provide a higher version than what was provided. The latest Analyzer version can be downloaded from the Doc ID mentioned in your service request, or in the Analyzer Report, by clicking on the 'Latest Version' flag. Review the documents listed below to see the current inventory of EBS Analyzers using the Analyzer Index and to learn how to install Analyzers via the Analyzer Bundle: Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Doc ID 1545562.1) E-Business suite Support Analyzer Bundle Menu Tool (Doc ID 1939637.1) New for System Administrators: Schedule the Analyzer Bundle AutoUpdate Concurrent Program to automatically update the Bundle every month. Set it and forget it. Bulk load some or all the Bundle Families of Analyzers, automatically includes new and updated Analyzers each month. Check out the details in E-Business Suite Support Analyzer Bundle AutoUpdate Concurrent Program (Doc ID 2377353.1). Community Information: Join the discussions with our Analyzer experts on our EBS Community: Analyzers - EBS (MOSC) Your feedback shapes the content of existing Analyzers and drives creation of new Analyzers. Use the feedback button on each Analyzer note to offer suggestions, improvements, or ideas oh how to make this proactive tool more useful.
All EBS Analyzers have been upgraded to ensure that the latest enhancements and improvements have been incorporated. The versions of Analyzers uploaded to the service request (SR) will be validated...
Oracle EBS Events
Sign up for Oracle Financials for India (OFI) - GST: Annexure 1 and Annexure 2 Reporting Oracle Advisor Webcast
Attend the March 24, 2020 Oracle Advisor Webcast on EBS FIN: Oracle Financials for India (OFI) - GST: Annexure 1 and Annexure 2 Reporting.
Attend the March 24, 2020 Oracle Advisor Webcast on EBS FIN: Oracle Financials for India (OFI) - GST: Annexure 1 and Annexure 2 Reporting.
Oracle EBS Events
Attend an EBS FIN Advisor Webcast on Oracle Financials for India (OFI) - GST: E-Invoicing Generation on March 12, 2020
Announcement for ADVISOR WEBCAST: EBS FIN: Oracle Financials for India (OFI) - GST: E-Invoicing Generation to be held on March 12, 2020
Announcement for ADVISOR WEBCAST: EBS FIN: Oracle Financials for India (OFI) - GST: E-Invoicing Generation to be held on March 12, 2020
Oracle EBS Events
Register and Attend an Oracle Advisor Webcast on EBS FIN: How to Debug Custom SLA Setup issues in Receivables to be held on March 11, 2020
Invitation to attend a March 11, 2020 ADVISOR WEBCAST on the topic EBS FIN: How to Debug Custom SLA Setup issues in Receivables
Invitation to attend a March 11, 2020 ADVISOR WEBCAST on the topic EBS FIN: How to Debug Custom SLA Setup issues in Receivables
Inventory
New Analyzer Player - Logistics Pick Release Analyzer
What We Are Announcing EBS Manufacturing Team is excited to announce the initial release of the Logistics Pick Release Analyzer. The Logistics Pick Release Analyzer is another example of a tool that EBS Support offers to assist with functionality across EBS Products. Our goal in developing the analyzer is to provide a one-stop-shop to help with all Pick Release issues, regardless of which Product is having an issue. Get the analyzer from the following note in My Oracle Support (MOS): Doc ID 2349700.1 - EBS Logistics Pick Release Analyzer Highlights: The Logistics Pick Release Analyzer was designed to specifically give solutions and information on the Pick Release process across all Manufacturing Products involved in the process. The analyzer assists and resolves issues in EBS Products Inventory, Order Management, Shipping, Warehouse Management Systems, and Work in Process. The initial analyzer version 200.1 includes: Parameters for a specific shipping batch, or sales order, and/or sales order line, or discrete job. The goal is to provide Pick Release solutions for any sales order, from open to close. Specific tiles for each EBS Product area covered. The tiles include Error and Warning signature solutions, as well as all needed Informational signatures related to Pick Release. A ‘Common Data Validations’ tile that consolidates Error and Warning signatures for all Products. It’s the go to tile for quick solutions for Pick Release known issues on your system. A tile for Proactive Recommendations to make sure your systems are up-to-date on patching and key Pick Release file versions, and clear of Pick Release invalid objects. The ‘Diagnostics Apps Check’ contains the parameter "Include Diagnostic Apps Check" when setting to Yes, the Apps Check section appears in the output. If set to No, it doesn’t. The default being No. Diagnostics Apps Check section will show file versions for INV, OM, WSH, WMS, and WIP Products. Sample Output screenshot: The Logistics Pick Release Analyzer is available now to run on SQL*Plus via Doc ID 2349700.1 and will be available in the March 2020 Analyzer Bundle Menu Tool (see Doc ID 1939637.1, for more details). We are also interested in your input. Let us know what you think and how we can enhance the analyzer for your needs. Give us Feedback in the Logistics Community at conversation Logistics Pick Release Analyzer.
What We Are Announcing EBS Manufacturing Team is excited to announce the initial release of the Logistics Pick Release Analyzer. The Logistics Pick Release Analyzer is another example of a tool that EBS...
Inventory
Unassign Added to Simplify User Activities in 12.2.9
Ever assign an item to an organization and realize that you assigned to a wrong organization? There is a new feature added in Oracle EBS 12.2.9 latest version to make the unassign process easier. In previous releases, item once assigned to child organization through items form in Inventory or through item overview page in Product Hub, cannot be de-selected or unassigned once an item is saved, the assign checkbox became read-only. The user would have to delete the item from the organization by creating a delete group. Here is what the user might see in the item form: The process was simplified by enabling the checkbox so the user can mark the checkbox to False. Upon saving the change, the concurrent program "Delete Item Information" is submitted to remove the item assignment. Here is what the user might see in the Product Hub: For details on how to set up, process flow and other helpful information, please check out the below document. Vision Demo - 12.2.9 PDH/Item Enhancement - Allow to Unassign Item from Organization (Doc ID 2581859.1)
Ever assign an item to an organization and realize that you assigned to a wrong organization? There is a new feature added in Oracle EBS 12.2.9 latest version to make the unassign process easier. In...
Inventory
New Year!! Exciting New Features Added in Receiving Analyzer!!
With Contributing Author: Sunil Mididuddi What We Are Announcing To better assist our customers, and provide additional information and solutions, the Receiving Analyzer Maintenance Team has released version 200.16 of the Procurement Receiving Analyzer. New feature highlights: This version was created specifically for performance and new enhancements. Modified RCV_HEADERS_INTERFACE data signature to improve performance Limiting the display of ‘Diagnostics Apps Check’ by a new parameter "Include Diagnostic Apps Check". When set to Yes, the Apps Check section appears in the output file else it doesn't. Displaying Errors when Pay on Receipt program fails to create an ERS invoice for Purchase order and Blanket Release source document types. Added new section to display Personalizations enabled in receiving module. Added different sections to fetch RCV_HEADERS_INTERFACE data, one for R12 and the other one for R11.5.10. Added additional columns to display for 'Receipt Eligibility Data based on Invoice Status Code' for standard purchase order and blanket release source document types. Modified AP_INVOICES_ALL signature to stop displaying duplicate rows. Modified the INV period statuses signature to show the correct information. Marked the signatures of MTL_MATERIAL_TRANSACTIONS_TEMP as 'Warning' if there is a record stuck in it. Duplicate PO lines will no more appear. Added solution note for recommended patches list. Diagnostics Apps Check section will show file versions for PO, INV and WMS products only from hereon. Analyzers are designed to proactively assist you to better diagnose and maintain your Oracle Application environments. We welcome and encourage you to share your feedback via the EBS Receiving Analyzer feedback thread in the My Oracle Support logistics Community. Your feedback shapes the content of existing Analyzers and drives creation of new Analyzers. Get the analyzer from the following note in My Oracle Support (MOS): Doc ID 2012304.1 - EBS Procurement Receiving Analyzer
With Contributing Author: Sunil Mididuddi What We Are Announcing To better assist our customers, and provide additional information and solutions, the Receiving Analyzer Maintenance Team has released...
ATG Applications Technology
E-Business Suite 12.2 Data Masking Template Certified with EM 13cR3
Announcement: Certification of E-Business Suite 12.2 Data Masking Template for the Data Masking Pack with Enterprise Manager Cloud Control 13cR3
Announcement: Certification of E-Business Suite 12.2 Data Masking Template for the Data Masking Pack with Enterprise Manager Cloud Control 13cR3
ATG Applications Technology
January 2020 Updates to EBS Technology Codelevel Checker (ETCC)
Announcement: January 2020 Updates to EBS Technology Codelevel Checker (ETCC) is now available for download
Announcement: January 2020 Updates to EBS Technology Codelevel Checker (ETCC) is now available for download
Inventory
Can Cartonization Help Your Warehouse?
With Contributing Author: Twila Chavez Cartonization - What is it and How Can It Help Your Warehouse? Have you and your colleagues been discussing if and how to implement Cartonization? Oracle EBS Warehouse Management can provide this functionality.Cartonization is the process that suggests a container to pack items based on constraints such as cubic volume of items and container volume. Cartonization Uses: Oracle Warehouse Management uses cartonization in three places: Sales order and manufacturing picking Prepack for manufacturing completion Inventory bulk pack Customer can have the ability to choose and create robust rules that automatically determine the best container during the pick release process. There are four types of Cartonization Single Item– An item is always matched to the same container based on the static relationship you setup in the item/container relationship window. Mixed Item– Uses the contained-container item capacity and dimension restrictions defined on the master item window and checks it against the category and category set setup as well. Pick Slip Grouping– Generate an LPN for all items that belong to the same pick slip. Customer Algorithm– Uses a stub API to interface with customer-defined cartonization rules. Process: The cartonization algorithm Oracle WMS uses, minimizes the number of containers used at each level in the packaging hierarchy, based on volume, weight and minimum percent fill settings of the containers. This algorithm also verifies the dimensions of the packed material can fit inside the dimensions of container. This is just a sneak peak of the cartonization setup and functionality. For more details of the setup and a demo please review to notes: INV Webinar Series: WMS Cartonization [Video] (Doc ID 1375161.1) EBS WMS: Cartonization Setup and Diagnostics (Doc ID 1496099.1)
With Contributing Author: Twila Chavez Cartonization - What is it and How Can It Help Your Warehouse? Have you and your colleagues been discussing if and...
Payroll
UK Legislation Tax Year End (TYE) 2019/20 Final Patch Released for 12.1 and 12.2
Patch release for UK 2019/20 tax year, and the legislative updates effective from 6th April 2020, as well as, Real Time Information changes for the tax year beginning on 6th April 2020
Patch release for UK 2019/20 tax year, and the legislative updates effective from 6th April 2020, as well as, Real Time Information changes for the tax year beginning on 6th April 2020
Receivables
Reconciliation Issues Are More Than Just Data Related....
Not all reconciliation issues are data related. To rule out whether it is a report code issue, it is always important to keep your code versions up to date. REPORTS AR Reconciliation Report [ARXRECON, ARRECONB.pls] Aging – 7 Bucket By Account Report [ARXAGMW, ARAGBKTB.pls] AR to GL Reconciliation Report [ARGLRECB, arglrecb.pls] AR Journal Entries Report [ARRGTA, arjigl.lpc] GL Account Analysis Report – 132 Char [GLACTANL, glijeapb.pls] JOURNALS Sales Journal [ARSJGLARPT, ARXLARB.pls] Applied Receipts Journal [ARXAPPJR, ARGLRECB.pls] Unapplied Receipts Journal [ARUNAJR, ARGLRECB.pls] Adjustment Journal [ARXADJJR, ARRXOTHB.pls] REGISTERS Transaction Register [ARRXINVR, ARRXTXB.pls] Applied Receipts Register [ARRXARRG, ARRXRCB.pls] Unapplied and Unresolved Receipts Register [RXARUNAR, ARRXUNAB.pls] Adjustment Register [ARRXARPB, ARRXADJB.pls] How to check file versions: a) Using UNIX command strings -a |grep '$Header' b) Via Analyzers under Setup & Environment Information Window File Version Information > AR Forms, Libraries and Report Versions To access & install E-Business Suite (EBS) Analyzers, see Get Proactive with Oracle EBS - Product Support Analyzer Index (Doc ID 1545562.1) EBS Support Analyzer Bundle Menu Tool (Doc ID 1939637.1) - Install all, some, one Analyzer c) Using My Oracle Support To Find Latest Report Version Additional References for non-code issues: AR to GL Reconciliation Report Shows DIFFERENCE_DR = DIFFERENCE_CR for Upgraded Data (Doc ID 1616730.1) AR to GL Reconciliation Report Showing Wrong Headings Debit / Debit Should Be Debit / Credit (Doc ID 1551873.1)
Not all reconciliation issues are data related. To rule out whether it is a report code issue, it is always important to keep your code versions up to date. REPORTSAR Reconciliation Report [ARXRECON,...
Oracle EBS Events
Mark Your Calendar, Attend February 12, 2020 Oracle Advisor Webcast EBS FIN:Leverage the NEW R12.2 Projects Offerings to Ease, Streamline & Deliver Business Commitments
Announcing a Oracle Advisor Webcast Leverage the NEW R12.2 Projects Offerings to Ease, Streamline & Deliver Business Commitments
Announcing a Oracle Advisor Webcast Leverage the NEW R12.2 Projects Offerings to Ease, Streamline & Deliver Business Commitments
Fixed Assets
How to Improve Depreciation Performance – Tips & Tricks
In Oracle fixed assets, depreciation program is the one which touches each and every asset in an asset book and calculates depreciation for each of these assets. So with huge number of assets in a book, depreciation program completing with a reasonable time is a challenge for every organization. The following provides some tips and suggestions which might help to reduce the overall runtime of the Depreciation Request Set : 1. Debug Profiles - Check the following profile options making sure they are NOT checked or enabled, as these can all affect performance: FA: Deprn Single FA: Print Debug FA: Print Timing Diagnostics FND: Debug Log Enabled 2. Concurrent Program Tracing - Check that you do NOT have the 'Trace' option checked on any of the concurrent programs in the Depreciation Request Set (Generate Accounts, Calculate Gains & Losses, Depreciation, Journal Entry Reserve Ledger Report). You can check this in the Concurrent > Program > Define form, from the System Administrator responsibility. 3. Security Profile and Parallel Processing - Check the following profile options which can impact the performance: FA: Security Profile If this profile is set, it means that security is enabled for the responsibility and this should be expected to slow down the processing slightly. FA: Number of Parallel Requests You may wish to consider setting this profile to improve the performance. Please see the 'Oracle Assets Profile Options' Chapter in the Oracle Assets User Guide, for more information about this profile option. 4. Latest Code Level - Consider applying more recent code for any of the programs which seem to be taking the most time in the Depreciation Request Set. In particular, it is recommended to be on the latest FA rollup patch for your patchset level. Refer to the following note for the Latest FA Rollup Patch numbers: Doc ID 466607.1 - R12 / 11i FA.M-P RECOMMENDED PATCH LIST 5. Data base Setup - Are all required init_SID.ora parameters set correctly according to the script in Note 174605.1? Refer to: Doc ID 174605.1 - bde_chk_cbo.sql - EBS initialization parameters - Healthcheck 6. Running Gather Schema Statistics Program - Ensure you run 'Gather Statistics' for the FA Schema on a regular basis; particularly important after any big data load. 7. Pr-Processing - Take advantage of the ability to do pre-processing before the period end time, by running 'Generate Accounts' and 'Calculate Gains and Losses' as standalone processes, as often as required during the month. This will ensure as much pre-processing as possible is done before the Depreciation Request Set is run, and will reduce the time of those elements of the request set. 8. Bulk Data Upload - Be aware, the runtime for the first depreciation run after a big data load should be expected to take considerably longer than for subsequent periods. The Depreciation Program (FADEPR) part of the request set has much greater processing than normal to achieve in such runs, as the addition rows for every new asset must be entered, as well as the depreciation rows.
In Oracle fixed assets, depreciation program is the one which touches each and every asset in an asset book and calculates depreciation for each of these assets. So with huge number of assets in a...
Property Manager
Property Manager & Equipment Lease – A New Cumulative Patch Released
As a part of new IFRS & ASC842 lease accounting requirement enhancement, we have released a new Cumulative patch. Patch Details are 12.1.3 - 30133777:R12.PN.B 12.2.X - 30746709:R12.PN.C The above cumulative patch not only has few critical bug fixes, it also has few product enhancements being included in it. The major enhancements that are released as a part of this cumulative patch is Consideration of "Options End Date" into Amortization– Functionality has be provided for users for considering Option end date for Amortization. This flexibility is provided via a profile option and while performing Renewal and Termination Options users can choose the amortization end date in a Lease to be that of Option end date or Lease End Date. Liability Flag Change - Discontinued to send the Liability Flag of Yes/No on Invoice Line DFF flag which was sent to AP in Invoice Line DFF number 2. We are now using Reference Key1 field is reserved for Property manager to store or derive PN Lease Liability Flag Decoupling feature - In the Link term feature the Amendment Commencement date and Contraction Date are coupled, and they cannot be separated. A new flag to be introduced and this will be called as ‘Expired Terms’ with values of ‘Y/N’. Users can decide to have Contraction adjustment to be spread until Lease End Date or Term End Date. Remeasurement value will be calculated only at the Lease level unlike linking of terms where it is captured at term level Add terms from past date - Add term calculations are going to be as of ACD and hence no reserve gets created if start date for ROU/Liability. For more information all the above enhancements, please refer Doc Id 2611417.1
As a part of new IFRS & ASC842 lease accounting requirement enhancement, we have released a new Cumulative patch. Patch Details are 12.1.3 - 30133777:R12.PN.B 12.2.X - 30746709:R12.PN.C The above...
Inventory
Know More about ‘Pay on Receipt Auto Invoice’
With Contributing Author : Kavita Yetakuri Do you want to create your receipt invoices automatically? Do you want to eliminate duplicate manual data entry steps? Do you know what is ‘Pay on Receipt Auto Invoice’ program and Evaluated Receipt Settlement (ERS) and Self Billing? “Payment on Receipt Auto Invoice” enables you to create standard, unapproved invoices for payment of goods based on receipt transactions. Invoices are created using a combination of receipt and purchase order information, eliminating duplicate manual data entry and ensuring accurate and timely data processing. Payment on Receipt Auto Invoice Program is also known as Evaluated Receipt Settlement (ERS) and Self Billing. It creates Invoices for three different types of business flows: Received POs Advanced Shipment and Billing Notice (ASBN) Consigned Inventory Three options are available for this feature: Receipt: Receipt is used for material that is not consigned Use: For consigned POs, if the invoice needs to be created automatically, then either Use or Receipt and Use should be used. Receipt and Use: Receipt and Use is for material that can be either consigned or non-consigned material. Process Flow of Pay on Receipt Auto Invoice: Whole process flow is available in below document id 2581713.1 For complete information on “Pay on Receipt Auto Invoice” Feature in Oracle eBusiness Suite, please refer below notes: Pay On Receipt AutoInvoice - ERS, ASBN, Consigned PO Step-by-Step Flow, Common Issues and Resolution Guide (Doc ID 2581713.1) FAQ : POXPOIV - Pay On Receipt AutoInvoice (Doc ID 210123.1)
With Contributing Author : Kavita Yetakuri Do you want to create your receipt invoices automatically? Do you want to eliminate duplicate manual data entry steps? Do you know what is ‘Pay on Receipt...
HR and Benefits
Released - Phase II Patches for the 2019 Employer Shared Responsibility Reporting Under the Affordable Care Act
Announcement: 2019 Employer Shared Responsibility Reporting Under the Affordable Care Act - Phase I Patch has been Released
Announcement: 2019 Employer Shared Responsibility Reporting Under the Affordable Care Act - Phase I Patch has been Released
Oracle Financials for India (India Localizations)
Advisory: New Goods and Services Tax(GST) Reporting Requirements and E-invoicing functionality under GST
A. New GST Reporting Requirements: Purpose: The GST Council in its 31st meeting decided that a new GST Return system will be introduced to facilitate taxpayers. Under the New GST Return System, there will be one main return called the GST RET-1 and two annexures i.e. FORM GST ANX-1 and FORM GST ANX-2. The returns will have to be filed on a monthly basis by all taxpayers. W.e.f.: 01st April, 2020. Overview: FORM GST ANX-1 is an annexure to the main return GST RET-1 introduced under the new filing system of simplified returns under GST. This annexure will contain details of all outward supplies, inward supplies liable to reverse charge and import of goods and services. Details in this annexure will have to be reported invoice-wise (except for B2C supplies) based on continuous uploading facility to be made available on GST portal. The reporting can be done on a real-time basis, and will be available for the recipient of supplies to take necessary action in their FORM GST ANX-2. For a detailed update and relevant communication please refer to the following MOS Note: E-Business Suite Release 12: Support on new GST Reporting Requirements (Doc ID 2623180.1) B. E-Invoicing Functionality under GST: Purpose: The GST Council in its 37th meeting held on 20th Sept 2019 approved the standard of e-invoice for introduction of ‘E-invoicing’ or ‘electronic invoicing’ in a phased manner for reporting of business to business (B2B) invoices to GST System. Further, the Central Board of Indirect Taxes had issued Notifications listed below on 13-December 2019 modifying the existing CGST Rules for implementing e-invoicing procedures with effect from 1-April-2020. Overview: In an e-invoicing regime, tax payers are required to generate their invoices for supply of goods or services at taxable event for a given supply and with e-invoicing, they will be mandated to follow the prescribed data structure and content. Below are the important points with regard to the complete process: This is applicable for B2B and B2G supplies. Invoice generated from the supplier system must contain the mandatory data as per the prescribed schema. Tax payers will be required to register their invoices electronically on real time basis with Invoice Registry Portal (IRP) prior to supply. If the invoice information received is in order, IRP will acknowledge the receipt of the invoice which will be registered at GSTN portal and send back the unique Invoice Reference Number (IRN) which must be printed in the tax invoice generated by tax payers from their ERP/Accounting system. On successful registration of the invoice at GSTN portal, IRP will digitally sign the invoice and assign a unique QR code and the same will be communicated back to the supplier. This document issued by IRP will be the fiscal document for supply and must accompany the consignment along with eway bill and the tax invoice generated by the supplier. Invoice generated from system without electronic registration and without QR code will be considered as an INVALID document. For further details and relevant recommendations, please refer to the following MOS Note: E-Business Suite Release 12: Support on E-Invoicing Requirements under Goods and Service Tax (GST) (Doc ID 2623708.1) Applicable to: Oracle E-Business Suite Release 12.1.X to 12.2.X
A. New GST Reporting Requirements: Purpose: The GST Council in its 31st meeting decided that a new GST Return system will be introduced to facilitate taxpayers. Under the New GST Return System,...
Inventory
No More Pain of A Backordered Quantity Left in Your Staging Sub Inventory
With Contributing Author Anitha Gogineni. Are you concerned that when backordering a staged delivery line, that material is left in the staging sub-inventory? This would then require you to manually move quantity after each backorder. This now can’t happen due to the new “Automated Backorder Move” functionality introduced in 12.2.9 that helps to carry out a well laid process for backorder material. You can leave it to the system to generate a Move Order while doing Backorder from Staging. To set-up this feature, configure Shipping Parameter ‘Automate Backorder Move’ to ‘Auto Transact’ or ‘Auto Allocate’. Then when backordering staged quantity, concurrent request ‘Process Move Orders for Backordered Materials’ is triggered. It creates move order for material movement and triggers concurrent request ‘Move order pick slip’. The ‘Move order pick slip’ request allocates and transacts move order based on shipping parameter ‘Automate Backorder Move’. A new Transaction type ‘Reverse Staging Transfer’ identifies the move orders and material transactions for the backordered delivery lines. To move the quantity to a location other than its originally picked location, a programmable custom hook is available. For details on how to setup, process flow and other helpful information, please check out the below notes. Vision Demo -How To Move Backordered Material Automatically to Source Location (Doc ID 2580082.1)
With Contributing Author Anitha Gogineni. Are you concerned that when backordering a staged delivery line, that material is left in the staging sub-inventory? This would then require you to manually...
Oracle EBS Events
Attend the Jan 22, 2020 Oracle Advisor Webcast on EBS HCM UK Payroll Legislative Updates
Announcing a Oracle Advisor Webcast on Jan 22, 2020 Oracle Advisor Webcast on EBS UK Payroll Legislative Updates
Announcing a Oracle Advisor Webcast on Jan 22, 2020 Oracle Advisor Webcast on EBS UK Payroll Legislative Updates
HR and Benefits
Announcing an Oracle Advisor Webcast EBS Coverage Restrictions Setup in Oracle Advanced Benefits
Announcing a Oracle Advisor Webcast on Jan 08, 2020,on EBS Coverage Restrictions Setup in Oracle Advanced Benefits
Announcing a Oracle Advisor Webcast on Jan 08, 2020,on EBS Coverage Restrictions Setup in Oracle Advanced Benefits
Inventory
Is It Possible to Verify Picked Material Before Shipping? Click Here to Find Out?
Did you anytime find discrepancies in loaded or the picked (Staged/loaded to dock) material (LPNs) for outbound customer orders prior to Shipping? You might have noticed these discrepancies and they might lead to incorrect shipments, in-accuracy in inventory quantities, increased Return Material (RMA) shipments and loose time and revenue. As of today, the warehouse users do not have a mechanism to verify the loaded or the picked (Staged/loaded to dock) material (LPNs) for outbound customer orders and move orders. Considering these business impacts, new ‘Verify Pick’ feature is introduced in Warehouse Management from Oracle EBS 12.2.9 latest version. There is option to make system to enforce inspection of picked material which contributes to efficient and timely tracking of picked contents (LPNs) and allows you to keep track of discrepancies and train your warehouse users to perform their job more effectively. Here's an example from an Oracle Vision Demo instance The goal of Verify Pick is to provide ability for users (pickers & shippers) to confirm the material picked during Load operation is same as what was confirmed by the users during picking process. It enables Warehouse Managers to track picking exceptions and take corrective measures to ensure on-hand (LPN's) shipped to customers have no picking discrepancies. In highly regulated industries like Pharma, system allows users to ensure proper lots and serials are shipped and conform to business process that requires another user to re-confirm the material loaded or picked in an LPN before it’s dropped to the staging area or is shipped out. Currently this feature 'Verify Pick' applicable for WMS enabled organizations only. For details on how to setup, process flow and other helpful information, please go through below notes. Vision Demo - 12.2.9 WMS Enhancement - Verify Pick Process (Doc ID 2582054.1)
Did you anytime find discrepancies in loaded or the picked (Staged/loaded to dock) material (LPNs) for outbound customer orders prior to Shipping? You might have noticed these discrepancies and...
Oracle EBS News
Join the Conversation in Our New E-Business Suite Support Analyzer Community
Oracle has created a new community for E-Business Suite Support Analyzers. This community space is your one-stop shop for everything Analyzers. Learn about new and exciting Analyzer diagnostic offerings, ask questions about analyzer installation and updates, or provide ideas for what you would like to see included in future releases. Analyzers are designed by Support to proactively assist you to better diagnose and maintain your Oracle Application environments. We welcome and encourage you to share you feedback in this new community. Go to directly to the community and click on follow button in the upper right hand corner. Analyzers are non-invasive scripts which collects data to diagnose issues. The scripts are meant to be part of your production maintenance program by your System Administrator, or can be used by designated end users. Join the community discussion today! Be sure to bookmark our Product Support Analyzer Index note for a list of all our EBS Analyzers in DocID 1545562.1
Oracle has created a new community for E-Business Suite Support Analyzers. This community space is your one-stop shop for everything Analyzers. Learn about new and exciting Analyzer diagnostic...
ATG Applications Technology
NEW EBS Report Manager Analyzer is now available!
We are happy to announce the release of new Report Manager Analyzer version 200.1 and available through Doc ID 2452639.1. The EBS Report Manager Analyzer is a self-service health-check script that reviews FSG and Report Manager data, analyzes current configurations and settings for the environment, gathers BNE log, FSG XML output, concurrent log files of FRM and RGRARG programs that are in Error/Warning status, and provides feedback and recommendations on best practices. As you may all know, Analyzers may also be used as data collection tools by Support Engineers and application data is not altered in any way when you run this analyzer. Report Manager Analyzer (Java Program) Features: Ø Log gathering (i.e. BNE log, FRM and RGRARG Concurrent Requests Logs, FSG XML output) is included in the Report Manager Analyzer. Ø This analyzer is run as a java program from the command line by SYSADMINS or DBAs. (Requires APPS password) Ø This Java program analyzer is not currently available as a concurrent program. Parameters : Ø FSG Report ID: (Optional) Enter the Financial Statement Generator(FSG) Report_ID in question. FSG Report Setup Definition section is only visible in the analyzer output when the analyzer is run with this parameter. Ø Responsibility_ID: (Optional) Enter the Responsibility_ID of the responsibility that was used to submit the Report Manager reports. FSG Drilldown Functions section is only visible in the analyzer output when the analyzer is run with this parameter. Ø FSG Report Set ID: (Optional) Enter the Financial Statement Generator(FSG) Report_Set_ID in case your issue is related to Report Manager FSG Report Sets. FSG Report Set Definition section is only visible in the analyzer output when the analyzer is run with this parameter. NOTE: The highlighted sections only appear on the output if one of the parameters is entered.
We are happy to announce the release of new Report Manager Analyzer version 200.1 and available through Doc ID 2452639.1. The EBS Report Manager Analyzer is a self-service health-check script that...
Fixed Assets
New Fixed Assets Analyzer Version is Now Available
Fixed asset analyzer is a self-service health-check diagnostic that will help you to review Assets related data, analyzes current configurations and set up you have in your instance and provides feedback and recommendations on best practices. In the new 200.39 version which can be downloaded from document 2061234.1, there are different sections like Proactive and Preventive recommendations, Setup related checks, Depreciation status, asset / tax work bench related issues, mass addition & sub ledger accounting related issues. In addition to that it also has list of recommendation for your period closure as well as depreciation calculator which will help you to understand how system has calculated the depreciation for a specific asset. In the latest version, we have also included many data inconsistency check which can create issues during your period closure / depreciation run. Note that the analyzer just extracts the data from your instance and in any case your application data is not altered when you run this Analyzer. Benefits of the Fixed Assets Analyzer: Immediate analysis and output of Fixed Assets data from a particular environment Identifies: Recommended patches to apply to avoid application bug issues Oracle Assets system setup and configurations Depreciation status of the book Gaps/Overlaps in Asset Calendars and Prorate Convention Calendars Known issues related to Workbench, Mass Additions, Subledger Accounting Payables to Oracle Assets invoice transfers Period Close process recommendations Highlights transactions which has data inconsistency Analyzers are designed to proactively assist you to better diagnose and maintain your Oracle Application environments. We welcome and encourage you to share your feedback via the Fixed Assets Analyzer feedback thread in the My Oracle Support Fixed Assets Community. Your feedback shapes the content of existing Analyzers and drives creation of new Analyzers.
Fixed asset analyzer is a self-service health-check diagnostic that will help you to review Assets related data, analyzes current configurations and set up you have in your instance and provides...
Oracle EBS Events
Join Us for Oracle Advisor Webcast on EBS FIN: Receivables Invoicing Using EDI and Document Transfer/Electronic Invoicing
Oracle Advisor Webcast: EBS FIN: Receivables Invoicing Using EDI and Document Transfer/Electronic Invoicing Schedule: Thursday , November 21, 2019 08:00 AM (US Pacific Time) Thursday , November 21, 2019 11:00 AM (US Eastern Time) Thursday , November 21, 2019 05:00 PM (Central European Time) Thursday , November 21, 2019 09:30 PM (India Standard Time) This one-hour advisor webcast is recommended for functional and technical users who wish to send invoices electronically through either EDI Outbound (ECEINO: 810 INO) or the XML Gateway using the AR document transfer program Topics Include: Differences between EDI and XML Gateway setups for EDI Outbound and XML Gateway Running the different processes to extract invoices Tables and files involved in each process Troubleshooting Register to Join Us at this event Register for this Advisor Webcast: HERE Current Schedule and Archived Downloads of ALL Oracle Advisor Webcast can be found in Note 740966.1
Oracle Advisor Webcast: EBS FIN: Receivables Invoicing Using EDI and Document Transfer/Electronic Invoicing Schedule: Thursday , November 21, 2019 08:00 AM (US Pacific Time) Thursday , November 21, 2019...
Property Manager
Understanding of Enhanced Amendment Functionality in Property Manager
As we have seen in the earlier posts, to meet the new compliance requirement of IFRS and US GAAP with respect to lease accounting, property manager has been enhanced. With this enhanced functionality, even the amendment transaction flow has been improvised to better user experience. Now when a user tries to amend an existing lease, they will be prompted with below options Depending on what changes user want to perform, they can select the corresponding amendment option and proceed further. Amend Lease: - Should be used to make any lease level changes like lease extension, lease contraction, change the interest index etc. Amend Terms :- Should be used when there is requirement to amend the payment terms. This option needs to be used when user want to extend a payment term or contract a payment term or add a new payment term etc. Amend Lease Classification: - This option should be used, only when the lease classification needs to be changed from Operating lease to Finance lease or visa versa. Link Terms: - Currently in Property Manager or Equipment lease, we cannot update most of the attributes of a payment term once it is created. So currently whenever there is a change in any of the attributes of payment term like payment amount, frequency, schedule day etc, we need to contract the existing payment term and create a new one. To perform this kind of amendment, link term option needs to be selected. For more information on the enhanced functionality in Property manager, please refer Property manager Info center Document 2482062.2.
As we have seen in the earlier posts, to meet the new compliance requirement of IFRS and US GAAP with respect to lease accounting, property manager has been enhanced. With this enhanced functionality,...
HR and Benefits
Mark Your Calendar, Attend December 5, 2019 Oracle Advisor Webcast on EBS Affordable Care Act 2019 Processing Review
Announcing a Oracle Advisor Webcast on December 5, 2019, Oracle Advisor Webcast EBS Affordable Care Act 2019 Processing Review
Announcing a Oracle Advisor Webcast on December 5, 2019, Oracle Advisor Webcast EBS Affordable Care Act 2019 Processing Review
ANNOUNCEMENT: EBS Enterprise Command Center (ECC) Analyzer (Doc ID 2587090.1) is now LIVE!
EBS Enterprise Command Center (ECC) Analyzer (Doc ID 2587090.1) is now LIVE! The EBS Enterprise Command Center (ECC) Analyzer is a self-service health-check script that reviews Oracle Enterprise Command Center related data, analyzes current configurations and settings for the environment and provides feedback and recommendations on best practices. Analyzers may also be used as data collection tools by Support Engineers. Your application data is not altered in any way when you run this analyzer.
EBS Enterprise Command Center (ECC) Analyzer (Doc ID 2587090.1) is now LIVE! The EBS Enterprise Command Center (ECC) Analyzer is a self-service health-check script that reviews Oracle Enterprise...
Receivables
New Analyzer: Download the Credit Management Analyzer today!
The Credit Management Analyzer has been released to PRODUCTION today! This Analyzer checks for: Credit Management system setups and configurations Missing critical RPC patches and known issues Identifies final score missing for additional data points Identifies the case folder missing for the application submitted AND much more! This analyzer will ask for Case Folder Number or Application Number and will ask to include apps checks (checks file versions). You can read all about this new analyzer in Note: 2587061.1 We will only be able to improve the analyzer if you use it and send us feedback. So please let us know if you find issues or have concerns/suggestions. We have a feedback thread on Oracle Communities.
The Credit Management Analyzer has been released to PRODUCTION today! This Analyzer checks for: Credit Management system setups and configurations Missing critical RPC patches and known issues Identifies f...
HR and Benefits
Need to Review Oracle Advanced Benefits - Eligibility Functionality? Attend this September 5th Advisor Webcast
Announcement for September 5,2019 , Oracle Advisor Webcast titled Oracle Advanced Benefits - Eligibility Functional Review.
Announcement for September 5,2019 , Oracle Advisor Webcast titled Oracle Advanced Benefits - Eligibility Functional Review.
ATG Applications Technology
Oracle E-Business Suite 12.2.9 Now Available
We are pleased to announce that Oracle E-Business Suite 12.2.9 is now available. Many new features and enhancements were requested and voted on by customers using the social media capabilities of the Oracle E-Business Suite Communities on My Oracle Support. Other new features and enhancements reflect continued development of themes introduced in earlier 12.2 releases, including support for modern business models, user interface modernization, and increased operational efficiency. For details regarding the EBS 2019 innovations, see: Announcing Oracle E-Business Suite 2019 Innovations (PDF) The EBS 12.2.9 release update pack (RUP) is delivered on My Oracle Support as Patch 28840850. Instructions for downloading and applying this latest RUP on top of the EBS 12.2 codeline can be found here: Oracle E-Business Suite Release 12.2.9 Readme (MOS Note 2495027.1) What Does Release 12.2.9 Include? As a consolidated suite-wide patchset, this RUP includes new features, statutory and regulatory updates, and enhancements for stability, performance, and security. Release 12.2.9 is cumulative. That means that as well as providing new updates for this release, it also includes updates that were originally made available as one-off patches for earlier 12.2 releases. For a complete list of new features, refer to: Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (MOS Note 1302189.1) Common Questions and Answers About Upgrading Q: Is there a direct upgrade path from EBS 12.2.x to 12.2.9? A: Yes. Release 12.2.x customers can apply 12.2.9 directly to their environments. EBS 12.2.9 is an online patch, so it can be applied while an existing Release 12.2.x system is running. Q: Is there a direct upgrade path from Release 12.1 to Release 12.2.9? A: No. Release 12.1 customers must first upgrade to Release 12.2 before applying 12.2.9. Q: Is there a direct upgrade path from Release 12.0 to Release 12.2.9? A: No. Release 12.0 customers must first upgrade to Release 12.2 before applying 12.2.9. Q: Is there a direct upgrade path from EBS 11i to 12.2.9? A: No. Release 11i customers must first upgrade to Release 12.2 before applying 12.2.9. Additional References Oracle E-Business Suite Release 12.2 Information Center (Doc ID 1581299.1) Oracle E-Business Suite Release 12.2 Documentation - Web Library (Oracle Technology Network) Related Articles Oracle E-Business Suite 12.2.8 Now Available Oracle E-Business Suite 12.2.7 Now Available Oracle E-Business Suite 12.2.6 Now Available Oracle E-Business Suite 12.2.5 Now Available Oracle E-Business Suite 12.2.4 Now Available Oracle E-Business Suite 12.2.3 Now Avaialble Oracle E-Business Suite 12.2 Now Available
We are pleased to announce that Oracle E-Business Suite 12.2.9 is now available. Many new features and enhancements were requested and voted on by customers using the social media capabilities of the...
ATG Applications Technology
NEW Update Patch for Oracle BI Publisher Enterprise 11g
July 2019, the latest update patch available for Oracle BI Publisher Enterprise 11g for Oracle BI Publisher Enterprise 11.1.1.9.x: Patch 29994430 BI Bundle Patch 11.1.1.9.190716 containing patch 29931930 Oracle BI Publisher 11.1.1.9.190619 Details are in the Overview of Available Update Patches for Oracle BI Publisher Enterprise 11g (Doc ID 1276869.1)
July 2019, the latest update patch available for Oracle BI Publisher Enterprise 11g for Oracle BI Publisher Enterprise 11.1.1.9.x: Patch 29994430 BI Bundle Patch 11.1.1.9.190716 containing patch...
Fixed Assets
Setting Up Depreciation Override in Oracle Assets
Depreciation Override allows you to optionally override the depreciation amounts calculated by Oracle Assets. Using this feature, you can manually override the calculated default depreciation amounts for standalone and group assets. Before running depreciation or performing adjustments, you must provide the necessary information in the Depreciation Override window or the FA_DEPRN_OVERRIDE table, and indicate whether the override data is for depreciation or adjustments. When running depreciation, the system will upload and use the depreciation amounts provided in the interface table. This feature uploads and overrides the system calculated depreciation amounts with the amounts you provided in the override interface table. Prerequisite:- The only per-requisite for using this feature is to setup the profile FA: Enable Depreciation Override to Yes Note that for MRC-enabled books, you do not need to provide the override amounts for the reporting currency books. The system will derive the reporting currency values based on the ratio of asset cost in the reporting currency to asset cost in the ledger currency. There are two way in which we can input the override values in Oracle assets i.e 1. Using the Depreciation Override window:- Navigate to the Depreciation Override window i.e Depreciation > Override Query the assets records you wish to modify, enter the asset number, book, and period of the asset in the rows of Depreciation Override window. In the Depreciation field, you can enter the override depreciation amount. In the Bonus Depreciation field you can enter the override bonus depreciation amount. In the Use By field, you can select the adjustment type of Depreciation or Adjustment. The default value is Depreciation when creating a new record. The Status field displays the current status of the override record, which may be New, Post, or Posted. If the status is Post or Posted, you cannot update the record, you can only delete the record and reenter the updated record. Select Save from the menu to save your work. 2. Using the FA_DEPRN_OVERRIDE table:- Define the override data in the FA_DEPRN_OVERRIDE table. In the FA_DEPRN_OVERRIDE table, enter all basic override depreciation information: BOOK_TYPE_CODE, ASSET_ID, PERIOD_NAME, DEPRN_AMOUNT, BONUS_DEPRN_AMOUNT and USED_BY. You can provide depreciation amounts for depreciation expense and bonus expense separately using the columns: DEPRN_AMOUNT and BONUS_DEPRN_AMOUNT. Define either DEPRECIATION or ADJUSTMENT in the USED_BY column depending on your requirement. Note that you can assign multiple override data for each asset as long as PERIOD_NAME and USED_BY do not overlap for records with a non-posted status. For more information on depreciation override functionality, please refer Oracle Asset User Guide
Depreciation Override allows you to optionally override the depreciation amounts calculated by Oracle Assets. Using this feature, you can manually override the calculated default depreciation amounts...
Property Manager
Foreign Currency Lease in Property Manager – An Overview
In today’s modern world with the globalization, it is quite common for any organization to have business spread across different countries. In this case, to run their business, organization will end up taking leases in the country in which they are operating and these lease payments need to be done in a foreign currency. To meet this growing requirement of organization, Oracle Property manager enhanced to handle the foreign currency leases. In property manager a billing / payment term can be entered in any other currency than the functional currency of the ledger. When a payment term is created with foreign currency, billing / payment amounts are converted into functional currency based on Conversion rate type specified in the Currency Conversion Type system option. Conversion Type specified in Reporting Currencies window for the functional currency. This will be used only if the Conversion rate type is not specified in system option Entering the conversion rate manually in Payment terms window. This can be entered only if the Conversion rate type is set to ‘user’ in System Option. Currently in property manager, the exchange rate can be derived in two different ways User Defined Exchange Rate – In system options you need to select the currency conversion type as user and in this case system will allow user to enter the required exchange rate at lease level itself and all future transactions for the lease will be converted based on this user defined exchange rate. Automatic derivation of Exchange Rate from GL – In System options, if the currency conversion type is set to “Corporate” or any other conversion type, system will automatically derive the exchange rate based on the conversion type. For converting the foreign currency to functional currency, system uses the transaction and system date to determine the rate. If you are using the oracle property manager & Equipment lease solution to meet your IFRS & USGAAP reporting requirements for lease accounting, then the exchange rate for foreign currency leases will be derived based on below logic For more information on the foreign currency leases, please refer the Property Manager User Guide
In today’s modern world with the globalization, it is quite common for any organization to have business spread across different countries. In this case, to run their business, organization will end...
Oracle EBS News
Congratulations! My Oracle Support Communities 2019 Most Valued Contributors EBS Winners
Congratulations to the My Oracle Support Communities E-Business Suite Most Valued Contributors 2019 winners!
Congratulations to the My Oracle Support Communities E-Business Suite Most Valued Contributors 2019 winners!
ATG Applications Technology
NEW Update Patch for Oracle BI Publisher Enterprise 12c (12.2.1.4)
July 2019, the latest update patch available for Oracle BI Publisher Enterprise 12c for Oracle BI Publisher Enterprise 12.2.1.4.x: Patch 29640387 BI Bundle Patch 12.2.1.4.190716 containing Oracle BI Publisher Details are in the Overview of Available Update Patches for Oracle BI Publisher Enterprise 12c (12.2.1.4) (Doc ID 2463289.1)
July 2019, the latest update patch available for Oracle BI Publisher Enterprise 12c for Oracle BI Publisher Enterprise 12.2.1.4.x: Patch 29640387 BI Bundle Patch 12.2.1.4.190716 containing Oracle BI...
Automatically Update & Deploy Your Analyzers Every Month!
Did you know that 80% of E-Business Suite DBAs are still updating their Analyzers manually, are you one of them? Save Time! No more manual downloads, FTP's, manual updates to Analyzers. Get them all at once, every month, downloaded and installed via a Concurrent Program! Since July 2018, Customers have utilized the AutoUpdate Concurrent Program over 2000 times to get their Analyzers delivered and installed Automatically! Join them now! If you have an Analyzer Bundle (200.50+) already, then you already have all the files you need to setup AutoUpdate! For more information, please visit My Oracle Support Doc ID 2377353.1
Did you know that 80% of E-Business Suite DBAs are still updating their Analyzers manually, are you one of them? Save Time! No more manual downloads, FTP's, manual updates to Analyzers. Get them all at...