Not able to find the exact calculation for OTBI columns in OAC

Question

This is more like a technical question. I was trying to migrate one OTBI report to OAC and one of the condition I was trying to create is

when   cdl.reversed_flag is not null    or   cdl.line_num_reversed is not null   then 'Y' else 'N' end cdl_net_zero (Currently used condition in OTBI report).

I can find the corresponding column for cdl.line_num_reversed in OAC which is "PPM - Project Costs"."Cost Distributions"."Reversed Line Number" , but not cdl.reversed_flag.

Is this possible to help me with the logic I can use to write this?

RVohra · Answer

Hi @User_AYOKV , as a general recommendation, when migrating from OTBI to OAC /FDI

* Do NOT try to map column-for-column
* Instead map business meaning
* OAC/FDI models are redesigned warehouse models, not 1:1 OTBI clones

You might not need reversed_flag , for OAC/FDI, you might make it work without the flag.

Silvio Garber-Oracle · Answer

If you need the flag but it isn´t there you can bring it to FDI using data augmentation and add it to your subject area.