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!

Single Sign On in Oracle Apex

SharmaRishuNov 9 2017 — edited Dec 20 2017

Hi All,

I am facing issue while try to authenticate Oracle Apex from Oracle HCM Cloud. I am integrating Oracle Apex application with Oracle HCM cloud. I am able to integrate and able to pass data from Apex to HCM cloud. My challenge is in HCM Cloud i have link to Oracle Apex application , whenever i click on link it will redirect to oracle apex login page where i need to entered again user name and pwd. I need oracle apex application should authenticate based on HCM cloud username  and pwd . I need whenever i click on Apex application url in HCM cloud , it should open URL without login and pwd renter. I don't need apex page as public or no authentication. I need this should authenticate based Oracle HCM cloud authentication. Please any one help me to resolve this error. Appreciate if i can get quick update.

Kind Regards,

Harish Sharma

Comments

Martin Maes

We use the following templates to create (POST) and alter (PATCH) an extract process. This works for us.

POST:

{

    "description": "Integrated Extract",
    "source": {
        "tranlogs": "integrated"
    },
        "credentials": {
                "alias": "{{ gg_user_alias }}"
        },
        "registration":"default",
    "begin": "now",
    "targets": [{
        "name": "{{ gg_trail_prefix }}",
        "sizeMB": 250
    }],
    "status": "stopped"
}

PATCH


{

        "credentials": {
                "alias": "{{ gg_user_alias }}"
        },
        "config": [
                "extract {{ gg_process_name }}",
                "extTrail {{ gg_trail_prefix }}",
                "useridAlias {{ gg_user_alias }}",
        ]
}

P.Huang

Hi Martin,

Thanks for your reply. However I am having problem create the extract. As far as I can tell, my payload matches the JSON specification. Do you happen to have a working JSON payload that you can share so that I know the difference between the 2?

BTW, I am assuming the 2 payload you have are from ansiable template, and I will replace {{ xx }} with the actual value, say if you have

    "config": [
            "extract {{ gg_process_name }}",
            "extTrail {{ gg_trail_prefix }}",
            "useridAlias {{ gg_user_alias }}",
    ]

The real payload becomes

    "config": [
            "extract ee123456",
            "extTrail ee",
            "useridAlias boston19",
    ]

(want to make sure I am not missing brackets or quotes.....)

What version of GolenGate Microservice do you have?

Martin Maes

Hi Mr Huang

Yes, that's correct, we're using ansible to create the extract process. Here are the 2 payloads we submit to OGG

cat ansible.2s4lnb2fbuild/extract.post.body.json
{
        "description": "Integrated Extract",
        "source": {
                "tranlogs": "integrated"
        },
        "credentials": {
                "alias": "ecdpt01"
        },
        "registration":"default",
        "begin": "now",
        "targets": [{
                "name": "g2",
                "sizeMB": 250
        }],
        "status": "stopped"
}

oraadmt04:/tmp> cat ansible.5pcj45xbbuild/extract.patch.body.json
{
        "credentials": {
                "alias": "ecdpt01"
        },
        "config": [
                "extract EXDPT01",
                "extTrail g2",
                "useridAlias ecdpt01",
        ]
}

We're using the following Version of OGG:

Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054

Kind regards,

Martin

P.Huang

Thank you Martin,

Let me try to add an integrated extract with noncdb to see if it works.

P.Huang

Hi Martin,

I am getting the same error.

[oracle@workstation ~]$ cat yy

#!/bin/bash

vPayload='{

        "description": "Integrated Extract",

        "source": {

                "tranlogs": "integrated"

        },

        "credentials": {

                "alias": "ds01"

        },

        "registration":"default",

        "begin": "now",

        "targets": [{

                "name": "g2",

                "sizeMB": 250

        }],

        "status": "stopped"

}'

echo $vPayload | python -mjson.tool

curl -s -X POST \

http://fseast:7001/services/v2/extracts/pp \

--user "oggadmin:"oracle_4U \

-H 'Cache-Control: no-cache' \

-d $vPayload | python -mjson.tool

[oracle@workstation ~]$

[oracle@workstation ~]$

[oracle@workstation ~]$ ./yy

{

    "begin": "now",

    "credentials": {

        "alias": "ds01"

    },

    "description": "Integrated Extract",

    "registration": "default",

    "source": {

        "tranlogs": "integrated"

    },

    "status": "stopped",

    "targets": [

        {

            "name": "g2",

            "sizeMB": 250

        }

    ]

}  <--------------------------------------------------------------- this step confirms I have a good json document

{

    "$schema": "api:standardResponse",

    "links": [

        {

            "href": "http://fseast:7001/services/v2/extracts/pp",

            "mediaType": "application/json",

            "rel": "canonical"

        },

        {

            "href": "http://fseast:7001/services/v2/extracts/pp",

            "mediaType": "application/json",

            "rel": "self"

        }

    ],

    "messages": [

        {

            "$schema": "ogg:message",

            "code": "OGG-12110",

            "issued": "2020-02-24T00:27:19Z",

            "severity": "ERROR",

            "title": "JSON element '/uri/extract' value does not match the required pattern",

            "type": "http://docs.oracle.com/goldengate/c1910/gg-winux/GMESG/oggus.htm#OGG-12110"

        }

    ]

}

[oracle@workstation ~]$

Maybe I am using the wrong port?

7000 is server manager

7001 is admin server

If I change the port to 7000, I got the following:

{

    "$schema": "api:standardResponse",

    "links": [],

    "messages": [

        {

            "$schema": "ogg:message",

            "code": "OGG-12031",

            "issued": "2020-02-24T00:30:39Z",

            "severity": "ERROR",

            "title": "The requested resource does not exist.",

            "type": "http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1"

        }

    ]

}

User_8E7RZ

Hi.. did you get this to work. I am hitting the same issue. Can you please help me to get past the issue.

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 17 2018
Added on Nov 9 2017
5 comments
1,556 views