X

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

Recent Posts

E-Business Suite Support

EBS HCM Meet the Experts Webcast

Please join us on 04-Nov-20 for what is easily one of the most informative and engaging sessions for EBS HCM. This is an open forum webcast that allows you to engage with both Oracle HCM Product Development and Support Leaders as well as your EBS HCM Peers globally. As the end of year is rapidly approaching, this session will focus on our North America Payroll Year End efforts. Additionally, there will be representatives from across the HCM Suite, so please join us to discuss topics related to Payroll, OTL (Oracle Time & Labor), HR (Human Resources), SSHR (Self Service Human Resources), AME (Approvals Management), OLM (Oracle Learning Management), Benefits & CWB (Compensation Workbench). This session will provide a platform for you to provide feedback and receive direction on any of your pressing EBS HCM priorities. Topics Include: North America Payroll Year End General HCM Product Functionality Support Questions Schedule: Wednesday, November 04, 2020 08:00 AM (US Pacific Time) Wednesday, November 04, 2020 11:00 AM (US Eastern Time) Wednesday, November 04, 2020 05:00 PM (Central European Time) Wednesday, November 04, 2020 09:30 PM (India Standard Time) Duration: 1 hr Register for the webcast: https://go.oracle.com/oraclesupportadvisorwebcasts

Please join us on 04-Nov-20 for what is easily one of the most informative and engaging sessions for EBS HCM. This is an open forum webcast that allows you to engage with both Oracle HCM Product...

E-Business Suite Support

Announcement of Oracle E-Business Suite Innovations in 2020

Oracle E-Business Suite 12.2.10 and Other Innovations Announced On Sept. 25, Oracle announced a new release of Oracle E-Business Suite and a number of other innovations: Oracle E-Business Suite 12.2.10: the latest in a series of annual, suite-wide updates (available for all 12.2 releases) Enterprise Command Centers: two releases of new and enhanced Enterprise Command Centers (available for 12.2.4 and higher) G-Invoicing for US Federal Program Agencies: support for more efficient management of intragovernmental buy/sell transactions (available for 12.2.7 and higher) EBS Mobile Release 9: updates to smartphone apps (available for 12.1.3 and all 12.2 releases) HRMS Release Update Pack: annual legislative updates for Oracle Human Capital Management (available for 12.1.3 and all 12.2 releases) EBS Person Data Removal Tool (PDRT): updates to the tool for safely removing sensitive data associated with people in EBS systems (available for 12.1.3 and all 12.2 releases) EBS Cloud Manager for EBS on Oracle Cloud Infrastructure: increased automation to help enterprises run Oracle E-Business Suite on Oracle Cloud Infrastructure (OCI) (available for 12.1.3 and all 12.2 releases)   Additional Resources: Oracle E-Business Suite Product Specific Release Notes, Release 12.2.10 (Doc ID 2666850.1) Oracle E-Business Suite Release 12.2.10 Readme (Doc ID 2666934.1)

Oracle E-Business Suite 12.2.10 and Other Innovations Announced On Sept. 25, Oracle announced a new release of Oracle E-Business Suite and a number of other innovations: Oracle E-Business Suite 12.2.10:...

Fixed Assets

Physical Inventory in Oracle Assets - An Insight

Physical inventory is a critical business process through which a successful enterprise periodically inspects its assets to protect its large capital investments and to comply with auditing requirements. Physical inventory is the process of ensuring that the assets a company has listed in its Production system matches the assets it actually has in inventory. It also ensures that capital assets recorded in the Fixed Asset Accounting and Control System physically exist, determine if unrecorded or improperly recorded transactions have occurred, and identify any excess, defective or obsolete assets on hand. An effective inventory results in an accurate accounting of capital assets, and indicates the reliability of the system of accountability for the acquisition, use, and disposal of those assets.  The frequency of taking an inventory depends on the nature, quantity, and value of the capital assets, and the cost and effort required to perform the procedures. How it works in Oracle Assets Oracle Assets is a worldwide best practice tool which automates the physical inventory process minimizing administrative costs. The Physical Inventory feature in Oracle Assets assists you in comparing and reconciling your physical inventory data. To use the Physical Inventory feature, you must first take physical count of your assets. You need to include the following information about your assets while taking : A unique identifier, which can be either the asset number, tag number, or serial number The location The number of units To know more details on how physical inventory functionality works in Oracle assets, what are all the per-requisite setups required and which reports can we use to reconcile the asset details etc, refer Doc Id 2003290.1

Physical inventory is a critical business process through which a successful enterprise periodically inspects its assets to protect its large capital investments and to comply with...

Property Manager

Introduction to Property / Equipment Lease Command Center

Enterprise application users have access to millions of transaction records and attached documents, yet they are unsure of what to work on next. While there are screens for entering and querying data, there is little to guide users to today’s most important business challenges. Oracle Enterprise Command Center (ECC) extends the owning Oracle E-Business Suite application with discovery-oriented dashboards that bring together diverse operational data from across Oracle E-Business Suite. With tools and visualizations such as actionable indicators, tag clouds, interactive charts, and consumer-like search and filters, users can browse and drill on whatever engages their attention. Oracle Lease Contracts Command Center (PN and Equipment leasing) enables users to quickly identify the areas with a potential problem at a glance within their area of responsibility, narrow down the set of transactions and pick specific transactions requiring attention, and finally take necessary actions. ECC pages will offer users an intuitive experience, with further navigation into Oracle Property Manager or Equipment Leasing application for performing specific actions like creating an amend with rate change, termination  viewing invoices for Receivables and Payables etc. Prerequisite The prerequisites for implementing the Oracle Lease Contact Command center is  Application version 12.2.X   Is available from V4 of ECC For more information on how to implement the V4 of ECC refer Document 2611443.1 Key Benefits Improved reporting with a graphical presentation Easy drill down to each of the compliance numbers Can modify the reporting parameters easily which in turn helps to extract the data based on higher management requirements. Helps in reconciling the balances between Property Manager and General ledger  Identify and act on top priorities without custom operational reporting  Access from any device with high performance and quick user adoption and   Improve data communication with support for a variety of visualizations and charts Dashboards Available Currently Property/Equipment Command Center provides mainly 3 dashboards i.e Lease Balances Lease Details Lease Cost For more information on each of these dashboards, please refer Document 2679613.1

Enterprise application users have access to millions of transaction records and attached documents, yet they are unsure of what to work on next. While there are screens for entering and querying data,...

E-Business Suite Support

Announcement: Oracle Market-Driven Support for Oracle E-Business Suite 12.1

Oracle Market-Driven Support for Oracle E-Business Suite 12.1 Oracle E-Business Suite Release 12.1.3 moves from Oracle Premier Support to Oracle Sustaining Support on January 1, 2022. Oracle Sustaining Support does not provide new fixes, updates or security patches.If you are running Oracle-E-Business Suite Release 12.1.3 and plan to upgrade to Oracle E-Business Suite Release 12.2or move to Oracle SaaS, but cannot complete the transition prior to January 1, 2022, you can use“Oracle Market-Driven Support for Oracle E-Business Suite 12.1”, offered by Oracle Advanced Customer Services (ACS), to bridge the support gap.Oracle Market-Driven Support for Oracle E-Business Suite 12.1canhelp you continue to operate safely and stably while you complete the project to move beyond Release 12.1. Available for 2022 and 2023, the ACS offering includes the following service components not available with Oracle Sustaining Support: Critical fixes, and/or workarounds for newly-discovered product issues resulting in Severity 1 and 2 Service Requests Periodic critical security patches and updates Legislative and regulatory updates, as well as payroll-tax updates for selected countries Click here for the announcement details...

Oracle Market-Driven Support for Oracle E-Business Suite 12.1 Oracle E-Business Suite Release 12.1.3 moves from Oracle Premier Support to Oracle Sustaining Support on January 1, 2022. Oracle Sustaining...

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

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

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

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

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

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

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

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

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

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

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

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