Posts by Venkatesh Balasubramanian

OAF – Creating Dyanmic Table Region in ProcessFormRequest

Description: Creating a Dynamic table region and attaching the VO to this dynamic Table region in ProcessFormRequest method of controller.   Consider the requirement, If user selects “U” then it should create…

Read More

Integrating With Fusion Application Using Services (APEX)

Description: Fusion Applications provides web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are created…

Read More

Implementing Search Functionality using LOV during query in Oracle Forms

Description: Oracle Fusion applications have support for attachments using functionality delivered by Oracle Enterprise Crawl and Search Framework (ECSF). This functionality is integrated at crawl time of the Search view…

Read More

How to Resolve the Shipping Exception Issue – Schedule Date has been Postponed – Exception Name “WSH_CHANGE_SCHED_DATE”

Description: Sometimes, we may change the Schedule Ship Dates in the Sales Orders. When we try to do the Ship Confirm for those revised orders, the system will not allow…

Read More

How to Process the Stuck Purchase Orders with an Pending “Respond to Changes” Action

Description: Requisitions are created using either from the Core Purchasing or Internet Procurement responsibilities. Then the requisitions will be converted into Purchase Orders using either Buyers Work Centre form or…

Read More

How to find error messages while doing Oracle workflow activities from backend

Description: The below workflow help to find out the error messages while doing oracle workflow activities from backend. We are finding error messages while doing workflow activities from the backend.…

Read More

How to change a LOV query Using Forms Personalization

Description: We can change the LOV query using form personalization. Sample provided below (Payment form).   Requirement: We have to change the “type”  field lov query for populating the custom…

Read More

How to Add or Assign the Printer to a desired Reports

Description: Oracle Applications provides you with predefined printer types, print styles, and printer drivers. Use the Printer Types form to query the combinations of print style and printer driver that…

Read More

Excel Template for BI Publisher Report

Description: This blog explains the process and steps to develop BI data templates with excel.   Steps in Brief: Create XML data template. Create a concurrent program with executable XDODTEXE.…

Read More

Eliminating block. field issue while upgrading from EBS R11i to R12 versions

Description: Problem: In 11i, Customers are accessed through Oracle forms where: block. Field reference is allowed to bring values in value sets dynamically. But in R12, Customers are accessed through…

Read More