nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Combining Project cost (Subject area) with General Ledger - Journals Real Time

Yamalia Roberts

Has anyone ever successfully created an OTBI report with Project - Costing Real Time and General Ledger - Journals Real time?

Having some issues with the values.

Thanks

Find more posts tagged with

OTBI

Accepted answers

Rich Merkel

Hi,

Please see if you can unarchive this file. Since it also has a prompt the archive allows us to embed the prompt too. I haven't found a way to get the XML for the dashboard prompt.

-Rich

Project Cost Account Reconciliation.catalog

All comments

RichardChan

I believe the rule for joining any subject areas are

Use common dimension fields
Include a measure from both subject areas
You don't have to use these in any of your tables or charts just in the criteria

Yamalia Roberts

Thanks, I've tried that. Some of the Project Columns (necessary ones) are blank.

Rich Merkel

I think the issue your probably dealing with are the AP related transactions.

They are not accounted in projects, so if you are looking for the accounting on invoices from project costing / GL the do not get accounted from projects to GL. It's AP to GL.

I have had some luck using project costing and subledger journals area to get the things like raw cost / raw cost clearing / burden cost / burden cost and using accounting class code in subledger journals to view the class, debit/credits along with concatenated segments posted to.

For invoices I've used a combination of invoice transactions subject area mixed with subledger journals and project costing to get the invoice postings.

You may need a complex query to combine both side that post from projects to GL along with the AP transactions posting directly to GL. (If there is burden calculated against invoice that will get picked up from project postings since that goes from projects to GL).

Only issue I've really had is when there is a payment discount back to the project, sometimes I'm unable to find the project # related to the discount on GL side specific, but you may have something like a supporting reference to do so.

Hope this helps...also suggest looking a the pre defined dashboard, keeping in mind same issue there is will only show costs originating in projects posting to GL, but not invoice posting.

Project cost account reconciliation (maybe copy the queries and edit to see the design)

Yamalia Roberts

Thanks @Rich....do you have the XML for that? For some reason I don't see that report. I'd definitely like to investigate it.

Rich Merkel

Hi,

Please see if you can unarchive this file. Since it also has a prompt the archive allows us to embed the prompt too. I haven't found a way to get the XML for the dashboard prompt.

-Rich

Project Cost Account Reconciliation.catalog

Yamalia Roberts

Thank you....Oracle is also recommending FAW. Just heard that today. What do you think

Klaus Dimitri Zuidwijk

So you are saying you should join Project costing, GL and payables subject areas to track the accounting coming from invoices in projects?

Upcoming Event

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…

Top Leaders