Posts

Showing posts from 2021

E-Text Report In Fusion | Types of E-Text reports

 WHAT IS Oracle Fusion E-Text Report ? An eText template is an RTF-based template that is used to generate text output  for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). How it generate the output for User or Bank? At runtime, BI Publisher applies this template to an input XML data file to create an output text file. that can be transmitted to a bank or other customer.  Because the output is intended for electronic communication, the eText templates must follow very specific format instructions for exact placement of data. Example :- Bank payment file , Bank MT940 File .. etc what is look and feel of this file ? Note:  There are two types of eText templates:  1. fixed-position based (EFT templates)  2. Delimiter-based (EDI templates) What IS EFT File? An EFT is an electronic transmission of financial data and payments to banks in a specific fixed-position format flat file (text). Link for download:- EFT :-  https://docs.google.com/document/d/14xAYceq2hx8WIy3Iux

Back Button or return Button script for fusion OTBI reports

  <script type="text/javascript"> function fnBk() { window.close(); window.open("your_report_url"); } </script> <button type="button" name="back" id="back" onclick="fnBk()" style="" class="bp" > Return </button>

URL's for Web Page Deeplinks in fusion with appropriate parameter attributes

  As per Oracle:- How To Drill Down To Fusion Financial Applications Transactions From OTBI ERP Reports (Doc ID 2603149.1) GOAL OTBI provides users with the ability to create reports using real time transactional data. It offers capability to build rich, visual and interactive reports to meet unique reporting requirements. In addition to the existing reporting capabilities, it also provides the ability to drilldown from OTBI adhoc reports directly to the transaction details in Oracle Fusion Financials Applications. This is possible by leveraging the action link framework and using a set of pre-configured URL’s called Deeplinks which will allow users to configure drilldowns to supported transaction detail pages from the adhoc OTBI reports.   SOLUTION At the time of writing this note, Deeplink feature is available for: 1. Payables Invoices and Payments (Introduced in Rel 13 Update 18B)    1.1 View Invoice Details    1.2 Edit an Invoice    1.3 Create Payment    1.4 View Payment D