Link to home
Start Free TrialLog in
Avatar of Pau Lo
Pau Lo

asked on

oracle financials R12 financials DB experts

Are there any experts with experience of the database for oracle EBS (financials) r12 who can write a query to show all payments made and charged to a specific cost centre? I am not getting far on the oracle forums.
ASKER CERTIFIED SOLUTION
Avatar of Wasim Akram Shaik
Wasim Akram Shaik
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Pau Lo
Pau Lo

ASKER

Thanks ... is this for r12 or r11... also it is not the supplier that is setup as the cost center rather the internal team paying for the goods from the external supplier. As a rule every internal team in the organisation has a cost center and budget for purchases
Avatar of Pau Lo

ASKER

Vendor is supplier in uk
Avatar of Pau Lo

ASKER

We are basically after a list of payments linked to a specific cost center (internal team)... my understanding was the invoice tables link to the ledger tables
Its for 11.5.10 that too for a link between payments made against invoices to vendors which is a generic query used in P2P process.

basically, to provide you a better answer we may need to understand your segregation of internal team and external teams.

Now if there are any customizations here in your part, it may need further digging to understand those.
Avatar of Pau Lo

ASKER

All the tables have changed though in r12. We follow the P2P process you noted. However I need to tie all payments (and invoices) to filter it based on data held with GL_CODE_COMBINATIONS:SEGMENT2)..
I have not yet worked on R12.. not sure about your requirement.. wait for some other experts to assist you further..