Monthly Archives: September 2021

Adding Dialog Confirmation alert In Oracle Apex Using JavaScript

OverView This document talks about how to add a confirmation dialog alert in oracle apex using JavaScript.  We are going to add a confirmation dialog alert using apex.message.confirm() JavaScript method. Technologies…

Read More

How To Setup And Use Approval Management Engine AME For Purchasing Documents

How To Setup And Use Approval Management Engine AME For Purchasing Documents Assign AME access to users Assign AME Roles and Responsibilities AME responsibilities in 11i.AME.A are assigned directly to…

Read More

Inline External Tables

Overview Inline external tables enable the run time definition of an external table to be part of a SQL statement, thus eliminating the need to create an external table as…

Read More

Loading CSV Files from External Tables

Overview This topic provides examples of how to load CSV files from external tables under various conditions. Some of the examples build on previous examples. Technologies and Tools Used The…

Read More

19C LISTAGG DISTINCT

Overview The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword. The LISTAGG aggregate function orders the rows for each group in a query according to…

Read More

Difference between PO Closed and PO Finally Closed

Difference between PO Closed and PO Finally Closed We can open a closed purchase order but you cannot take any control action on Finally Closed POs. The system automatically closes…

Read More

When Importing Internal Requisitions getting Error Item is missing or invalid

Error ‘Item is missing, invalid, or not internally orderable’ When Importing Internal Requisitions When attempting to import internal requisition lines, the following error occurs : ERROR —– Item is missing,…

Read More

Oracle APEX Chart Conditional Bar Colors

Overview This document explains how to to change the chart bar colors based on the conditions in Oracle APEX. I will be very useful when we want some one Technologies…

Read More

AR Interface Issue Transaction Currency Payment Method Setup

Sales Order Transaction Currency not Associated with Payment Method Currency – Solution Setup Step 1:Navigation : AR IE Manager -> Control -> Auto Invoice -> Interface Line STEP 2 :Navigation…

Read More

View Accounting Function is Not Available in Receiving Transactions Summary

Module – Oracle Purchasing While attempting to view the accounting information from View Receiving Transactions of Inventory Receiving, the following error occurs: Error: Function not available to this responsibility. Change…

Read More