Oracle Apps Technical Stuff: CreditCard

Use the below WSDL to get the Instrument assignment id for all available Credit Cards on a Customer

WSDL: https://serverName/fscmService/PayerDetailServiceV2?WSDL
Service Name: findAssignedInstrumentsByPayer

PartyID : PARTY_ID of HZ_PARTIES of a Customer

CustomerAccountId : CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS

Sample Payload
==================

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/payments/shared/payeePayerInstruments/externalPayerServiceV2/types/">
<soapenv:Header/>
<soapenv:Body>
<typ:findAssignedInstrumentsByPayer>
<typ:partyId>100000014531116</typ:partyId>
<typ:customerAccountId>100000032507573</typ:customerAccountId>
<typ:paymentFunction>CUSTOMER_PAYMENT</typ:paymentFunction>
<typ:instrumentType>CREDITCARD</typ:instrumentType>
</typ:findAssignedInstrumentsByPayer>
</soapenv:Body>
</soapenv:Envelope>

Sample Response

==============

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">
<env:Header>
<wsa:Action>http://xmlns.oracle.com/apps/financials/payments/shared/payeePayerInstruments/externalPayerServiceV2/PayerDetailService/findAssignedInstrumentsByPayerResponse</wsa:Action>
<wsa:MessageID>urn:uuid:d1447dc5-20e8-4f7e-9fa3-f90ee4f2e9df</wsa:MessageID>
</env:Header>
<env:Body>
<ns0:findAssignedInstrumentsByPayerResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/payments/shared/payeePayerInstruments/externalPayerServiceV2/types/">
<ns2:result xsi:type="ns1:AssignedPmtInstrument" xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns1="http://xmlns.oracle.com/apps/financials/payments/shared/payeePayerInstruments/externalPayerServiceV2/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns2="http://xmlns.oracle.com/apps/financials/payments/shared/payeePayerInstruments/externalPayerServiceV2/types/">
<ns1:InstrAssignmentId>300000055014</ns1:InstrAssignmentId>
<ns1:ExternalPayerId>300000055013</ns1:ExternalPayerId>
<ns1:PaymentFunction>CUSTOMER_PAYMENT</ns1:PaymentFunction>
<ns1:PartyId>100000011116</ns1:PartyId>
<ns1:CustomerAccountId>100000007573</ns1:CustomerAccountId>
<ns1:AccountSiteUseId xsi:nil="true"/>
<ns1:InstrumentType>CREDITCARD</ns1:InstrumentType>
<ns1:InstrumentId>31300900</ns1:InstrumentId>
<ns1:CurrencyCode xsi:nil="true"/>
<ns1:CardNumber>7809</ns1:CardNumber>
<ns1:CardExpirydate>2025-08-31</ns1:CardExpirydate>
<ns1:CardIssuerCode>MASTERCARD</ns1:CardIssuerCode>
<ns1:CardIssuerName>MasterCard</ns1:CardIssuerName>
<ns1:PurchasecardSubtype xsi:nil="true"/>
<ns1:CardHolderName>ABC Corp</ns1:CardHolderName>
<ns1:CardBillingAddressId>300000019901</ns1:CardBillingAddressId>
<ns1:CardFiName>300000008684</ns1:CardFiName>
<ns1:CardSingleUseFlag>false</ns1:CardSingleUseFlag>
<ns1:CardInformationOnlyFlag>false</ns1:CardInformationOnlyFlag>
<ns1:AccountNumber xsi:nil="true"/>
<ns1:BankName xsi:nil="true"/>
<ns1:BankNumber xsi:nil="true"/>
<ns1:BranchName xsi:nil="true"/>
<ns1:BranchNumber xsi:nil="true"/>
<ns1:BICNumber xsi:nil="true"/>
<ns1:Description xsi:nil="true"/>
<ns1:AssignmentLastUpdate>2022-12-16T11:49:26Z</ns1:AssignmentLastUpdate>
<ns1:AssignmentStartDate>2022-09-30</ns1:AssignmentStartDate>
<ns1:AssignmentEndDate>4712-12-31</ns1:AssignmentEndDate>
<ns1:CreatedBy>xyz</ns1:CreatedBy>
<ns1:CreationDate>2022-12-16T11:49:25.047Z</ns1:CreationDate>
<ns1:LastUpdatedBy>xyv</ns1:LastUpdatedBy>
<ns1:LastUpdateDate>2022-12-16T11:49:26Z</ns1:LastUpdateDate>
<ns1:LastUpdateLogin>EFF17E6849E8E0539560310A7831</ns1:LastUpdateLogin>
<ns1:ObjectVersionNumber>2</ns1:ObjectVersionNumber>
<ns1:PrimaryFlag>true</ns1:PrimaryFlag>
</ns2:result>
<ns2:result xsi:type="ns1:AssignedPmtInstrument" xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns1="http://xmlns.oracle.com/apps/financials/payments/shared/payeePayerInstruments/externalPayerServiceV2/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns2="http://xmlns.oracle.com/apps/financials/payments/shared/payeePayerInstruments/externalPayerServiceV2/types/">
<ns1:InstrAssignmentId>300000063931</ns1:InstrAssignmentId>
<ns1:ExternalPayerId>300000055013</ns1:ExternalPayerId>
<ns1:PaymentFunction>CUSTOMER_PAYMENT</ns1:PaymentFunction>
<ns1:PartyId>100000011116</ns1:PartyId>
<ns1:CustomerAccountId>100000007573</ns1:CustomerAccountId>
<ns1:AccountSiteUseId xsi:nil="true"/>
<ns1:InstrumentType>CREDITCARD</ns1:InstrumentType>
<ns1:InstrumentId>2479025</ns1:InstrumentId>
<ns1:CurrencyCode xsi:nil="true"/>
<ns1:CardNumber>XXXXXXXXXXXX5100</ns1:CardNumber>
<ns1:CardExpirydate>2030-03-31</ns1:CardExpirydate>
<ns1:CardIssuerCode>MASTERCARD</ns1:CardIssuerCode>
<ns1:CardIssuerName>MasterCard</ns1:CardIssuerName>
<ns1:PurchasecardSubtype xsi:nil="true"/>
<ns1:CardHolderName>ABC Corp</ns1:CardHolderName>
<ns1:CardBillingAddressId>300000013928</ns1:CardBillingAddressId>
<ns1:CardFiName>300000008683</ns1:CardFiName>
<ns1:CardSingleUseFlag>false</ns1:CardSingleUseFlag>
<ns1:CardInformationOnlyFlag>false</ns1:CardInformationOnlyFlag>
<ns1:AccountNumber xsi:nil="true"/>
<ns1:BankName xsi:nil="true"/>
<ns1:BankNumber xsi:nil="true"/>
<ns1:BranchName xsi:nil="true"/>
<ns1:BranchNumber xsi:nil="true"/>
<ns1:BICNumber xsi:nil="true"/>
<ns1:Description xsi:nil="true"/>
<ns1:AssignmentLastUpdate>2023-08-28T14:52:29.542Z</ns1:AssignmentLastUpdate>
<ns1:AssignmentStartDate>2023-08-28</ns1:AssignmentStartDate>
<ns1:AssignmentEndDate>4712-12-31</ns1:AssignmentEndDate>
<ns1:CreatedBy>xyz</ns1:CreatedBy>
<ns1:CreationDate>2023-08-28T14:52:12.09Z</ns1:CreationDate>
<ns1:LastUpdatedBy>xyz</ns1:LastUpdatedBy>
<ns1:LastUpdateDate>2023-08-28T14:52:29.542Z</ns1:LastUpdateDate>
<ns1:LastUpdateLogin>013AE5810B5E063E262310ABDD1</ns1:LastUpdateLogin>
<ns1:ObjectVersionNumber>1</ns1:ObjectVersionNumber>
<ns1:PrimaryFlag>false</ns1:PrimaryFlag>
</ns2:result>
</ns0:findAssignedInstrumentsByPayerResponse>
</env:Body>
</env:Envelope>

Use the Instrument assignment ID from above Payload in below Mentioned REST API

REST API

=================

https://servername/fscmRestApi/resources/11.13.18.05/instrumentAssignments/{instrumentassignmentid}

Operation: PATCH

Sample Payload

===================

{

"EndDate": "2024-03-12",

"Intent": null

}

User below SQL to get the Instrument assignment id for a Customer

SELECT p.party_name

, ca.cust_account_id

, ca.account_number

, iepa.ext_payer_id

, ipiu.instrument_payment_use_id instr_assignment_id

, ifte.*

FROM iby_creditcard icc

, iby_external_payers_all iepa

, iby_pmt_instr_uses_all ipiu

, iby_fndcpt_tx_extensions ifte

, hz_parties p

, hz_cust_accounts ca

WHERE p.party_id = icc.card_owner_id

AND p.party_id = ca.party_id

AND icc.card_owner_id = iepa.party_id

AND ca.cust_account_id = iepa.cust_account_id

AND iepa.acct_site_use_id IS NULL

AND icc.instrument_type = ipiu.instrument_type

AND icc.instrid = ipiu.instrument_id

AND iepa.ext_payer_id = ipiu.ext_pmt_party_id

AND ipiu.instrument_payment_use_id = ifte.instr_assignment_id

AND iepa.ext_payer_id = ifte.ext_payer_id

AND ca.account_number = :p_account_number;

Oracle Apps Technical Stuff

Tuesday, March 12, 2024

Update Credit Card "Assignment Inactive On" for a Customer in Oracle Fusion (Using SOAP/REST API)

Translate

Contact Form