Review EBS product's new releases & features, troubleshooting tips & tricks, best practices, upcoming webcasts

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...

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).

Announcement: The OA Framework 12.2.6 Bundle 23 is Now Available

Announcement: The OA Framework 12.2.6 Bundle 23 is Now Available

Announcing the release of the 'EBS PTO Accrual Plan Analyzer

Announcing the release of the 'EBS PTO Accrual Plan Analyzer

Here is the Quarterly EBS Upgrade Recommendations: February 2020 Edition

Here is the Quarterly EBS Upgrade Recommendations: February 2020 Edition

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...

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.

Announcement: Oracle Database 19c Now Certified with EBS 12.1 for Linux on IBM Z

Announcement: Oracle Database 19c Now Certified with EBS 12.1 for Linux on IBM Z

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 Mexico Payroll Customers Year End 2019 Phase 2 Patches have been released.

Oracle Mexico Payroll Customers Year End 2019 Phase 2 Patches have been released.

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...

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.

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

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

Announcing the release of The Korea Cumulative Release Patch KR.93 for EBS Release 12.1 and 12.2.

Announcing the release of The Korea Cumulative Release Patch KR.93 for EBS Release 12.1 and 12.2.

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...

Announcement of the release of UK P11D Legislative Payroll Changes 2019-20 Patches

Announcement of the release of UK P11D Legislative Payroll Changes 2019-20 Patches

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...

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...

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

Patches are available via My Oracle Support for New Zealand Statutory updates effective April 2020

Patches are available via My Oracle Support for New Zealand Statutory updates effective April 2020

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

                                              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...

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

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,...

Announcement: OA (Oracle Applications) Framework 12.2.7 Bundle 7 is now available for download

Announcement: OA (Oracle Applications) Framework 12.2.7 Bundle 7 is now available for download

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

Announcing the release of Korea Cumulative Release Patch KR.92 for 2019, 2020 Statutory updates.

Announcing the release of Korea Cumulative Release Patch KR.92 for 2019, 2020 Statutory updates.

Here is an Overview of Available Update Patches for Oracle BI Publisher Enterprise 11g

Here is an Overview of Available Update Patches for Oracle BI Publisher Enterprise 11g

Announcing new JRE 1.8.0 & 1.7.0 Certification with EBS Releases 12.2 and 12.1

Announcing new JRE 1.8.0 & 1.7.0 Certification with EBS Releases 12.2 and 12.1

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...

Announcement: Critical Patch Update (CUP) for January 2020 Now Available

Announcement: Critical Patch Update (CUP) for January 2020 Now Available

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...

Join an Oracle Advisor Webcast on February 5, 2020 titled EBS HCM Meet the Experts.

Join an Oracle Advisor Webcast on February 5, 2020 titled EBS HCM Meet the Experts.

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...

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

Announcing US and CA Year End Statutory Patch 3 release.

Announcing US and CA Year End Statutory Patch 3 release.

Announcing the Oracle E-Business Suite Learning Center

Announcing the Oracle E-Business Suite Learning Center

Announcing Active Data Guard 19c Certifiion with E-Business Suite 12.2

Announcing Active Data Guard 19c Certifiion with E-Business Suite 12.2

Announcing new certification for Integrated SOA Gateway (ISG) with EBS 12.2 and Database 19c

Announcing new certification for Integrated SOA Gateway (ISG) with EBS 12.2 and Database 19c

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,...

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...

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

Patches have been released for US Payroll Customers for the Federal W-4 2020 Phase I Update

Patches have been released for US Payroll Customers for the Federal W-4 2020 Phase I Update

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

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 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...

Oracle E-Business Suite at Oracle OpenWorld 2019 Video Recording

Oracle E-Business Suite at Oracle OpenWorld 2019 Video Recording

Australia HCM Legislation Cumulative Patch AU.2019 is released via My Oracle Support.

Australia HCM Legislation Cumulative Patch AU.2019 is released via My Oracle Support.

Announcement for Ireland Legislation Year End / Budget Changes Patch for Tax Year 2020

Announcement for Ireland Legislation Year End / Budget Changes Patch for Tax Year 2020

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 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 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...

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,...

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: Consolidated Patch - IN.19 patch has been released.

Announcement: Consolidated Patch - IN.19 patch has been released.

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...

Japan Consolidated Patch - 2019 is now available

Japan Consolidated Patch - 2019 is now available

Announcement for the release of 2019 Year End Phase I patch for US and CA Legislation.

Announcement for the release of 2019 Year End Phase I patch for US and CA Legislation.

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...

The United States (US) Third Quarter (Q3) Statutory Update, 2019 has been released!

The United States (US) Third Quarter (Q3) Statutory Update, 2019 has been released!

Announcing the availability of Oracle E-Business Suite (EBS) Innovations in 2019

Announcing the availability of Oracle E-Business Suite (EBS) Innovations in 2019

Announcement of the release of the 2019 US US HR Annual Statutory Update patch

Announcement of the release of the 2019 US US HR Annual Statutory Update patch

Announcing the release of the phase 3 patch for Oracle HRMS (South African) SARS PAYE BRS

Announcing the release of the phase 3 patch for Oracle HRMS (South African) SARS PAYE BRS

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.

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...

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...

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...

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...

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!

Announcement for the release of the 2019 Annual Geocode updates for both Oracle US and Canadian HRMS customers.

Announcement for the release of the 2019 Annual Geocode updates for both Oracle US and Canadian HRMS customers.

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...

Announcement that Korea Cumulative Release Patch KR.90 has been released.

Announcement that Korea Cumulative Release Patch KR.90 has been released.

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...

Announcement for US Payroll Customers indicating that Q2 2019 Statutory Update Patch is now available for Release 12.1 and R12.2.

Announcement for US Payroll Customers indicating that Q2 2019 Statutory Update Patch is now available for Release 12.1 and R12.2.

Oracle EBS patch release announcement for Republic of Korea - New Simple Earnings Report.

Oracle EBS patch release announcement for Republic of Korea - New Simple Earnings Report.

Announcement: New Zealand Payday Reporting of Employee Details is now available!

Announcement: New Zealand Payday Reporting of Employee Details is now available!

Announcing a Oracle Advisor Webcast on August 7th, 2019, EBS HCM Meet the Experts

Announcing a Oracle Advisor Webcast on August 7th, 2019, EBS HCM Meet the Experts

Announcement for Employees State Insurance (ESI) Contribution 2019 changes.

Announcement for Employees State Insurance (ESI) Contribution 2019 changes.

Announcement for the new Oracle EBS Order to Cash E-Business Tax Analyzer.

Announcement for the new Oracle EBS Order to Cash E-Business Tax Analyzer.

EBS HCM payroll announcement of an Australia Statutory updates effective July 1, 2019 patch.

EBS HCM payroll announcement of an Australia Statutory updates effective July 1, 2019 patch.

Announcing a Oracle Advisor Webcast on June 20th, 2019 Oracle Advisor Webcast on Person Termination and Implication in EBS HCM

Announcing a Oracle Advisor Webcast on June 20th, 2019 Oracle Advisor Webcast on Person Termination and Implication in EBS HCM

Patch announcement for India Form 24Q File Format Changes and India Form 16 Format Changes for Financial Year 2018-19 Patches

Patch announcement for India Form 24Q File Format Changes and India Form 16 Format Changes for Financial Year 2018-19 Patches

Does your Open Account Balances Report not balance to Aging - 7 Bucket By Account Report? The two reports are not intended to be reconciled.  This is designed functionality. The issue is with the Open Account Balances Report.  This report will always only display the original open amount. For further information, reference: DocID 1486236.1 Reconciliation Report Issue: AR Open Account Balances Listing Report - XLATBRPT Shows Remaining Amount Always With Original Amount   Open Account Balances Report Aging - 7 Bucket By Account Report Identifies General Ledger accounts with outstanding balances and displays the subledger transactions that contribute to that balance. This report provides GL account information and automatically displays invoice details. Users define the accounts to be tracked in report. Receivables also gives you the option to age or summarize on-account credits, unidentified payments, and on-account and unapplied cash amounts.   Users can create their own layout and publish their reports using Oracle XML Publisher. The aging reports are sorted by company with each item allocated to a company.    

Does your Open Account Balances Report not balance to Aging - 7 Bucket By Account Report? The two reports are not intended to be reconciled.  This is designed functionality. The issue is with the Open...

Announcement for Release 12.2 HRMS RUP13 for EBS HCM Clients

Announcement for Release 12.2 HRMS RUP13 for EBS HCM Clients

FOR FINANCIAL ACCOUNTING HUB (FAH) APPLICATIONS ONLY, the "Overwrite" option has been removed from the Application Accounting Definition (AAD) Import application since RPC5.   The 'Overwrite' option has been replaced with 'Purge Application Accounting Definition Setup'. When 'Purge Application Accounting Definition Setup' parameter is set to "Yes" then: • The existing AAD is cleared. Before the clearing the existing AAD is exported to the directory specified by newly added parameter "Destination Directory Path", • The new AAD is imported. This functionality is equivalent to the "Overwrite" option. So, when using, you should be able to import older versions of AAD’s. Example: PARAMETERS   AMB Context Default Source File Path name <full path to your file being imported> Merge Analysis No Import Option Merge Validate No Purge Application Accounting Definition Setup Yes Destination Directory Path <full path to a directory where the old ADD to be saved> Purge Application Accounting Definition History No Note: These parameters are greyed out for seeded applications. There is no change in existing functionality for seeded applications.) For further information, please review How Can Financial Accounting Hub (FAH) Customers Overwrite the Existing Application Accounting Definition Version with a Lower Version? Doc ID 2032771.1  

FOR FINANCIAL ACCOUNTING HUB (FAH) APPLICATIONS ONLY, the "Overwrite" option has been removed from the Application Accounting Definition (AAD) Import application since RPC5.   The 'Overwrite' option...

The Advanced Collections team is proud to announce the release of our first analyzer.  The EBS Advanced Collections Analyzer is available to download today DocID 2536952.1 This analyzer provides immediate analysis and output for Advanced Collections, Universal Work Queue, Dunning and Strategy data from a particular environment.  The analyzer displays factors that can adversely affect Advanced Collections run time data such as: Missing critical RPC patches and known fixes Missing required setups for Resources and Collectors Missing or incorrect data from the AR/IEX summary tables Scoring setup Dunning Plan seutp Strategy setup This analyzer also provides: Advanced Collection RPC levels Collections and related profile options settings AR and IEX summary table information and action plan to resolve Scoring definitions and scoring data Dunning definitions and customer specific dunning data Strategy related definitions, assignments, and data integrity checks Recommended actions and best practices The Advanced Collections and Receivables team is striving to enhance all analyzers to cover as many scenarios and provide as many solutions as possible.  Be sure to help us by sharing your comments, suggestions or questions on our analyzers by clicking on the Feedback button in the top right of the your analyzer output as shown below.

The Advanced Collections team is proud to announce the release of our first analyzer.  The EBS Advanced Collections Analyzer is available to download today DocID 2536952.1 This analyzer provides...

Please join us for an informative and engaging session for Understanding the Transfer of Data Between Subledger Accounting (XLA) & General Ledger (GL).  This one-hour advisor webcast is recommended for functional users who would like a better understanding how data flows from SubLedger Accounting (XLA) to General Ledger (GL). Topics Include: Create Accounting vs Online Accounting Process of Records (Detail vs Summary) Transfer Journal Entries to GL Process GL to Subledger Accounting (XLA) - How to find what processed Q & A session at the end. We look forward to you  being online with us for this event  ! Dates and Times: Wednesday, June 19, 2019 08:00 AM (US Pacific Time) Wednesday, June 19, 2019 11:00 AM (US Eastern Time) Wednesday, June 19, 2019 05:00 PM (Central European Time) Wednesday, June 19, 2019 08:30 PM (India Standard Time)   Register to Join Us at this event  

Please join us for an informative and engaging session for Understanding the Transfer of Data Between Subledger Accounting (XLA) & General Ledger (GL).  This one-hour advisor webcast is recommended...

Announcement for Release 12.1 HRMS RUP12 for EBS HCM Clients

Announcement for Release 12.1 HRMS RUP12 for EBS HCM Clients

In today’s world, for any business organization which could be a small business organization or an MNC, generating reports for management reporting or for tax authority / compliance reporting is one of the major task. In Oracle application, we have many standard reports to extract the different set of data in each of the subledgers that you are using. However these standard reports will have fixed format / columns and they cannot be modified / changed to meet the reporting requirement of the organization. This restriction of standard report, can be over come by using Rxi reports. In Rxi reports all formatting and column information is defined and maintained in attribute sets. Each RXi report comes with one or more attribute sets / Predefined columns. You can use these attribute sets window to view columns available in the rxi report and you can also add and substract columns for each of these pre defined rxi reports  in the format and data that your company need. From fixed asset point of view, for most of the fixed format reports, we have parallel rxi reports which means you can view and manipulate the report data in the desktop application of your choice. For example, you can download the information into Microsoft Excel and sort, analyze, and manipulate the report data using familiar spreadsheet features. You can also format the report as an HTML file and place it on your Web server or directly into the database for general access. For more information on the list of Rxi reports available in fixed assets, how we can modify / change the attribute sets of these reports etc. refer document 2237957.1.

In today’s world, for any business organization which could be a small business organization or an MNC, generating reports for management reporting or for tax authority / compliance reporting is one...

Recently a new Cumulative patch is released for the Property Manager IFRS and Equipment leasing solution. The patch details are 12.1.3 - 29789413:R12.PN.B 12.2.X - 29789413:R12.PN.C In the above cumulative patch, in addition to few regular bug fixes, few major enhancements are also done to the product. Below is the a quick glimpse of those enhancements Linking of Payment 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 when ever 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.   When a new payment term is added as a replacement of outgoing payment term(contracting), the applications treat them as different terms. As a result, the ROU balances are not carried forward +/- remeasurement value and instead, the ROU balance is recalculated. As a result of recalculation of Liability, the re-measurement amount is not captured but in its place Liability/ROU are calculated afresh from the new term. To over come this issue, we have released a new API to link an existing payment term to a new payment term that is being added. The API will end date the existing payment term and will create a new payment term with reference to the existing payment term that is being end dated. Cancellation of Options :- Currently once an option is created which is not yet exercised, we can only terminate the option to reverse the effect of it on ROU and Liability balances. Going forward we can cancel an option which is in future date and not yet exercised. Multiple Amendments api for Equipment Leases :- The amendment API for equipment lease has been enhanced to handle multiple amendments in the same period. Going forward, we can perform multiple amendments on a lease not only via application, the same can be done via API as well. In addition above major enhancements, we have also enhanced the lease expense calculation while performing an amendment. For more details on these enhancement, refer the Property Manager IFRS & Equipment lease Info center Document 2482062.2 .

Recently a new Cumulative patch is released for the Property Manager IFRS and Equipment leasing solution. The patch details are 12.1.3 - 29789413:R12.PN.B 12.2.X - 29789413:R12.PN.C In the above...

Is your Aging - 7 Bucket by Account Report not matching with your India-Debtor Trial Balance Report? Are you using any localizations, such as India Localization? These two reports are not designed to tally, AR Aging Report may not match with India-Debtor Trial Balance Report due to Localization issues.  India debtor Trail Balance will capture the transactions where they are having India Localization Taxes. Whereas Aging Report will capture all the AR Related transactions. Some information on the AR Aging Reports: Provides data on outstanding Receivables as of a specific date Reports customer information in Detail and Summary modes Shows current and past due transactions for invoices, debit memos and chargebacks Choose to age or summarize credits and payments See cash claims (if using Oracle Trade Management) Sort by Company, each item allocated to a company Excludes customers with zero balances So Reconciliation between this two reports is sometimes not possible due to localization issues not captured in the Aging. For further information, please refer to Doc ID 834176.1 AR Aging Report is not matching with India-Debtor Trial Balance Report

Is your Aging - 7 Bucket by Account Report not matching with your India-Debtor Trial Balance Report? Are you using any localizations, such as India Localization? These two reports are not designed to...

The EBS Order Management Credit Check Analyzer is now Live! You can start using the Order Management Credit Check Analyzer today to help resolve your credit check issues.  The Credit Check Analyzer will assist you in determining if your setups are correct, along with determine if credit check should / should not have run and why. The analyzer is designed for an individual sales order and will obtain the credit check setups, credit check levels for the specified sales order.   It will show the sales order information along with its associated credit information.  The Credit Check Data Analyzer tile will verify credit check data analysis, showing the following: Credit Check Rules Credit Check Phases If credit check should have run If Pre-Calculation Exposure is being used, and if it has run recently If the order is on a manual release hold etc... Along with the above checks, there will be suggestions to follow to assist you in resolving your credit check issue. The Credit Check Analyzer will be added to the Analyzer Bundle.  You can download the Credit Check Analyzer from either of the following documents: EBS Order Management Credit Check Analyzer Doc ID 2493364.1 Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index Doc ID 1545562.1

The EBS Order Management Credit Check Analyzer is now Live! You can start using the Order Management Credit Check Analyzer today to help resolve your credit check issues.  The Credit Check Analyzer...

Check Out the New and Enhanced Oracle Enterprise Command Centers available in Oracle E-Business ERP and SCM Applications.  These 19 Oracle Enterprise command centers (ECC) and 62 role-based dashboards help Oracle E-Business Suite (EBS) users visualize, analyze, identify and act on transactions from interactive screen. They allow you to search, filter and drill down into priority transactions. Patch information: Patch 28779983: Oracle Enterprise Command Center Framework Release 12.2 V2 Quick Install for Linux x86-64.  Available only for  Release 12.2.4 and higher. Readme: Readme Instructions can be found in “Installing Oracle Enterprise Command Center Framework, Release 12.2 V2”, Doc ID 2495053.1. Available 19 Command Centers for EBS: Financials Oracle Receivables Command Center: minimize customer account delinquency, reduce Days Sales Outstanding (DSO), and tailor collection strategy per customer. Oracle iReceivables Command Center: optimize cash outflow for customer users and minimize revenue leakage for internal users. Oracle Channel Revenue Management Command Center: eliminate revenue leakage, improve collections, and increase profit margins. Oracle Payables Command Center: optimize Days Payable Outstanding (DPO) and cash outflow. Improve supplier relationships. Oracle Assets Command Center: speed up period close, forecast and manage capitalization events, and increase asset utilization. Oracle Incentive Compensation Command Center: drive desired selling behavior, minimize overpayment, and improve sales team morale. Oracle Lease and Finance Management Command Center: increase revenue from asset usage, improve billing accuracy, and improve dealer / partner cash flow. Order Management and Logistics Oracle Order Management Command Center: increase customer satisfaction and revenue by accelerating the order flow and quickly acting on order exceptions. Oracle Inventory Management Command Center: optimize order release, expedite high priority orders, and streamline transportation activities. Procurement and Projects Oracle iProcurement Consumer-like Shopping: enable efficient, consumer-like shopping while minimizing non-catalog spend. Deliver customer feedback to drive better contract utilization and renegotiation. Oracle Projects Command Center: efficiently manage and control budgets, costing, accounting, and capitalization processes. Oracle Contract Lifecycle Management for Public Sector Command Center: provide consistent information across teams, improve procurement cycle time, and maintain better contract compliance. Manufacturing Oracle Discrete Manufacturing Command Center: increase the efficiency of manufacturing operations while meeting customer commitments and reducing risk. Oracle Process Manufacturing Command Center: efficiently manage process manufacturing operations and enable preventive and corrective actions. Oracle Outsourced Manufacturing Command Center: gain visibility across manufacturing partners and better manage material replenishment to avoid delays. Oracle Cost Management Command Center: identify transaction costing bottlenecks, resolve costing and accounting errors, and mitigate period close risks. Asset Lifecycle and Service Oracle Enterprise Asset Management Command Center: maximize asset availability, prioritize work order exceptions, and react quickly to material shortages. Oracle Service Contracts Command Center: coordinate contract renewal cycle to increase on-time renewals and improve customer satisfaction. Oracle Service Command Center: mitigate service level agreement risks, identify and act on critical service requests, and provide quality service. Supporting Resources Announcing New and Enhanced Oracle Enterprise Command Centers (PDF) Oracle E-Business Suite Enterprise Command Centers (Video) Oracle Enterprise Command Centers (PDF) Oracle Enterprise Command Center Quick Start Guide (PDF)   For questions regarding the command center for a product area, please interact with others in the E-Business Suite My Oracle Support Community.  If you experience any issues with the patch application or functionality, log a Service request with the corresponding product on My Oracle Support

Check Out the New and Enhanced Oracle Enterprise Command Centers available in Oracle E-Business ERP and SCM Applications.  These 19 Oracle Enterprise command centers (ECC) and 62 role-based dashboards...

Announcement Japanese Payroll Legislation regarding the release of the new Reiwa Era calendar and statutory changes.

Announcement Japanese Payroll Legislation regarding the release of the new Reiwa Era calendar and statutory changes.

Announcing a Oracle Advisor Webcast on May 08, 2019, EBS HCM Meet the Experts

Announcing a Oracle Advisor Webcast on May 08, 2019, EBS HCM Meet the Experts

EBS IN Payroll patches for NPS Changes effective April 1, 2019,

EBS IN Payroll patches for NPS Changes effective April 1, 2019,

  ~Starting Tuesday April 9, 2019~ When you log a new SR for:   Enterprise Edition   Workforce Management   Business Intelligence you will be introduced to 'guided resolution automation' What is 'guided resolution automation' ? > Guided resolutions are intelligent guides to help troubleshoot issues you may be experiencing. > You will be guided thru a series of simple questions that qualify the problem and identify if there is a known solution to that issue. > If a solution is found, it is presented right there. > If a solution is not found or you still wish to create the SR, the information you already provided is captured and entered into the created SR. How does this work? Answer the questions to the best of your knowledge. 1. Be as specific as you can in the free text boxes (names of instances, time of occurrence, URLs) 2. Avoid entering N/A or DK; please provide details 3. Use 'Just have a question' very judiciously If you need to make a change, click Edit: What benefits to guided resolutions offer? * an opportunity for customers to quickly locate (self-service) resolutions to known issues * improved quality of SR logged * provide value added information & data collection to analyst receiving the SR to improve time to resolution * automatically check your problem against a database of solutions, then provide you with a corresponding match * consistent data collection, no matter where the issue gets logged Help us make it better, please provide feedback For additional details on the SR Automation process, refer to Doc ID 1998077.1

  ~Starting Tuesday April 9, 2019~ When you log a new SR for:   Enterprise Edition   Workforce Management   Business Intelligence you will be introduced to 'guided resolution automation' What is 'guided...