Monthly Archives: September 2021

AP Open invoice extract in EBS

Introduction: This script will extract the AP open invoices select aia.invoice_num, aia.invoice_currency_code, DECODE(aia.PAYMENT_STATUS_FLAG,’N’,’UN-PAID’,’P’,’Partial Paid’,’Y’,’PAID’) PAYMENT_STATUS_FLAG , aia.invoice_date, aps.vendor_name, apss.vendor_site_code, aila.line_number, aia.invoice_amount, aila.amount line_amount, pha.segment1 po_number, aila.line_type_lookup_code, apt.name Term_name, gcc.concatenated_segments distributed_code_combinations,…

Read More

Drag and Down Using Oracle Apex

1.        Overview This document explains how to create a Drag and Down the rows using Oracle APEX. 2.        Technologies and Tools Used The following technologies has been used to achieve…

Read More

Allow Only Number and Decimals Using Jquery in Oracle Apex

1.        Overview This document explains how to Allow only Numbers and Decimal Using Jquery in Oracle APEX. 2.        Technologies and Tools Used The following technologies has been used to achieve…

Read More

Table Function to return look up value for LOV’s In Oracle Apex

1. Overview This document is about table function to return lookup values For LOV’s in oracle apex. 2. Technologies and Tools Used The following technologies have been used for table…

Read More

Sales Order Warranty Item Setup

SALES ORDER Warranty Item Setup STEP BY STEP Process STEP1: Create Warranty Item Navigation : Inventory -> Item -> Master Item CREATE A NEW WARRANT ITEM CODE HS-T7PSWAR-03 ITEM MASTER…

Read More

How To Add row from another report in Interactive Grid using JavaScript

1.  Overview This document is about Interactive Grid – Add row from another report using JavaScript in oracle apex. 2. Technologies and Tools Used The following technologies have been used…

Read More

Oracle Apex Detect Multiple Browser Tabs

1. Overview This document is about to detect multiple browser tabs in oracle apex. 2. Technologies and Tools Used The following technologies have been used to detect multiple browser tabs.…

Read More

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 More

Classic 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 More

Blanket 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 More