Oracle Financial Consolidation and Close Cloud Service (FCCS) Certification Practice Test

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all
Session length

1 / 20

When creating a member mapping for account Sales in Data Management, the following script is entered. UD5 refers to a Product custom dimension: WHEN UD5 LIKE 'CAR_%' THEN 'AUTO_SALES'ELSE 'SALES'Which statement is True?

The script can be eliminated by using a multi-dim map on the Product dimension that also looks for the account Sales.

The script will work if the script is referenced in the In mapping type with #SQL as the target.

In Data Management, you can use SQL-style expressions in a member mapping by setting the target to #SQL. The script shown is a simple conditional expression: if UD5 matches the pattern CAR_%, the mapped product becomes AUTO_SALES; otherwise it becomes SALES. By referencing this script in an In mapping with #SQL as the target, Data Management evaluates the expression for each UD5 value and assigns the corresponding Product dimension member. That’s why this approach works—the mapping engine is designed to evaluate such SQL-like logic when the target is #SQL.

The other statements aren’t correct because Data Management does support scripting through #SQL, so claiming scripting isn’t supported is false; the idea of eliminating the script with a multi-dim map isn’t what the question tests; and there’s no requirement that UD5 values must start with FCCS_.

The script will not work since Data Management does not support scripting.

The script will not work since the UD5 member referenced does not start with FCCS_

Next Question
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy