Oracle
1Z0-241 · Question #24
The Customer Orders page has a requirement that Order Status cannot be changed to Closed if Fill Status is ' ' for any row in Order Details. You write a FieldChange PeopleCode program with a loop to…
The correct answer is A. &Status = FetchValue(Scroll ORDER_DTL, &I, ORDER_DTL.FILL_STATUS). See the full explanation below for the reasoning.
Question
The Customer Orders page has a requirement that Order Status cannot be changed to Closed if Fill Status is ' ' for any row in Order Details. You write a FieldChange PeopleCode program with a loop to check the values of Fill Status. Each loop increments &I. Which statement would you use in the loop to check the values of Fill Status?
Options
- A&Status = FetchValue(Scroll ORDER_DTL, &I, ORDER_DTL.FILL_STATUS);
- B&Status = FetchValue(&I, ORDER_DTL.FILL_STATUS);
- C&Status = FetchValue(ORDER_DTL.FILL_STATUS, &I);
- D&Status = FetchValue(ORDER_DTL.FILL_STATUS);
- E&Status = ORDER_DTL.FILL_STATUS;
How the community answered
(47 responses)- A81% (38)
- B2% (1)
- C2% (1)
- D9% (4)
- E6% (3)
Community Discussion
No community discussion yet for this question.