Syntax to user oracle functions in BI Publisher
XML Publisher has extended a set of SQL and XSL functions for use in RTF templates. The syntax for these extended functions is for extended SQL functions <?xdofx:expression?> for extended…
Read MoreQuery to find responsibility from a form name
SELECT FORMS.form_name, FORMSTL.user_form_name, RESTL.responsibility_name, FORMSTL.language FROM fnd_form FORMS, fnd_form_tl FORMSTL, fnd_form_functions FUNC, fnd_menu_entries MENU, fnd_responsibility RES, fnd_responsibility_tl RESTL WHERE FORMSTL.user_form_name LIKE ‘%Workbench%’ AND FORMS.form_id = FORMSTL.form_id AND FUNC.form_id = FORMS.form_id…
Read MoreUnable to raise the change request on the requisition in iprocurement
Change request cannot be initiated for this requisition since none of the associated purchase orders are eligibile for change. Issue Description: Unable to raise the Change request on the requisition…
Read MoreBI Publisher If then Else Statement
Conditional Format Statements in BI/XML Publisher : If if-then-else choose- when-otherwise The Conditional Formatting using if statement: If statement: Use if statement to define a simple condition; for example, if…
Read MoreData Migration and Conversion Strategy
Data migrations generally result from the introduction of a new system. This may involve an application migration or consolidation in which one or more legacy systems are replaced or the…
Read MoreBreak Comma Separated String
1. Overview This document will be helpful to print comma separated string with the new line report 2. Technologies and Tools Used Oracle Plsql code. 3. Use Case To display comma separated…
Read MoreHow to Change the Default Request Group in E-Business Suite Support Analyzer Bundle Menu
It is possible to change the default request group for a given Analyzer at the individual analyzer level. 1.Start the menu with “perl Menu.pl” 2,Select a Product Family 3.Select an…
Read MoreAR AUTO ACCOUNTING SETEUP
Step 1 : Define Auto Accounting Rule Setup Navigation : Account Receivable -> Setup -> Transactions -> Auto Accounting. Define Tax Code Auto Accounting Rules Setup: Define Receivable Auto Accounting…
Read MoreGet working days between two working date excluding weekends
This function which will help you to get number of working days between two date excluding the weekends. This will help other to get logic between two working date.This is…
Read MoreInteractive grid cell coloring without condition using css class invoke
1. Overview This Document is used to get selected IDs from the Interactive grid based on selection. 2. Technologies and Tools Used The following technologies have been used to achieve this …
Read More