My Portfolio

Hi, I am going to explain you about the customization of Account Generation Processes/Account generator workflows in various modules in Oracle Applications. For all modules the basic profile option to run account generator workflow is "Account Generator:Run in Debug Mode". So Set the profile "Account Generator:Run in Debug Mode" to "Yes" Account Payables:  Workflow Name: Project Supplier Invoice Account Generation Process  Internal Name:      PAAPINVW    If the new invoice is created in the AP module (Oracle Payables  à  Invoice  à  Entry  à  Invoices) with the Project details. OR Invoice has interfaced from the other module like i-expense with Project details, we should definitely customize the ‘Project Supplier Invoice Account Generation Process ( PAAPINVW.wft )’ workflow to create account in distributions. What will happen if the workflow is not customized?     ...

B.2.20  How to Configure GL Account and GL Segments for Oracle E-Business Suite This section explains how to configure General Ledger Account and General Ledger Segments for Oracle E-Business Suite, and contains the following topics: Section B.2.20.1, "Overview" Section B.2.20.2, "Example of Data Configuration for a Chart of Accounts" Section B.2.20.3, "How to Set Up the GL Segment Configuration File" Section B.2.20.4, "How to Configure GL Segments and Hierarchies Using Value Set Definitions" B.2.20.1  Overview If you are deploying Oracle Financial Analytics, Oracle Procurement and Spend Analytics, or Oracle Supply Chain and Order Management Analytics, then you must configure GL account hierarchies as described in this topic. Thirty segments are supported in which you can store accounting flexfields. Flexfields are flexible enough to support complex data configurations. For example: You can store data in any segment. You can use more or fewer seg...

You must configure GL account hierarchies if you are deploying Oracle Financial Analytics, Oracle Procurement and Spend Analytics, and Oracle Supply Chain and Order Management Analytics. For information on how to configure Hierarchies using GL Accounting flexfields value sets definitions, see  Section B.2.20, "How to Configure GL Account and GL Segments for Oracle E-Business Suite" . If you need to define GL account hierarchies based on multiple segments within a chart of accounts, then you can use the Oracle FSG report definition in E-Business Suite to define them. You should first use the Oracle FSG form to define a row set or a column set, then Oracle BI Applications will extract the row set or column set definition and convert them into hierarchies. Oracle FSG hierarchies are extracted from following E-Business Suite source tables: RG_REPORT_AXIS_CONTENTS This table defines the relationship between the FSG report axis and GL code combinations. The GL code combinations wit...

B.2.8  How to Set Up Accounts Payable Security for Oracle E-Business Suite Financial Analytics supports security over Payables Invoicing Business Unit in Accounts Payable subject areas. This Business Unit is the same as Operating Unit Organizations in E-Business Suite, and the list of Operating Unit Organizations that a user has access to is determined by the grants in E-Business Suite. Configuring Accounts Payable Security In order for data security filters to be applied, appropriate initialization blocks need to be enabled depending on the deployed source system. To enable Accounts Payable security for E-Business Suite, enable Oracle E-Business Suite initialization block and make sure the initialization blocks of all other source systems are disabled. The initialization block names relevant to various source systems are given below. If more than one source system is deployed, then you must also enable the initialization blocks of those source systems. For example: Oracle Fusion A...

You may also face similar issue while upgrading OBIEE to a newer version or if you upgrade some of your dashboards from OBIEE 10.1.3.4 to 11.1.1.5. The issue is that, some of the calculations under certain columns in the reports were showing zeros instead of the calculated values.  The requirement was to calculate a match rate % for some data based on another field that showed 'MATCH' or 'NO MATCH'.   The real-time scenario was (SUM(CASE Table1.Column1 WHEN 'MATCH' THEN 1 ELSE 0 END)/COUNT(Table1.Column1))*100 However, this was returning 0% as the result. With the help of some blogs and questions raised on OBIEE threads I came to know that this happens when you have an integer in a calculation. The solution which I used is very simple and was successful in achieving the requirement. The very easy fix to this issue is to multiply the calculation by 1.0.  The updated calculation which works is shown below and provides a meaningful result. ( don't use 1, as th...

OBIEE 11.1.1.7 has been released by Oracle and they included more than two hundred enhancements, designed to add new functionality for improved performance and deliver an enhanced end user experience. The major features and enhancements are listed down based on my reading and collection from various online portals and articles. Check it out!!! 1. New UI Features: a. New graphs:  Performance Tile, Waterfall, and 100 percent stacked bar b.Breadcrumbs: A feature taken from Endeca Breadcrumbs have been added to help users understand their current location within Oracle BI content and the path that they have used to navigate Oracle BI content. Breadcrumbs display at the bottom of the page, and users can click a breadcrumb or the breadcrumb overflow button to navigate to a specific location on their breadcrumb trail. c. Enhancement to Dashboards  - This release provides the following enhancements to dashboards: The ability to create custom print layouts for high-fidelity printi...