Yearly Archives: 2021

How to Use Apex Collection

Overview Apex Collections (APEX_COLLECTION) is a package that comes with Oracle Apex and is one of the most important features that comes with Oracle APEX. Each member has a sequence…

Read More

Custom Interactive grid manual process

1. Overview This document explains how to call/invoke manually interactive grid process . 2. Technologies and Tools Used The following technologies have been used to validate IG columns. Oracle Apex 3. Use Case…

Read More

System variable to get current language by default in Oracle Fusion BIP report

Objective : Sometimes having a requirement to build the BIP report to display records other than English (ex: Arabic, French, German etc).  In Order to build such a report, you…

Read More

How to add Cross validation Rule In GL ?

Navigation -> GL –> Setup -> Financials -> Flexfields -> Key -> Rules Search  Application Names. Query the CVR Name Enter the Code Combination values. Click on Save.   Thanks!…

Read More

How to add security Rules In GL ?

Define Security Rules: Navigation: General Ledger –> Setup –> Financial –> Flexfields –> Key –> Security –> Define. To define security rules: 1. Navigate to Define Security Rules window. 2.…

Read More

Oracle unveils Next-Gen Autonomous Data Warehouse

In what can be seen as a significant step towards customer empowerment with regards to data, Oracle unveiled the next-generation update of Autonomous Data Warehouse last week. The latest enhancements…

Read More

How to give the approval limits by user in AR

How to give the approval limits by user in Increase decrease in AR Navigation :-  AR Responsibility >>> Transaction>>> approval limits… mandatory parameters: User name >>> Document type >>> Source…

Read More

HOW TO ADD UNAPPLIED RECEIPTS REASON CODES TO BE ADDED SETUP IN ORACLE APPS

To achieve this we need to follow the below steps: Login with AR SuperUser Navigation: Collections>>Account Details Click on Account Details . One New Window will Display & Give the…

Read More

Goldengate Replication for a US-based Client

Goldengate is an Oracle product that allows organizations to replicate and transform data between databases. It synchronizes data in real-time and also works in heterogeneous environments. Goldengate is a helpful…

Read More

AP Payment status showing unprocessed in oracle apps

AP Payment status showing unprocessed in oracle apps   1>>> Check account status unprocessed ,it showing period exception reports   2>>> Check invoices status is accounted or not. 3>>> Check…

Read More