Posts by Venkatesh Balasubramanian

Query for AR Transactions Header with GST

Introduction This Post is about to AR Transactions Header with GST Query.   SELECT DISTINCT rcta.trx_number, rcta.ct_reference, lep.legal_entity_id, lep.NAME legal_entity, rcta.trx_date invoice_date, –Bill to location details hp.party_name bill_cust_name, hcs1.LOCATION bill_to_loc, RTRIM (hrl.address_line_1, ‘,’) Billadd1, RTRIM (hrl.address_line_2, ‘,’) Billadd2, RTRIM (hrl.address_line_3, ‘,’) Billadd3, RTRIM (hrl.loc_information15, ‘,’) Billadd4,…

Read More

CAPTURE LOG (LOGIN, LOGOUT, SESSION, SYSTEM) DETAILS IN ORACLE APEX 4.2

Description: User Log Reports provides detailed information about the users’ login details along with their history. These reports are more accurate and also provides the details of the user, their…

Read More

HOW TO PLAY VIDEOS IN ORACLE APEX 4.2

Description: Viral advertising is a proven technique that will assist in enhancing your enterprise internet presence in a really Expense-powerful manner. It is a marketing activity in which information about a products spreads between people, especially on the internet. This technique allows you to play…

Read More

DYNAMIC DATE RANGE IN APEX DATEPICKER

Description: Using this method, you can set the range of selectable dates by entering a Minimum and Maximum Date value dynamically “real-time.” Step 1: Create a Page Item (Example: “P101_DATE”). Step 2: Go to Settings -> Minimum Date In Minimum Date, valid condition has…

Read More

COORDINATE MAPPING IN ORACLE APEX

Description: Line coordinates are used to specify the position of a line just as point coordinates (or simply coordinates) are used to specify the position of a point. Users can draw multiple lines on an Apex Image Item, and the Coordinates of all the drawn lines can be obtained and stored in the Database Table. This…

Read More

RUPEE SYMBOL IN REPORTS IN ORACLE APEX 4.2 USING HTML

Description: Most of the Applications includes Accounts Reports like Employee Payroll Reports, Company Purchase Reports, Invoice Reports, etc.  Now using this method user can add RUPEE symbol in your reports.…

Read More

DYNAMICALLY ADDING ROWS IN TABULAR FORM IN ORACLE APEX 4.2

Description: A good web design involves the better user interaction and the ability to fetch the data in a better way. In Tabular Form, the user can add rows only…

Read More

ADDING A FAVICON TO APEX

Description: A Favicon (Favorite Icon), also known as a Shortcut Icon, Web site Icon, Tab Icon, or Bookmark Icon, is a file containing one or more small icons, associated with…

Read More

Restrict Copy Paste & Right Click In Apex Page

Description: The purpose of this component is to restrict the copy option from the user level of apex page. SCENARIO : Consider in our apex application we are providing any confidential message or data that should not be copied by the user level;…

Read More

Apex.server.process

Description: This function calls a PL/SQL on-demand process defined on page or application level. It’s a wrapper of the jQuery.ajax function and supports all the setting the jQuery function provides but…

Read More