Steps to Develop a custom PO Output for Communication Template
Generate the XML Tags from “PO Output for Communication” Based on the generated XML we need to develop a Custom RTF template. Once the Template is Developed it needs to…
Read MoreTroubleshooting XML Publisher Out of memory Error
When an BI Publisher report completes with Out of memory issue it can be at 2 Levels. XML Data generation Report Generation from XML data. This Document will cover the…
Read MoreUnderstanding XML Bursting in BI Reports
XML Bursting is used to split a single XML file in to multiple XML blocks as the per the defined XML Element. Below are the Steps involved. Generate the XML…
Read MoreAlternate Options for Using LISTAGG Function
If we have a Requirement to Concatenate the list of values in to a Single Field than we can achieve it with LISTAGG Function. As Listagg Function having Size limitation…
Read MoreQUERY TO FIND THE WORKFLOW SERVICE COMPONENETS STATUS
This following query is used to fetch the status of the workflow service components. login as APPS user, SQL> desc apps.fnd_svc_components; Name Null? Type —————————————– ——– —————————- COMPONENT_ID NOT NULL…
Read MoreMANAGING ORACLE TEMP TABLESPACE AND TABLESPACE RELATED QUERIES
Tablespace Management. Tablespace and datafile related dba tables dba_tablespacedba_data_filesdba_temp_files Tablepace Queries. To Create New Tablespace.create tablespace tablespace_name datafile ‘location/tablespace_name.dbf’ size 2g; Add new datafile to the tablespace.Alter tablespace add datafile…
Read MoreEXPORT AND IMPORT DATAPUMP BACKUP USING TABLESPACE PARAMETER
EXPORT AND IMPORT DATAPUMP BACKUP USING TABLESPACE PARAMETER In this blog, we are going to learn about how to do export/import data pump backup by using the tablespace parameter [oracle@oracle Desktop]$ cd [oracle@oracle ~]$ export ORACLE_SID=Trainee [oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu Feb 4 10:42:03 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started.…
Read MoreAR Tax code update API
Introduction: Requested to update the Tax code in customer Ship-to. Solution: We have update the Tax code by using the oracle API. API: DECLARE x_return_status VARCHAR2(10); l_init_msg_list VARCHAR2(1000) := FND_API.G_FALSE;…
Read MorePurchase order Detail Report
Introduction: User wants to pull the Open Purchase order details data. Solution: We provide the view to fulfill their requirement. View: CREATE OR REPLACE VIEW “APPS”.”XDMC_OPEN_PO_DETAIL_V” (“BUYER”, “VENDOR_NO”, “VENDOR”, “SITE_NO”,…
Read MoreAnnouncing New Sales Head – Pritam Jaipuriar
Leadership Announcement We are happy to announce the on-boarding of Pritam Jaipuriar as Vice President and Head of Sales. Pritam is an Electrical Engineer with extensive experience in manufacturing, software…
Read More