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…
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.…
How to populate View Object rows programmatically, without SQL?
I think that first thing beginner ADF developer gets familiar with is bussiness components (BC) and in particular View Objects. Thats the base and main axis of ADF BC. Most common usage is definately Entity or SQL Query based View Objects. But when facing a real world requirements, its not as rare case to build BC on some different kind…
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…