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
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
I believe the rule for joining any subject areas are
Thanks, I've tried that. Some of the Project Columns (necessary ones) are blank.
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)
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.
Thank you....Oracle is also recommending FAW. Just heard that today. What do you think
So you are saying you should join Project costing, GL and payables subject areas to track the accounting coming from invoices in projects?
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
