Home › Discussions › Questions & Answers › Validating Custom Development Code in Parameters

Validating Custom Development Code in Parameters

Avatar photoCustomer March 23, 2024 at 5:32 pm

We use the `xxen_util.dff_columns` function in our parameters, but sometimes developers input the wrong Descriptive Flexfield (DFF) table name. Is there a validation report to catch these errors?

Viewing 4 reply threads
  • Author
    Replies
    • Support March 25, 2024 at 11:00 am  

      Yes, the Blitz Report Parameter DFF Table Validation report shows any parameters using the `xxen_util.dff_columns` function which reference an incorrect DFF table name.

    • Avatar photoCustomer March 26, 2024 at 5:48 am  

      We also need to check for potentially confusing scenarios where the same bind variable name is accidentally used across different parameters, or if multiple bind variables exist in one parameter’s SQL text.

    • Support March 27, 2024 at 1:56 am  

      Use the Blitz Report Parameter Bind Variable Validation report. This report checks which bind variables were assigned to which Blitz Report parameter, useful for detecting cases where the same bind variable name is incorrectly used in different parameters.

    • Avatar photoCustomer March 28, 2024 at 7:38 pm  

      What is the primary architectural recommendation for avoiding performance issues associated with optional parameters?

    • Support March 29, 2024 at 1:53 pm  

      It is recommended to use dynamic SQL anchors, such as `n=n`, instead of `nvl(:bind_variable, column_name)` coding for optional parameters to avoid performance issues.

  • Author
    Replies
Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123745

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19792

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14614

How to check if a patch is applied in Oracle EBS 12.2 14385

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14071

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11965

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9897

Migration to Java Web Start in Oracle EBS 12.2 instance 9890

Securing sensitive data with Oracle VPD 7793

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6447

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018