Posts by Doyensys

Using Oracle Forms to load local files

using the below code In load file “button” using “when-button-pressed” trigger. DECLARE    l_userhome            VARCHAR2 (200)          := webutil_clientinfo.get_system_property (‘user.home’)             || ‘Desktop’;    l_filename            VARCHAR2 (200) := NULL;   …

Load JSON File to Oracle table

For Example : 1)  Sample Json:- {   “department”: {     “department_number”: 10,     “department_name”: “ACCOUNTING”,     “employees”: [       {         “employee_number”: 7782,         “employee_name”: “CLARK”       },      …

Punchout in Oracle iProcurement

Punchout in Oracle iProcurement   Punchout is an Oracle standard functionality to purchase an item directly from supplier’s website by a requester.In this feature, the supplier catalogue contains latest product…

Personalization at Adjustment/Sales order/Credit Memo application form

This component can be used, for requirement related to personalization where we want to restrict the user to create RMA/Adjustment/Credit memo if certain(user defined) conditions are not met. Personalization at Transaction/Adjustment…

Create AR Transaction/Invoice adjustment(API)

Scope: To apply the adjustment in AR Invoice. (eg. To make AR Invoice amount roundoff). Before RoundOff adjustment API. Applying Adjustment through API. —++———————————-Code—————–++————————- DECLARE up_adj_rec         …

Opening Modal Dialog page using JavaScript

In APEX, when there is a requirement for opening pages dynamically JavaScript must be used. Normal pages can be easily opened in JavaScript’s by mentioning the URL using window.location, but…

Hiding Hidden column cells in IR using CSS

Select List Pagination in APEX IG

One main disadvantage of APEX Interactive Grid is the pagination. IG default pagination doesn’t have the option as classic Select List Pagination, instead it has page by page selection with…

Refresh IG on Region Display Selector Activation

Interactive Grid region within the region display selector must be refreshed every time on click/activation of the region display selector. This can be achieved by using the below code there…

Displaying Processing Spinners in APEX AJAX Process

When a process is called in APEX page without page submission (AJAX Process), user will have no visual feedback that something is happening. For example if an AJAX (apex.server.process) “EMP_INSERT”…