Oracle Analytics and AI

2845107

Hi Experts,

I am trying to understanding the OBI Apps tables and their uses and what kind of information they hold. Like below example

W_AP_INV_DIST_F Fact Table

AP Invoice Distributions

Fact table stores the AP invoice data at invoice distribution level

Can any one guide me through any link to get this kind of information would be great help.

Thanks

Thomas Dodds

What you posted answers your question ...

W = Warehouse OOTB (not custom)

AP = Accounts Payable

INV = Invoicing

DIST = Distribution

F = Fact  (base fact grain; not aggregated)

Now if you don't know what a distribution is from an accounting perspective that's a different matter:

"Distribution details include invoice accounting details, the GL date, charge accounts, and project information. An invoice line can have one or more invoice distributions."  Oracle EBS Docs

Distributing an invoice/invoice line means you can code it to various business functions for tracking. 

Silly example:  Think of your own checking account - you use the card and then maybe in your home finance application or on a site like Mint.com, you code the purchase to a category for tracking.  So you went to McDonald's for lunch on a work day - distribute that charge to Eating Out.  Go and get the same thing while on vacation; you might distribute it to Vacation, so later you can see how much you've spent eating out and what your total vacation costed you.