Posts by Venkatesh Balasubramanian

Configuring APEX to use BI Publisher

Description: Configuring APEX is use to  BI Publisher as your Report Server, first, access the Report Printing parameters Go to The following navigation in APEX with Admin credentials. 1 Access the Administration Services home page 2 Select Manage Service 3 Select Instance Settings, under Manage Environment Settings 4 Click Report Printing to focus on just the Report Printing attributes   Now, specify the following attributes:   Oracle BI Publisher: Advanced Support Print Server Protocol: HTTP or HTTPS (depends on your configuration) Print Server Host Address: the hostname for the machine where you installed BI Publisher –…

Read More

Clearing Session State in APEX

Description: To develop the applications, we may find it useful to clear the cached value for specific items, all items on a page, all pages in an application, or the…

Read More

AR Transactions Query

Description: The below Post indicates the responsibility to check the AR Transactions Query on AR XLA GL   SELECT glcc.segment1 company, glcc.segment2 LOCATION, glcc.segment3 cost_center, glcc.segment4 ACCOUNT, glcc.segment5 product, glcc.segment6…

Read More

How to put the Company logo in each APEX page.

Description: Go to Shared Components, then click the images link and upload the image to the application. Click the Definition write the image name to logo text field as #WORKSPACE_IMAGES#company_logo.gif. Go to Page Template and add the LOGO prefix at the table.…

Read More

How to Apex Interactive Report Cosmetics

Description:  The Interactive Reporting Region is an innovative new technology that allows end users to customize reports. By putting more power in the hands of users it reduces development time…

Read More

Third Party Process – Colombia

Description: This page explains the steps involved in generating the Colombia Third-party report balances.   This process ensures the passage of the third party details to GL. This is mandatory…

Read More

Sending Calendar Invite via APEX Application

Description: ICS is a global format for calendar files widely being utilized by various calendar and email programs, including Google Calendar, Apple iCal, and Microsoft Outlook. These files enable users…

Read More

How to Oracle BI Publisher Introduction

Description: Oracle XML/BI Publisher is a very good reporting tool, which outputs reports into many formats like Word, Excel, PowerPoint, PDF and even to Adobe Flash. This can deliver reports…

Read More

Query to get the details of invoice with tax information’s

Description: Query to get the details of invoice with tax information’s select ctx.customer_trx_id, case when (    hrloc.address_line_1 is not null and (   hrloc.address_line_2 is not null or hrloc.address_line_3 is not…

Read More

Query to fetch Customer Statement of Account Details

Description: Query to fetch Customer Statement of Account Details SELECT   rc.customer_name “Customer_Name”, rc.customer_number “Customer_Number”, hou.NAME operating_unit, DECODE (ps.CLASS, ‘INV’, ‘Invoice’, ‘DM’, ‘Debit Memo’, ‘DEP’, ‘Deposit’, ‘CM’, ‘Credit Memo’, ‘PMT’, ‘Receipts’…

Read More