Deep Linking in Oracle APEX :
Deep linking refers to the ability to link to an Oracle Application Express page out of context . When you link to a page out of context and the application…
Read MoreWord Wrap in APEX IR:
One of the common problems with APEX IR is word wrap. Add the below code in Column formatting in column attribute: <table style=“word-break: break-all; width:100px”> <tr> <td >#COLUMN_NAME# </td> </tr> </table>
Read MoreAPEX – Report Rows Clickable to detailed page
Overview: 1. Purpose. 2. Benefits. 3. Steps 4. Conclusion. 1. Purpose: This document describes how to make a Apex Reports clickable to detailed page with an option of entire row selection. In Apex,…
Read MoreFreeze Columns in Tabular Form/ Report (Classical Report)
Today I would like to share “How to Freeze/Fix Column Header Row of a Classic Report” which I found very useful when the number of report columns/rows are more per…
Read MoreItem Category Conversion Categoriesare the method …
Item Category Conversion Categories are the method by which the items in inventory can be separated logically and functionally for planning, purchasing and other activities.You can use categories and category…
Read MoreCustomer Item Cross Reference Conversion
Customer Item Cross Reference Conversion A Customer Items are Item Numbers used by customer for the items you sell to your customers. Customer Item numbers are customer specific, so you…
Read MoreQuery to get the Outstanding Amount of Customers in Project Accounting
SELECT ar.customer_number “CUSTOMER NUMEBR”, ar.customer_name CLIENT, (arp.amount_due_original – arp.amount_due_remaining ) “PAID AMOUNT”, (TRUNC(sysdate) -rac.trx_date) +1 “DAYS OUTSTANDING”, rac.trx_number “INVOICE NUMBER”, rac.trx_date…
Read MoreShell Script to Migrate our Technical Components during Migration
Shell Script to migrate all technical components in a single step The below query will help us to migrate all the components from one instance to another instance. Basically we…
Read Moreperformance of functions -12C
Oracle Database 12c includes two new features to enhance the performance of functions when called from SELECT statements. With Oracle 12c, a PL/SQL subprogram can be created inline with the…
Read MoreCalculate PO Balances
— Query to retrieve customer PO details SELECT obha.order_number, obha.sold_to_org_id, obha.cust_po_number, obha.header_id, obha.org_id, TO_DATE (obha.attribute16,’YYYY/MM/DD HH24:MI:SS’) po_last_calc_date, …
Read More