Accounts Payable (AP) Dashboard For Oracle EBS (12.1.x)

[fasibaig]

Dear Community,

Please find a QlikView Application for Accounts Payable on Oracle EBusiness Suite. Which was recently created by Me and My colleagues.

The attached word file (AP QlikView Dashboard Documentation) has all the documentation and related information. The rar file has the Application and QVD Files. The QVD files were refreshed using Oracle Vision Database (Sample database of Oracle Ebusiness Suite).

Added the Purchase Requisitions and Receipts tables to complete the procure to pay cycle.

Thanks & Regards

Ishaq Baig
ishaqbaig AT yahoo DOT com

Keywords for search - Qlikview AP App on Oracle EBS, Qlikview Apps for Oracle ERP, Account Payable App for Oracle EBS

[#2]

http://dbmanagement.info/Tutorials/Oracle_EBS.htm

Oracle EBS- Video Training Tutorial DVDs (2 DVDs)

More than 8 GB of Video files Sale Price 19.97

[#3]

I am new to Qlik and trying to create this AP dashboard.    Also is there an AR or  FA dashboard?

• Where can I find the information in step #8  for the various tabs?

[Sajid_Mahmood]

Hi Ishaq,

Any update on the HRMS dashboard or any other dashboard apart from AP & GL.

Regards

Sajid Mahmood

[#5]

Will you be creating an AR dashboard?   I would really appreciate it.

[fasibaig]

Please find Link to the Order to Cash Dashboard

Order to Cash Dashboard For Oracle EBS (12.1.x) Covering AR and OM Module

[#7]

Hi Ishaq,

This is very helpful. I am trying to create a AP dashboard in qlikview.

I am very new to qlik view. I have uploaded the Qlikview_AP.rar and created a view, packages and tables in EBS database.

Copied to QVDs files to c:'\\qlikview\QVDs folder

Copied qvc_runtime to c:\\qlikview\qvc_runtime

Can you please guide me how to upload it.

[salurkar]

Hello Ishaq,

First of all excellent work and thank you. We are trying to leverage the work you have shared on Qlik sense.

Qlik sense 3.2 release does have a built-in converter tool to convert qlikview application to qlik sense app.

We did try converting the application, the conversion using the migrator utility did work, but I am stuck when executing incremental data load.

for example AP Qlikview Application's Incremental Load fails when trying to update AP invoices from ebs.

Statement at which qlik sense data load errors out...

CALL Qvc.log ('>>> Incremental Load of AP Invoices All with inserts & updates');

Error received =>  undefined: CALL >>>>>>Qvc.log<<<<<<('>>> Incremental Load of AP Invoices All with inserts & updates')

Note: Prior to the statement Qvc.log statement is executed call the incremental data load routine did successfully extract data from other views (AP Dimensions, AP Vendors, AP Vendor Bank Details)

Was wondering if you were able to migrate the Qlik view application to Qliksense ?@

[fasibaig]

Hello Sandeep,

I have not tried to convert the App to Qliksense. The Incremental load uses QVC Components try using the latest QVC Components hope this helps. (GitHub - RobWunderlich/Qlikview-Components: A library for common Qlikview Scripting tasks)

Thanks & Regards

Ishaq