Generated by Rank Math SEO, this is an llms.txt file designed to help LLMs better understand and index this website.

# CID Software Solutions

## Sitemaps
- [XML Sitemap](https://cidsolutions.com/sitemap_index.xml): Includes all crawlable and indexable pages.

## Posts
- [CID Fusion Query v3.3.0 — Ready for Fusion 26C’s New BI Publisher SQL Injection Check, Plus Paged Results and Custom Row Limits](https://cidsolutions.com/2026/10/13/cid-fusion-query-3-3-0-fusion-26c/): Fusion 26C added a new SQL injection check to BI Publisher that blocked the report CID Fusion Query relies on. Version 3.3.0 fixes it the right way, and brings back paged results with search, adds a record count and custom row limits.
- [AI Revolution in OIC Development and Analysis: Searching Inside 500+ Integration Flows](https://cidsolutions.com/2026/10/06/search-oic-integrations-ai-sqlcl-mcp/): A large OIC instance, a service user deleting files nobody could explain, and 500+ integrations to check. How a local Oracle database, SQLcl MCP and Claude turned the OIC export into a searchable model of every flow, with the full code.
- [Visual Builder Studio Issues: Run a Fusion RICE Delivery Process by using a Documented Epic/Task Model — and Load It in Bulk with a Free Python Tool](https://cidsolutions.com/2026/09/08/visual-builder-studio-issues-rice-backlog/): Difficulty: Intermediate
- [OIC: Passwordless connections for Fusion BI Publisher — why SOAP is the last holdout, and the CID adapter that closes the gap](https://cidsolutions.com/2026/08/27/passwordless-bi-publisher-connection-oic/): Difficulty: Advanced
- [Fusion Redwood: Add context-aware links to any page by using Guided Journeys – and discover the hidden URL context variables](https://cidsolutions.com/2026/08/12/redwood-guided-journey-context-variables/): Difficulty: Intermediate
- [Fusion Apps: Call OIC Synchronously as the Real User by using a Native IDCS OAuth Connection](https://cidsolutions.com/2026/07/23/fusion-apps-call-oic-native-idcs-oauth-connection/): Difficulty: Advanced
- [CID Fusion Query v3.0.0 — Free Chrome Extension for Oracle Fusion Developers and Business Analysts](https://cidsolutions.com/2026/07/01/cid-fusion-query-v3-0-0-free-chrome-extension-for-oracle-fusion-developers-and-business-analysts/): ✨ Key Highlights
- [APEX on ATP: Add “Log in with Microsoft” by using Entra ID OIDC Social Sign-In](https://cidsolutions.com/2026/06/15/apex-entra-id-oidc-login/): Difficulty: Intermediate
- [OIC: Fix business event filters that validate but never fire by using the wire payload](https://cidsolutions.com/2026/06/08/oic-business-event-filter-wire-payload/): Difficulty: Intermediate
- [Fusion AI Agent Studio: Run SQL directly from an agent by using an Application Composer Business Object Function](https://cidsolutions.com/2026/06/04/fusion-ai-agent-studio-run-sql-directly-from-an-agent-by-using-an-application-composer-business-object-function/): Difficulty: Advanced
- [Fusion OTBI: Securely obtain a session ID from OIC by using OCI Vault and an Oracle Function](https://cidsolutions.com/2026/05/15/fusion-otbi-securely-obtain-a-session-id-from-oic-by-using-oci-vault-and-an-oracle-function/): Difficulty: Advanced
- [Useful PowerShell Script for Downloading Files from UCM Based on a CSV File](https://cidsolutions.com/2026/03/10/useful-powershell-script-for-downloading-files-from-ucm-based-on-a-csv-file/): Sometimes we need to download multiple files from Oracle WebCenter Content (UCM) in bulk — for example, after running a BICC extract job, retrieving reports, attachments, or exported data. Manually downloading each file through the UI is time-consuming and error-prone.
- [Oracle ACE Live: Mastering Design Patterns for Custom Business Processes in Oracle Fusion Applications: Strategies for CX, HCM, and SCM](https://cidsolutions.com/2026/02/26/oracle-ace-live-mastering-design-patterns-for-custom-business-processes-in-oracle-fusion-applications-strategies-for-cx-hcm-and-scm/): Here is the presentation given on Oracle ACE Live platform:
- [Improve development and maintainability of Visual Builder AppUIs by utilizing code sharing](https://cidsolutions.com/2026/02/24/improve-development-and-maintainability-of-visual-builder-appuis-by-utilizing-code-sharing/): In many Visual Builder Studio projects, custom AppUIs are developed to extend Oracle Fusion Cloud applications. Each custom AppUI typically lives in its own Git repository within the Visual Builder workspace. While Oracle provides a rich set of built-in actions and components, developers frequently need custom JavaScript logic — and the same helper functions often get duplicated across multiple AppUIs.
- [CID Fusion Query v2.8.0 — Free Chrome Extension for Oracle Fusion Developers and Business Analysts](https://cidsolutions.com/2026/02/08/cid-fusion-query-v2-8-0-free-chrome-extension-for-oracle-fusion-developers-and-business-analysts/): We have just improved the plugin and the utility communication report and now 32K BIP parameter limitation is now raised!
- [Utilize Visual Builder Studio To Streamline File Upload, ESS Submission and Output Download](https://cidsolutions.com/2026/01/29/utilize-visual-builder-studio-to-streamline-file-upload-ess-submission-and-output-download/): In one of our previous posts Oracle Fusion SaaS BIP Report: Combine SQL reports with user’s manually uploaded files, we demonstrated a method for end users to upload a file and use an ESS job to run a report that combines the uploaded file with data from Oracle Fusion SaaS.
- [Fusion Apps: Submit Asynchronous OIC Integrations by Using Custom Object Integration Events – Revised](https://cidsolutions.com/2026/01/13/fusion-apps-submit-asynchronous-oic-integrations-by-using-custom-object-integration-events/): Using Oracle Integration Cloud (OIC) as a business logic execution platform is a widely adopted approach in Oracle Fusion Applications implementations. Several methods exist to trigger OIC integrations from Fusion:
- [Fusion Service CX Redwood: Adding Part Line DFF segment dependent on standard field by using Visual Builder Studio](https://cidsolutions.com/2025/12/25/fusion-service-cx-redwood-adding-part-line-dff-segment-dependent-on-standard-field-by-using-visual-builder-studio/): In Oracle Fusion Service CX, there is a need to add a new Descriptive Flexfield (DFF) segment to the Part Line of a Service Request. This new field should enable the selection of a contact associated with the "Return To Party." The List of Values (LOV) for this segment must dynamically query contacts based on the currently selected "Return To Customer Party" using the following SQL query, where partyId is derived from the selected party:
- [Fusion CX: Perform Mass Date Change in Subscription by using custom groovy based ESS](https://cidsolutions.com/2025/12/18/fusion-cx-perform-mass-date-change-in-subscription-by-using-custom-groovy-based-ess/): In Oracle Fusion Subscription Management, performing mass date changes on active subscriptions—such as updating start dates for specific product lines—can be complex. Standard processes often require manual amendments, updates, and activations, which are time-consuming and error-prone for large volumes. Additionally, handling parameters like new dates, periods, durations, and targeted line numbers dynamically is not natively supported in scheduled Groovy functions.
- [Using Visual Builder advanced mode to Add dynamic URL with order context to Redwood Order screen](https://cidsolutions.com/2025/12/14/using-visual-builder-advanced-mode-to-add-dynamic-url-with-order-context-to-redwood-order-screen/): Update (Aug 2026): where the Redwood page actually exposes the record context, you can now do this config-only — no advanced mode — with a Guided Journey. See Fusion Redwood: Add context-aware links to any page by using Guided Journeys . Use the DOM approach below when the context isn't exposed (e.g. Inventory Transactions).
- [Test Oracle Fusion REST APIs in Postman Without User Credentials Using Bearer Token from Browser Session](https://cidsolutions.com/2025/12/04/test-oracle-fusion-rest-apis-in-postman-without-user-credentials-using-bearer-token-from-browser-session/): Oracle Fusion Applications developers and business analysts often need to test REST APIs against environments where they lack direct user/password access, especially when company Single Sign-On (SSO) is enforced. Traditional authentication methods in tools like Postman require credentials, which may not be available or practical in such secured setups. This limitation can hinder rapid testing and development workflows.
- [Overcome newly introduced limitation of using SQL inside OM Extensions by using BIP and OIC](https://cidsolutions.com/2025/11/25/overcome-newly-introduced-limitation-of-using-sql-inside-om-extensions-by-using-bip-and-oic/): According to Oracle documentation, the objects developers can access inside Order Management (OM) extensions are limited. The full accessible list is described in this Oracle documentation.
- [Overcome Application Composer CRM/ERP ViewObject Domain Restrictions Using Web Services REST Connection](https://cidsolutions.com/2025/11/13/overcome-application-composer-crm-erp-viewobject-domain-restrictions-using-web-services-rest-connection/): Oracle Fusion Application Composer separates business objects into two distinct domains: CRM and ERP.While implementing Groovy business logic within one domain, developers can typically use the built-in newView functionto query both standard and custom objects — but this access is restricted to the current domain.
- [Overcome Missing REST API Functionality by Utilizing Application Composer to Expose SOAP ShipmentService to VB AppUI](https://cidsolutions.com/2025/10/26/overcome-missing-rest-api-functionality-by-utilizing-application-composer-to-expose-soap-shipmentservice-to-vb-appui/): A customer needed to update the Shipping Method for a Shipment using a custom screen built in VB AppUI.
- [Create Parametrized Custom ESS Jobs Running Scheduled Custom Groovy Function](https://cidsolutions.com/2025/10/25/create-parametrized-custom-ess-jobs-running-scheduled-custom-groovy-function/): Oracle Fusion provides a very powerful framework for executing custom Groovy functions via scheduled ESS jobs.However, according to official documentation, you cannot pass parameters to these scheduled functions.
- [Prevent Submitting Non-Catalog Requests with Missing DFF Using Visual Builder Studio Extension](https://cidsolutions.com/2025/09/20/prevent-submitting-non-catalog-requests-with-missing-dff-using-visual-builder-studio-extension/): In Oracle Fusion Self Service Procurement, the Non-Catalog Request screen allows displaying DFF segments from the Requisition Lines Flexfield. One of our clients had a strict requirement: prevent submission of the request if the Legal Entity DFF segment is not populated. This was critical because the value is later used in account combination generation.
- [CID Fusion Query v2.7.0 — Free Chrome Extension for Oracle Fusion Developers and Business Analysts](https://cidsolutions.com/2025/09/16/cid-fusion-query-v2-7-0-free-chrome-extension-for-oracle-fusion-developers-and-business-analysts/): 💪 Version 2.7.0 makes query analysis even more powerful with professional explain plan tools!
- [Overcome Groovy Execution Limits by Submitting OIC Integration Through ESS Job](https://cidsolutions.com/2025/09/02/overcome-groovy-execution-limits-by-submitting-oic-integration-through-ess-job/): However, a key limitation is that Groovy scripts invoked this way are capped to 60 seconds execution time. This becomes a problem when:
- [Oracle HCM: Utilization of Table Value Sets in EIT in Migration to Redwood Pages](https://cidsolutions.com/2025/07/12/oracle-hcm-utilization-of-table-value-sets-in-eit-in-migration-to-redwood-pages/): Oracle Fusion HCM customers extensively use Independent Value Sets attached to flexfield segments in Extra Information Types (EIT). These value sets provide both a code and description, offering users a clear selection mechanism with meaningful context.
- [Fusion Apps: Send Report Output to Currently Running User by Using BIP Bursting Engine](https://cidsolutions.com/2025/06/01/fusion-apps-send-report-output-to-currently-running-user-by-using-bip-bursting-engine/): Oracle Fusion Applications provide robust reporting capabilities through Oracle BI Publisher (BIP). Often, organizations require sending report outputs directly to the user who triggered the report execution. By default, Fusion reports use predefined or static email recipients, limiting dynamic user-specific delivery options.
- [Fusion Apps: Identify & Troubleshoot Slow Access to Custom Objects](https://cidsolutions.com/2025/03/29/fusion-apps-identify-troubleshoot-slow-access-to-custom-objects/): Oracle Fusion Applications provide robust customization capabilities, allowing implementors and developers to create Custom Objects within CRM Cloud, ERP, and SCM Cloud using the Application Composer.
- [Fusion SaaS: Prevent Users from Reopening and Printing AR Invoice Original Documents While Allowing IT Access](https://cidsolutions.com/2025/03/02/fusion-saas-prevent-users-from-reopening-and-printing-ar-invoice-original-documents-while-allowing-it-access/): In Oracle Fusion SaaS, every AR invoice print action generates a PDF file attached to the invoice record. By default, this allows users to reopen and print the invoice multiple times—a behavior that many businesses seek to prevent.
- [Fusion SCM: Calculate Order Price Adjustments by using OM extension and OIC](https://cidsolutions.com/2025/01/31/fusion-scm-calculate-order-price-adjustments-by-using-om-extension-and-oic/): Oracle Fusion Supply Chain Management (SCM) provides powerful Order Management (OM) capabilities, yet businesses often need to implement customized price adjustments beyond standard configurations. While Oracle Fusion OM Extensions allow for business logic customizations, they have read-only access to manual price adjustments, making direct modifications impossible.
- [New version of our free Chrome extension for querying Fusion SaaS DB](https://cidsolutions.com/2025/01/21/new-version-of-our-free-chrome-extension-for-querying-fusion-saas-db/): We are glad to share that a new version of our free Chrome extension for querying the Fusion SaaS database has been published.
- [Fusion SaaS AppUI: Enable Groovy-only solution for SOAP based ErpObjectAttachmentService](https://cidsolutions.com/2024/12/24/fusion-saas-appui-enable-groovy-only-solution-for-soap-based-erpobjectattachmentservice/): This post further extends the solution of exposing Visual Builder AppUI ready REST APIs on Fusion backend for business entities that do not have such REST APIs out-of-the-box.The previous post used Application Composer, Custom Object, Groovy and OIC. The solution below uses Groovy-only implementation leveraging internal URL https://fa-internal.oracleoutsourcing.com:10663 and SOAP based ErpObjectAttachmentService. Such a solution can be deployed to PROD and will work without any changes in lower environments after P2T process.Similar approach is also described in https://cidsolutions.com/2024/11/03/fusion-saas-implement-p2t-hassle-free-generic-sql-query-rest-utility-for-vb-appuis-by-using-bip-and-app-composer/
- [VB AppUIs: submit an ESS job with printer and BIP template](https://cidsolutions.com/2024/11/29/vb-appuis-submit-an-ess-job-with-printer-and-bip-template/): Visual Builder AppUIs empower us to create custom-built screens within the Oracle Fusion interface, significantly simplifying user actions and automating complex activities. The following use case illustrates how Visual Builder AppUIs can enhance efficiency by enabling users to submit a shipping label ESS job directly from the delivery screen. With a single click, the system automatically captures the delivery parameters from the current screen, submits an ESS job using a predefined template, and sends it to a printer specified in the Application Profile. This post will guide you through the detailed steps to accomplish this task.
- [Fusion SaaS: Implement P2T hassle-free generic SQL query REST utility for VB AppUIs by using BIP and App Composer](https://cidsolutions.com/2024/11/03/fusion-saas-implement-p2t-hassle-free-generic-sql-query-rest-utility-for-vb-appuis-by-using-bip-and-app-composer/): In the previous post we have improved the solution allowing running SQL queries from VB AppUIs by utilizing BIP lexicals.The solution was based on the following:
- [Fusion SaaS: improved method for running SQL queries by using generic OIC integration and BIP lexicals](https://cidsolutions.com/2024/10/20/fusion-saas-improved-method-for-running-sql-queries-by-using-generic-oic-integration-and-bip-lexicals/): In the previous post we have presented a generic OIC integration that can receive an SQL parameter and return JSON array result,The solution presented there had limited number of resulting columns and due to the predefined response schema the results records had also common names; COL1, COL2, etc.This post will show how the previous solution can be improved by using BIP lexicals and OIC binary output. The solution that is presented in this post will remove the resulting columns limit, will provide a readable output in a more efficient manner.The wrapper Groovy code presented before can be still used to expose the integration to VB AppUIs.
- [Fusion SaaS BIP: Utilize lexical feature to improve Custom Object SQL access](https://cidsolutions.com/2024/10/11/fusion-saas-bip-utilize-lexical-feature-to-improve-custom-object-sql-access/): Custom Objects in Fusion SaaS are very useful feature allowing customers to add their own data and use it together with existing Oracle provided seeded tables.In the past we have published a solution that allows writing environment independent SQL based BIP reports that can be easily moved between environments.The method is described here https://cidsolutions.com/2023/11/15/improved-method-for-writing-instance-independent-sql-queries-over-custom-objects-in-fusion-saas/ .The solution above utilizes XML Query feature of Oracle database.This post will show even more efficient approach using lexical feature of BI Publisher.The new approach uses native SQL without XMLQuery parsing and much more efficient in performance.There are still places like bursting that we can not use the new proposed approach and should still use the XML Query feature.
- [Fusion SaaS: Add additional parameter to standard report without duplicating the ESS job](https://cidsolutions.com/2024/09/13/fusion-saas-add-additional-parameter-to-standard-report-without-duplicating-the-ess-job/): Oracle Fusion SaaS provides seeded BIP reports which can be customized by using the Customize option in BIP catalog.This option allows to use standard ESS Job provided by Oracle, utilize the existing built-in report executions from UI like View Image in Receivables or Procurement and still modify the report layout and associate with a copy of vanilla data model if needed.Although the report can be customized, the report parameters passed from the ESS job can not be modified, they can only be modified if the ESS is cloned but this will not support built-in report executions and in some cases due to dedicated parameters region the clone of standard ESS job is not possible.This post will show a workaround how to access the Submission Notes field passed to an ESS job within the data model and then use it within the requested business logic modification.
- [Fusion SaaS: Perform efficient SQL validation for incoming files by using Custom Object CLOB fields, OIC and BIP](https://cidsolutions.com/2024/08/09/fusion-saas-perform-efficient-sql-validation-for-incoming-files-by-using-custom-object-clob-fields-oic-and-bip/): Importing external files into Oracle Fusion SaaS is a common requirement. Oracle provides HDL and FBDI that perform efficient pre-validations on input files before loading them to the system.This post will show a generic approach of performing efficient SQL validation of custom incoming file by utilizing OIC, Application Composer Custom Object CLOB fields and BIP SQL queries.
- [Procurement SaaS: Display Buyer’s Signature From Document of Records in a PO PDF Report](https://cidsolutions.com/2024/07/19/procurement-saas-display-buyers-signature-from-document-of-records-in-a-po-pdf-report/): Oracle BI Publisher allows generation of PDF outputs with dynamically embedded images. This post will demonstrate how OIC can be used inside a BIP model to fetch image file from UCM attachments as part of PDF generation.The idea of embedding the image coming from database rather that from URL was taken from the following post http://www.geek-bench.com/2021/06/how-to-display-images-dynamically-in-bi.html.
- [Visual Builder Extension for Fusion SaaS: upload an attachment without existing REST API endpoint](https://cidsolutions.com/2024/06/22/visual-builder-extension-for-fusion-saas-upload-an-attachment-without-existing-rest-api-endpoint/): Oracle Visual Builder Studio has a pre-configured backends for REST API available in Fusion Apps.Not all business entities that allow attachment management in UI of Fusion Apps expose REST APIs for attachment management.This post will show how to overcome this obstacle by utilizing SOAP ErpObjectAttachmentService, Application Composer, Groovy and Oracle Integration Cloud.
- [Visual Builder Extension for Fusion SaaS: submit ESS jobs directly from Visual Builder](https://cidsolutions.com/2024/05/06/visual-builder-extension-for-fusion-saas-submit-ess-jobs-directly-from-visual-builder/): Oracle Visual Builder Studio allows us to extend existing Visual Builder screens or create new App UIs. The automatically provisioned backends allow convenient access to Oracle Fusion REST resources but submitting and monitoring ESS jobs is not a straightforward task. This post will show how ESS job submissions can be easily achieved in Visual Builder Studio.
- [Visual Builder Extension for Fusion SaaS: speed up development process by using generic REST SQL query utility](https://cidsolutions.com/2024/03/08/visual-builder-extension-for-fusion-saas-speed-up-development-process-by-using-generic-rest-sql-query-utility/): Following the post showing the method of running BIP SQL reports from Visual Builder Extension described here, we have built a generic solution that allows running any Fusion SaaS related SQL queries without the need of creating a dedicated report, custom object and groovy functions.
- [Visual Builder Extension for Fusion SaaS: utilize BIP SQL queries by using Groovy and OIC](https://cidsolutions.com/2024/02/09/visual-builder-extension-for-fusion-saas-utilize-bip-sql-queries-by-using-groovy-and-oic/): Using of OIC for exposing BIP reports to Visual Builder Application is a quite common approach. However when we develop SaaS extensions we have only access to SaaS backend and there is no secure way (at least up until today) to create a connection to an OIC instance. According to VBCS blog, the ability to add local server connection in Visual Builder Studio will provide solution for this need.Meanwhile we can implement the workaround by using Application Composer Groovy scripting, OIC and BIP.
- [Oracle Fusion SaaS free SQL query tool](https://cidsolutions.com/2024/01/09/oracle-fusion-saas-free-sql-query-tool/): Check out the new free chrome extension we have just published!
- [Oracle Fusion SaaS BIP Report: Combine SQL reports with user’s manually uploaded files](https://cidsolutions.com/2023/12/22/oracle-fusion-saas-bip-report-combine-sql-reports-with-users-manually-uploaded-files/): There are cases when Oracle Fusion SaaS user would like to invoke a BIP report, pass it user file as a parameter and use the data from the uploaded file together with regular SQL queries.Example: perform validations for Excel list of items.
- [Visual Builder Extension for Fusion SaaS: creating complex queries with Application Composer Groovy methods](https://cidsolutions.com/2023/12/01/visual-builder-extension-for-fusion-saas-creating-complex-queries-with-application-composer-groovy-methods/): Utilize Application Composer for creation of complex queries invoked from VBCS Extension for Fusion SaaS
- [Improved method for writing instance independent SQL queries over custom objects in Fusion SaaS](https://cidsolutions.com/2023/11/15/improved-method-for-writing-instance-independent-sql-queries-over-custom-objects-in-fusion-saas/): In previous post https://cidsolutions.com/2023/07/18/create-instance-independent-custom-object-sql-queries-in-oracle-fusion-saas/ we described the method to overcome the issue of different mapping between logical custom field name to its mapped table and underlying column.

## Pages
- [CID Fusion Query Privacy Policy](https://cidsolutions.com/cid-fusion-query-privacy-policy/): Last updated: October 11, 2026
- [Home](https://cidsolutions.com/)
- [Terms of Service](https://cidsolutions.com/terms-of-service/): Welcome to CID Software Solutions. By accessing or using this website, you agree to be bound by these Terms of Service.
- [Oracle Fusion Apps and OCI Practice](https://cidsolutions.com/oracle-fusion-apps-and-oci-practice/)
- [Salesforce Implementation & Integration](https://cidsolutions.com/salesforce-implementation-integration/)
- [Contact Us](https://cidsolutions.com/contact-us/)
- [Blog](https://cidsolutions.com/blog/)
- [Enterprise Architecture Services](https://cidsolutions.com/enterprise-architecture/)
- [Software Products & Enterprise Solutions CID Delivered](https://cidsolutions.com/case-study/)
- [Our Tools](https://cidsolutions.com/our-tools/)
- [Wall of Fame](https://cidsolutions.com/wall-of-fame/)
- [about](https://cidsolutions.com/about/)
- [Privacy Policy](https://cidsolutions.com/privacy-policy/): Suggested text: Our website address is: https://cid.