OTBI - Join/Union Subject Area Payables Transactions Real Time to Payables Installments Real Time — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI - Join/Union Subject Area Payables Transactions Real Time to Payables Installments Real Time

edited Jan 24, 2025 9:01AM in Payables, Payments & Cash Management 5 comments

Summary:


Content (please ensure you mask any confidential information): We need to pull Due Date from Subject Area Installments Real Time against columns Invoice Number and Concatenated Segments (Distribution Combination) from Transactions Real Time in OTBI. As soon as we pull due date, it breaks the analysis.

Is there any Union that can be done between these two subject areas? Invoice Number is available in both SAs but Concatenated Segments (Transactions) and Due Date (Installments) are unique. Column matching needs to be one for one and I don't know if this combination is doable.


Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!