Need a query to get Period name for asset addition transactions in FA in ORACLE FUSION
Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period in which a capitalized asset is added to the system and the period in which a CIP asset is capitalized, which means the period where the addition transaction for an asset is done.
Hereby, I'm attaching the period name which is displayed in the front end for the transaction. Please do advise!