Tuesday, June 19, 2012

AP Trail Balances SQL Query for R12

›
SELECT  aia.invoice_num, aia.description inv_description,aia.attribute2 "Dept", aps.segment1 vendor#,        aps.vendor_name, ai...
7 comments:
Saturday, July 9, 2011

User Function (oracle APPS)

›
create function mazeeddecrypt(key in varchar2, value in varchar2) return varchar2 as language java name 'oracle.apps.fnd.security.WebS...
Thursday, July 7, 2011

AP Trail Balances SQL Query for 11i

›
SELECT alb.invoice_id invoice_id,inv.INVOICE_NUM,inv.DESCRIPTION INV_DESCRIPTION, alb.vendor_id vendor_id,pv.SEGMENT1 Vendor#,pv.VENDOR_NAM...
2 comments:

Discoverer with EBS in R12 (DISCOVERER REPORT REGISTRATION PROCESS)

›
* Navigate > System Administrator > Application > Function * Go to the Description TAB     * Enter Function Name =test_DWB     * ...

XML Publisher Report Disappearing Parameters / Top Level Elements in Template after adding @section to BI / XML Publisher Report

›
When you group with a section, you effectively "set" the base level of your XML to the level at which you group'ed. Hmm, bette...

XML Automatically submit XML Report Publisher request for Oracle Receivables Statements output

›
Update: This post is specifically for Release 11i. New functionality in Release 12 implements BI Publisher in many of the 3rd party facing ...

XML BI Publisher EBS Bursting Process (send Suppliers their Remittance Advice via email)

›
Ensure that you have the desired patches, as per your EBS Level, as mentioned in Prasad's article. select application_short_name, bug_nu...
5 comments: