I was able to do a workaround for this problem using age old Oracle database practice. Though I am not using the Project BU in this query, I include a filter that looks for Project BU between 0 and ZZZZZZZ and this takes of using the Oracle index that exists.

I wrote a LSQL based query where I pick the Employee name from the 'Project Costing - Actual Costs Real Time' and the Employee number from the 'Project Billing - Invoices Real Time' subject area and I force the Project BU, Project number in the join criteria. This works but with limitations. You cannot pass the Project BU…

Is there a workaround for this problem? A few reports are getting timed out as Employee BU is not indexed. Even when you run a report of trying to get timecard data for 2 months for one employee, it times out.

Agreed. Here is a list of important pieces of Contract Info that one cannot report using OTBI: 1. Payment Terms (part of the Bill Plan) 2. Job based Bill Rates (Task Rate Overrides) 3. Job Title Billing Overrides 4. Bill Plans 5. Soft and hard limits on the contract 6. Invoice comments 7. Billing instructions 8. Revenue…

To be clear, Enterprise Contracts does report the contracts setup in PFM. However, it does not have information related to the soft, hard limits etc. It also does not help with reporting Task Rate Overrides which have the bill rates by job.

Hi Nathan, My query has nothing to do with Enterprise Contracts. In Project Financial Management, (PFM) there are two parts to a project. First the project is created and it has a schedule. It is assigned resources from HCM and this takes care of the cost side. Within PFM, you need to setup the customer contract for…

Logical SQL does work. It comes with maintenance headaches. Thanks for your suggestion Bhaskar. Oracle has to fix this glaring error, though.

@Praveena Kambhampati I disagree. Not everything can be turned into a pivot report. I solved the problem by doing a workaround on the detailed PO info being repeated. I used a white font for the white background and ensured that the totals show up for the PO. OTBI has several such limitations that I have reported here and…

Found this by a Google search and tested it. It works: TIMESTAMPADD(SQL_TSI_DAY,- DAYOFWEEK(MIN("Expenditure Item and Cost Distribution Details"."Expenditure Item Date")) + 1, MIN("Expenditure Item and Cost Distribution Details"."Expenditure Item Date"))

I forgot to include an important piece of information. In our setup, the British user cannot see Italian contracts and vice versa. They are allowed to see only their own business unit. Barring a few exceptions (Canada, Mexico and Middle East countries), contract, budget, revenues, costs are always in the country's local…

Thanks for sharing the document. The requirement we have is a very simple one. The UK user enters his/her amounts in Pound Sterling and the Italian user enters his/her amounts in Euros. The report, when run by the UK user must simply have the £ symbol before the amount and the Italian user should see € symbol. There is no…

Thanks Vivek for bringing this up. I raised a SR on this:…

See the attached screenshot where a repeating invoice number results in wrong invoice and outstanding totals. I have played with the various settings of 'Aggregate rules' and I am not able to get the result I am looking for. BTW, the behavior of OTBI is a bit different when it is driven by Logical SQL as opposed to picking…

Let me provide some more insight into what I am experiencing. I will take the case of a single project and one resource and one time entry of a US Consultant working on a Canadian Project. This is the what you get from Q1: Project Consultant Hours Cost Rate Cost Task Code Emp Type Comments PRJ123 Joe B 10 $100 1.3.2…

* Yes. I tried combining them and I do not get the results I was expecting. * Yes