Oracle Fusion - Oracle Apps Technical Stuff

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

WSDL: https://serverName/fscmService/PayerDetailServiceV2?WSDLService Name: findAssignedInstrumentsByPayerPartyID : 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 APIREST API =================https://servername/fscmRestApi/resources/11.13.18.05/instrumentAssignments/{instrumentassignmentid}Operation: PATCHSample 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;