Credit Card Authorization With Paypal Gives ORA-00904: "EXTDATA"."CURRENCY": Invalid Identifier (Doc ID 1612406.1)

Last updated on JUNE 15, 2021

Applies to:

Symptoms

Attempting to perform credit card authorization with Paypal.  When submitting the order for booking, the following error is seen:

ERROR
-----------------------
Internal error to payment server:ORA-00904:"EXTDATA"."CURRENCY":invalid identifier (IBY_45000)

STEPS
-----------------------
Sales Order-->Header-->Lines
Enter sales order line. Save the order.
Goto header-->Other and select payment type as Credit Card.
Book the order.
Sales order status shows as booked but the authorization fails.

PL/SQL logs shows show the following error:

Input url = http://<server.domain>:<port>/OA_HTML/ibyecapp?OapfAction=oraPmtReq&OapfECAppId=660&OapfStoreId=pfp&OapfMode=ONLINE&OapfOrderId=ONT2002&OapfPrice=2700&OapfCurr=USD&OapfPayerId=12390&OapfOrgId=101&OapfOrgType=OPERATING_UNIT&OapfPmtRegId=10000&OapfPmtInstrType=CREDITCARD&OapfAuthType=AUTHONLY&OapfPmtChannelCode=CREDIT_CARD&OapfPmtInstrAssignmentId=227034&OapfRecMethodId=1004
Enter
starting req
set headers
writing body
reading resp
ENTER
INSTRUMENT_TYPE = CREDITCARD
debug pt 6
debug pt 1
debug pt 2
debug pt 3
debug pt 5
resp status code:=200
Exit
Exit
Enter
Exit
Setting fields from unpacked response
Response code=IBY_45000
Response status=3
Response message=Internal Error to Payment Server: ORA-00904: "EXTDATA"."CURRENCY": invalid identifier
x_return_status=U
req response status=3

Java layer logs show the following error:

[Dec 19, 2013 10:35:35 PM EST]:1387510535081:-1:-11:oacore.default_group.3:443294012:-1:-1:ANONYMOUS(-1):-1:Thread[AJPRequestHandler-HTTPThreadGroup-8,5,HTTPThreadGroup]:1387510531:000.00.00.000:21833:0:257:UNEXPECTED:[iby.ecapp.PmtECApp.oraPmtReq]:IBY_45000:ORA-00904: "EXTDATA"."CURRENCY": invalid identifier

[Dec 19, 2013 10:35:35 PM EST]:1387510535084:-1:-1:oacore.default_group.3:443294012:-1:-1:ANONYMOUS(-1):-1:Thread[AJPRequestHandler-HTTPThreadGroup-8,5,HTTPThreadGroup]:1387510531:000.00.00.000:21833:0:257:UNEXPECTED:[iby.ecapp.PmtECApp.oraPmtReq]:java.lang.RuntimeException: ORA-00904: "EXTDATA"."CURRENCY": invalid identifier

at ibyextend.TxnCustomizer_pfp.preTxn(Unknown Source)
at oracle.apps.iby.extend.ExtUtils.customizePre(ExtUtils.java:76)

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.