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 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 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 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 MoreSupplier Master Data Import – FBDI Template
Title: Supplier Master Data Import – FBDI Template In this post , We will discuss about Supplier import in oracle fusion. Oracle has provided the FBDI tool to import suppliers…
Read MoreOrder To Cash Script
Order To Cash Script o2c SELECT hp.party_name customer, hca.account_number, hp.party_number, ooh.order_number, ooh.flow_status_code order_status, rcta.trx_date invoice_date, rcta.trx_number invoice_number, rcta.status_trx invoice_status, rcta.invoice_currency_code invoice_currency, rctla.line_number, msi.segment1 item_number, rctla.description, rctla.extended_amount line_amt, arp.amount_due_original, arp.amount_due_remaining,…
Read MoreORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError – ecx_utils.INITIALIZE
When trying to submit one of GL report end with error. The error message shows ORA-29532: Java call terminated by uncaught Java exception. select * from ************_LOV ORA–29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException 29532. 00000…
Read MoreWhile starting database ORA-03113: end-of-file on communication channel
ERROR While starting database ORA-03113: end-of-file on communication channel Problem: On further diagnosis of ADRCI logs, I found disk space size assigned to Flash recovery area falling short Solution: Mount…
Read More