Hello Team and APEX Expert,
I am facing a strange problem with the Oracle APEX page.
How can I get Form Data Payload from the external web page (Payment Gateway -PG page) to Oracle Apex? Here I am not sure from which URL I am getting Respose to my APEX Page. I am using the APEX23.1.0 version. I can use APEX_WEB_SERVICW / ajax to get the response as I am not sure from which URL I need to get/consume the response.
Detail:
I have an APEX form in which I make a submit request to PG (with Required Parameters along with the SuccessURL/ Return URL. Here note that I am calling Payment getaway and Return URL both are APEX pages with the same apex Session ID)
Now I redirect to Payment Gateway. Here user can select any payment method and click on the Pay button. After successful payment, Gateway sends the POST Request to the APEX Return URL along with the Payment Success/Failure details (msg=S|123|pay_ID|... in From Data (In Inspect> Network I can see PG Payload).
Now here I am facing 2 problems,
- Once PG Page redirects to my APEX page (Called APEX Response Page) I get the HTTP status -403 (nonfriendly URL/ f?p..) OR HTTP - 404(friendly URL). My APEX response page is not loaded and a 404/403 error is displayed on the screen (Note: my APEX session is the same). I see the POST method along with the Payload in the Network tab. Now if I copy that URL and Paste it to another tab OR refresh the existing error page my APEX Response page displays well.
- Now after showing the proper APEX Response page How can I get the Payload (Payment Details) in the Oracle APEX page Item?
So After redirecting my APEX page back with Payment details, I need to see my APEX and Its response in my APEX item on the page.
Any help will be appreciated!