Yearly Archives: 2024

Network Connectivity issue in Azure VM

Introduction/ Issue: Intermittent network connectivity drops on an Azure Virtual Machine (VM)  Why we need to do / Cause of the issue:  Network connectivity issues on an Azure VM can…

Read More

Configuration to update the same customer tax registration number for multiple customers/sites

Introduction : This blog has the configuration update the same customer tax registration number for multiple customers/sites Why we need to do : As per the legal requirement, Business requested…

Read More

How to skip deletion of the entries from AR_STATEMENT_HEADERS and AR_STATEMENT_LINE_CLUSTERS

Introduction : This blog has the configuration to skip the deletion of the entries from AR_STATEMENT_HEADERS and AR_STATMENT_LINE_CL   Why we need to do : While creating/customizing/debugging the customer statement…

Read More

Oracle Fusion query to get the Tax_Reporting_Type_Code_For_a_Tax_Regime

Introduction: This SQL query is fetching the data of Tax reporting type code details by passing the tax regime. Cause of the issue: To find if any of the tax…

Read More

Oracle Fusion India_Customer_Trx_GST_Details_Query

Introduction: This SQL query is fetching the data of India customer’s transaction with the company and the customer GST details. Cause of the issue: To find out the customers GST…

Read More

TOSCA automation can overcome the limitations of manual testing in fast-paced software development, ensuring efficiency, scalability, and consistent quality.

Introduction/Issue:  It’s important to ensure effective and consistent testing in today’s fast-paced software development environment. Traditional manual testing procedures can be time-consuming and prone to errors, leading to delays in…

Read More

Revolutionizing Test Automation with TOSCA Copilot: Efficiency, Scalability, and Quality

Introduction/Issue:   Tosca Copilot enhances productivity by optimizing test portfolios, explaining complex test cases, and providing actionable execution insights. It is seamlessly integrated within Tosca, boosting application quality, accelerating onboarding, and…

Read More

The project budget for the respective task code is not updated in oracle however it is available in Tririga.

Everyday(four times a day) project, budget and forecast files are interfaced from Tririga to oracle through integration DLK , OIC and finally in cloud. However some of the project budget…

Read More

KPI Notifications triggered after 24B upgrade for Project manager.

After 24B upgrade patch applied to Oracle fusion environment causing this issue. Solution: Run the “Update Project Performance Data Without producing report” process with from and to project number as…

Read More

Query to extract modifiers have been applied to a particular sales order

oracle-ebs-modifier-applied-against-so SELECT a.NAME “Modifier Name”,b.INVENTORY_ITEM_ID, b.list_line_no “Modifier Line No”, a.description “Modifier Description”, a.comments, b.list_line_type_code, d.qualifier_context, a.orig_org_id, a.active_flag, b.start_date_active, b.end_date_active, a.list_type_code, b.modifier_level_code, b.organization_id, f.order_number, b.pricing_phase_id, b.last_update_date, b.list_line_no, d.header_quals_exist_flag, d.qualifier_datatype, d.qualifier_attribute, d.segment_id,…

Read More