Oracle Application Blog

How to Remove Error Workflow Notifications from Work list

How to Remove Error Workflow Notifications from Work list Issue:  In some of the Oracle users Work-list, will have multiple notifications with Error message “Document Manager Failed with Error Number…

OAF – Creating Dyanmic Table Region in ProcessFormRequest

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…

Useful SQL Queries – Oracle EBS

Query to find Runtime, Status and Argument of a Concurrent Request   SELECT fcp.user_concurrent_program_name, fcr.requested_by, fcr.request_id,          fcr.request_date, fcr.phase_code, fcr.status_code,fcr.requested_start_date,           fcr.actual_start_date,fcr.actual_completion_date,          ROUND((nvl(fcr.actual_completion_date,sysdate) –fcr.actual_start_date) * 1440, 2)            “Runtime (in…

Excel Template for BI Publisher Report

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

Min-Max Planning Method in Oracle Apps – Planning Level: Organization, Source Type: Inventory, Item: Buy

Planning Level: Organization, Source Type: Inventory, Item: Buy Responsibility: Inventory          Navigation: Items > Master Items. Create a item in Item Master and assign it to Source and Destination Organizations.…

Min-Max Planning Method with various Scenarios in Oracle Apps

Order Import Issue – Item with inventory_item_id=XXXXXX is not defined in Item validation Org XXX

IR-ISO – Order Import Issue Issue: Approved Internal Requisitions are not converted into Internal Sales Orders. Description: In Purchasing Responsibility, an Internal Requisition (447493) has been created and approved. “Create…

Adding Condition While Calling the Bursting Program

In the Below Program we would be restricting the Mails for which the outstanding balance is Less that Zero. Statement Generation Program Bursting AR Statement Print report is used to send…

Sending E-mail with Excel Attachment Using UTL_SMTP

The utl_smtp package is used to send e-mails from any database to a valid recipient/receipents with or without attachements.The generic code is given to send e-mail with excel attachment ,…

Setting VO query dynamically in OAF

Generally while creating the View Objects we define a query to it. While rendering the OAF page these view objects get executed (either by framework or by the java code). …