Oracle.Yash

  APEX Reports have a horizontal scrollbars positioned at the bottom of reports. This can prove as a difficulty to users if the report has too many rows. Solution - A dd Scrollbar at the top of Interactive Report using CSS  Follow the link for detailed video -  https://youtu.be/M_iz6wzQ0Xg CSS : #STATIC_ID .t-fht-thead {   overflow: auto !important; } The CSS works as below -  t-fht-thead -  Header of the report overflow: auto - Property #STATIC_ID - static id of the IR   Sample Image -  

Let’s discuss some key parameters frequently used in fusion REST APIs.   Let's use the following API endpoint as our reference throughout -   /fscmRestApi/resources/11.13.18.05/invoices   Query Parameters: 1)      Expand Fields like invoiceDFF, invoiceLines are not fetched by default in this API. The Expand parameter allows fetching additional fields. Fields that are usable in parameter – invoiceLines invoiceGdf invoiceDff invoiceInstallments attachments appliedPrepayments availablePrepayments   Example – Put this string in Bulk edit: expand:appliedPrepayments,invoiceDff,attachments,availablePrepayments,invoiceGdf,invoiceInstallments,invoiceLines     2)      Fields Fetch any Specific field that you want. Including Expand fields mentioned above.   Example – Put this string in Bulk edit: -  fields:InvoiceId,InvoiceNumber,invoiceDff   3)      Limit Limit the number of rec...

 We can use this feature to notify users of downtime during updates. Steps -  1)  Setup and Maintenance > Search 2) Search %Manage%Profile%. Then Select Manage Administrator Profile Values . 3) In Profile Display Name search for %Banner% . Now in Profile options select FND_BANNER_MESSAGE. 4)   Click on + sign and add a new Value. Set it to Site Level. 5) Write your custom message in Profile Value field.  Now select Save and Close.  NOTE - You have to Logout and Login again for the changes to be visible. REVERT CHANGES 1)   To revert the changes, delete the Profile value under  FND_BANNER_MESSAGE using x icon. 2)   Select Save and close and Logout and Login again.

Encountering precision problems in Excel is a common frustration. This issue happens because Excel tends to round off digits beyond 15 digits.  Refer the video below -  As we can see  10000231170000999 gets converted into  10000231170000900 To solve this issue, we need to adjust the format of the affected column in our template. In our case its Invoice Number. 1) Open the Report Template > Select the Invoice number field.  2) Navigate to Home > Number > Select 'Text' from dropdown.

In this post, lets discuss the process of mailing or bursting an OTBI report to business users. Much like BI report bursting, this functionality enables you to customize the mail subject, body, output file format and mail recipients.   Supported Formats by OTBI -  HTML,  Plain Text,  CSV,  Tab Delimited,  Excel,  PowerPoint,  PDF   Step 1 - Select a recipient to  schedule with and set a mail frequency : 1) Go to the OTBI Report you want to Mail. Navigate to More > Schedule > General. 2) Select a User ID/Name to execute the agent. 3) Set the desired mail frequency (once/daily/weekly/monthly). You can optionally specify an end date.   Note - Condition Tab is set by default. The condition in below screenshot checks whether the report is generating any output or not.   Step 2 – OTBI Report Selection and Email Customization: 1) Choose "Analysis" from the content tab dropdown and locate your OTBI Analysis. 2) Customize th...

In this post, I'll walk you through the process of converting your CSV File data into application within Oracle APEX. You can find a sample CSV file here : Sample CSV File   For a walkthrough of the steps involved, refer to the following yt video tutorial -   Oracle APEX Application Creation Tutorial Key Points: 1)       Your data inside the file gets inserted into a table within Oracle APEX/Any Database you have linked. Additionally, you have the flexibility to either create a new table or update existing data within a table. 2)       APEX allows you to set the data types of each column according to your specific requirements, ensuring optimal data handling. 3)       Interactive Report, Search Report and Dashboards are automatically created within the application.    

Let's embark on our journey to Oracle Apex application development! Firstly, we dive into the creation process of an APEX application. If you're new to this or need a refresher, check out the YouTube tutorial on my channel that walks you through the steps: Creating a New APEX Application Let's add some flair and customization! Here are a few tutorials to get you started: 1)    Customizing Application Name and Logo -  Want to personalize your application's identity? Learn how to change the application name and logo with this guide: Changing Application Name and Logo 2)  Enhancing Navigation Menu Style -   Navigation menus play a crucial role in user experience. Apex provides various options for Navigation menu. Changing Navigation Menu Styles 3)  Changing Application Themes and Global Notifications -   Change the look of your application by altering its theme to match with your organizations theme and logo.  Adding global noti...