Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI Receivables Subject Areas required Profile Class

Organization Name
EMSS
Description
In "Receivables - Customer Real Time" subject area there are two valuable fields which helps us with the classification AR Debt collection strategy, these are...
"Receivables - Customer Real Time"."Profile Class"."Account Profile Class"
"Receivables - Customer Real Time"."Site Profile Class"."Site Profile Class"
However, both of these fields are not available in any other Receivables OTBI subject areas; can these 2 fields be made available in all Receivables OTBI subject area especially "Receivables - Payment Schedules Real Time" subject area?
Thank you.
Use Case and Business Need
We need to break down the "Receivables - Payment Schedules Real Time"."Payment Schedules"."Accounted Amount Due Remaining" by Account Profile Class which is our debt collection strategy.
More details
I have raised a separate Customer Connect Forum post dated 4th September 2019 asking for help to produce a report using "Receivables - Payment Schedules Real Time" subject area as a based data but include Account Profile Class and Site Profile Class from "Receivables - Customer Real Time" subject area; but at time of writing this post there is no response.
I thought if these 2 fields were available directly in "Receivables - Payment Schedules Real Time" subject area it would makes the analytic run quicker than the Left Join query.
Original Idea Number: 3bf982f972