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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Vendor is supplier in uk
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.
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.
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:SEGME NT2)..
I have not yet worked on R12.. not sure about your requirement.. wait for some other experts to assist you further..
ASKER