Problem I have a bind variable (i.e. “bindVariableName“) defined in view object query scope. It is based on groovy expression which access ADF security context. In particular I try to verify whether user is in certain role: adf.context.securityContext.isUserInRole(“RoleName”). And get an exception: JBO-25186: Exception in expression “IsPlanAssumptProvideAssigned” of unknown type : oracle.jbo.ExprSecurityException Reason Looks that ADF does not execute groovy…
Author: Danas Tarnauskas
How to enable and disable flashback for a table in Oracle database? How to create flashback data archive?
Here is just a reminder what is Oracle Flashback in general: Oracle Flashback Technology is a group of Oracle Database features that that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery. Here are the steps which we need to accomplish if want to have table enabled…
What is an impact of “immediate” attribute either for UICommand and UIInput behaviour? ADF Faces Page lifecycle.
In ADF development we face immediate attribute for a button quite frequently. Sometimes developers do not clearly understand what the meaning and impact for action behaviour it cause. Actually this attribute makes sense not just for UICommand (buttons), but for UIInput (input fields) as well. And by the way, its not an ADF invention, it comes from JSF (Apache MyFaces) framework.…
What are possible message states in Oracle Advanced Queuing (AQ) ?
When we experience any problems with Oracle AQ (Advanced Queuing), messages are not going in or out, first place to look at is queue table itself. There is column STATE. It can tell us if a message is stuck for some reason or in any other state which can give us important information for debugging. Here are all states a message…
Depended list of values (LOV) in ADF Desktop Integration (ADFDI) table component
It is so common requirement in any kind web apps – to have dependent lists of values. For example in order to choose location, first of all we choose country, then in another combo box choose state, which is already filtered out against country. MS Excel itself has such a feature. We implement lists of values in excel by adding…
How to delete a record in table component of ADF Desktop integration (ADFDI) Excel workbook?
In my previous post I’ve introduced what needs to be done in order to be able to insert and update data in ADF Desktop integration (ADFDI) table component: How to insert new record in table component of ADF Desktop integration (ADFDI) Excel workbook ? How to update a record in table component of ADF Desktop Integration (ADFDI) Excel workbook ?…
How to insert new record in table component of ADF Desktop integration (ADFDI) Excel workbook ?
In previous post I’ve provided some guidance how to use update operation in ADFDI table component. Here I’m going to show how to insert data. Assuming that you’re already familiar with update from post – How to update a record in ADF Desktop Integration (ADFDI) Excel workbook table component?. I’ll just further extend demo application developed in preceding post. So, to support…
How to update a record in table component of ADF Desktop Integration (ADFDI) Excel workbook ?
Update – the easiest of CRUD operations to configure in ADF Desktop Integration (ADFDI) table component. Here is what needs to be assured to have it working: Commit action binding available in page definition file. Upload ribbon command is set up in excel worksheet. It must have at least to actions – upload and commit. Updating of row enabled in…
How to pass a parameter to ADF Desktop Integration (ADFDI) excel workbook?
ADF Desktop Integration (ADFDI) would not be so attractive and flexible if we could not parameterise data requests to limit data scope working on. Thus parameterising is must have feature and it might look not so straight forward how to leverage it. Because we need to set it up in several places all the way to application layer, where data…
How to create ADF Desktop Integration (ADFDI) Excel workbook
I’m going to show the basic steps to get ADF Desktop Integration (ADFDI) Excel workbook running. Here is what we need to accomplish: Create Fusion web application with some ADF bussiness components in model layer. Create ADFDI page definition file. This one will be dedicated for excel and provide necessary bindings to be utilised by ADFDI Excel components. Create special…