Home › Discussions › Questions & Answers › Export API Parameters for Dependent Objects

Export API Parameters for Dependent Objects

Avatar photoCustomer January 21, 2021 at 9:21 pm

When migrating reports, we need to ensure all dependent setup, like LOV definitions and category assignments, are included in the exported XML. Which parameters control this in `export_file_data`?

Viewing 2 reply threads
  • Author
    Replies
    • Support January 23, 2021 at 5:47 pm  

      You control this using specific optional parameters. To include definitions used by the report, you set parameters such as `p_include_lovs`, `p_include_categories`, `p_include_assignments`, and `p_include_templates` to ‘Y’.

    • Avatar photoCustomer January 24, 2021 at 1:34 am  

      What about multi-language column translations and number formats?

    • Support January 24, 2021 at 9:11 am  

      For column translations and number formats, you use `p_include_columns`. Be aware that using this option might slow down the export significantly, as the database needs to parse all exported report SQLs to identify column names.

  • Author
    Replies
Viewing 2 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™ 123750

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

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14617

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

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

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11966

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9900

Migration to Java Web Start in Oracle EBS 12.2 instance 9893

Securing sensitive data with Oracle VPD 7798

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

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