Skip to Main Content
Forums

Analytics Software

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!

Possible Block Creation Problem - Not Sure

708875Nov 4 2009 — edited Nov 4 2009
Account and Period are Dense. We basically want to put a qualifier in that if the 'Jan' intersection is not #Missing then it will not overwrite it with a zero. If it is #Missing then it can put the zero in the 'Jan' intersection..... Is this a block creation issue. I'm stumped.....

Why does this work just fine:


FIX( [Scenario_rtp] , [Version_rtp] ,[CCCC_rtp] , [Years_rtp] ,
[Activity_rtp] , [Resource_rtp] , [SAU_CAU_Facility_rtp],
"No_Account" )

"AN_Charge_Type" = 0;

ENDFIX


But this doesn't:


FIX( [Scenario_rtp] , [Version_rtp] ,[CCCC_rtp] , [Years_rtp] ,
[Activity_rtp] , [Resource_rtp] , [SAU_CAU_Facility_rtp],
"No_Account" )

"Jan"(

IF ("AN_Charge_Type" == #Missing)
"AN_Charge_Type" == 0;

ELSE
"AN_Charge_Type";

ENDIF;)

ENDFIX

Comments

Timo Hahn

User, tell us your exact JDev version, please!
Your REST endpoint wouldn't make sense this way. The 'Employees' represent a collection that isn't parameterized by default. That's why you normally add something like 'action' or 'acton/test1' to the endpoint to make sure everybody knows that you do something on the collection of employees.
I would not encourage you to use the method at all, as in 12.2.1.4 you don't even get it in the wizard. It's easier to create your own REST service and call the application module methods from there. This way you can design your own API, e.g more like OpenAPI instead of relying on JDev and ADF.

Timo

Joby-Oracle

I am using Jdev 12.2.1.5.0.
I used the above link for reference.
My actual URL looks like:
{{hostAddress}}/restApp/resources/11.13.18.05/employees
I have added manually methodAction tag in the resource xml file , to enable the custom method.
So you are saying that this is not possible using ADF .

Timo Hahn
Answer

There is no official version 12.2.1.5. You are using an internal version not available to the public.
All I'm saying is that you don't even see the method tab in 12.2.1.4 and custom methods are depricated. So, yes, from my point of view you can't do it with ADF REST service.
It might be possible that you see the tab in your version, but then you have to ask this question to some internal resource.

Timo

Marked as Answer by Joby-Oracle · Jun 2 2022
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 2 2009
Added on Nov 4 2009
#business, #business-intelligence-applications, #performance-management-applications, #planning, #planning-and-budgeting, #rules
1 comment
537 views