Blank Row Restriction in Oracle APEX
Description: Blank Row Restriction is to avoid unwanted addition of rows in detail report (tabular Form) when a blank row already exists. This functionality can be achieved by Javascript. It…
Read MoreAvoid wrapping of fields in APEX Interactive reports
Description: Due to many columns in the report, the Data will be wrapped automatically. Resolution: In report attributes, assign the static ID for the column that you want not…
Read MoreAPEX – Report Rows Clickable to detailed page
Description: This document describes how to make an Apex Reports clickable to a detailed page with an option of entire row selection. In Apex, Report is an important…
Read MoreHow to JQuery Id selector in ADF
Description: The ADF components will render with some mixed special characters. For this case, if you want to find the id, We need do add ‘\\’ before to the special character. Example: ADF Actual Rendered ID:pt1:r1:0:pgl13 JQuery ID selector: $(“#pt1:r1:0:pgl13”);———-It doesn’t work $(“#pt1\\:r1\\:0\\:pgl13”)——-It works. Summary: The…
Read MoreAR Receipt Query: AR XLA GL
Description: The below steps describe the responsibilities to check the AR Receipt Query on AR XLA GL. SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product,…
Read MoreHow to Set Interactive Report Filter with URL Parameters
Description: Interactive Reports are very powerful; the end-user can set filters, highlighting, add computed columns, do control breaks or groupings, and much more. As a Developer, you might sometimes have…
Read MoreAR Receipt Distribution Query: AR XLA GL
Description: The below process explains the responsibilities of AR Receipt distribution query on AR XLA GL SELECT glcc.segment1 co, glcc.segment2 loc, glcc.segment3 cc, glcc.segment4 acct, glcc.segment5 prod, glcc.segment6 chan,…
Read MoreHow to Highlight Tabular Form Rows on addition from Pop-up
Description: This is often used to show additional information about a row, particularly when you wish to convey more information about a row than there is space for in the…
Read MoreAR Receipt Distribution Query: AR XLA GL
Description: The below process explains the responsibilities of AR Receipt distribution query on AR XLA GL SELECT glcc.segment1 co, glcc.segment2 loc, glcc.segment3 cc, glcc.segment4 acct, glcc.segment5 prod, glcc.segment6 chan,…
Read MoreAR Adjustments Query: AR XLA GL
Description: The below post explains the code and step to create AR Adjustments Query of AR XLA GL SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product_line,…
Read More