Paymentech Credit Card Testing in Test Instance

Paymentech Credit Card Testing in Test Instance

1)Testing HTTP (non SSL) connections from database to ECAPP servlet run the following query:

 SQL>select utl_http.request('&value_of_IBY_ECAPP_URL') from dual;

Must return:

Results

OapfCode: IBY_204704
OapfStatus: 3
...

NOTE: Please also verify the value of profile option "IBY: HTTP Proxy" when executing this test.

2)If you are using  HTTPS connection(SSL) please follow below query

Run the script bellow in SQL*Plus. The script will require the values set for the two profile options required at this code level.

SQL>variable wallet_loc varchar2(300);

SQL>exec begin :wallet_loc := iby_netutils_pvt.path_to_url('&value_of_FND_DB_WALLET_DIR'); end;

SQL>select utl_http.request('&value_of_IBY_ECAPP_URL', null, :wallet_loc, null) from dual;

Must return:

Results

OapfCode: IBY_204704
OapfStatus: 3
...

If you get any error in the sql result please follow the below note and check for the error.

Troubleshooting iPayment/Payments connection from Database to Engine (Doc ID 313951.1).

Follow below note if you are using Encryption in PROD and cloned the PROD data in TEST instance

How To Reset Oracle Payments Encryption Wallet Location After Instance Clone ? (Doc ID 1571608.1)

If you still face the same error then enable the debug as per below note and verify the log for the cause.

If Issue still exits please open oracle SR 
Follow the section "A" of the below note and upload all the files to the SR mentioned in the step 7.

Debug logs How to generate Debug Log Files for Oracle Payments Funds Capture R12 (Doc ID 452830.1).