Oracle EBS R12: Query for Inventory AP Reconciliation SLA to GL

The query provided in this post will provide you with the complete list of transactions that sum up to make your AP Accrual Balance in General Ledger. You may amend the query to run for whatever date range/GL Accrual Account you require, and any other columns you see fit:

Continue reading

Advertisements

Oracle EBS R12: Upload Inventory Item Category Assignments Through WebADI

This post will provide you with the complete detailed method to upload Inventory Item category assignments into your instance through WebADI.

A complete functional solution to uploading category assignments, no IDs required whatsoever. Just enter all the functional data available to you (that the WebADI demands for uploading category assignments) and the WebADI will do the rest for you.

This setup can be used to both CREATE and UPDATE category assignments at Item level.

Continue reading

Oracle EBS R12: Upload Inventory Items Through WebADI

This post will provide you with the complete detailed method to upload Inventory Items into your instance through WebADI.

Thats right, straight from the excel generated sheet right into your oracle instance. Bringing the uploading control right back to the Functional level.

All you need to do is set up the customized WebADI once, and upload away!

Continue reading