Fusion

Configuration changes in SetDomainEnv.sh

JAVA_PROPERTIES configuraion in SetDomainEnv.sh:- login to particular server Go to Domain/bin Take backup of SetDomainEnv.sh vi SetDomainEnv.sh Edit SetDomainEnv.sh and replace the JAVA_PROPERTIES url as per requested save and…

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…

Fusion – 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

Fusion – 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

Fusion – 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…

Fusion – 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>…

Fusion – 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:–>…

Fusion – 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>…

Fusion – 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>…

Project 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…

We take you from best practices to next practices of software implementation

Solutions that Ensure You Stay Ahead of Competition

Your Partner for Strategic Technology Solutions

Guiding Your Digital Transformation Journey