Skip to Main Content

APEX

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!

How to change the Home URL of an Apex Application using Apex API in Oracle Apex 5 ?

RobieAug 2 2016 — edited Aug 9 2016

Hi Guys,

I have 2 questions regarding Apex API Concept.

According to our requirement. we need to create the Application Authentication Schemes and Applications using Apex API.

Now we successfully created the Application items, Application Process, Pages, Items.

1. Can anyone help me on how to set the home URL of an Apex Application Using Apex API ?

We all know that to change the Home URL of an application through Shared Components > User Interface > Desktop > Home URL

But here we want to change the Home URL from Apex API / PL/SQL.

Below is the code, we tried to implement using Substitution String API but it's not working.

BEGIN

  **wwv\_flow\_api.set\_static\_sub\_strings**

                **(p\_flow\_id                     => lv\_n\_user\_interface\_id,**

                 **p\_substitution\_string\_01      => 'HOME\_LINK',**

                 **p\_substitution\_value\_01       => 'f?p=&APP\_ID.:3006:&SESSION.'**

                **);**

END;

2. Our requirement is to implement the SSO Concept in Apex Application. Hence We created the authentication scheme using Apex API, Below is the implementation Query,

BEGIN

  **wwv\_flow\_api.create\_authentication**

                         **(p\_id                             => wwv\_flow\_id.next\_val,**

                          **p\_name                       => 'HTTPHeaderAuth',**

                          **p\_scheme\_type           => 'NATIVE\_HTTP\_HEADER\_VARIABLE',**

                          **p\_attribute\_01              => 'REMOTE\_USER',**

                          **p\_attribute\_02              => 'ERROR',**

                          **p\_attribute\_04              => 'No user exists &APP\_USER.',**

                          **p\_attribute\_06              => 'CALLBACK',**

                          **p\_post\_auth\_process   => 'post\_auth',**

                          **p\_use\_secure\_cookie\_yn      => 'N',**

                          **p\_ras\_mode                  => 0**

                         **);**

END;

Oracle Community.PNG

We successfully Created the HTTP Header Type Authentication but we can't set it as Make Current Scheme.

How we can set it as a current scheme through the API ?

Can someone help me on this ?

I'm using

Apex Version - 5.0

Theme - Universal Theme

Apex Listener - PL/SQL Gateway

Database - Oracle 12 C

Thanks in advance!!!

Regards,

Robie

Hi Guys,

I have 2 questions regarding Apex API Concept.

1. Can anyone help me on how to set the home URL of an Apex Application Using Apex API ?

We all know that to change the Home URL of an application through User Interface > Desktop > Home URL

but here we want to change the Home URL from Apex API / PL/SQL.

Below is the code, we tried to implement but it's not working.

BEGIN

  **wwv\_flow\_api.set\_static\_sub\_strings**

                **(p\_flow\_id                     => lv\_n\_user\_interface\_id,**

                 **p\_substitution\_string\_01      => 'HOME\_LINK',**

                 **p\_substitution\_value\_01       => 'f?p=&APP\_ID.:3006:&SESSION.'**

                **);**

END;

2. Implementing SSO Concept in Apex Application. Hence We created the authentication scheme using Apex API, Below is the implementation Query,

BEGIN

  **wwv\_flow\_api.create\_authentication**

                         **(p\_id                             => wwv\_flow\_id.next\_val,**

                          **p\_name                       => 'HTTPHeaderAuth',**

                          **p\_scheme\_type           => 'NATIVE\_HTTP\_HEADER\_VARIABLE',**

                          **p\_attribute\_01              => 'REMOTE\_USER',**

                          **p\_attribute\_02              => 'ERROR',**

                          **p\_attribute\_04              => 'No user exists &APP\_USER.',**

                          **p\_attribute\_06              => 'CALLBACK',**

                          **p\_post\_auth\_process   => 'post\_auth',**

                          **p\_use\_secure\_cookie\_yn      => 'N',**

                          **p\_ras\_mode                  => 0**

                         **);**

END;

Oracle Community.PNG

We successfully Created the HTTP Header Type Authentication but we can't able to make it as a Make Current Scheme Option.

How we can make it as a current scheme through the API ?

Please Help me on the above topics.

Thanks in advance!!!

Regards,

Robie

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2016
Added on Aug 2 2016
3 comments
3,651 views