Replicate Project segment Code to Asset Number with different Event Type in Oracle OTBI Analysis
Summary:
Hi, I'm building an OTBI Analysis report using "Fixed Assets - Asset Transactions Real Time" subject area where the requirement is to copy the PROJECT segment code to each Asset Number regardless of the Event Type/Account Code. Any input is highly appreciated!
Content (please ensure you mask any confidential information):
Current Output:
Accounting Period Name | Asset Number | Event Type | PROJECT | Asset Cost Center Code | Account Code | |
|---|---|---|---|---|---|---|
Nov-24 | 111111 | CIP Addition | 0 | 123456 | 125000 | |
Nov-24 | 111111 | CIP Addition | 999999 | 123456 | 125999 | |
Nov-24 | 111111 | Capitalization | 0 | 123456 | 124100 | |
Nov-24 | 111111 | Capitalization | 0 | 123456 | 125000 |
Expected output:
Accounting Period Name | Asset Number | Event Type | PROJECT | Asset Cost Center Code | Account Code | |
|---|---|---|---|---|---|---|
Nov-24 | 111111 | CIP Addition | 999999 | 123456 | 125000 | |
Nov-24 | 111111 | CIP Addition |