Creating a view-only or inquiry-based access to Oracle BI Publisher Administration pages can be challenging because Oracle Fusion does not natively support view-only roles for BI Publisher Administration functions. However, you can take a couple of alternative approaches to allow support staff to access relevant…

To achieve the requirement of generating a ZIP file containing both CSV and XML output from a BI report and uploading it to the UCM (Universal Content Management) server in Oracle Fusion, you can implement a workaround using Oracle BI Publisher’s scheduling and file generation capabilities along with PL/SQL or Java to…

To allow users to select multiple values for a parameter in an ESS (Enterprise Scheduler Service) Job in Oracle Cloud, while currently limited to selecting a single value for List of Values (LOV) parameters, a workaround may involve changing the design approach. Possible Solution: Concatenate Multiple Values: A common…

This is interesting!

To fix the issue where the salary is still appearing in English words in your BI Publisher report, even after using locale-specific functions like toCheckNumber('lv-LV', ...) or toCheckNumber('et-EE', ...), you can try the following: Make sure that the locales (lv-LV, et-EE) are installed and supported by your BI Publisher…

Hi @Pradeep kudale In Oracle Transactional Business Intelligence (OTBI), the limitation for downloading reports is typically set at 75,000 rows when exporting to CSV format. This limit is imposed to optimize performance and manageability, especially for larger datasets. If you need to work with larger datasets, consider…

Hi @Opkey PA In Oracle Cloud, the relevant table for storing information about Cost Accounting Distributions is CC_COST_DISTRIBUTIONS. This table includes various columns that capture the details of cost accounting distributions, including: RUN_CONTROL_ID: Identifier for the run control. PREPROCESSOR_STATUS: Status of the…

To join the ACN_IDEA_VL (ideation management) and EGP_SYSTEM_ITEMS_B_V (items), use a common key like ITEM_ID or an intermediate table that links ideas to items. Typically, you would look for a field in ACN_IDEA_VL that relates to item details, like PRODUCT_ID or ITEM_ID, and join it to inventory_item_id in…

In Oracle Cloud, sales agreements information is typically found in the DOO (Distributed Order Orchestration) and Order Management modules. Some relevant tables for sales agreements include: DOO_HEADERS_ALL: Contains high-level information on sales orders and agreements, including header_id, agreement_name, and dates.…

To join the ACN_IDEA_VL table (for ideation) and EGP_SYSTEM_ITEMS_B_V (for item details), you need an intermediary table that links ideas and items, often based on IDEA_ID and INVENTORY_ITEM_ID. Check for relationship tables such as ACN_IDEA_RELATIONSHIPS or similar. A potential query could look like this: sqlCopy…

In Oracle BI Publisher (BIP), the priority of an email sent from scheduled jobs is not explicitly set via the BIP scheduler itself. However, some factors could result in certain reports being marked as "Important" in Outlook or other email clients: Email Client Rules: Outlook or other email clients may have rules that…

To print the salary amount in words for Latvian and Estonian employees in an Oracle BI Publisher report, the correct XDOLOCALE values for the languages may be causing issues in the function. In Oracle BI Publisher, the xdoxslt:toCheckNumber function needs the proper locale code for the desired language. Based on your…

Looks helpful thanks for sharing