Oracle APEX and Adobe Sign integration - part 3
APEX stuff in one place
by
1w ago
  Oracle APEX and Adobe Sign electronic signature integration Retrieving the access Token   In the first two parts we learned how we can let end users authorize your APEX app to send request to Adobe which resulted in code being returned to us. This was then used as a token to retrieve access and refresh tokens which we will be using going forward. Before we proceed further at this stage we need a document that we want people to sign. If you are already on AOP this would be the place and time to generate the document perhaps store it in a table so that we can send it to Adobe API. Ho ..read more
Visit website
Oracle APEX and Adobe Sign integration - part 2
APEX stuff in one place
by
1w ago
Oracle APEX and Adobe Sign electronic signature integration Retrieving the access Token   Now that we have verified that our ORDS REST redirect call is functioning as expected we need to try doing the same using the full Adobe OAuth process. Again the simplest way is add another button called Request authorization to your page which will be submitting the page or redirecting to URL should work too.  Add a post processing branch that redirects to  https://secure.au1.adobesign.com/public/oauth/v2?redirect_uri=https%3A%2F%2Fapex.oracle.com%2Fpls%2Fapex%2FYOURREST%2Fadobe%2Fredire ..read more
Visit website
Oracle APEX and Adobe Sign integration - part 1
APEX stuff in one place
by
2w ago
  Oracle APEX and Adobe Sign electronic signature integration Getting your documents signed electronically   Back in 2017 I had an opportunity to write about DocuSign integration with Oracle APEX and documents generated with AOP. This time around it is the post about its alternative.    How do we integrate Adobe Sign and electronic signature with our APEX apps?  Before we get started first thing we need to do is read/visit an extensive documentation on Adobe website.    After initial intro from Adobe you should have an idea how things work. As usual we typica ..read more
Visit website
Getting different results in APEX app vs SQL Commands/database - default conversion?
APEX stuff in one place
by
2M ago
  Oracle APEX vs SQL Commands/database execution - default conversion Getting different results?   Another one for the books. You have a procedure or a function that someone developed which runs in APEX application without any problems.    Someone gives you to change a smallest piece in it and you are ready to test it. You take the same code and try to run it in SQL commands or in your SQL developer.    All of the sudden some strange database errors come up like typically ORA-01843 not a valid month. You make sure parameters you pass in are correct? Check.  ..read more
Visit website
Oracle APEX Classic report Card template - card link
APEX stuff in one place
by
4M ago
  Oracle APEX Classic report Card template - card link Making your card be a link?   This one is more for my reference as it comes handy on many occasions.   You made a classic report with a card template based on a query and you want your card title link to be applied on card level? Quick cookbook: create region based on a query pick one column and make it a link using column settings for example card_title Create After Refresh region Dynamic action and this JS to it $('.t-Card-title a').each(function(index) {    lnk = $(this).attr('href');       ..read more
Visit website
Oracle APEX page Item type Number - Format and alignment vs Read Only
APEX stuff in one place
by
4M ago
  APEX page Item type Number - Format and alignment vs Read Only Format is not respected and item changed alert triggers?   Here is the situation, you have a simple form with number fields. Imagine you have to make some read only vs some that need to be enter-able but right aligned. We all know it is easy to do - you would go into the page and change item settings and move onto the next task.  If you look closely you will notice that read-only field will encounter two issues. It does not format the number any more if you provided the format.    Secondly, APEX also ..read more
Visit website
ORACLE APEX page item Text Case setting
APEX stuff in one place
by
5M ago
ORACLE APEX page item Text Case setting Value Placeholder text gets updated too - How to fix it? We may argue that this is one of unwanted features of APEX 23.x but it is what it is.  Here is the situation, you have a simple form with fields and someone asks you to impose a rule on one of the items that as soon as end users enters a value we want it to be upper or lower cased.  Luckily there is a nice Item setting to help us with it called Text Case situated under Settings section   Only issue we found is that except doing what you expected making your input text upper or low ..read more
Visit website
ORACLE APEX Application item with global scope
APEX stuff in one place
by
6M ago
  ORACLE APEX Application item with global scope Sharing the value between two or more applications - How to? Simple use case - we have two apps that share authentications and now we want to pass the application items value between these two.  For a long time now APEX application definition had this feature where we can declare global application items.  But what does it actually mean and how do we actually do this when there are more apps in place?!!  Create an app, add an application item to it with a global scope. Have some way of setting this item to a certain value ..read more
Visit website
Using this.triggeringElement in apex.item
APEX stuff in one place
by
8M ago
ORACLE APEX Dynamic action - apex.item and this.triggeringElement A perfect JavaScript expression usecase If you ever wanted to trigger your DA based on an item that is a select list here is a quick read. Scenario here is we want to trigger an action when item we interacted with contains a certain string like NBME in my case. How would we do this?  To be 100% correct we want to check it against the item display value and not its return value (one hidden from the end users). I strongly encourage you to visit apex.oracle.com/jsapi for a full reference of apis available to us.  We all k ..read more
Visit website
ORACLE APEX Security scan - APEX SERT 23.1
APEX stuff in one place
by
9M ago
  ORACLE APEX Security - APEX SERT 23.1 Free and easy security scanning tool for your Oracle APEX apps Kscope has passed and I managed to get some time to do this.  A new version of APEX SERT for APEX 23.1 has ben made available for download. Anyone who is on APEX 23.1 version this is the SERT version you want to be on. Install, share and provide feedback ;) Happy APEXing, SLino   p.s. will be working to get this onto the original repo soon OraOpenSource/apex-sert ..read more
Visit website

Follow APEX stuff in one place on FeedSpot

Continue with Google
Continue with Apple
OR