People and Culture Blog

Validation Based on Row Value in Interactive Report

1. Overview This document will be helpful to validate interactive report column value using dynamic action. 2. Technologies and Tools Used The following technologies have been used to achieve this functionality, SQL Javascript 3. Use Case I had a situation to restrict the user input based on the “helpline” column,…

Read More

Updating InteractiveGrid using JSON

1. Overview This document will be helpful to update interactive grid data using JSON without using an automatic process or manual process. 2. Technologies and Tools Used The following technologies have been used to achieve…

Read More

How To Dynamically Hide Inbuilt Success Notification On Click Download In Interactive Grid

1. Introduction In this blog, we will learn how to hide inbuilt success notification on click download in interactive Grid. The following technologies has been used to achieve the same.…

Read More

Custom Checkbox Behavior in Oracle APEX Interactive Reports

1.Introduction In Oracle APEX, interactive reports are typically used for reporting purposes, as opposed to interactive grids, which allow for direct modifications to the database. However, there are situations where…

Read More

Dynamically Hide/Show IG columns based on LOV in Oracle APEX

1.Overview This document explains about how to dynamically hide and show Interactive grid columns based on list of values in Oracle Apex 2.Technologies and Tools Used The following technologies has…

Read More

How to save multiple blob response into database table using java script(API&Promises) and AJAX callback in Oracle APEX

1. Overview This document explains about how to fetch response and save multiple blob contents into database table using JavaScript API & Promises and AJAX callback from server in Oracle…

Read More

Optimal utilization of Custom SLA can eliminate delays in Month-end closings

Optimal utilization of Custom SLA can eliminate delays in Month-end closings   Introduction/ Issue:  Effective utilization of Sub ledger Accounting can help eliminate delays in month-end close processes. Sub ledger…

Read More

AR Receipt Un-apply Using SOAP Webservice – Oracle Fusion

Introduction: This blog has the SOAP Webservice details that can be used to Un-apply AR Receipts in Oracle Cloud application. Cause of the issue: Business wants to fix the number…

Read More

Import Auto Invoice – Error Message: You must enter a valid original system bill-to customer address reference. The current reference is {ORIG_SYSTEM_BILL_ADDRESS_REF.

Import Auto Invoice – Error Message: You must enter a valid original system bill-to customer address reference. The current reference is {ORIG_SYSTEM_BILL_ADDRESS_REF.   Introduction/ Issue:  We have an invoice which…

Read More

Restoration job failed in Log shipping

  What is Log shipping?  SQL Server Log shipping is an automatic process that sends transaction log backups from a primary database server instance to secondary databases server on secondary server instances.…

Read More