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

[Sajid_Mahmood]

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

Regards

SM

[#3]

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

[fasibaig]

Hi Vinod,

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

Thanks & Regards

Ishaq

[Sajid_Mahmood]

Hi Ishaq,

What other dashboards for Oracle EBS R12 you have created ?

Regards

Sajid

[fasibaig]

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

[#7]

Excellent work Ishaq!

[Sajid_Mahmood]

Hi Ishaq,

Any update on the GL dashboard.

[fasibaig]

Hi Sajid,

Not yet, Work in Progress.

Thanks & Regards

Ishaq

[Anonymous]

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

[fasibaig]

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