Qlik Community

QlikView Documents

Documents for QlikView related information.

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

fasibaig
New Contributor III

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

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

Attachments
Comments
Sajid_Mahmood
Contributor


Excellent work done on this AP dashboard of Oracle EBS r12.1.x

Regards

SM

0 Likes
Not applicable

Ishaq - Would you be able to share HR dashboard for Oracle EBS R12

0 Likes
fasibaig
New Contributor III

Hi Vinod,

I have not yet created a HR dashboard for Oracle EBS R12. Shall upload it once it is created.

Thanks & Regards

Ishaq

0 Likes
Sajid_Mahmood
Contributor

Hi Ishaq,

What other dashboards for Oracle EBS R12 you have created ?

Regards

Sajid

0 Likes
fasibaig
New Contributor III

Hi Sajid,

This was the first dashboard created using Oracle EBS. Right Now I am working over GL Dashboard and shall upload it when it is created.

Regards

Ishaq

0 Likes
Not applicable

Excellent work Ishaq!

0 Likes
Sajid_Mahmood
Contributor

Hi Ishaq,

Any update on the GL dashboard.

0 Likes
fasibaig
New Contributor III

Hi Sajid,

Not yet, Work in Progress.

Thanks & Regards

Ishaq

0 Likes
joshi_qlikview
Contributor

Hi ishaq,

iam started working on ORACLE EBS, can u share some Incremental load Script you implemented for this Project.

AP_Invoice_all Table contains Crores of record. Last_update_date>='$(vLastreload)'

iam unable to match sql date with qlikview last reload Time.

Thanks,

Joshi

0 Likes
fasibaig
New Contributor III

Hi Joshi,

Incremental Load script is based on QVC Components

https://github.com/RobWunderlich/Qlikview-Components

  

Qvc Components for Qlikview were used for incremental load of tables. To incrementally load data from Oracle Views into the QVD Files.

http://code.google.com/p/qlikview-components/downloads/list

Following was the change done in the qvc.qvs script File

Changed the Variable to ORACLE instead of SQLSERVER

SET Qvc.Loader.v.Database = ORACLE;

On first load all records are being loaded and on subsequent loads the incremental records are loaded. You need to have a Unique Key and Last Update date field in the Table/View from where incremental load is to be done.

Thanks & Regards

Ishaq

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-04-10 11:27 AM
Updated by: