An India-based global leader in Energy and Process Automation Solutions has been a customer of Doyensys for several years. Along the way, Doyensys has established itself as a trusted partner…
Read MoreSince the inception of Doyensys, there have been a few clients who have supported us whole-heartedly. They have been instrumental in our journey and have anchored our growth. One such…
Read MoreOutbound Interface using PL/SQL Follow the steps PLSQL Stored Procedure (utl_file Method) to design the Outbound Interface in Oracle Apps PROCEDURE XX_PAYMENT_EXTRACT(p_err_message OUT VARCHAR2, p_err_code OUT NUMBER) is CURSOR…
Read MoreFBDI Upload Data from EBS supplier-invoice-mapping doyensys_ebs_fusion_integration_fbdi_v2
Read Moresteps-for-creating-bip-reports-in-fusion Oracle Fusion has divided the Oracle Reporting system in 2 Parts. BIP (Business intelligence publisher) BIP :- BIP is the customize reporting tool. Oracle Fusion has provided BIP to…
Read MoreThe following steps have to be created in fusion before extracting data from EBS instance: BU Legal Entity Assign legal entity with BU Ledger Assign Legal Entity with Ledger…
Read MoreDownload the Standard Workflow for creating a new workflow item type: To download the workflow file we can download using wfload or from Oracle Workflow Builder. Navigation: File –>…
Read MoreTip 1 – Monitor Wait Times Oracle provides wait events that allow you to understand the total time a query spends in the database. Start your tuning efforts with the…
Read MorePO interface based on project, Task, Expenditure type Staging.sql CREATE TABLE APPS.XX_NEW_PO ( ROWNUMBER NUMBER, SUPPLIER_NUMBER VARCHAR2(30 BYTE), SUPPLIER_SITE VARCHAR2(30 BYTE), SUPPLIER_NAME VARCHAR2(240 BYTE), PO_NUMBER VARCHAR2(30 BYTE), SHIP_TO_LOCATION…
Read MoreQuery to check if DMZ is enabled select p.user_profile_option_name “Profile Name”, decode(v.profile_option_value, 1, ‘Admin’, 2, ‘Normal’, 3, ‘External’, ‘Unknown’) Value, decode(v.level_id, 10001, ‘SITE’, 10002, (select ‘App:’||a.application_short_name from fnd_application a where…
Read More