How to wrap PL SQL Code in Oracle
1. Overview This document is about how to wrap the PLSQL code in oracle. 2. Technologies and Tools Used The following technologies have been used to wrap the PLSQL code.…
Read MoreClassic Report Filter Option in Oracle Apex
1. Overview This document is about how to add filter option in classic report in oracle apex. 2. Technologies and Tools Used The following technologies have been used to wrap…
Read MoreBlanket Purchase Agreement Using AME, Stuck an Incomplete Status
The Document Type of Blanket Purchase Agreement (BPA) fails using the Approval Management Engine (AME) Approval. • The AME rule has been set up and is used both for Standard…
Read MoreAdding 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 MoreHow 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 MoreInline 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 MoreLoading 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 More19C 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 MoreDifference 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 MoreWhen 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