Hi Ashu, These are all the unique combination I am getting in my data: Payment Status CASE WHEN Payment Status Code IS NULL THEN Payment Status Name ELSE Payment Status END Payment Status Name Not paid Cleared Cleared Fully paid Fully paid Negotiable Negotiable Fully paid Voided Voided Fully paid So unfortunately, it does…

Ugh just typed up my comment and clicked select as best answer by accident and cannot undo it. Here goes again: I input the following formula: CASE WHEN "Payables Payments - Payment History Real Time"."- Payment Information"."Payment Status" in ('Cleared','Negotiable','Voided') THEN "Payables Payments - Payment History…

Hi Ashu, A - "Payables Payments - Payment History Real Time"."- Payment Information"."Check Status lookup Code" CLEARED VOIDED NEGOTIABLE B - "Payables Invoices - Transactions Real Time"."- Reference Information"."Payment Status Name" Fully paid Not paid Partially paid C - "Payables Payments - Payment History Real Time"."-…

Hi Brenda, Thanks for this code snippet, it is helping me get on the way but I'm not quite there yet for my own requirement. I want to run the report with 30 days (or 1 month, it does not have to be very accurate) added to the sysdate. I find it very hard to find what the syntax is in this SQL prefix. Tried a number of…

Hi all, I found this online: https://oraclecloudtools.com/ Does anyone have experience using this tool? Is it legit? Site looks a bit crappy. I'm a bit hesitant to try this out, also because the price is quite high for the functionality it's actually providing. Are there more third party software suites that connect to…

I totally agree with you on this. I don't need anything to execute actual queries, but just something which helps with editing based on the known Oracle table schema. Also to explore the schema, as the Oracle repository is not always that helpful. Having something like this would already be such a big help.

Hi Stephanie, You could use the RANK function to create a helper column and filter on this. I used this in a bit different situation, but I think it might work for you as well. We needed a deduped export of our employees, but the multiple (emergency) contacts added by employees were showing up one row each. We added a…

Also having the same issue. In my case I want a report outputting new joiners to our workforce, which is data we need to set up the users in other systems. Data is required from various subject areas, and a few are giving me a headache. Example: If HR has not yet received and/or entered the Bank Account from the new…

Hi Nathan, For quick and dirty SQL to troubleshoot issues I use the New analysis -- > Create Direct Database Query method. This sends you to <cloud base url>/analytics/saw.dll?Answers&criteriatype=physical Here I connect to Fusion OLTP Connection Pool. However, I did read in patch notes somewhere they're phasing this out…

Hi Santosh, Great tips on the keyboard short-cuts, those will come in handy. Those SQL developer tools are definitely something I'm looking for, but I am aware of the limitations. Was really hoping there's a way around and I am just doing it wrong all this time. Maarten

@Adam Bloom-Oracle is there any documentation available on those OAS command line scripts or OAC functionality? Is this included without any additional license requirements?

We had a couple of incident in the last months. Among others, there was an occasion where a folder was moved (breaking DM/Report links) and on another occasion an entire folder was deleted. Fortunately we could restore it using the Archive/Unarchive function using our TEST environment. This made us realise how fragile this…