PGP Key Encryption in AP Payment Outbound Interface
PGP Key Encryption in AP Payments Generally, the PGP keys will be used to Encrypt and Decrypt the messages transferred between one system to another to enable the security. In…
Read MoreFusion – Query to extract Oracle Enterprise Contract Clauses
Cloud Enterprise Contract Clause Query ============================ select ch.contract_number, cab.label||’ ‘||caa.article_title from okc_k_headers_vl ch,okc_k_articles_b cab,okc_articles_all caa, okc_article_versions cv where ch.id = cab.document_id and cab.article_version_id = cv.article_version_id and cv.article_id = caa.article_id
Read MoreFusion – Query to extract Customer Details
select hp.party_name customer_name, a1.account_number customer_number, a3.STATUS site_status, SITE_USE_CODE,LOCATION,PRIMARY_FLAG ,PARTY_SITE_NUMBER,A5.ADDRESS1,A5.ADDRESS2,A5.ADDRESS3,A5.ADDRESS4,A5.CITY,A5.POSTAL_CODE,A5.STATE,A5.COUNTRY from hz_cust_accounts a1,hz_cust_acct_sites_all a2, hz_cust_site_uses_all a3,HZ_PARTY_SITES A4,HZ_LOCATIONS A5, hz_parties hp where a1.CUST_ACCOUNT_ID=a2.CUST_ACCOUNT_ID and a1.party_id=hp.party_id and a2.CUST_ACCT_SITE_ID=a3.CUST_ACCT_SITE_ID and nvl(A1.STATUS,’A’)=’A’ and nvl(A3.STATUS,’A’)=’A’ AND A2.PARTY_SITE_ID=A4.PARTY_SITE_ID AND A4.LOCATION_ID=A5.LOCATION_ID
Read MoreFusion – Global Human Resources Views
Global Human Resources Views EEC_CONTEST_TEMPLATE_HDR_VL EEC_METRICS_VL EEC_REWARDS_VL HCM_EXTENDED_LOOKUP_CODES_VL HR_ALL_ORGANIZATION_UNITS HR_ALL_ORGANIZATION_UNITS_F_VL HR_ALL_ORGANIZATION_UNITS_TL HR_ALL_ORGANIZATION_UNITS_VL HR_ALL_ORGANIZATION_UNITS_X HR_ALL_POSITIONS HR_ALL_POSITIONS_F_VL HR_ALL_POSITIONS_X HR_BU_LOCATIONS_X HR_COMPANY_VS_V HR_COST_CENTER_VS_V HR_DOCUMENT_TYPES_VL HR_LEGAL_ENTITIES HR_LOCATIONS HR_LOCATIONS_ALL HR_LOCATIONS_ALL_F HR_LOCATIONS_ALL_F_VL HR_LOCATIONS_ALL_TL HR_LOCATIONS_ALL_VL HR_LOCATIONS_ALL_X HR_LOCATION_EXTRA_INFO HR_LOCATION_EXTRA_INFO_F…
Read MoreFusion – Sample Payload For FindCustomerAccount Operation In TCA Account Web Service
SOLUTION Below are some sample payload for findCustomerAccountOperation: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/cdm/foundation/parties/customerAccountService/applicationModule/types/” xmlns:typ1=”http://xmlns.oracle.com/adf/svc/types/”> <soapenv:Header/> <soapenv:Body> <typ:findCustomerAccount> <typ:findCriteria> <typ1:fetchStart>0</typ1:fetchStart> <typ1:fetchSize>1</typ1:fetchSize> <typ1:filter> <typ1:conjunction/> <typ1:group> <typ1:conjunction/> <typ1:upperCaseCompare>false</typ1:upperCaseCompare> <typ1:item> <typ1:conjunction/> <typ1:upperCaseCompare>false</typ1:upperCaseCompare> <typ1:attribute>AccountNumber</typ1:attribute> <typ1:operator>=</typ1:operator> <typ1:value>GB000557</typ1:value> </typ1:item>…
Read MoreFusion – Update Supplier, Supplier Site, Supplier Contact Payload – Webservice
<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/” xmlns:sup=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/” xmlns:sup1=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierSites/” xmlns:sup2=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierAddress/” xmlns:sup3=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplier/” xmlns:sup4=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierContact/”> <soapenv:Header/> <soapenv:Body> <typ:updateSupplier> <typ:supplierRow> <!–Optional:–> <sup:SupplierId></sup:SupplierId> <!–Optional:–> <sup:Supplier></sup:Supplier> <!–Optional:–> <sup:SupplierNew></sup:SupplierNew> <!–Optional:–> <sup:SupplierNumber>1538988727</sup:SupplierNumber> <!–Optional:–> <sup:AlternateName>SV supplier 01 updated</sup:AlternateName> <!–Optional:–> <sup:TaxOrganizationType></sup:TaxOrganizationType> <!–Optional:–> <sup:SupplierType></sup:SupplierType> <!–Optional:–>…
Read MoreFusion – Create Supplier, Supplier Site, Supplier Contact Payload – Webservice
<soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/types/” xmlns:sup=”http://xmlns.oracle.com/apps/prc/poz/suppliers/supplierServiceV2/” xmlns:sup1=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierSites/” xmlns:sup2=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierAddress/” xmlns:sup3=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplier/” xmlns:sup4=”http://xmlns.oracle.com/apps/flex/prc/poz/suppliers/supplierServiceV2/supplierContact/”> <soapenv:Header/> <soapenv:Body> <typ:createSupplier> <typ:supplierRow> <sup:Supplier>SV supplier01 Corporation</sup:Supplier> <sup:BusinessRelationship>SPEND_AUTHORIZED</sup:BusinessRelationship> <sup:TaxOrganizationType>CORPORATION</sup:TaxOrganizationType> <sup:SupplierType>SUPPLIER</sup:SupplierType> <sup:AlternateName>SV supplier 01</sup:AlternateName> <sup:SupplierBusinessClassifications> <sup:Operation>CREATE</sup:Operation> <sup:BusinessClassification>WOMAN_OWNED</sup:BusinessClassification> <sup:CertifyingAgency>Association for Women Owned Business</sup:CertifyingAgency> <sup:CertificateNumber>AS105</sup:CertificateNumber>…
Read MoreFusion – Sample Payload To Update Descriptive Flexfield On Internet Supplier Portal Invoice
Sample Payload to update AP Invoice Header level DFF attribute: Payload: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/” xmlns:erp=”http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/”> <soapenv:Header/> <soapenv:Body> <typ:updateDffEntityDetails> <typ:operationMode>single</typ:operationMode> <typ:object> <erp:EntityName>Payables Invoice</erp:EntityName> <erp:ContextValue>JLxMXPayablesInformation</erp:ContextValue> <erp:UserKeyA>DFF-1</erp:UserKeyA> <erp:UserKeyB>Vision Operations sample</erp:UserKeyB> <erp:UserKeyC>XXHealth Care</erp:UserKeyC> <erp:UserKeyD>12136</erp:UserKeyD>…
Read MoreProject Expenditures Import Using FBDI – Oracle Fusion
This blog describes the step by step process of Project Expenditures data conversion in Fusion Application using File Based Data Import. FBDI Template: ProjectUnprocessedMiscellaneousExpenditureItemImportTemplate.xlsm Interface Tables: PJC_TXN_XFACE_STAGE_ALL Base Table: PJC_EXP_ITEMS_ALL…
Read MoreFusion Reporting Sequence
Fusion Reporting Sequence Step by step process to create reporting sequencing in Fusion
Read More