Creating Bank account,receipt method
md120_greece_bank_account-_-creation-2
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 MoreSIPEC – Doyensys Brings an Exclusive Month-End Close Product for Oracle Process Manufacturing Users
For all large-sized organizations, month-end close is a crucial process. The management expects the finance department to publish the results at the earliest possible. However, the department has a dependency…
Read MoreWhen Doyensys worked with an International Fitness and Lifestyle Client
A billion-dollar Manager Services Provider, based in the US, offers multiple products and services to their clients. It provides database management and migration to Cloud, among other services. The company…
Read MoreItem Interface(Update)
DECLARE CURSOR C1 IS SELECT (upper(A.item_code)) ITEM_CODE, A.ORGANIZATION_ID ORG_ID, A.sales_account FROM hs_item_sales_account_conv A WHERE A.ORGANIZATION_ID=111 AND A.ITEM_CODE IN() AND EXISTS (SELECT 1 FROM MTL_SYSTEM_ITEMS_B MSI WHERE MSI.ORGANIZATION_ID=111 AND MSI.SEGMENT1=(upper(A.item_code))); BEGIN…
Read MoreWhen Doyensys was approached by Hardscape and Masonry Company to Reduce the Operating Expenses
In today’s time, technology is at the core of the smooth functioning of organizations. Such is the dependence that it is hard to imagine a day without it. However, it…
Read MoreLife At Doyensys – Prem Shanker Singh
Employees are the backbone of an organisation. With the right people, a company can not only achieve its goals but also surpass them. We want to thank our employees and…
Read MoreFind tax intended use for an Item
SELECT NVL (attribute_value, ‘N’) FROM jai_item_templ_hdr_v jih, jai_item_templ_dtls_v jid WHERE 1 = 1 AND jih.template_hdr_id = jid.template_hdr_id AND jid.attribute_code = ‘RECOVERABLE’ AND jih.inventory_item_id = 73838 AND jih.organization_id = 101
Read MoreAR Transaction Register Details report at Distribution Level
The below is the query for AR Transaction Register details at Distribution Level SELECT RCTL.CUSTOMER_TRX_line_ID, hou.name ou_name, c.account_number “Customer Number”, ( SELECT party_name FROM apps.hz_parties WHERE party_id = c.party_id )…
Read MoreAR Transaction Register Summary Report
The below is the query for AR Transaction Register Summary Report at Line Level SELECT hou.name ou_name, c.account_number “Customer Number”, ( SELECT party_name FROM apps.hz_parties WHERE party_id = c.party_id…
Read More