Skip to Main Content

Cloud Connectivity

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

FCCS - Movements calculated from a FCCS_Mvmts_FX_Movement

Hello experts!
We are in the process of validating consolidated documents.
FCCS provides an FCCS_ClosingBalance_Input member to capture information. I am aware that this member is not consolidated or translated.
We configure the average exchange rate to carry out the conversion of the amounts, however when the information is uploaded to the consolidated ones, a movement is entered that performs a conversion with the closing exchange rate, this movement is carried out by the member FCCS_Mvmts_FX_Movement.
Why does the application calculate an adjustment in the movement FCCS_Mvmts_FX_Movement? It does this to equal the Closing Exchange Rate, even though I have configured the Average Exchange Rate. What is the purpose of such a calculation?
Also, is it correct to delete this setting so that my Income Statement shows the desired result? o How can I prevent this adjustment from being calculated and only take the average exchange rate?

Version

Service:Enterprise Performance Management Enterprise CloudBusiness

Process:Financial Consolidation and Close

Version:24.02.95

Regards!!

Comments

InoL Apr 29 2024

How doc gen treats nulls values?

You have to be more specific. Are your referring to the pre-built Document Generator function?

If so:

When my query return null in some columns

What is the JSON that is generated?

You should always include the element in the JSON, with an empty value. Don't leave it out.

Francois Robert-Oracle Jan 8 2025 — edited on Jan 8 2025

Since September 2024, when a tag has no corresponding value in the JSON data or the value is null, the tag is replaced by an empty string.

See the September Release Notes

1 - 2

Post Details

Added on Feb 29 2024
1 comment
456 views