Blog / Category
People and Culture Blog
1143 articles in this category
Dataguard manual switchover
Introduction Oracle Data Guard plays a pivotal role in ensuring business continuity by maintaining synchronized standby databases that can seamlessly take over…
Troubleshooting Query Plan Optimization Using Query Store
Introduction SQL Server Query Store is enabled to assist in monitoring query performance and identifying query plan regressions. Query Store captures a history…
When tempdb Won’t Shrink
Introduction In SQL Server, the tempdb system database can grow significantly due to heavy workloads, temporary objects, or large queries. Sometimes, even after…
How I Grew in My Career at Doyensys
From a Fresher to Project Manager: My 12-Year Journey at Doyensys “Do your work and the rest will follow.”– These simple words reflect the career journey of Akh…
AR Invoice Created Through Autoinvoice Cannot Be Completed Due To Error
AR Invoice Created Through Autoinvoice: Cannot Be Completed Due To Error Error ORA-01407: cannot update (???) to NULL ORA-06512: at “FUSION.ARP_UTIL”, line 6272…
SLA Customization in Oracle Fusion.
What is Subledger Accounting? Oracle has provided standard accounting derivation for all the possible events of different aspects of business. However, there co…
Fixing Node Not Ready in Kubernetes
Fixing Node Not Ready in Kubernetes Introduction/Issue: One day, while working on our Kubernetes cluster, we noticed that one of the nodes went into a NotReady…
Read permission on secondary replica in always-on AG
How to give read permission on secondary replica in always-on AG Purpose of Log shipping: Always On availability groups feature is a high-availability and disas…
Permission on secondary database in loginshipping
How to give read permission on secondary server in log shipping Purpose of Log shipping: SQL Server Log shipping allows databases to automatically send transact…
Convert Comma-Separated Values from a Single Row into Multiple Rows in MSSQL
Introduction:- Handling comma-separated values (CSV) is a common requirement in database management, especially when working with data that needs to be parsed i…
Seamlessly Integrating Python with Power BI Using Anaconda: A Comprehensive Guide
Introduction/Issue Integrating Python with Power BI using Anaconda can sometimes be challenging due to compatibility issues and configuration complexities. This…
Power BI Row-Level Security (RLS)
Introduction: Row-Level Security (RLS) in Power BI controls data access at the row level based on user identity. It restricts users to viewing only the data tha…
Power BI File Types Demystified: Your Guide to PBIX, PBIT, and PBIP
Introduction/Issue Understanding the different Power BI file types—PBIX, PBIT, and PBIP—can be confusing for users. This blog aims to clarify the distinctions b…
Enabling Navigation Menu Adjustments in Oracle APEX
Introduction : The navigation menu is a critical part of the user interface, enabling users to easily access various features and pages of the application. Howe…
Best Practices for Data Modeling in Power BI
Introduction In this blog post, we’ll explore the best practices for building effective and efficient data models in Power BI. Data modeling involves creating v…
Auto-Format Aadhaar Numbers in Oracle APEX Using Java Script
Introduction : Oracle APEX simplifies web app development, while JavaScript adds real-time interactivity. Together, they offer a powerful solution for capturing…
Balamurugan: From Humble Beginnings to Inspiring Leadership Starting the Journey
Balamurugan, fondly known as Bala, hails from Keezha Eral village in Thoothukudi district. Born in 1981, he grew up in Puliyanthope, a bustling neighborhood in…
Venkatesh GK: A Journey of Values at Doyensys
In the bustling heart of Madurai, where the air is fragrant with the aroma of Jigarthanda and Biryani, a young Venkatesh GKV, a passionate cricketer who spent t…
how-can-troubleshooting-for-a-network-switch-down
blog-2-how-can-troubleshooting-for-a-network-switch-down
how-can-troubleshoot-the-application-slowness-and-drop-issue
blog-1-how-can-troubleshoot-the-application-slowness-and-drop-issue
Extract Email Details to Excel File Using Power Automate
Introduction: Managing email communication is essential in any organization, and extracting specific details from emails can help streamline processes and impro…
OFFSETTING CUSTOMER AND SUPPLIER BALANCE NETTING
To offset the Customers and Supplier balances and update the accounts with netting balances. This functionality is enabled to check the AP and AR open invoices…
Limitation of the characters on creation of receipts
where the receipt entered by the accountant was crossing 20 digits which was an error, though it was reversed, it caused issues in GL, need to put limit on the…
Production to Test Clone Activity Oracle Fusion Cloud
Please follow below steps: Go to https://cloud.oracle.com Enter the cloud account name Choose OracleIdentityCloudServices click Next Login with Admin User Name…
How do you query Employee Type Suppliers from the Suppliers form, called from a custom Inquiry responsibility
Solution: 1) Exclude the function ‘Supplier Full Access: Buyer View’ from the responsibility assigned to the user From a System Administrator responsibil…
Password Generation
Introduction/ Issue: Write the issue that you face or the issue that you want to provide a solution through this blog. Password generation based on input parame…
Telephone Number Format
Introduction/ Issue: Write the issue that you face or the issue that you want to provide a solution through this blog. Mobile number should be digits Why we nee…
PostgreSQL Master and Slave Configuration Guide: Implementing Streaming Replication
PostgreSQL’s streaming replication is a powerful feature that allows real-time data replication from a primary database server (master) to one or more standby s…
Overcoming Deployment Hurdles: Managing Build Permissions
Introduction In today’s fast-paced development environment, efficient and smooth application deployment is critical. A common challenge faced by development tea…
Credit Card Format
Introduction/ Issue: Write the issue that you face or the issue that you want to provide a solution through this blog. Credit Card number will be formatting bas…
Zip code Validation
Introduction/ Issue: Write the issue that you face or the issue that you want to provide a solution through this blog. Zip code will be validated based on input…
Automating Infrastructure Monitoring with Datadog and Terraform
Introduction/Issue: As organizations scale their cloud infrastructure, maintaining consistent and effective monitoring becomes crucial. One common issue is the…
Optimizing Kubernetes Resource Management with ResourceQuotas
Introduction/Issue: In large-scale Kubernetes environments, managing and controlling resource allocation among different namespaces can become challenging. Team…
ORDS 22 Installation Steps
ORDS 22 Installation Steps Introduction: Installing Oracle REST Data Services (ORDS) 22 for Oracle Application Express (APEX) is crucial for enabling RESTful we…
Steps to Patch MySQL Server
Steps to Patch MySQL Server Introduction Patching your MySQL server is essential to maintain security, stability, and performance. This guide will walk you thro…
Customize Reports Header color in Oracle Apex
Introduction In Oracle APEX, crafting visually appealing and functional applications often involves customizing various elements to align with your brand or enh…
Customizing Logs with Serilog in ASP.NET Core
Introduction: Logging is essential in any application to ensure reliability and maintainability, especially in complex systems. In an ASP.NET Core Web AP…
Power BI Copilot
Power BI Copilot Introduction: Power BI Copilot is an AI-driven assistant integrated into both the Power BI Service and Power BI Desktop. It provides end users…
How to Dynamically Disable Slicers in Power BI Based on Selections
Introduction: In today’s blog post, we’ll explore how to enhance your Power BI reports by dynamically disable slicers in Power BI based on other slicer selectio…
AI VISUALS IN POWER BI
Introduction: – POWER BI, a leading tool in business intelligence, has embraced AI to offer advanced visual capabilities. This integration brings data to life,…
SQL Server Maintenance Plan
Introduction: A SQL Server Maintenance Plan is an essential strategy for managing and optimizing the performance of your SQL Server databases. These plans are d…
SQL DB Linked Servers
Introduction: SQL Server Linked Servers is a feature in Microsoft SQL Server that allows you to connect and execute commands against OLE DB data sources on diff…
SQL Server Show Plan Permission
Introduction: In this blog, we will explore what Show Plan permission is and how it can help DBAs and developers gain insights into the Estimated and Actual Exe…
SQL Server Query Store
Introduction The Query Store is a feature in SQL Server that provides insight into query performance by tracking and storing detailed information about query ex…
Oracle EBS – Query to get Purchase Order Details approved based on Hierarchy
Oracle EBS – Query to get Purchase Order Details approved based on Hierarchy Select * from ( SELECT TO_CHAR (SYSDATE, ‘DD-MON-YYYY HH:MI:SS’) rp_run_date, po.*…
Oracle EBS – Query to get Open Purchase Order Details
Oracle EBS – Query to get Open Purchase Order Details SELECT org_code, org, operating_unit, buyer, supplier, po_number, line_num line_number, item_code item, it…
How to Monitor the Performance of MYSQL Database
How to Monitor the Performance of MYSQL Database Introduction: – Monitoring MySQL performance is crucial for maintaining a healthy and efficient database system…
How to Monitor the Performance of Amazon DynamoDB
How to Monitor the Performance of Amazon DynamoDB Introduction: – Monitoring the performance of Amazon DynamoDB involves tracking key metrics, setting up alarms…
The Fundamentals of User Interface Design
The Fundamentals of User Interface Design Introduction: In digital experiences, user interface (UI) design is pivotal in shaping how users interac…
DB Alert Log: “Shutdown Waiting for Active Calls to Complete”
DESCRIPTION: When attempting to shut down database, the database hangs and the alert log contains the below messages. “SHUTDOWN: Waiting for active calls to com…
Configuring Select one, Select many page items In oracle Apex
Introduction: – Oracle APEX offers a robust set of page item types to capture user input effectively. Among these, Select One and Select Many items are p…
Hiding Default Toolbar Buttons in Oracle APEX Interactive Grids
Introduction Oracle APEX Interactive Grids are highly flexible for managing data, but sometimes you need to customize the toolbar by hiding default buttons like…
Dynamic Action Success Message Oracle APEX
Introduction: Oracle APEX (Application Express) is a robust platform that simplifies web application development. One key aspect of building user-friendly appli…
Open AI Assistant Dynamic Action In Oracle Apex
Introduction: – In Oracle APEX, the Open AI Assistant dynamic action allows us to seamlessly integrate a chat bot into our application. By using this feature, w…
Configuring AI With Oracle APEX Personal Workspace
Introduction: – Configuring AI with Oracle APEX Personal Workspace allows us to integrate AI capabilities into our APEX applications. By providing our AI with a…
Unlocking the Power of Scatter Plots in Power BI
Introduction As a data analyst, you’re likely familiar with the importance of visualizing data to gain insights and make informed decisions. One of the most pow…
Enhancing Navigation in Power BI: How to Use Image Buttons for Seamless Page Transitions
Introduction: Power BI offers robust tools for data visualization, but effective navigation within reports is crucial for a seamless user experience. Image butt…
Configuring dynamic action Browser event : Input in Oracle Apex
Introduction: – In Oracle APEX, browser events refer to various actions or interactions that occur within the web browser while users interact with a web page.…
Mastering Dates as Measures and Dimensions in Power BI
Introduction When working with dates in Power BI, it’s essential to understand the nuances of how they can be used as both measures and dimensions. In this blog…
Integrating Power BI Reports into Oracle APEX: A Step-by-Step Guide
Introduction: Integrating Power BI reports into Oracle APEX allows you to leverage advanced data analytics and visualization within your web applications. This…
Enhanced Dashboard Cards in Oracle APEX
Introduction In Oracle APEX, “Enhanced Dashboard Cards” provide users with a visually appealing and intuitive way to display key metrics and information at a gl…
Retrieving Values on Row Click in Oracle APEX Interactive Report
Introduction Interactive reports serve as pivotal components in Oracle Application Express (APEX), offering users a dynamic platform to explore and interact wit…
Customizing Individual, All, and Selective Column Widths in APEX Interactive Grid Using JavaScript
Introduction In Oracle APEX, customizing individual, all, and selective column widths in Interactive Grids using JavaScript enhances data presentation and usabi…
Drag-and-Drop File Upload, Zipping, and Database Storage in Oracle APEX
1.Introduction In Oracle APEX, integrating drag-and-drop file uploads with automated compression and storage in the database enhances user experience and…
Dynamically Highlighting the duplicates in the interactive grid in Oracle Apex
1. Introduction In Oracle APEX, the interactive grid is a powerful tool used to display and manage reports. It offers dynamic features, including the ability to…
IP ROUTING ISSUE
Introduction: This blog explains about troubleshooting IP routing issues in a Cisco network. Cause of the Issue? Usually, when we need to send/receive data from…
L2 VLAN CREATION AND VERIFICATIONS
Introduction: This blog explains about L2 (Layer 2) Vlans in the Local Area Network. This document reveals how to create/delete/modify and verification of L2 vl…
Client-Side Validation for APEX_ITEM Elements in Classic Report Using JavaScript
Introduction Client-Side Validation for APEX_ITEM Elements in Classic Report Using JavaScript” refers to the process of implementing validation checks directly…
Displaying an Icon on Page Item Dynamically Based on User Input
Introduction The goal is to display an icon on a post text of page item, dynamically based on user input. This approach enhances user experience by providing im…
Validation Based on Row Value in Interactive Report
1. Overview This document will be helpful to validate interactive report column value using dynamic action. 2. Technologies and Tools Used The following technol…
Updating InteractiveGrid using JSON
1. Overview This document will be helpful to update interactive grid data using JSON without using an automatic process or manual process. 2. Technologies and T…
How To Dynamically Hide Inbuilt Success Notification On Click Download In Interactive Grid
1. Introduction In this blog, we will learn how to hide inbuilt success notification on click download in interactive Grid. The following technologies has been…
Custom Checkbox Behavior in Oracle APEX Interactive Reports
1.Introduction In Oracle APEX, interactive reports are typically used for reporting purposes, as opposed to interactive grids, which allow for direct modificati…
Dynamically Hide/Show IG columns based on LOV in Oracle APEX
1.Overview This document explains about how to dynamically hide and show Interactive grid columns based on list of values in Oracle Apex 2.Technologies and Tool…
How to save multiple blob response into database table using java script(API&Promises) and AJAX callback in Oracle APEX
1. Overview This document explains about how to fetch response and save multiple blob contents into database table using JavaScript API & Promises and AJAX call…
Optimal utilization of Custom SLA can eliminate delays in Month-end closings
Optimal utilization of Custom SLA can eliminate delays in Month-end closings Introduction/ Issue: Effective utilization of Sub ledger Accounting can help…
AR Receipt Un-apply Using SOAP Webservice – Oracle Fusion
Introduction: This blog has the SOAP Webservice details that can be used to Un-apply AR Receipts in Oracle Cloud application. Cause of the issue: Business wants…
Import Auto Invoice – Error Message: You must enter a valid original system bill-to customer address reference. The current reference is {ORIG_SYSTEM_BILL_ADDRESS_REF.
Import Auto Invoice – Error Message: You must enter a valid original system bill-to customer address reference. The current reference is {ORIG_SYSTEM_BILL_ADDRE…
Restoration job failed in Log shipping
What is Log shipping? SQL Server Log shipping is an automatic process that sends transaction log backups from a primary database server instance to secondary da…
ORACLE E-BUSINESS SUITE 12.2.10 RELEASE UPDATE PACK failure : ORA-06501: PL/SQL: program error
This post talks about the issue you may encounter when applying R12.2.10 RUP patch as part of R12.2.11 Upgrade. ERROR: sqlplus -s APPS/<passwd> @/pvebsua…
TempDB full issue
TempDB Files space issue What is the purpose of tempdb in SQL server.? Ans: Tempdb is a temporary database which contains tables data for temporary purpose SQL…
Hot Patching in Oracle E-Business Suite R12.2: Best Practices and Considerations
Introduction: When it comes to managing Oracle E-Business Suite (EBS) R12.2, applying patches swiftly to tackle urgent issues is crucial. In the past, DBAs were…
ADOP cutover phase has failed in PROD system. But the Run and Patch file systems have switched roles.
Introduction: ADOP cutover phase has failed in a PRODUCTION system while running a patch cycle. But the roles between Run and Patch file systems have switched,…
Understating Transmission configuration in Oracle Cloud
Introduction Oracle fusion has a direct option to transmit the payment files from Cloud application to Payment system or Bank based on the setup defined in syst…
AR Interface Exception Corrections
AR Interface Exception Correction Introduction/ Issue: We have an invoice which need to be imported to oracle Cloud Applications but unfortunately it got…
Celebrating Doyensys Culture: A Day of Unity, Fun, and Recognition
At Doyensys, our culture isn’t just a set of values on paper; it’s the heartbeat of our organization, shaping every interaction and decision we make. Rooted in…
To Upload Credit Memos in EBS
DEclare l_tax_combination_id number; l_return_status VARCHAR2 (100); l_error VARCHAR2 (1000); v_request_id NUMBER; v_msg_count NUMBER; v_msg_data VARCHAR2 (2000…
Interfacing EBS Orders with External Application
We made use of utl_http to post json_data. This piece of code will help in sending data to Custom Applications DECLARE vrequest CLOB; oresp_status_code VARCHAR2…
Lease process from Lease creation to Termination
Step by step process for Lease Creation to Termination Go the Manage Leases : Enter all the details in Create Lease Page by clicking (+) button Once all details…
Foreign currency journals / FX Journals/ Entered currency journals
Steps Manage Exchange (Conversion) Rate type (Optional) Mange Exchange( daily) Rates Enter FX Journal and Post Manage Exchange (Conversion) Rate type (Optional)…
Uploading bulk users in oracle cloud
uploading-bulk-users-in-oracle-cloud
Broad access in Oracle cloud
broad-access-in-oracle-cloud
Revenue Recognition in AR
revenue-recognition
Suspense account setup in GL
suspense-account
Unleashing Efficiency: Navigating Business Optimization with Oracle ERP
In the fast-paced world of modern business, organizations are continually seeking ways to streamline their operations for enhanced efficiency. Enter Oracle ERP…
Unlocking the Power of Oracle Cloud: A Comprehensive Business Guide
In today’s rapidly evolving technological landscape, businesses are constantly seeking innovative solutions to enhance their performance and scalability. One su…
Nurturing Culture and Values
A company’s success is often attributed not only to its innovative products or services but also to the strength of its organizational culture. Doyensys stands…
Revolutionizing Medical Device Operations: Doyensys’ Successful Cloud Migration Journey
Doyensys, a global IT services powerhouse, has recently achieved a significant milestone with the successful execution of a groundbreaking upgrade and migration…
XML Bursting via Alerts
Initially there was an alert in the system but due to alignment Issues we planned to go with trigger and XML Bursting. As there was already Alert in the system…
Oracle / PLSQL: LISTAGG Function
Oracle / PLSQL: LISTAGG Function how to use the Oracle/PLSQL LISTAGG function with syntax and examples. Description The Oracle/PLSQL LISTAGG function concatenat…
Tricentis Tosca – Templates
introduction: Tosca test case templates are pre-defined structures that outline the general flow of test steps required for a particular testing scenario. These…
Create User and Add Responsibility from Backend
blog-2-create-user-and-add-responsibility-from-backend Query: declare v_user_name varchar2(30) :=’AJ_TEST’; — User Name v_password varchar2(30) :=’johnyt…
Script to Create Responsibility using API
blog-1-script-to-create-responsibility-using-api Query: CREATE TABLE APPS.XXRAN_RESPONSIBILITY_TAB ( RESP_NAME VARCHAR2(100 BYTE), APPLICATION VARCHAR2(50 BYTE)…
VLAN TRUNKING PROTOCOL IN NETWORK
Introduction: This blog explains about the feature of VLAN TRUNKING Protocol on Network. Why VTP IS REQUIRED ? Traditionally, when there are multi…
NETWORK DYNAMIC ROUTING PROTOCOL
Why Dynamic routing protocol? During the early days of the network, static routing was in the play. But later at the stage when the network start to grow static…
Query to generate file in remote server when new record inserted into table.
oracle-ebs-query-to-generate-file-in-remote-server-when-new-record-inserted-into-table Script 1: CREATE OR REPLACE DIRECTORY XDMC_OUTBOUND AS ‘XX_TEST/outbound/…
Query to Find Form Responsibility in Oracle E-Business Suite (EBS)
query-to-find-form-responsibility-in-oracle-e-business-suite-ebs Query 1: SELECT function_id,USER_FUNCTION_NAME, FUNCTION_NAME, form_name FROM fnd_form_function…
Undo accounting AP invoices to fix errors
undo-accounting-ap-invoices-to-fix-errors
Customize account rules for recoverable tax
customize-account-rules-for-recoverable-tax
How to zip current running file with out any issues on prod weblogic servers
Issue:- How to zip current running file with out any issues on prod weblogic servers Alert:– Disk space alert >90% from weblgoic servers Error:– Some times .out…
Weblogic apps are failed/admin state after applying weblogic patches and after restart twice came to up and running mode.
Issue: Weblogic apps are failed/admin state after applying weblogic patches and after restart twice came to up and running mode. If your weblogic applications a…
How to Upgrade JDK in OEM agent
Steps to upgrade the latest JDK in OEM agent : 1. Check JDK Version. Go to OEM agent location and check the java version. cd /u01/app/oracle/product/agent13c/ag…
Worker Assignment Change Using REST API – Oracle Fusion
Introduction: This blog has the REST API details that can be used to update worker assignment details in Oracle Cloud application. Cause of the issue: Business…
Cisco – Hot Standby Router Protocol (HSRP)
Introduction: This blog explains about the Cisco Hot Standby Router Protocol (HSRP) feature. What is HSRP? HSRP stands for Hot Standby Router Protocol. This is…
XML Publisher Bursting Barcode Font is Ignored
In XML Publisher Bursting Barcode Font is Ignored. An XML Publisher concurrent program that produces a PDF output with barcodes works when running the concurren…
BoM Interface
BoM-Interface
For Example, two countries the Natural account for Cash Clearing account should hit 1460020, this is to identify the TnE Cash Reimbursements.
For Example, two countries the Natural account for Cash Clearing account should hit 1460020, this is to identify the TnE Cash Reimbursements. The following conf…
Cash Management Reconciliation Error
Cash Management Reconciliation Error (Trying to match the lines and reconcile. However, system throws an error as it exceeds the limit of 10000.) Below attached…
Unable to Generate Accounting for Receipt GRNs
Introduction/ Issue: Unable to Generate Accounting for Receipt GRNs Why we need to do / Cause of the issue: Unable to Generate Accounting for Receipt Accounting…
Unable to Claim Expenses due to Aged Corporate Card Transactions
Introduction/ Issue: Employees Forced to Include At least One Aged Corporate Card Transactions. Why we need to do / Cause of the issue: Employee unable to claim…
Dynamic Visual Attribute
1. Overview This blog explains about, How to Set Current Record Color -Multi Color. 2. Technologies and Tools Used The following technology has been used to ach…
Email Checking Validation function
1. Overview This blog explains about, how we can Email validation using PLSQL function. 2. Technologies and Tools Used The following technology has been used to…
NETWORK ACCESS CONTROL LIST (ACL)
Introduction: This blog explains Network Access control list. What is an ACL? Access Control List is a Network security feature that filters traffic on Layer 3…
Using Bulk Collect with FORALL
1. Overview This blog explains about, How to insert bulk records within a milli seconds by using Bulk Collect with FORALL. 2. Technologies and Tools Used The fo…
Using Webutil browse file from desktop to dir
1. Overview This blog explains about, How to Use Webutil browse file from desktop to directory . 2. Technologies and Tools Used The following technology has bee…
Oracle EBS – Query to concurrent details for past 60 days
oracle-ebs-query-to-concurrent-details-for-past-60-days SELECT distinct ft.user_concurrent_program_name “Concurrent Program Name”, fr.REQUEST_ID “Request ID”, t…
Oracle EBS – Query to get PO details
oracle-ebs-query-to-get-po-details Select * from ( SELECT TO_CHAR (SYSDATE, ‘DD-MON-YYYY HH:MI:SS’) rp_run_date, po.* FROM (SELECT ou, supplier_number, supplier…
Google Cloud Infrastructure Using Terraform
Introduction to Google Cloud and Terraform Google Cloud Platform provides a comprehensive suite of cloud services, including computing, storage, databases, mach…
WebADI Create Document Redirects From HTTP To HTTPS
WebADI Create Document Redirects From HTTP To HTTPS Error := Causing Error ERR_SSL_PROTOCOL_ERROR On Oracle EBS R12.2.5 the default URL is HTTP:// but wh…
Inventory load failed in Oracle APPS R12
Inventory load failed in Oracle APPS R12 Inventory load failed… OPatch cannot load inventory for the given Oracle Home in Oracle APPS R12. Possibl…
Terraform Orchestration: Scaling Infrastructure Deployment with Modules and Workspaces
The Challenge:As infrastructures grow in complexity, maintaining and deploying resources across multiple environments can become a daunting task. Code duplicati…
CREATING MAINTENANCE PLAN FOR BACKUP
A maintenance plan is a set of measures (workflows) taken to ensure that a database is properly maintained and routine backups are scheduled and handled. Login…
Identify and remove unused indexes in SQL Server
Identify and remove unused indexes in SQL Server Introduction: Indexes means order information about data, with indexes we can retrieve data from the database m…
Database Migration from Non-ASM to ASM
We are going to convert our oracle Database to be migrated from Non ASM to ASM storage using RMAN commands Check the ASM instance is up and running If not start…
Cloning Tables Between Databases in SQL Server Using Export and Import Functions
Overview: Cloning tables between databases in SQL Server can be efficiently achieved through the use of the built-in export and import functions. This process i…
INSTALLATION OF OEM 13.5 USING SILENT METHOD IN ORACLE DATABASE 19.3 ON LINUX.
OEM OVERVIEW: Oracle Enterprise Manager is management tool, which is used for integrated solution for managing your heterogeneous environment. It Includes, Grap…
Upgrading Oracle database from 12.1.0.2 to 19.20 using AutoUpgrade tool
This blog aims to support DBAs upgrading databases from 12.1.0.2 to 19.20 using the new AutoUpgrade tool. Oracle Database AutoUpgrade is the supported and recom…
Converting a Non-CDB to PDB using remote cloning method
This blog aims to support DBAs in converting a Non-CDB database to a PDB using remote cloning method. Note: Non-CDB and target CDB are on different hosts (both…
Exploring the significance and utility of responsive number counters in Oracle APEX applications
Overview A responsive number counter is not only capable of displaying numeric values but also adjusts its appearance. It provides a means to present data or pe…
Installation of Autonomous Transaction Processing (ATP) Database
OVERVIEW: Oracle Autonomous Transaction Processing (ATP) is a cloud-based, fully managed database service by Oracle. It automates administrative tasks, enabling…
MongoDB Backup and Restore
This blog post will discuss the process of backing up and restoring a MongoDB database using the built-in commands and tools provided by MongoDB. To perform a d…
GridFS file system on Mongodb
Introduction to Grid FS: MongoDB has a 16 MB limit for normal document size. To store larger files, MongoDB offers Grid FS, which divides files into smaller chu…
PERFORMANCE TUNNING IN MSSQL
INTRODUCTION SQL tuning is the process of improving SQL queries to accelerate your servers performance. It’s general purpose is to reduce the amount of time it…
Enhancing Data Input Efficiency with APEX Multi Row Item Plugin
Overview The APEX-Multi Row-Item-Plugin is a free and open-source plugin for Oracle Application Express (APEX) that allows you to create multi-row input fields…
Efficient Date Picking: Exploring the APEX Scroll-able Date Picker Plugin
Overview The Scroll-able Date Picker Plugin for Oracle APEX enhances the user experience with features like scroll-able calendars, drag-and-select functionality…
Elevating Security with Oracle Database 23c: Schema-Level Grants Unveiled
Introduction: In the world of database management, developers used to face a tough decision – either spend time granting specific permissions for each table or…
Decoding “ORDS 404 Not Found” error in ORDS
Cloning oracle databases from production to test environments is a common practice, but it comes with its own set of challenges, particularly in handling critic…
How to merge cells in classic report using JavaScript.
Overview This document is about how to merge cells in classic report using javascript in oracle apex. Technologies and Tools Used The following technologies hav…
Building a Contextual Back Button with Application Page Items in Oracle APEX
Overview In ORACLE APEX we generally use page number in the URL to redirect the page from one to another. However in this session dives deep into the hidden pot…
Enforcing Save Before Adding New Row in Oracle APEX Interactive Grid using JavaScript
Overview In Oracle APEX, a interactive grid had a concept of adding multiple row. Here in some cases the specific requirement here is to insert only one record…
A Dynamic Scaling Solution for Batch Processing Workloads
Problem: Traditional batch processing setups often face resource inefficiencies, as they are provisioned statically, leading to underutilization during low-dema…
Managing Infrastructure Complexity with Terraform Modules
Problem: In a rapidly evolving and dynamic IT environment, managing complex infrastructure configurations across various projects and environments can be daunti…
Oracle EBS – PO Report with Bursting
Oracle EBS – PO Report with Bursting https://doyensys.com/wp-content/uploads/2024/01/oracle-ebs-po-report-with-bursting.doc
How to create dynamic quick picks for page items in Oracle APEX
1.Overview This document explains about how to create dynamic quick picks for page items in Oracle Apex. 2.Technologies and Tools Used The following technology…
Empowering APEX Applications: Exploring New Page Item QR Code Generator in Oracle Apex 23.2
Overview A new page item introduced in APEX 23.2 is the QR Code Generator. This brings QR code generation native to APEX, previously only possible using third-p…
Exploring the new Combo box item In APEX 23.2
Overview The new combo box in Oracle APEX 23.2 introduces exciting possibilities for building dynamic and user-friendly applications. They are akin to the class…
Exploring New Image Upload Page Item in Oracle Apex 23.2
Overview In Oracle APEX 23.2, the Image Upload Page Item revolutionizes image management. It offers a contemporary interface for users to preview and modify ima…
Decimal length and Numeric Character Validations using Java script
1. Overview In this we are going to see about how to check the character in the numeric page item on lose focus and also going to check the decimal length on lo…
Using Java Script To Highlight The Updated Page Item And Make Region Read Only
1. Overview In this we are going to update the details in the master table and the request will send to the request table we will show both forms in single scre…
PATCHING: SQL Server 2019 Version
Description: SQL Server is the database management systems. If you want to protect your data and applications from hackers, malware, and other risks, you need t…
Amazon Dynamodb Installation
Description: Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. database tables…
Dynamic Data Masking at table column level in Oracle Database
Database tables often contain sensitive information such as credit card details, contact information, and personal bank details, which require safeguarding agai…
How to load Chart of Accounts Mapping
How to load Chart of Accounts Mapping Introduction: This can be used as a reference document while we do the chart of accounts mapping. You can define ch…
How to install Mongodb on linux Mongodb version 3.4
Mongodb on linux Mongodb version 3.4 Step -1 -Create a directory to keep the software – Give full permission to the directory for Execute Step -2 -Downlo…
How Oracle Intelligent Document Recognition Works for Payables Invoices
Introduction Oracle fusion comes with IDR Solution or Intelligent Document recognition solution. The integrated invoice imaging solution which is part of Oracle…
Expand and Collapse Multiple Classic Report Region by using Java script
1. Overview We know that the oracle apex have default collapsible option in reports ,in some case we have multiple region and if we wants to expand and collapse…
Valid Date Format Check by using java script in Oracle Apex
1. Overview We know some time user might enter a wrong date while entering, to avoid this we can create some dynamic actions and validation to notify user have…
REPLICATION CONFIGURATION IN MSSQL
INTRODUCTION MSSQL replication refers to technologies used for copying and distributing data and database objects from a Microsoft SQL Server database to anothe…
MONGODB INSTALLATION IN WINDOWS
INTRODUCTION MongoDB is an open source NoSQL database management program. NoSQL (Not only SQL) is used as an alternative to traditional relational databases. No…
Installing MySQL on linux
Installing MySQL on linux STEP -1 -Download the rpm required based on your operating system here iam using linux -User the below link to assess the RPM -Link- h…
How to create custom shortcuts for Interactive Repot fields in Oracle APEX
Overview This document explains about how to create custom shortcuts for Interactive report fields in Oracle Apex. Technologies and Tools Used The follow…
Apply Dark & Light Mode In APEX Applications During Runtime
Overview Dark and light modes in APEX applications is a user interface design enhancement that allows users to choose between different color schemes to suit th…
Password Feed Back Form In APEX
Overview In Oracle APEX, a “Password Feedback” form is often used to provide feedback to users when they are creating or updating their passwords. This form typ…
Dynamically set Decimal value Using JavaScript
1. Overview This document talks about dynamically setting decimal value for a particular column in an Interactive Grid report or Item using JavaScript. 2. Techn…
Migrating Oracle E-Business Suite to Oracle Cloud Infrastructure
This blog post offers insights into the optimal options and best practices for migrating your Oracle E-Business Suite (EBS) from on-premises to Oracle Cloud Inf…
On closure of the popup set focus to IG column
1. Overview This document talks about how to set focus to a particular column in an Interactive Grid report on the closure of inline pop up region using JavaScr…
Create users and assign access in DynamoDB
Introduction: Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. When working w…
Steps to backup Dynamo DB
Introduction: DynamoDB, Amazon’s managed NoSQL database service, is a scalable and highly available solution for storing and retrieving data. Despite its robust…
Steps to migrate Non-container Database to Container Pluggable Database
Steps to migrate Non-container Database to Container Pluggable Database Introduction: This document is intended for DBA’s who need to know how to migrate the No…
AWS certificate Import in OCI
AWS certificate Import in OCI Introduction: This document is intended for DBA’s who need to know how to import AWS certificates into Oracle Cloud Infrastructure…
What are the logs and their location in MYSQL
What are the logs and their location in MYSQL Introduction:- MySQL logs are very important to manage database roles in monitoring, troubleshooting, and maintain…
User Management in MYSQL
User Management in MYSQL Introduction:- Effective user management is a critical aspect of MySQL database administration. Creating users and assigning access in…
Object Storage in Oracle Cloud
Object Storage in Oracle Cloud: A Comprehensive Guide to Upload and Download Options INTRODUCTION: OCI stands tall as a fastest growing platform offering a suit…
Nurturing Success: The Key Priorities for People & Culture in 2024
In today’s dynamic business landscape, the success of an organization is deeply intertwined with its people. The People & Culture team plays a pivotal role in s…
Channelize Energy & Equip Using Mind Maps
Our brain is capable of much more of what we can’t imagine. According to Tony Buzan, the inventor of “Mind maps”, everyone is capable of doing many things at a…
Autoconfig Error on AppsTier after Cloning : ORA-01422
ERROR: Executing script in InstantiateFile: /olvtestt1_olvtst_cls/apps/fs1/FMW_Home/webtier/perl/bin/perl -I /olvtestt1_olvtst_cls/apps/fs1/FMW_Home/webtier/per…
Empowering Future Leaders: Doyensys LEAD Management Trainee Program
At Doyensys, we understand that the vitality of any thriving organization lies in its people. In our unwavering commitment to shaping the future of technology,…
Oracle Forms and Reports 11.1.2.2.0 Installation: “invoking target agent” Error
Description: During installation of Oracle Forms and Reports 11.1.2.2.0 on Oracle Linux 7.2 the following error occurs at 92% of progress. Cause: This is a bug…
Oracle Analytics Cloud: Turning Data into Strategic Insights
In today’s data-driven business landscape, organizations are inundated with vast amounts of information from various sources. The ability to transform this data…
Oracle Cloud Applications: Revolutionizing Enterprise Resource Planning
In today’s fast-paced business landscape, organizations face an ever-increasing demand for agility, scalability, and real-time data insights. Traditional Enterp…
Unleash Your Potential with LEAD – Doyensys’ Management Trainee Program
At Doyensys, we believe that the core of any successful business lies in its people. To stay ahead in today’s rapidly evolving tech landscape, we are committed…
Unlock Efficiency with Oracle Multi-tenant Architecture
In today’s data-driven world, managing databases efficiently is crucial for businesses to thrive. Oracle, a pioneer in database technology, presents a groundbre…
Sober curious champions share their stories
Now she’s a homeowner, she started a small business and says life is “awesome.” “I’ve had a really hard time getting my recovery back. I wasn’t sponsoring anybo…
How to Manage/Correct Daily Rates through ADFDI
How to Manage/Correct Daily Rates through ADFDI Introduction:- Oracle Fusion Cloud Applications 23B (11.13.23.04.0) Information in this document applies to any…
Receivables Auto Invoice Import Failed with DUPLICATE INVOICE Error Message
Receivables Auto Invoice Import Failed with DUPLICATE INVOICE Error Message Introduction:- Oracle Fusion Cloud Applications 23B (11.13.23.04.0) Information in t…
Mastering Data Integration with Oracle GoldenGate
In today’s fast-paced digital landscape, seamlessly integrating and replicating data across heterogeneous environments is crucial for businesses of all sizes. T…
Unlocking Business Insights: Oracle Business Intelligence Suite
In today’s data-driven world, organizations are constantly seeking ways to transform raw data into actionable insights. The ability to make informed decisions b…
How to bulk import Lookup Types and Lookup Codes using File Based Loader
Introduction: This process would overview bulk load of Lookup Type & Lookup Codes in Oracle fusion. Cause of the issue: When there is a need of entering…
New Pluggable Database shows the Wallet Error “OPEN_NO_MASTER_KEY”
Issue: The wallet status for newly created PDB shows “OPEN_NO_MASTER_KEY” SQL> select * from v$encryption_wallet; WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALL…
11i & R12.2 Technical Upgrade Reference guide
11i-r12.2-technical-upgrade-reference-guide
R12.2 Functional Enhancements – A Quick Reference
r12.2-functional-enhancements–a-quick-reference
Expanding the Collaboration: Oracle and Microsoft Bring Oracle Database Services to Azure
Exciting news! ? Oracle and Microsoft are taking their partnership to the next level with the launch of Oracle Database@Azure. This collaboration offers custome…
NETWORK ETHER-CHANNEL
NETWORK ETHER-CHANNEL Intrhttp://staging.doyensys.com/blogs/wp-admin/upload.phpoduction: This blog explains about the feature of Ether-channel/Port channel on N…
NETWORK – DYNAMIC ROUTING PROTOCOL
Introduction: This blog explains about the feature of dynamic routing protocol in a Network. Why Dynamic routing protocol? During the early days of the network,…
The state of AI in early 2024: Gen AI adoption spikes and starts to generate value
This way, you can offer your customers a one-stop shop for all their wedding needs.Another example is an e-commerce store that partners with a fulfillment cente…
Oracle ERP Implementation: Best Practices for a Successful Project
Implementing an Enterprise Resource Planning (ERP) system like Oracle is a significant undertaking that can reshape the way an organization operates. A well-exe…
streamlabs chatbot gif video commands
Top Streamlabs Cloudbot Commands You can also use this feature to prevent external links from being posted. Timers are commands that are periodically set off wi…
Oracle Fusion Middleware: Connecting Applications for Seamless Workflow
In the ever-evolving business technology landscape, seamless connectivity between applications has become a critical determinant of success. This is where Oracl…
Send an email (with attachement) using Oracle PLSQL
Send an email (with attachement) using Oracle PL/SQL create or replace procedure SEND_EMAIL_WITH_TXT_ATTACH ( PVA_SENDER varchar2, PVA_RECEIVER varchar2, PVA_SU…
Checking The performance & Advantage of using BULK COLLECT
SET SERVEROUTPUT ON DECLARE TYPE t_bulk_collect_test_tab IS TABLE OF bulk_collect_test%ROWTYPE; l_tab t_bulk_collect_test_tab; CURSOR c_data IS SELECT * FROM bu…
Service Contract line price Adjustment Issue while modified the prices user manually.
Use the okc_price_adjustment_pub.create_price_adjustment API with appropriate input values to effect the adjusted prices manually.
Service Contract Header amount total field is not affected while user manually update the price or quantity in line level.
Use the oks_auth_util_pvt.check_update_amounts API to refresh the header amount after the line level modifications.
Service Contract Interface – Billing schedule issue where the amount field was not showing at stream level.
Parameter p_billing_sch needs to be passed as E instead of T to the API Create_Bill_Schedule API.
PO Promise Date/Need By Date Automation Based on Date Entered
This Blog is used to automate PO Promise Date/Need By Date Based on Date Entered in PO Line level/Shipment level by using Form Personalization Please follow the…
Oracle EBS – Query to get MultiOrg Info
————————————————————————————– Oracle EBS – Query to get MultiOrg Info ————————————————————————————– ————– Execute the below query into EBS database.————————————…
WEBADI for Asset upload in EBS
web-adi-fa-loading-process This document will explain how user can upload fixed asset using web Adi process. How to Effectively Upload Data To Ora…
Translation
Translationtranslation
Charge Back
charge-back
User has closed FA Corp Books for Jul-23 Period, and after closing it, oracle cloud should show the Aug-23 month, But it is showing Sep-23 as below
User has closed FA Corp Books for Jul-23 Period, and after closing it, oracle cloud should show the Aug-23 month, But it is showing Sep-23 as below That means A…
Action Details Are Not Available
action-details-are-not-available
How to Configure Invoice Approval Rules for Different Purchase Order PO Matched Scenarios
how-to-configure-invoice-approval-rules-for-different-purchase-order-po-matched-scenarios
BSV_to_default_from_the_parent_charge_line_for_Rec_Tax_
Steps to configure company segment to be defaulted from the Item change account for recoverable tax lines bsv_to_default_from_the_parent_charge_line_for_rec_tax…
Payment_Clearing_Maturity_Event_Error_870639
Issue Payment clearing events are not getting accounted because the error “The journal entry line can’t be accounted until the Payables transaction that it refe…
Corporate Cards Need to be Reassigned To a Permanent Employee Account from Contract Employee Account
Corporate Cards Need to be Reassigned To a Permanent Employee Account from Contract Employee Account Oracle Fusion Expenses Cloud Service – Version 11.13.20.01.…
Terraform script to install VPC
provider “aws” {region = “us-east-1” # Set your desired region here} resource “aws_vpc” “my_vpc” {cidr_block = “10.0.0.0/16” # Set your desired CIDR block for t…
Lock Box_Customer profile missing history error correction
Customer profile missing history Error Correction.. Nav- Receivables Accounts Receivables. Select one Batch Click on Post.. Copy Request ID.. &nbs…
SLA Adjustment for AR Transaction
SLA Adjustment for AR Transaction SLA Adjustment Error Text You must either modify the account rule to use a different balancing segment value for the journal l…
Difference Between Reassign And Delegate In Vacation Rules
Question: Difference between standard functionality of REASSIGN and DELEGATE in vacation rules setup. Application: Oracle Fusion Self Service Procurement – Vers…
BPA or Requisition Template are not Visible for Other Languages
Requirement: BPA or Requisition Template With Expense Lines ( non catalog request items) Is Not Visible for Other Languages In iProcurement Application: EBS Ora…
AP Invoice Approval Failing For Custom Conversion Rate Type Condition in Rules
Requirement AP Invoice Approval Failing For Custom Conversion Rate Type Condition in Rules Application: Oracle Fusion Payables Cloud Service – Version 11 Detail…
Scheduling in Order Management
scheduling-in-order-management Scheduling in Order Management
Bill Of Material & Work In Process End to End Cycle
bill-of-material-work-in-process-end-to-end-cycle
JENKINS FOR BUILD NOTIFICATION ON THE SLACK CHANNEL
SEND NOTIFICATION (groovy) // Send Slack and Mail build notification def call(Map config = [:]) { slackSend ( color: “${config.slackSendColor}”, message: “${con…
Queries to analyze the Business
Introduction: These queries gives the modules used, data volumes, top products they have sold and other details about the Business. Queries: The below are the q…
Supplier Import process through FBDL (File based data loader) Template
supplier_.import_fbdldocx
Person Security Profile in Oracle Fusion HCM
person_security_profile_hcm
FND_FILE.PUT_LINE CLOB file writing causes error.
Need to write output file using CLOB variable which contains more than 32767 bytes of data even it may contain up to 8 GB data. If it exceeds more than 32767 by…
Oracle Data Dictionary Tables
USER_TABLES Lists each table that belongs to your Oracle user.USER_TAB_COMMENTS Shows comments on the tables and views.USER_TAB_COLUMNS Tells you the names, dat…
Bulk Collect for Delete
CREATE OR REPLACE PROCEDURE BLK_CLCT_DELISL_LIMIT PLS_INTEGER := 20000; CURSOR C1ISSELECT row_idFROM s_invoice_itemWHERE person_id IN(SELECT b.row_idFROM disall…
Rich text Editor using TinyMCE(Moxiecode Content Editor) in Oracle Apex 23.1
INTRODUCTION: TinyMCE is a web-based WYSIWYG (What You See Is What You Get) editor that allows users to create and edit HTML content in a browser. It is a popul…
DISPLAYING LATITUDE AND LONGITUDE BY POINTING THE LOCATION
INTRODUCTION: Maps are introduced in oracle apex to show the exact locations and information in a simple way. In this blog, we are displaying the latitude and l…
Query to find the Legal Entity, Organization, Company Code in Oracle Apps EBS.
Intro:-This script will provide all related Bom Routing department details. Code:- SELECT xep.legal_entity_id “Legal Entity ID”, xep.name “Legal Entity”,…
Query to find Form Personalization in Oracle apps
Intro:-This script will provide all related Form Personalization details. Code:- SELECT ffv.form_id “Form ID”, ffv.form_name “Form Name”, ffv.user_form_n…
Customer Contact Extraction Query in Fusion FSCM
Introduction: This SQL query is used to fetching the data of Customer contact details like Customer Name, Contact Name, Email Address Contact Number and…
Customer CIF Extraction Query in Fusion FSCM
Introduction: This SQL query is used to fetching the data of Customer CIF information to identify whether we have any duplicate CIF numbers exists or not…
Query to get project and task details – Fusion
Query to get Projects and Tasks Details – Fusion SELECT TO_CHAR(PPA.PROJECT_ID) PROJECT_ID ,TO_CHAR(PPA.SEGMENT1) PROJECT_NUMBER ,PPA.NAME PROJECT_NAME ,PPA.DES…
Queries to get Employee related information – Fusion
Query to Fetch Employee’s Legal Employer SELECT papf.person_number, hauft.NAME LegalEmployer FROM HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS…
CVE-2023-34362 protection on GKE
A SQL injection vulnerability has been found in the Progress MOVEit Transfer web application and has been assigned CVE-2023-34362 (also known as MOVEit Transfer…
Fastly – Robots.txt
Synthetic response in Fastly is a very fast and useful way to deliver static content on a webpage. This is useful for sitemaps, robots.txt and ssl verification…
what is psudocolumn, Rowdepandancy and Norowdepandency in oracle
what is psudocolumn, Rowdepandancy and Norowdepandency in oracle A pseudocolumn behaves like a table column, but is not actually stored in the table. You can se…
CRS-6706: Oracle Clusterware Release patch level (‘35319490) does not match Software patch level (‘xxxxxxxxx’). Oracle Clusterware cannot be started
Problem: After patching an Oracle 19.8 GRID_HOME on Oracle Restart setup with 19.20 RU patch [35319490], I was not able to start up Oracle Restart HAS due to me…
How To Open the Standby Database When the Primary Is Lost
In this case how to open your standby database in read/write mode when you don’t have any access (Lost) on Primary database. NOTE: Currently both Primary and St…
Implementing High-Availability Two-Node TOMCAT and ORDS Architecture for APEX
Introduction: In today’s dynamic IT landscape, ensuring seamless access to critical applications is paramount. This guide outlines the strategic steps to deploy…
Adding data file to Log-shipping database
What is log shipping? SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to o…
Database Connection Management with ORDS Instance API
INSTANCE API Oracle REST Data Services (ORDS) offers a powerful solution for managing connection pools, enabling efficient communication between applications an…
ORACLE OS WATCHER
What is oracle OS watcher? Oracle OS watcher is collects and stores as archives operating system and network metrics that you can use to diagnose performance is…
TABLE REORGANIZATION
Precheck in table and index level: Step 1: Check the Table size and Index size select segment_name,TABLESPACE_NAME ,segment_type, bytes/1024/1024/1024 size_gb f…
Oracle Employee Self Service – Employee_Family&Emergency_Contact_Details_Change
This Blog helps employees to change thier Emergency Contact Details in Fusion HCM.
Fusion HCM _ Activating Address Validation – Global
Hi This Blog help you to Activating Address Validation Fusion HCM Global. With Step by Step Process for Activation.There are no predefined geographies for Many…
Oracle Wait Events and Their Solutions
Db file sequential read: This event occurs when a user tries to perform a Physical I/O while waiting for sequential reads from the Buffer cache. It occurs when…
ORA-24247: network access denied by access control list (ACL)
ERROR:- Error starting at line : 20 in command – BEGIN APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG; END; Error report – ORA-24247: network access denied by access…
An API call has been prohibited
While calling the object in oracle apex metadata we are getting this issue. This issue was raised by development team. ISSUE:- Getting an error An API call has…
Methods to fix adrelink fails in cloned environments
This blog post will discuss how to deal with adrelink failures when applying patches in EBS tech_st home. Sometimes, when you apply OPatch to EBS $ORACLE_HOME i…
EBS Application Migration Issues from RHEL 5 to RHEL 7 for Oracle EBS 12.1
One of the common challenges that Oracle EBS 12 users face is migrating their applications from RHEL 5 to RHEL 7. This process involves several steps to fix the…
Display Any Country’s Current Date and Time in Oracle Forms
1. Overview This blog explains about, how we can shows a text box to display the current date and time for the selected country in oracle forms. 2. Technologies…
How do I fix the ORA-01172 error?
Issue: I have the ORA-01172 error in my alert log, and I cannot start my database: ORA-01172: recovery of thread 1 stuck at block 25 of file 2 ORA-01151: use me…
How to Generate Serial Number in Oracle Forms
1. Overview This blog explains about, how we can Generate Serial Number in Oracle Forms. 2. Technologies and Tools Used The following technology has been used t…
How to fix if SRVCTL is not working?
Issue: srvctl commands and functionalities are not working in the RAC databases. Error: [oracle@host oracle] srvctl config database -d SID_NAME PRCR-1119 : Fail…
Employee Work Schedule Update Integration
Employee Work Schedule Update Integration – Oracle Fusion HCM. Introduction: This blog explains about how to call a bip report placed in the oracle fusion hcm i…
Employee Assignment Update Integration
employee-assignment-update-integrationEmployee Assignment Update Integration – Oracle Fusion HCM. Introduction: This blog explains about how to call a bip repor…
Configure formsweb.cfg to Run Oracle Forms Application
1. Overview This blog explains about, how we Configure formsweb.cfg to Run Oracle Forms Application. 2. Technologies and Tools Used The following technology has…
How to Hide Password in Oracle Forms
1. Overview This blog explains about, how we can hide Password in oracle FORMS. In Oracle Forms, if you are creating any custom login screen or giving any passw…
Oracle APEX Security Features
Overview The Purpose of the document is to highlight the security features in Oracle APEX.Oracle Application Express (APEX) is a low-code development platform t…
Creation of Mini Calendar and Sticky Notes using with Oracle Apex
INTRODUCTION: The Mini Calendar Plug-In and the Sticky Notes Plug-In are two handy and adaptable Oracle APEX plug-ins that will be introduced in this article. T…
UNEXPECTED Nodes are listed in the ADOP_VALID_NODES table but not in the FND_NODES table
UNEXPECTED Nodes are listed in the ADOP_VALID_NODES table but not in the FND_NODES table Error : adop phase=FS_CLONE failed with below error. Validating system…
Steps to configure Google Looker to connect to an Oracle database
GOOGLE LOOKER Introduction: Google Looker is a cloud-based business intelligence and data analytic platform. Looker is a tool that helps us to explore, share, a…
Save image into local directory and Server directory in Oracle Apex
INTRODUCTION: The well-liked web development framework Oracle Application Express (APEX), you may create database-driven web apps fast and effectively. One of t…
404 not found error, the request could not be mapped to any database while running newly developed application in Apex.
Issue : While running the newly developed application in Apex, I encountered a 404 Not Found error. The request could not be mapped to any database. Reason : In…
Comprehensive Guide: Removing and Adding RAC Nodes in Oracle Clusterware
Overview Diving into the intricacies of Oracle Clusterware management, this comprehensive guide elucidates the meticulous steps involved in the process of delet…
Troubleshooting and Resolving ‘CheckApplicable’ Prerequisite Error When Applying Oracle GI RU July-2023 Patch
Overview of blog In this blog post, we will explore a comprehensive solution to resolve the issue of ‘oracle.rdbms.deconfig, 19.0.0.0.0’: Cannot delete file ‘/u…
HARNESSING BLOCK CHANGE TRACKING FOR ENHANCED PERFORMANCE
Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental bac…
ORA-20004:ERROR IN SENDING AN EMAIL IN APEX
ORA-20004: Error in sending an Email – You have exceeded the maximum number of email messages per workspace. Please contact your administrator. REASON: Actually…
ODA (Oracle Database Appliance) Monitoring commands
Hardware monitoring commands: – Display information about the environment and hardware:- odaadmcli show env_hw Display information about the filesystem:- odaadm…
Delete Archive logs in primary database and then sync primary and standby databases.
Delete Archive logs in primary database and then sync primary and standby databases. Introduction: This article delves into the careful process of deleting arch…
Autoconfig Completed with error issue in applptmp
Autoconfig Completed with error issue in applptmp Introduction: The objective of this blog is to overcome an error while running autoconfig in oracle EBS 12.2.1…
ORA-07445 – exception encountered: core dump
ORA-07445 – exception encountered: core dump Issue :- DB was down due to the ORA – 07445 error in the alert log Cause:- ORA-07445: exception encountered: core d…
DIRECT JOINS in UPDATE and DELETE statements.
ORACLE 23-C NEW FEATURES DIRECT JOINS in UPDATE and DELETE statements. CONTENTS SNO CONTENTS PAGE NUMBER 1 Introduction 3 2 Why do we need this feature 3 3 Upda…
GENERATING THE REPORT WITH APEX_DATA_EXPORT
1. Overview If we need to generate our report with the APEX_DATA_EXPORT this Document will Explain you how to generate the report with the APEX_DATA_EXPORT 2. T…
HOW TO CUSTOMIZE TEXT FIELD INTO SLIDER PAGE ITEM
1. Overview If we have a requirement to show the text field page item into the slider page item then this Document will Explain How to customize text field into…
Delete Data Using AJAX
1. Overview We know that there is an button option to delete record in oracle apex. But in some scenarios we may have to delete records instead of buttons but o…
Aliasname_Groupby_Blog
ORACLE 23-C NEW FEATURES Using column alias name in GROUP BY & HAVING clause Using column position in GROUP BY & HAVING clause CONTENTS SNO CONTENTS PAGE NUMBER…
Count characters in input item
1. Overview We know that there is an inbuilt option to restrict character count in oracle apex. But in some scenarios we may have to know how many characters we…
Viewing alert log for Amazon RDS for Oracle
This blog is intended for Oracle DBA’s administering Amazon RDS for Oracle. Issue: Oracle DBAs may need to view alertlog for the database, for troubleshooting i…
Concurrent Program Output Saving as FNDWRR.txt
Using Edge Browser Concurrent Program Output Saving as FNDWRR.txt SYMPTOMS: Using Edge browser when concurrent program output is saved the output file name defa…
Online reorganization of a table using Oracle DBMS_REDEFINITION package
This blog is intended for DBA’s who would like to reorganize tables online using Oracle dbms_redefinition package. Issue: DBAs may need to reorganize tables to…
Merge PDF in AOP
1. Overview This document talks about how to merge the pdf in AOP. 2. Technologies and Tools Used The following technologies has been used to achieve exporting…
HTML Templates in AOP
1. Overview This document gives an idea about the HTML template in AOP. 2. Technologies and Tools Used The following technologies has been used to achieve expor…
PHONE NUMBER VALIDATION USING PLUGIN IN OUTSYSTEMS
INTRODUCTION: Phone number validation is a common requirement for ensuring that users provide valid and correctly formatted phone numbers. Proper phone number v…
DATA AGGREGATION USE CASES IN OUTSYSTEMS
INTRODUCTION: Aggregate is used to fetch data from database. If the Data model had any changes aggregation automatically get that and load the database data fro…
Customized Delete Icon and Delete all Functionality in Report in Outsystems
1. Introduction Allowing users to delete records through icons provides a simple and intuitive way to manage data within the application. The use of icons for c…
Editable Data Grid In Outsystems
1. Introduction This document will refer Outsystem data grid, is a user interface component that allows to display data in a structured way. The data grid is pa…
How to capture DOM manipulation and set validation for Interactive grid in Oracle APEX
Overview This document explains about how to capture DOM manipulation and set validation for Interactive grid in Oracle APEX. Technologies and Tools Used The fo…
How to preview multiple Blob contents while uploading using file browser in Oracle APEX
Overview This document explains about how to preview multiple blob contents while uploading using file browser element in Oracle Apex. Technologies and Tools Us…
AutoNumber Generation for Serial Column without Sequence in Interactive grid using JavaScript
Overview This document talks about how to Customize Interactive Grid with Auto Populate Column value without Database sequence using JavaScript. Technologies an…
Vendor Transaction Report
1.Overview This document talks about getting the vendor transaction detailed report in oracle apps r12 2.Technologies and Tools Used The following technologies…
Sales Margin by Item
1. Overview This document talks about getting the sales details of the item in oracle apps r12 2.Technologies and Tools Used The following technologies have bee…
Oracle Data Integrator installation on windows
Oracle Data Integrator installation on windows Introduction:- Oracle Data Integrator (ODI) is a comprehensive data integration platform developed by Oracle Corp…
ORDS Configuration Multiple database in single tomcat server.
ORDS Configuration Multiple database in single tomcat server. Introduction:- Oracle RESTful Data Service (ORDS) is a powerful tool that enables organizations to…
Unlocking the Power of Oracle Cloud: Benefits and Features Explained
In today’s fast-paced and competitive business landscape, organizations are continually seeking innovative solutions to enhance their operations and stay ahead…
Oracle ERP Implementation: Best Practices and Success Factors
In today’s fast-paced business landscape, implementing a robust Enterprise Resource Planning (ERP) system is essential for organizations to streamline operation…
Oracle Security Best Practices: Protecting Your Data Assets
In today’s digital landscape, data security has become paramount. Organizations across the globe are constantly grappling with threats and vulnerabilities that…
AD-TXK Delta 14 on Oracle EBS R12.2
This AD-TXK Delta 14 release includes new features, plus performance and stability fixes for the Applications DBA (AD) and Technology Stack (TXK) components for…
Oracle Exadata for Data Warehousing: Enhancing Performance and Scalability
Businesses are realizing the need for an enterprise data warehouse (EDW). A genuine EDW offers a unified 360-degree perspective of the business and a robust pla…
How to create/upload Journal Entries in Bulk
How to create/upload Journal Entries in Bulk Why we need to do / Cause of the issue: Using journal spreadsheet entry in Oracle Cloud allows the user to c…
What’s New in Oracle APEX 23.1?
OCI (Oracle Cloud Infrastructure) areas worldwide have rolled out Oracle APEX 23.1 version, which is generally accessible for download. It means all newly creat…
How Oracle E-Business Suite Simplifies Your Business Operations?
In today’s fast-paced business landscape, streamlining operations and enhancing efficiency are crucial for sustained success. One powerful solution that can hel…
Unlocking the Power of Your Data with Oracle Analytics Cloud
In today’s data-driven world, organizations of all sizes are recognizing the importance of leveraging their data to gain valuable insights and make informed dec…
How Does Oracle Cloud Support Customer Data Privacy?
Understanding the laws and regulations affected by your firm’s operations is necessary for a multinational corporation with offices and employees in numerous na…
The Benefits of Migrating to Oracle Cloud Infrastructure
Migrating to the cloud is no longer a question of if, but when. The cloud offers businesses significant benefits in terms of scalability, flexibility, and cost-…
The Benefits of Upgrading to Oracle EBS R12.2.11
If you’re still running an older version of Oracle E-Business Suite (EBS), it might be time to consider upgrading to the latest version, R12.2.11. The benefits…
What’s next for Oracle Fusion Analytics?
Today’s companies rely heavily on data and statistics because they help with strategic decision-making. In addition, customers in the healthcare, retail, educat…
What’s New in Oracle Cloud Infrastructure in 2023?
Oracle Cloud Infrastructure (OCI) is always changing! New data centers, the latest features, and extensions to existing ones are being introduced. It means more…
Unlocking the Power of Oracle ERP Implementation: Top Benefits for Your Business
In today’s fast-paced business environment, having a robust and efficient Enterprise Resource Planning (ERP) system is crucial for businesses of all sizes. Orac…
WLS Admin Console Trusted access – EBS R12.2
Here I’m going to explain the alternative methods to allow access to the Oracle WebLogic Server Administration Console and Fusion Middleware Control if you cann…
EBS System Schema Migration (R12.2)
EBS System Schema Migration (R12.2) System schema migration ‘consolidated’ patch is included in R12.2.11 /R12.2.12 update packs, but the system schema migration…
Oracle Brings Out Sovereign Cloud Capabilities – The New Buzz!
A sovereign cloud is not a new notion. Due to a shifting geopolitical environment and new laws that impact data control, it has recently become a hot topic. In…
Benefits of Oracle Cloud Fusion ERP – Financials
Are you looking for a modern and streamlined approach to financial management? Oracle Cloud Fusion ERP – Financials could be the solution for you. Here are six…
How Oracle Cloud A1 and platformOS are impacting DevOps?
To extend its PaaS (platform-as-a-service) creator community to Oracle Cloud Infrastructure’s Ampere A1 computing from Arm, Oracle Cloud Infrastructure (OCI) ha…
CREATE A NEW PARTITION IN RUNNING ORACLE LINUX SERVER
Description: Already we have created partition while installed the operating system. But after installation, we need a new one partition means we have to do som…
Query to get Lease assets – Oracle EBS to Fusion
Introduction: This blog has the SQL query that can be used to pull the lease assets details per asset book for EBS to Cloud data migration. SQL Query: SELECT fb…
Customer Contact Details in EBS
Introduction: This blog has the SQL query that can be used to pull the data Organization contact details. Cause of the issue: Business wants to reach the…
SQL Loader using External table
Introduction: This blog has the SQL loader using external Table. Cause of the issue: Business wants to load the data with a field having multiple line we can us…
PANCARD Validation – PL/SQL Function
1. Overview When we give PANcard, We are returning PANcard is valid or not. 2. Technologies and Tools Used The following technology has been used to achieve the…
Dynamic List of values (LOV)
1.Overview LOVs can be displayed by end user request (when an LOV is available), Most of the user does not know the item have LOV option. For this we add a Push…
Unable to close the Period in AR Blog
unable-to-close-the-period-in-ar-blog
Service contract reconciliation Report
SELECT okha.sts_code,okha.scs_code,okha.date_approved,okha.estimated_amount, xscb.price_list_id, xscb.customer_bill_to_number, xscb.customer_ship_to_number, xsc…
AR invoice details
Introduction: This SQL query is used to fetching the details of an institution Based on their requirements overview: this query gives AR invoice details…
Fetching and Parsing Data from Other Online Source To Oracle Database Using Web service in Oracle Apex
Overview This Document will Explain How to Fetch and Parse Data from Other Online Source To Oracle Database Using Web service in Oracle Apex . Technologies and…
CREATE CATALOG AND RECOVER CONTROLFILE WITH CATALOG
CREATE CATALOG AND RECOVER CONTROLFILE WITH CATALOG PRIMARY CATALOG HOSTNAME 192.168.1.33 192.168.1.21 DB PORT 1521 1525 DB NAME VIYANI CATDB In Oracle, A catal…
Object Abstraction In PL/SQL
1.Overview This document explains about Object abstraction in PL/SQL. An Object abstraction refers to the high-level description or model of a real-world entity…
Inserting a new Record into an Interactive Grid using Java Scripts
Overview This Document will Explain How to Insert a new Record into an Interactive Grid using Java Scripts. Technologies and Tools Used The following technology…
CALLING API USING JAVA SCRIPT IN ORACLE APEX
1. Overview This Document will Explain How to call a API using java script in oracle apex. Technologies and Tools Used The following technology has been…
FREEZED COLUMN HEADER WITH SCROLLBAR IN CLAASIC REPORT
1. Overview This Document will Explain How to create fixed column header with scrollbar in classic report Technologies and Tools Used The following techn…
Automation Testing In Oracle Apex Using Selenium Web Driver
1.Overview This document explains about how to perform unit testing using selenium web driver in Oracle Apex. Selenium Web Driver is a web framework that permit…
Query to get Lot , Sublot information for Sales Order in Oracle Fusion SCM
select MAX(CASE WHEN seq =1 THEN parent_lot_number END) parentlot1, MAX(CASE WHEN seq =2 THEN parent_lot_number END) parentlot2, MAX(CASE WHEN seq =3 THEN paren…
Query to Get the Payroll Run Details for Person
SELECT ppf.person_id, ppf.person_number, paam.assignment_number, to_char(ptp.start_date,’YYYY/MM/DD’) startdate, to_char(ptp.end_date,’YYYY/MM/DD’) enddate, ptp…
R12.2: Script $FND_TOP/bin/irep_parser.pl Fails With Error Can’t Locate Class/MethodMaker.pm When Attempting to Generate *.ildt File
This blog is intended for Oracle Application DBA’s who have issues generating Integration Repository loader file (iLDT). Exposing Oracle E-Business Suite PL/SQL…
Oracle Database 19C Time zone not updated in PDB after applying RDBMS DSTv40 Patch# 3469179
Oracle Database 19C Timezone not updated in PDB after applying RDBMS DSTv40 Patch# 3469179 This blog is intended for Oracle DBA’s who are tasked with patching t…
Installing Oracle Apex in Docker.
Introduction In this blog, we are going to see how to install Oracle Database 19c in Docker and then to install ORDS and APEX. Introduction about Docker Docker…
Interactive Report – Column Headings Custom Tooltip
1. Overview This document talks about how we can achieve the custom column heading tooltip in Interactive report. 2. Technologies and Tools Used The following t…
Interactive Report – Collapse and Expand Feature using Control Break
1. Overview This document talks about how we can achieve the Collapse and Expand Feature in Interactive Report using control break. 2. Technologies and Tools Us…
How to integrate Chat GPT in Oracle APEX
1. Overview This document talks about how we can integrate chat GPT in Oracle APEX, OpenAI created ChatGPT, an AI language model. It is a modified version of th…
Oracle APEX- Display Regions in Side Navigation menu
1. Overview This document talks about how we can show the regions in side navigation menu in oracle apex application 2. Technologies and Tools Used The followin…
Unable to alter APPS_NE user to change password
APP-FND-02704: Unable to alter user APPS_NE to change password” while changing APPS password using FNDCPASS Issue: Changing apps password using FNDCPASS fails w…
HRglobal driver in Oracle APPS R12.2 Version
How to Run hrglobal driver in Oracle EBS 12.2.X Version? Steps to apply hrglobal driver in Oracle EBS 12.2.x version Start an Oracle online EBS Patching cycle.…
Detailed Margin Report
1.Overview This document talks about getting the report of detailed sales margin by customer by invoice by item (both Invoice and credit memo). 2.Technologies a…
Sales Daily Pick Report
1.Overview This document talks about getting the sales daily stock pick report in oracle apps r12 2.Technologies and Tools Used The following technologies have…
Solution to not logged on error and up the database
Solution to not logged on error and up the database ORA-01012: not logged on error ERROR ERROR at line 1: ORA-01012: not logged on Process ID: 0 Session ID: 0 S…
SWITCH OVER IN DATAGUARD
SWITCH OVER IN DATAGUARD CHECK THE FOLLOWING IN PRIMARY AND STANDBY STEP-1 STANDBY -Keep the database in mount state -keep the standby in MRP mode …
Smart Filters in Classic Reports
Introduction This document talks about how to use smart filters in classic reports. It provides users to filter the data easily and find the necessary records.…
Creating Pie and Combination Charts in Oracle Apex 22.2
Introduction This document talks about how to create pie and combination charts in Oracle Apex 22.2. This will depict a clear picture to understand for users. W…
Invoke API Process using PLSQL in Oracle Apex 22.2
INTRODUCTION : The Invoke API process in Oracle Apex allows developers to make API calls from within an Oracle Apex application to retrieve data or perform acti…
Approval workflow with Oracle Apex
INTRODUCTION : This feature lets users change an employee’s salary or job, or order a new laptop for them, after getting the approval of an appropriate individu…
Installing oracle database 19.3 in Docker
Use the yum-utils package to enable and install all the required repositories. yum install -y yum-utils zip unzip Then enable all the necessary repositories whi…
UPGRADE 12C to 19C IN PDB USING AUTOUPGRADE METHOD
UPGRADE 12C to 19C IN PDB USING AUTOUPGRADE METHOD LOG INTO THE DATABASE AND MAKE SURE THE CORRECT ORACLE HOME HAS BEEN SET. CHECK STATUS OF ARCHIVELOG M…
GENERATING RANDOM NUMBERS IN OUTSYSTEMS
OUTSYSTEMS: Outsystems is an excellent and rapid Application Development platform for mobile and web-based applications. Outsystems is a low-code programming sy…
How Oracle Cloud Infrastructure Powers Fusion Applications?
Businesses are finding innovative ways to use Oracle Cloud Infrastructure (OCI) every year to foster innovation and development. This year is no exception, with…
TXK Delta 13 failed due to missing files
TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin Th…
Adop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found
AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome th…
FIXING APEX ERROR DURING UPGRADATION IN PDB
FIXING APEX ERROR DURING UPGRADATION IN PDB INTRODUCTION :- I got the following APEX error in 19C pluggable database while upgrading the PDB database from lower…
Progressive Web Application –Next Generation Mobile Application Development with Oracle Apex
Introduction: Progressive Web Applications are web apps that use service workers, manifests, and other web-platform features in combination with progressive enh…
Undo Corruption in Oracle
What is Undo ? Undo records are used to: Oracle Database creates and manages information that is used to roll back, or undo, changes to the database. Such infor…
Redo log corruption
What is a Redo log corruption? In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the…
Wonders in AWS RDS – Good Deployment techniques
Introduction Amazon Web Service offers a diverse range of products and services to clients across the globe and shapes. Amazon RDS is one of the most popular an…
Oracle Blob and Clob Datatypes
CLOB and BLOB are two types of data types used in databases to store large amounts of data. BLOB: BLOB, or Binary Large Object, is used to store binary data suc…
what are the oracle index status
Oracle index is a database object that is used to improve the performance of certain queries by providing direct access to the data in a table. Indexes are crea…
Oracle Cloud – GL Journal Import by using FBDI process
Oracle Cloud – GL Journal Import by using FBDI Process Overview FBDI Journal Import Oracle Cloud made life easy for the data entry in creating/preparing…
Oracle Cloud – How to Install ADFDI Plug In
Oracle Cloud – How to Install ADFDI Plug In Introduction: ADFDI is an excel plug-in needed to use any spreadsheet functionality within Oracle Cloud (i.e.…
Oracle Cloud – How to do Form Personalize to stop showing ICONS on spring board
Oracle Cloud – How to do Form Personalize to stop showing ICONS on spring board Introduction: If we need to hide/display spring board icons or extend the…
Resource Database Corruption
Resource Database Corruption: What is resource database: Resource database is a binary and a system database, and its corruption would not allow instance to sta…
Making Use of APEX BLOBS with Oracle Storage Cloud Service
1. Overview This document talks about how to push the blob uploaded by the end-user to Oracle Cloud Storage. 2. Technologies and Tools Used The following techno…
Time and Month Selection in Oracle APEX
1. Overview This document talks about how to bring the Time and Month Selection in Oracle APEX. 2. Technologies and Tools Used The following technologies has be…
Configure tomcat web server to prevent information leakage
Configure tomcat web server to prevent information leakage: Problem Description: This information can help an attacker gain a greater understanding of the syste…
ORA-38824 for trigger FLOWS_FILES.wwv_biu_flow_file_objects
ORA-38824 for trigger FLOWS_FILES.wwv_biu_flow_file_objects. Issue Faced: After installing apex 20.2 some of the APEX functions were not working as expected. Fo…
TABLE RECOVERY USING RMAN BACKUP
Objective is to recover a table using the database and archive log backup with the help of timestamp and backup destination. Here, As an example we have an data…
Automatic Indexing (DBMS_AUTO_INDEX) in Oracle Database 19c
Automatic Indexing (DBMS_AUTO_INDEX) in Oracle Database 19c The automatic indexing feature automates the index management tasks in an Oracle database. Automatic…
Workspace Manager in Oracle 19c
Workspace Manager in Oracle 19c Introduction: Workspace Manager, a feature of Oracle Database, enables application developers and DBAs to manage current, propos…
OEM Upgrade from 13.4 to 13.5
OEM UPGRADE FROM 13.4 TO 13.5 PRE-REQUISITE: First, we need to take a backup of the Middleware Home, the Management Repository, Central inventory, Software libr…
Item Conversion
Item Conversion
Service Contract Details Query
Service Contract Details Query
OEM 13.4 Step by Step Installation
OEM 13.4 INSTALLATION AND CONFIGURATION OEM OVERVIEW: Oracle Enterprise Manager is management tool, which is used to integrated solution for managing your heter…
All you need to know about Oracle Consumer Goods Suite
Consumer goods manufacturers and distributors are under unprecedented pressure to deliver a larger variety and quality of items, streamline complex supply chain…
Why Network Service Providers are turning to Oracle Communications?
Oracle Cloud for Communications is “redefining the telco market. Oracle Communications offers integrated cloud solutions that help Service Providers and Enterpr…
Oracle Financial Services Cloud – How can it help you?
The financial services sector now has access to the cloud thanks to developing technology. While there are still mission-critical issues with security, complian…
What’s New in Oracle Application Cloud Security Solutions?
One of the most significant resources in contemporary business is data. Organizations rely on this data for crucial tasks like analytics and transaction process…
Oracle Solutions for Hospitality Industry
The hotel sector has undergone a vital shift thanks to technology. Even as the industry struggles to stay up with the changes, customer expectations keep rising…
3 Key Elements in Digital Transformation – What you Need to Know!
The phrase “digital transformation” has been used frequently over the past few years. Digital transformation is widely misunderstood, as with many other termino…
How Oracle Powers Industrial Manufacturing?
The most recent advancements in manufacturing are referred to as “industry 4.0.” Digital technologies like big data, IoT & hyperconnectivity are being incorpora…
What does Continuous Innovation in Oracle EBS mean for Users?
For more than 30 years, millions of businesses worldwide have relied on Oracle E-Business Suite (EBS) to manage their critical business operations and activitie…
Oracle Cloud Infrastructure Expands New Capabilities
The base of your cloud estate is your core cloud infrastructure. Like the motor in your car, its goal is to work quietly and consistently. Your fundamental clou…
Oracle has announced the database upgrade 23c, available in Beta!
The Oracle Database 23c beta release is now available, giving customers of the company’s namesake relational database technology a sneak peek at new features th…
Oracle vs. other Cloud Partners – Why Oracle is the Best?
Organizations are not only finding it necessary to transfer to the cloud due to the recent and abrupt shift to a remote and scattered workforce, but they are al…
How Oracle Powers the Construction & Engineering Sector?
The engineering and construction (E&C) sector are particularly at a technological crossroads, or “the dawn of the digital era,” with adoption and development ri…
Check out Oracle APEX 22.2 – What’s new?
Oracle Application Express (APEX) provides developers with the tools they need to swiftly create engaging apps with the best possible functionality, performance…
How Oracle Powers the Automotive Industry?
There has never been a more exciting time of transition in the automobile business. Every day, automobiles are becoming more and more sophisticated technologica…
Oracle Cloud ERP named in Gartner Magic Quadrant 4th time
Oracle Fusion Cloud Enterprise Resource Planning has been awarded a Leader in the 2022 Gartner Dream Quadrant for Cloud ERP for Product-Centric Enterprises for…
How to Upload and Download Files using Object Storage Unit in Oracle Apex
Overview Object Storage unit is a high-performance storage platform. It is ideal for storing an unlimited amount of unstructured data.The files can be uploaded…
Explore the New Possibilities in the Oracle Sector!
6 Books to Maximize Potency in any Organization The work culture and operation in every organization are different. Tons of technologies and services may be ada…
Employee Expenses Query – Fusion Expense Module
Introduction: This blog has the SQL query that can be used to pull employee expenses data from Fusion Expense Module. Cause of the issue: Business wants a repor…
Enabling DFF Attributes for Lookups in Oracle Fusion
Step1: Navigate to Set Up And Maintenance à Search Task à Manage Applications Core Descriptive Flexfields. Search with Flexfield Code: FND_LOOKUP_VALUES_…
Setting Up Language Profile for HDL Import and Load in Fusion HCM
Please click on the below link for the attachment. setting-up-language-profile-for-hdl-import-and-load-in-fusion-hcm
Why do Customers opt for Oracle APEX?
One of Oracle’s best-kept secrets about Oracle APEX is partly because many Oracle employees don’t seem to comprehend the advantages of their product. You can de…
Query to fetch dunning contact for customer
Using below query we can get dunning contact information. SELECT account_number customer_number, party_name customer_name, ( SELECT LISTAGG(party_name, ‘…
8 Reasons Why you Should Run your Applications in OCI!
Oracle Cloud Infrastructure (OCI), a comprehensive platform of public cloud services, enables users to create and execute various applications in a scalable, se…
Key Features of Oracle Autonomous Database
Autonomous Database provides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance, and requires no database admini…
Top 10 Reasons Why Customers Choose Oracle Cloud HCM
The way that businesses run is changing dramatically throughout the world. Customers desire quick, convenient, personalized goods and services and have high exp…
12 Reasons to Consider Oracle Linux for your Application Workloads in OCI
An Oracle database powers several crucial corporate applications, including order entry, accounting, human resources, customer relationship management & enterpr…
Why Oracle Cloud ERP is the #1 Choice for Businesses?
Many firms rely on enterprise resource planning (ERP) systems to handle their accounting, procurement procedures, projects, and other business-wide activities.…
Migrate On-premises Oracle Apps to Oracle Cloud Infrastructure (OCI)
By increasing business agility, cutting expenses, and emphasizing key skills, moving to the cloud strengthens an organization’s capacity for innovation and enha…
Oracle & Microsoft Eases the Pathway to Multi-cloud Sector
Organizations now manage infrastructure, secure data, and develop apps in fundamentally different ways, thanks to the cloud. Rapid resource provisioning, demand…
Oracle CloudWorld 2022 – What you Should Know!
To learn first-hand from their peers and Oracle professionals, Oracle CloudWorld brings together customers, partners, and users of Oracle Cloud infrastructure a…
Cloud Security Trends to Safeguard your Enterprise
The complexity of IT infrastructure and the rise of cyberattacks has become a concern for the security leaders with ever-changing problems. Due to the adoption…
Know how Oracle Database Consultancy Services can help your Business
Most business leaders today are aware of using data to generate business results. Data security, organization, and maintenance are more challenging than ever, b…
Oracle Launches Dedicated OCI Regions in India
Oracle has launched the “OCI dedicated Region” for the Indian market to reach the public sector and regulated businesses. This region will allow users to utiliz…
Switch to Oracle Gen-2 Cloud Infrastructure for elevated business growth | Tips for CIOs
CIOs are expected to lead an organization’s digital disruption through anything from corporate initiatives to incremental innovation. You need to use data-drive…
Six Reasons Oracle Cloud Infrastructure is Preferred Over Other Cloud Vendors
Cloud computing has grown at an exponential rate over the past decade. The cloud computing market is now greater than it has ever been. Because of the COVID-19…
What does Oracle EBS’s Upgrade mean for Business?
Choosing which E-Business suite to connect with can be challenging since cloud computing & e-commerce grows to pervade every element of modern enterprises. It c…
Why is it Necessary to have Oracle APEX for Businesses?
Oracle Application Express (APEX) is a low-code application development platform that allows users to create scalable, secure enterprise apps with world-class c…
Automating Data Management with Oracle Autonomous Database
Cloud computing is transforming corporate practices and streamlining data centre operations. Many IT administrators appear wary of shifting crucial database res…
Executive presence is within our reach
Have you ever wondered why one person with the same skills and qualifications gets promoted over another? Executive presence, this term may sound vague and inde…
Triage E-business Suite Performance tuning
Performance issues in the application are the most common thing in every organization, almost in every product. Oracle performance issues are prevalent in E-bus…
Elevate your performance by shifting to Oracle Cloud Infrastructure
Increased technical performance is one of the many advantages of moving to the cloud, and it supports both business and operational growth. Since its conception…
Top 10 Reasons to Adopt Oracle Cloud
Even though cloud technology has been here for over a decade, many businesses have not realized its full potential. Simply introducing Cloud into your company p…
Oracle Received a 2022 Gartner® Peer Insights™ (Voice of the Customer) – Enterprise Low-Code App Platforms
The honourees of Gartner’s new 2022 Peer Insights Voice of the Customer: Enterprise Low-Code Application Platforms were just revealed. Gartner Peer Insights rev…
10 Benefits of Oracle’s Database Management Platform
As the volume of data generated by customers expands, so does the opportunity to use it to further your company’s objectives. Almost every online activity your…
Check out the latest deployment strategies for OCI DevOps from Oracle
Not long ago, Oracle has announced that continuous integration (CI) tools from its Oracle Cloud Infrastructure (OCI) DevOps solution are now generally available…
Windows 10 Activator Download | 2024
Windows 10 Activator Latest Free Download Understanding the significance of this utility is key. Thus, we encourage you not to waste moments poring over the dow…
Oracle is on a mission to break cloud “myths” with advanced tools
Oracle Platform has updated its IaaS product, Oracle Cloud Infrastructure (OCI), with 11 new tools throughout its compute, storage, and networking services to p…
Oracle (ORCL) launches multi-VM Autonomous Database
Oracle is introducing a new way for businesses to use Oracle Autonomous Database on Exadata Cloud@Customer, which takes on-premises database cloud automation to…
Why is a Multi-Cloud Perfect Solution for your Business?
As more businesses migrate to the public cloud, they must decide whether to employ a single cloud provider, including popular Amazon Web Services (AWS) that use…
Migration to Oracle Cloud
By improving business agility, lowering expenses, and strengthening the focus on core skills, moving to the cloud strengthens an organization’s ability to innov…
Oracle has Launched Updated Functionalities for its Oracle Fusion Cloud SCM Offering
Updating Enterprise Resource Planning or ERP modernization systems that manage core business and data can be daunting for most people. However, upgrades are nec…
Oracle Enhances Oracle Cloud Lift Services
Many firms have been shifting their IT infrastructure from on-premise to cloud settings in recent months. While some key apps and workloads will remain on-premi…
All Information Windows 10 Activator | 2022 Download
Windows 10 Activator 2022 is the simplest and easiest to use activator for Windows Vista, 7, 8, 8.1, 10. It is a safe activator, without damaging the system fil…
Here is the answer to why many businesses turn to the Cloud for Faster & more Flexible Operations!
Cloud computing is more than just a piece of software. It is a force that elevates CIOs to innovators and catalysts of organizational success. CIOs do not have…
Key Milestones for Doyensys in 2021
We are happy to share our Key Milestones achieved for the last year. We aligned our efforts and activities with proper solutions and technologies to address our…
New Cloud Regions in Sweden, Italy & South Africa
With high client demand for Oracle Cloud services, Oracle currently has 37 cloud regions worldwide, with intentions to have a minimum of 44 cloud regions by the…
ORA-01775: looping chain of synonyms
I encounter the looping chain of synonyms error Reason:- ORA-01775: looping chain of synonyms – Basically means that you created a synonym that points to anothe…
Check Out the Recent Oracle Analytics Updates for 2022
Oracle Analytics is a potent combination of three forces: augmented analytics, self-service analytics, and regulated analytics. Oracle provides a single solutio…
Business Benefits of Oracle Cloud ERP
The recent digital era changes much faster than it has ever been. Adopting new technology, embracing new business models, and using the cloud as a platform for…
Loading and unloading java Jar in to database
1.For Loading jar use cmd loadjava -force -genmissing -r -user username/password@servicename -verbose jar 2.For droping jar use cmd dropjav…
Find the session which generates more archive log
Query: select s.sid,sn.SERIAL#,n.name, round(value/1024/1024,2) redo_mb, sn.username,sn.status,substr (sn.code1,1,21) “code”, sn.type, sn.module,sn.sql_i…
Query to find how many chained (and migrated) rows each table has
Query: SELECT owner, table_name, chain_cnt FROM dba_tables WHERE chain_cnt > 0; SELECT owner_name,table_name,count(head_rowid) row_countFROM chained_rows GROUP…
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
ERROR: While running adcfgclone faced below error, AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. [AutoConf…
How to update Workflow Administrator Role in Oracle EBS
How to update Workflow Administrator Role in Oracle Applications 1..update wf_resources set text=’&Enter_Admin_Name’ where name=’WF_ADMIN_ROLE’; e.g update wf_r…
ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE
Error: ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE Cause: a database link connected to a database with a different name. The connection is…
ORA-12609: TNS: Receive timeout occurred 12 & 19c
Sometimes You can get “ORA-12609: TNS: Receive timeout occurred ” error. Details of error are as follows. ORA-12609: TNS: Receive timeout occurred Cause: The re…
Agent resident memory utilization in KB is
EM Incident: Warning:New: – Agent resident memory utilization in KB is 1. ./emctl stop agent Ensure no EMAgent process is running with the following comm…
ORA-01552: cannot use system rollback segment for non-system tablespace, clone database
ORA-01552: cannot use system rollback segment for non-system tablespace “TBS Name” ORA-01552: cannot use system rollback segment for non-system tablespac…
Enhance your Business Operations with Oracle ERP Health Check
A well-executed ERP system is a highly valued business strategy secured by every organization. When a company successfully implements the right ERP solution, ap…
Life At Doyensys – Kuleena Sanju Thomas
We at Doyensys, believe in the fact that every employee possesses their own set of strengths and efficiencies. It is those values of our employees that has kept…
Does Oracle EBS Health Check increase the efficiency of Businesses?
Oracle E-Business Suite is used by thousands of organizations worldwide. In the digital world, we need cloud migration and integration to run business operation…
Version Conflicts among development maintained and customized templates encountered; aborting AutoConfig run.
Error: Version Conflicts among development maintained and customized templates encountered; aborting AutoConfig run. Cause: While running autoconfig we faced be…
Empathy – A Powerful Tool
It was the first day of WFH after my maternity leave. As I had a call scheduled with my boss Somu at 10:30 AM, I had prepared all the information required for t…
Oracle Database Health Check – Importance, Benefits, Checklist and Metrics
A crucial component of every business, a stable health check database is important to ensure the well-being of the staff and the customers. With a periodic insp…
Uplift your Business with Oracle Outsourcing Services
Cloud Computing is the beginning for your business to achieve thousands of potentials. In the competitive marketing space, we have hundreds of companies offerin…
Getting Blank Page When Create Document via Desktop Integrator – EBS 12.2.X
Issue: On : Oracle EBS 12.2.8 version, When attempting to create document, get a blank page. The issue is not limitted to Create Document page, it could happen…
ASSERTION ERROR IN WEBLOGIC
Problem:-Assertion Error Cause:- We will get the Assertion Error in the console because while running managed servers some one clear the cache. So that we will…
How to choose the Best Offshore Oracle Service Provider?
In the current business environment, cloud-based services have grown in high popularity among companies. Statistically, 93% of enterprises preferred the multi-c…
Creating Excel File in Oracle Forms
Below is the example to create an excel file in Oracle Forms. Pass the Sql query string to the below procedure to generate an Excel file using Ole2 package. Sam…
Using Find_Alert and Show_Alert in Oracle Forms
Introduction Show_alert is used to display model window messages in Oracle Forms and Find_alert searches the list of valid alerts in Form Builder, when the give…
Using Post_Query Trigger in Oracle Forms
Introduction When a query is open in the block, the Post-Query trigger fires each time Form Builder fetches a record into a block. The trigger fires once for ea…
Error: resource-env-ref,CDI Container and disable policy
org.apache.cxf.jaxws.context.WebServiceContextResourceResolver/bus’ declared in the standard descriptor or annotation has no JNDI name mapped to it. The resourc…
weblogic error ‘could not get the server file lock’
Down the Admin server console Clear AdminServer.lok file from tmp foleder under Admin server
Getting prepared for the Changing world
Due to current situations, the desk, sofa or even the dining table has become our office. Now, working from home is a very common affair for people like us who…
Item Master Data Management (IMDM) Implementation for a US based Dairy Cooperative Society
For any organization, Item Master is the core set of data that is used for most of the daily processes in an ERP system. Items are used to represent products an…
adcfgclone.pl appsTier on a new setup or a clone fails with : sh: /u01/apps_st/comn/clone/bin/../jre/bin/java: /lib/ld-linux.so.2: bad ELF interpreter
Error: sh: /u01/apps_st/comn/clone/bin/../jre/bin/java: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory Cause: Missing library file on the Ap…
Concurrent Programs failing in a newly cloned or created EBS Instance
Error : Environment:Environment java.lang.UnsatisfiedLinkError: no rwu in java.library.path Environment:getEnvironmentStrings java.lang.UnsatisfiedLinkError: no…
Rman Active duplication or Standby creation fails with RMAN-03002, RMAN-05501
Error : RMAN-03002: failure of Duplicate Db command at 09/03/2021 03:44:34 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in sto…
R12.1.3 opmnctl services failed with Error code : 204 in a new setup
Error : Cause : Missing a mandatory RPM and symbolic links to the generated lib file. Solution: Install the rpm : libdb-5.3.21-25.el7.i686 create the below symb…
RPMs required when Migrating or Cloning to a new server – EBS R12.1.3
If not using the pre-install rpm, the following packages (or versions of packages) are not part of the OS distribution media and must be downloaded separately (…
Fusion HCM Query to Fetch Payroll Details
SELECT papf.payroll_name, papf.period_type, pcs.consolidation_set_name, ptp.period_name, to_char(ptp.start_date, ‘YYYY/MM/DD’) start_date, to_char(ptp.end_date,…
Fusion HCM Query to Fetch Assignment Details
SELECT papf.person_number, ppnf.full_name employee_full_name, ppnf.first_name, ppnf.last_name, to_char(ppos.date_start, ‘MM/DD/YYYY’) date_start, paam.assignmen…
Fusion HCM Query to fetch HDL Load Error Details
SELECT hddsb.data_file_name, hdds.ucm_content_id, hdds.creation_date, hdds.data_set_name, hdds.imported_status, hdds.loaded_status, hdds.import_lines_success_co…
Allow Only Number and Decimals Using Jquery in Oracle Apex
1. Overview This document explains how to Allow only Numbers and Decimal Using Jquery in Oracle APEX. 2. Technologies and Tools Used The following technologies…
Table Function to return look up value for LOV’s In Oracle Apex
1. Overview This document is about table function to return lookup values For LOV’s in oracle apex. 2. Technologies and Tools Used The following technologies ha…
Sales Order Warranty Item Setup
SALES ORDER Warranty Item Setup STEP BY STEP Process STEP1: Create Warranty Item Navigation : Inventory -> Item -> Master Item CREATE A NEW WARRANT ITEM CODE HS…
How To Add row from another report in Interactive Grid using JavaScript
1. Overview This document is about Interactive Grid – Add row from another report using JavaScript in oracle apex. 2. Technologies and Tools Used The following…
Oracle Apex Detect Multiple Browser Tabs
1. Overview This document is about to detect multiple browser tabs in oracle apex. 2. Technologies and Tools Used The following technologies have been used to d…
How to wrap PL SQL Code in Oracle
1. Overview This document is about how to wrap the PLSQL code in oracle. 2. Technologies and Tools Used The following technologies have been used to wrap the PL…
Classic Report Filter Option in Oracle Apex
1. Overview This document is about how to add filter option in classic report in oracle apex. 2. Technologies and Tools Used The following technologies have bee…
Blanket Purchase Agreement Using AME, Stuck an Incomplete Status
The Document Type of Blanket Purchase Agreement (BPA) fails using the Approval Management Engine (AME) Approval. • The AME rule has been set up and is used both…
How To Setup And Use Approval Management Engine AME For Purchasing Documents
How To Setup And Use Approval Management Engine AME For Purchasing Documents Assign AME access to users Assign AME Roles and Responsibilities AME responsibiliti…
Difference between PO Closed and PO Finally Closed
Difference between PO Closed and PO Finally Closed We can open a closed purchase order but you cannot take any control action on Finally Closed POs. The system…
When Importing Internal Requisitions getting Error Item is missing or invalid
Error ‘Item is missing, invalid, or not internally orderable’ When Importing Internal Requisitions When attempting to import internal requisition lines, the fol…
Oracle APEX Chart Conditional Bar Colors
Overview This document explains how to to change the chart bar colors based on the conditions in Oracle APEX. I will be very useful when we want some one Techno…
AR Interface Issue Transaction Currency Payment Method Setup
Sales Order Transaction Currency not Associated with Payment Method Currency – Solution Setup Step 1:Navigation : AR IE Manager -> Control -> Auto Invoice -> In…
View Accounting Function is Not Available in Receiving Transactions Summary
Module – Oracle Purchasing While attempting to view the accounting information from View Receiving Transactions of Inventory Receiving, the following error occu…
Accrue On Receipt Flag in PO Shipments can not be Unchecked
Module: Oracle Purchasing Enter Purchase Orders Error : Can not uncheck the ‘Accrue On Receipt’ flag in PO shipments Error : Cannot update ‘Accrue On Receipt’ f…
Item Ranging – Oracle Retail Merchandising System Module
Item Maintenance RMS is responsible for the creation and maintenance of all items. RMS uses a flexible data hierarchy for an item, with levels that allow…
Workflow Fundamentals
Introduction to workflow Tool from Oracle Works with Oracle Database PL/SQL Based Widely Used with Oracle Applications Can be Used Stand-Alone or with Oracle Ap…
Oracle BI Publisher report output sorting
We can sort data in XML report a group by any element within the group. Sort data based on Empno: Syntax: <?sort:Field_Name?><?Field_Name?> It sorts the data in…
Setup a new store in Oracle RMS
To Setup a new store in RMS follow the steps given below Step 1: First open the browser and type the given URL: http://shk-oratestapp02.hk.oracle.se:7783/Retail…
Oracle Query for the Users who have access to a particular form
select a.menu_id , menu_name , c.responsibility_name , g.user_name , g.description from fnd_menu_entries a , fnd_menus b , fnd_responsibility_vl c , fnd_form_fu…
Oracle PO Inbound interface EBS
CREATE TABLE xxcus.XX_PO_HEADERS_STG ( INTERFACE_HEADER_ID NUMBER , BATCH_ID NUMBER, INTERFACE_SOURCE_CODE VARCHAR2(25), PROCESS_CODE VARCHAR2(25), ACTION VARCH…
Syntax to user oracle functions in BI Publisher
XML Publisher has extended a set of SQL and XSL functions for use in RTF templates. The syntax for these extended functions is for extended SQL functions <?xdof…
Query to find responsibility from a form name
SELECT FORMS.form_name, FORMSTL.user_form_name, RESTL.responsibility_name, FORMSTL.language FROM fnd_form FORMS, fnd_form_tl FORMSTL, fnd_form_functions FUNC, f…
BI Publisher If then Else Statement
Conditional Format Statements in BI/XML Publisher : If if-then-else choose- when-otherwise The Conditional Formatting using if statement: If statement: Use if s…
How to Change the Default Request Group in E-Business Suite Support Analyzer Bundle Menu
It is possible to change the default request group for a given Analyzer at the individual analyzer level. 1.Start the menu with “perl Menu.pl” 2,Select a Produc…
AR AUTO ACCOUNTING SETEUP
Step 1 : Define Auto Accounting Rule Setup Navigation : Account Receivable -> Setup -> Transactions -> Auto Accounting. Define Tax Code Auto Accounting Rules Se…
Interactive grid cell coloring without condition using css class invoke
1. Overview This Document is used to get selected IDs from the Interactive grid based on selection. 2. Technologies and Tools Used The following technologies ha…
Supplier Master Data Import – FBDI Template
Title: Supplier Master Data Import – FBDI Template In this post , We will discuss about Supplier import in oracle fusion. Oracle has provided the FBDI tool to i…
Order To Cash Script
Order To Cash Script o2c SELECT hp.party_name customer, hca.account_number, hp.party_number, ooh.order_number, ooh.flow_status_code order_status, rcta.tr…
ORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError – ecx_utils.INITIALIZE
When trying to submit one of GL report end with error. The error message shows ORA-29532: Java call terminated by uncaught Java exception. select * from *******…
While starting database ORA-03113: end-of-file on communication channel
ERROR While starting database ORA-03113: end-of-file on communication channel Problem: On further diagnosis of ADRCI logs, I found disk space size assigned to F…
Prevent the APEX application from being opened in multiple tabs with the same Session state
1. Overview This document talks about prevent opening Oracle APEX application in multiple tabs with the same session state. 2. Technologies and Tools Used The f…
SharePlex reports out-of-sync conditions
How SharePlex reports out-of-sync conditions For all objects except those involved in transformation, SharePlex verifies that the source and target data in a gi…
Invalid receipt due to previous pay from customer and customer site issue for receipt
Issue ; while closing the AR period we could see one receipt in in valid status in subledger period close exception report. Fix ; we have data fix for th…
Steps to start/stop Workflow Notification Mailer–backend
Steps to start/stop Workflow Notification Mailer Check workflow mailer service current status SQL> select running_processes from fnd_concur…
21c New Feature – Result Cache for Standby Database
Oracle 21c introduces the ability to improve the performance of queries executed on the read-only active Standby Database by enabling the use of the Result Cach…
ORA-17629: Cannot connect to the remote database server | Active Duplicate on RAC
If you got this error in the RMAN active duplication of RAC database fails on restart operation with the following error messages: RMAN-03002: failure of Duplic…
The Store Record X Could Not Be Found
Shutdown manage servers and Admin server, clear below extension file on under domain home. Clear temp and cache of manage and admin servers find . -name…
Life At Doyensys – Bhagavathy Ramachandran M
We at Doyensys, believe in the fact that every employee possesses their own set of strengths and efficiencies. It is those values of our employees that has kept…
Auto Refresh Report and Hide Processing Spinners in Oracle Apex
Overview This document explains how to auto refresh report after a specified interval and hide processing spinners in oracle apex. Technologies and Tools Used T…
FIND APEX USERS LOGIN DETAILS
Description: Following sql script is used to find the Application Express users , who all are logged in previous days or specific period (months , years) . Step…
OPMN Error : R12.1.3 EBS front-end console won’t come up
Error Log location: $INST_TOP/logs/ora/10.1.3/opmn/default_group~oacore~default_group~1.log $INST_TOP/logs/ora/10.1.3/opmn/default_group~oafm~default_group~1.lo…
Schema validation errors while parsing /Weblogic/Admin/config/config.xml
While starting weblogic aAdmin server getting error as below Schema validation errors while parsing /Weblogic/Oracle/Admin/config/config.xml – Expected elements…
Insert script with error log table
1. Overview This document will be helpful to insert data from intermediate table to source table with error log table 2. Technologies and Tools Used Oracle Plsq…
Caps Lock On/Off indicator in Oracle APEX.
Overview This document explains how to show Caps Lock On/off Indicator in Oracle Apex. Sometimes it is necessary to check whether caps lock is on or off. Capslo…
How to disable update for a particular column in Oracle APEX Interactive Grid
Overview This document explains how to disable update for a particular column in Interactive Grid using the Read Only property of a column. Technologies and Too…
Disable update for a particular column in Oracle APEX Interactive Grid
Overview This document explains how to disable update for a particular column in Interactive Grid using the Read Only property of a column. Technologies and Too…
How to create or rebuild Context file in database DB Tier on R12.2
1. Find out the Template file. [oracle@ebs bin]$ cd $ORACLE_HOME [oracle@ebs 12.1.0]$ cd appsutil/template/ [oracle@ebs template]$ pwd /u01/StageR122/PROD/12.1.…
Fusion Financial Configuration – Bills Payables
Title : Fusion Financial Configuration – Bills Payables Overview: Future dated payments or Bills Payable in Fusion Application is used to control the timing of…
JServer JAVA Virtual Machine Component Is in Removing state
ERROR: JServer JAVA Virtual Machine Component Is in Removing state CAUSE: SQL> select comp_name, version, status from dba_registry; COMP_NAME VERSION STATUS ———…
ORA-38760: This database instance failed to turn on flashback database
ERROR: ORA-38760: This database instance failed to turn on flashback database CAUSE: When we are upgrading from 12c to 19c we faced below error, SQL> alter data…
Script to Schedule concurrent program from back end
Sample Script to Schedule concurrent program from back end Procedure xxTTK_schedule_prog is l_conc_id VARCHAR2(500); l_responsibility_id NUMBER; l_application_i…
Query to find GL Period status
Query to find GL Period status SELECT * FROM gl_period_statuses ps, gl_sets_of_books sob, fnd_application_vl fnd WHERE 1=1 and ps.application_id = 101 AND sob.s…
Query to find Sales Person
Query to find Sales Person SELECT hcsu.primary_salesrep_id FROM hz_cust_accounts hca, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu WHERE hca.cust_acc…
10 лучших вариантов размещения в Осло, Норвегия
The landlord has been waiting for us in the house. When we arrived, she was very enthusiastic about introducing us to the interior of the house. The facilities…
Query to find Third Party Registration
Query to find Third Party Registration SELECT DISTINCT TRIM (TO_CHAR (b.registration_number)) gst_num INTO lv_gst_num FROM jai_party_regs a, jai_party_reg_lines…
APPLYING WELOGIC PACTH FOR R12.2 VIA COMMAND
ORACLE WEBLOGIC SERVER (WLS) 10.3.6.0.7 — 10.3.6.0.191015: … Continue reading APPLYING WELOGIC PACTH FOR R12.2 VIA COMMAND
Order Creation Using API
Script to OE_ORDER_PUB.PROCESS_ORDER ( Sample Script Create Sales Order ) Script PROCEDURE xx_bdg_so_interface ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_or…
Remove Options from the Interactive Grid Row Action menu
1. Overview This document talks about how to remove the options from the interactive grid action menus. 2. Technologies and Tools Used The following technologie…
Auto New Line Generation in Interactive Grid
1. Overview When using Interactive grid, sometimes user don’t want to go with add row button for a new row generation. On those cases, this document shows, how…
ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE”, line 536 ORA-29283: invalid file operation
Description: The oracle OS user does not have the appropriate privileges on the OS directory, or if the path specified in the database does not match to an actu…
CREATING DATABASE SCHEDULER JOBS
Description: Scheduler jobs are the automated process handled by the database scheduler in oracle. It will run the scheduler jobs in a specific server time inte…
Responsive Report
1. Overview Responsive Reports can be created in Oracle Apex Classic Reports. Standard Oracle APEX which shows the tabular format of the dataset doesn’t support…
How to check what current IDLE_TIME is set at in 11g ORACLE DATABASE
The Idle Time Resource Usage setting limits the maximum idle time allowed in a session. Idle time is a continuous inactive period during a session, expressed in…
Popup Menu in Apex
1.Overview A popup menu can be created in the application by using Lists and associating a button with the menu. To create a popup menu in the application, firs…
RMAN-03009: ORA-17628:
Error:- While the RMAN Active Duplicate is initiated, the rman job failed with the below errors, RMAN-03009: failure of backup command on C1 channel ORA-17628:…
Unknown Parameter Name ‘utl_file_dir’
ERROR:- SQL> create spfile from pfile; create spfile from pfile * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-32003: error occured p…
Delete a node from application Tier in Oracle Apps R12.2
Description: Delete the Secondary application Node from Application Tier, follow the below steps. Note: This steps are ONLY for deletion of secondary applicatio…
Create Oracle BI Publisher Report
Create Oracle BI Publisher Report create-oracle-bi-publisher-report
How to fix deployment is in start running state- weblogic 12c
When we see the app is in start running state at the time of deployment in weblogic 12c Go to the logs if you didn’t see any issues Just try to restart the mana…
Weblogic app installed state
Some times we will get the status of application is INSTALLED. The admin server console shows all deployments in INSTALLED state when they should be showing as…
ORACLE ADVANCE QUEUING
1. Overview This document talks about the steps to working with Oracle Advance queue. Advance queue is awesome feature of Oracle. By using this technique we can…
Recurring Journals – General Ledger
Recurring Journals – General Ledger Define recurring journal for transactions that you repeat every accounting period, such as accruals, and allocations. Your r…
Life At Doyensys – Gobinath Radhakrishnan
We at Doyensys, believe in the fact that every employee possesses their own set of strengths and efficiency. It is those values of our employees that has kept u…
Sending Email Using Oracle Apex and PL/SQL With Examples
Objective: Using Oracle Apex Package Apex mail, How we can frame mails and send with the help of oracle PL/SQL Program. Definition: We have 3 Proc…
Oracle Fusion configuration – Payment Process Request
Title : Payment Process Request Manage Payment Method Manage Payment Document Payment Process Profile Payment Process Request Template Enter Invoices Submit Pay…
Oracle Fusion configuration – Account Hierarchies
Title: Oracle Fusion Configuration – Account Hierarchies We need to create account hierarchies in order to reflect managerial, legal or geographical relationshi…
GST P2P TRANSACTION SETUP
GST P2P TRANSACTION SETUP STEP 1 :-Define Purchase Tax Category Navigator:- Oracle Finance > Tax Configuration > Define Tax Category Create Tax Category same fo…
Oracle Fusion Configuration – General Ledger
Tile: Oracle Fusion Configuration – General Ledger Manage Currencies Manage Accounting Calendars Manage Chart of Accounts Value Sets Manage Chart of Accounts St…
Interactive Grid Selected IDs based on selection
1. Overview This Document is used to get selected IDs from the Interactive grid based on selection. 2. Technologies and Tools Used The following technologies ha…
Exporting User Objects Using SQL developer
There will be scenarios like the developer wants to export the DDL/Data of user objects like Table, View, Packages, Functions, Procedures, Trigger, etc. Using S…
Steps to configure Oracle Database server with Apache tomcat
Step to configure Oracle Database server with Apache tom 1) Copy Oracle Jar file ojdbc14.jar (or) ojdbc6.jar till the lib directory to tomcat server 2) Modify t…
Futuristic Benefits of EBS Migration to Cloud
The Oracle E-Business Suite (EBS) offers advanced business functionalities to various enterprises. With Oracle Cloud Infrastructure, you can reap enormous benef…
GST TAX CATEGORY SETUP
GST Tax Category Setup: I.USER SETUP 1. Create a new GST Responsibility – ( Oracle India Financial) Navigator:- Navigator:- System Administrator > Security > Us…
Script to see all lock objects
set term on; set lines 130; column sid_ser format a12 heading ‘session,|serial#’; column username format a12 heading ‘os user/|db user’; column process format a…
Java Script to return of no. of days between two date
// JavaScript program to illustrate // calculation of no. of days between two date <script type = “text/javascript” > // To set two dates to two variables var d…
Roll Back the Import Load Program Submitted in HCM
roll-back-the-import-load-program-submitted-in-hcm
Calling Java Script Inside OIC Integrations
calling-java-script-in-integrations
Create PO Change Order in Oracle Cloud – Add New Line To Existing PO Using SOAP request
This blog describes the sample request for creating Change Order in Oracle Cloud for the existing Purchase Order. This Change Order creates new line to the exis…
Create PO Change Order in Oracle Cloud – Add Project Info To Existing PO Line Using SOAP request
This blog describes the sample request for creating Change Order in Oracle Cloud for the existing Purchase Order. This Change Order is to add project details in…
Manage IN and OUT Time Events Using REST API – Oracle Cloud OTL
The timeRecordEventRequests REST API requires both IN and OUT time to be supplied in the payload to create time entries in Oracle OTL. In real time clock integr…
Useful CRSCTL Commands
STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs Enable/Disable auto restart of CRS. $GRID_HOME/bin/crsctl…
unable to find the newly created asset category.
Issue : I have created new major category and minor category ..so after that i have created asset category with newly created Major category and minor category……
Excel is waiting for OLE” issue
How to fix the “Excel is waiting for OLE” issue Open the Excel sheet. Go to the File menu. Click on Options. Go to the Advanced tab. Scroll down to the General…
Oracle EBS SSO Benefits ?
1. Users don’t have to remember dozens of passwords for Oracle e-Business Suite – 11i, 12.1, and 12.2. 2. Weak passwords in Applications are no longer allowed.…
How to Define a PROJECT in FUSION Applications
How to Define a PROJECT in FUSION Applications When we are implementing Fusion Applications for any of our client, we can refer this document, by looking at thi…
Oracle Fusion – How to Create an Implementation User
Oracle Fusion – How to Create an Implementation User When we are implementing Fusion Applications for any of our client, we can refer this document, how…
Plan Creation Flow in Config Snapshot
Plan Creation Flow in Config Snapshot We have Config Snapshot tool to automate the migrations from one instance to another instance with less time and wi…
Open Purchase Orders for specific OU or a Ledger
Open Purchase Orders for specific OU or a Ledger Below is the script which can be used to extract the Open Purchase Orders for a specific operating unit and the…
Creating Object Library OLB in Oracle D2k Form
Step – 1 Create a form in form builder and create objects like Data Block, Canvases, Windows, Program Units etc. as shown in below image. Step – 2 Then Highligh…
Script for Fixed Assets Books Close Status
Script for Fixed Assets Books Close Status In generally FA need to be closed before the GL is closed.. in some cases if the business is not following the proces…
Query to find the special characters in a Payment batch
Query to find the special characters in a Payment Batch If we have encountered any special characters in Invoice Description or at the supplier bank acco…
Expense report ORPHAN Record deletion with Script
Expense report ORPHAN Record deletion with Script Sometimes, we can see that the expense report can have some orphan events and this is system bug which…
Upgrading a CDB & PDB from 12c to19c using Manual Upgrade
In this article we are going to see how to upgrade a oracle 12c container database from 12c to 19c using manual upgrade method. Here we are going to proceed wit…
Synchronizing the Expense Report Status
Synchronizing the Expense Report Status Normally when any employee submits the expense report, it will go to the supervisor for approval and after the approval…
Automate configuration with the Data loader
Automate configuration with the Data loader Sometimes, data may be huge and need to push the data to the oracle applications. Either it may be transactio…
Accounts Payables Trial Balance Mismatch
Accounts Payables Trial Balance Mismatch Normally we will do the reconciliation between AP to GL to make sure our liability account/control account is matching…
Active Suppliers with Payment terms and Payment Methods in EBS R12
Active Suppliers with Payment terms and Payment Methods in EBS R12 Business team or the vendor team will look for the active vendors which are associated…
Automate your payments from Oracle to Financial Institution
Automate your payments from Oracle to Financial Institution The overall purpose of the blog is to import payments information from Payables module to Bank of Am…
ORACLE GOLDEN GATE ERROR OGG-00868
In this tutorial, we are going to learn about, “How to resolve this ERROR OGG-00868″ I got the below type of error while re-start the replicat in golden gate. I…
Workflow notification goes down frequently
Error: Workflow notification mailer goes down frequently. While we checking at the workflow log file in $APPLCSF/log location(FNDCPGSC786733.txt), we can able t…
Failed to write core dump. Core dumps have been disabled. To enable core dumping, try “ulimit -c unlimited” before starting Java again
ERROR: Concurrent program error-ed out with below error, Failed to write core dump. Core dumps have been disabled. To enable core dumping, try “ulimit -c unlimi…
Unable to change apps password due to ORA-29548
Recently I have faced below error, while running FNDCPASS for changing apps password. ORA-29548: Java system class reported: release of Java system classes in t…
To Enable & Disable ADDM reports in Pluggable Database Oracle
Enable & Disable ADDM reports in Pluggable Database Oracle you can configure ADDM reports for Pluggable database(PDBs). By default it is disabled. You need to e…
Oracle 19c Grid Silent installation
Step by Step installation of 19c Grid software, 1. Download the 19c Grid software from ORACLE, https://www.oracle.com/in/database/technologies/oracle19c-…
PRCR-1001 : Resource ora.asm does not exist
Cause: After installing grid,i cant start asm resource [oracle@dbadb01 ~]$ srvctl start asm PRCR-1001 : Resource ora.asm does not exist Check the resource statu…
Validate Duplicate Values In the Interactive Grid Using PLSQL
1. Overview This document talks about finding duplicate values in the Interactive Grid using PLSQL. 2. Technologies and Tools Used The following technologies ha…
READ AND INSERT THE FILE NAMES FROM DIRECTORY TO DATABASE TABLE USING JAVA SOURCE
1.CREATE TABLE FOR THE FILES create global temporary table FILE_NAME ( filename varchar2(255) ) 2.CREATE JAVA SOURCE. This java is used to read the file from di…
Ledger Open Balance Script
select gl.name ledgername, gjb.name “Journal Batch Name”, gjh.name “Journal Name”, gjh.je_source “Journal Source”, gjh.je_category “Journal Category Name”, gcc.…
Vendor Open Balance Script
select aia.invoice_num, aia.invoice_currency_code, DECODE(aia.PAYMENT_STATUS_FLAG,’N’,’UN-PAID’,’P’,’Partial Paid’,’Y’,’PAID’) PAYMENT_STATUS_FLAG , aia.invoice…
How to check weblogic version
To check weblogic version From registry.xml from Middleware_Home Go to Middleware_Home under which weblogic is installed and look for a file registry.xml Defaul…
Check out the 5 Latest Cloud Security Trends of 2021
No matter how advanced a business gets, the integrated technology that supports it keeps on changing. But the thing that remains constant is the need to keep co…
Oracle Time Entries Creation Using REST API
Oracle Time and Labor (OTL) – Time Entries Creation Using REST API When we have a requirement to integrate Oracle Time and Labor with external clocks of…
Script to extract the accounting rule and source wise AR invoice counts
Introduction: This script will extract the accounting rule and trx source wise invoice counts. SELECT C.NAME RULE_NAME, D.NAME SOURCE_NAME, count(A.TRX_NUMBER),…
how to define currency in oracle r12
To define a new currency: Go to GL Responsibility Navigate to the Currencies window. Setup >> Currencies >>Define
Add Shortcut key to Apex IG
1. Overview This document will be helpful to add shortcut key for Add row and filter in Interactive Grid. 2. Technologies and Tools Used The technology used is…
API for Supplier/ Vendor Site Creation in R12
Overview:- In this post , I am sharing the example how to create Supplier Site through Oracle Standard API. You can refer this code to create suppliers through…
API for Supplier/ Vendor Creation in R12
Overview:- In this post , I am sharing the example how to create Supplier through Oracle Standard API. You can refer this code to create suppliers through backe…
AP Aging Report Query in Oracle Apps
Overview:- In this post , We will discuss about AP aging report query in oracle apps. The AP aging report helps us to identify the creditor aging which is due i…
WEB ADI Run-time error 91”
When the users trying to open the downloaded web adi template, they are getting the run time error 91 …when opening web adi .We need to follow the below procedu…
Working With Oracle APEX_LANG
1. Overview This document talks about how to use the APEX_LANG.MESSAGE API & also teach how can we define a message for each desired language. 2. Technologies a…
Display BOM in Hierarchy Tree Structure
Overview Bill of materials (BOM) is a centralized source of information used to manufacture a product. It is a list of the items needed to create a product as w…
Displaying Multiple Columns in Popup LOV
Overview This document explains how to display multiple columns in Oracle Apex pop up LOV. The following steps are to be followed to display multiple columns in…
Data Loading in Oracle Apex
Overview This document explains how to load from XML file into table using Data loading facility in Oracle Apex 21.1.1. Technologies and Tools Used The followin…
Integrating Web History JavaScript API’s with Oracle Apex
1. Overview This Document is used to implement Incremental search on Interactive report and Interactive grid 2. Technologies and Tools Used The following techno…
How Oracle Apex can transform your Enterprise Apps?
Oracle Application Express or Apex is a modernized and advanced web-oriented software development tool explicitly designed to run on the Oracle Database. It can…
How does End-to-End Process Automation work for TTK Healthcare?
Have you ever wondered about the process of how an order reaches you? It is not a simple process of click, ship, and delivery. Time-consuming and mundane proces…
ora- 01017- Invalid username/password log on denied
Cause : Apps account locked. Solution : unlock the Apps account in system using below command Sql > Alter user apps account unlock;
Life At Doyensys – Buchupalli Gayathri
We at Doyensys, believe in the fact that every employee possesses their own set of strength and efficiency. It is those values of our employees that has kept us…
Query to Get Employee Leave Details in Project
SELECT PAPF.EMPLOYEE_NUMBER, PAPF.FULL_NAME “EMPLOYEE NAME” , PT.DESCRIPTION “LEAVE DESC”, TO_DATE(trunc(ei.EXPENDITURE_ITEM_DATE),’DD-MON-YYYY’) “DATE”, EI.QUA…
Query to Get AP Expense Report Made By an Employee
SELECT GSOB.NAME “SOB Name”, AEH.INVOICE_NUM “Report Number”, AEH.TOTAL, AEH.DESCRIPTION, PPX.FULL_NAME, PPX.EMPLOYEE_NUMBER, decode(AEH.WORKFLOW_APPROVED_FLAG,…
Query Project with Revenue Amount Along with Event Details
BEGIN mo_global.set_policy_context(‘S’,84); END; SELECT project_number, project_name, :p_gl_period MONTH, ou.NAME org_name, (SELECT revenue_amount FROM pa_event…
Query Project Unbilled Amount
SELECT TO_CHAR(TRUNC(PE.CREATION_DATE),’MON-YYYY’) MONTH, (SELECT NAME FROM HR_ORGANIZATION_UNITS WHERE organization_id =ppa.carrying_out_organization_id ) Busi…
Query Project Agreement with Project Details.
SELECT d.customer_id, ppc.customer_name, d.agreement_type, d.description agreement_desc, d.CUSTOMER_ORDER_NUMBER, AGREEMENT_NUM,TRUNC(D.CREATION_DATE) AGGREMENT…
API to Check the Available credit On a Sales Order.
DECLARE l_header_id NUMBER; l_calling_action VARCHAR2 (200); l_msg_index NUMBER; l_error_message VARCHAR2 (2000); x_msg_count NUMBER; x_msg_data VARCHAR2 (200);…
API TO CANCEL PO invoice
API TO CANCEL PO invoice AP_CANCEL_PKG.IS_INVOICE_CANCELLABLE: —- CREATE OR REPLACE PROCEDURE XXDOYEN_INV_CANCELLABLE (p_inv_id IN NUMBER) is v_boolean BOOLEAN;…
Ways to Embrace Hybrid Cloud with the Oracle Cloud Infrastructure (OCI)
We are living in a time where automation takes over the human workforce to simplify the process. Many businesses have started to adapt to this culture and are a…
Working With Nested Table Oracle
1. Overview This document talks about the steps to working with Oracle nested tables.Nested table is awesome feature of Oracle. You can create table inside a ta…
Oracle AP Month End Close Request Set
1. Login to Oracle Enter User Name and Password and Click – Login SELECT System Administrator Responsibility and Press OK Button GO to Requests : Select -> Set…
Difference between AR and GL
User reported that they are getting differences in GL and AR for particular accounts. we noticed that the user is comparing with the custom reports like AR agei…
Error on updating customer taxpayer id
Proactively support team has identified an issue with duplicate party id. Support team has worked with oracle to get a fix for the same.01_sop-cm_ora_gdf_01-dat…
Difference between Oracle EBS R12.1.3 and Oracle EBS R12.2.4
We have recently upgraded Oracle EBS 12.1.3 to Oracle EBS R12.2.4. There are lot of differences. 1)In R12.2 we have to kind of filesystems fs1(run filesystem) a…
ORA-29702: error occurred in Cluster Group Service operation
While trying to login in oracle database, after that ORA-29702 error coming. $sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 10 10:29:23…
adop prepare phase failing with the error ![UNEXPECTED]Nodes are listed in the ADOP_VALID_NODES table but not in the FND_NODES table.
[applmgr@Doyen ~]$ adop phase=prepare Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing. Run…
DBA_HIST_SEG_STAT become invalid
Unpublished Base Bug 3603160 has been fixed in the patchset 10.2.0.3.0 For version 10.1.0.4 and version 10.1.0.5 oneoff patches exists for some platforms. Below…
Install oracle client via yum
CMD for Installation. yum -y -q install oracle-instantclient18.3-basic.x86_64.
ORA-00000: normal, successful completion
check correct hostname and ip on /etc/hosts fie or check environment variables.
expdp throwing ORA-04031 (stream pool) error
increase the memory_max_size to resolve.
Query to find ASM Error details.
Description: This script is used for finding ASM error details on ASM disk. script: select io.inst_id , dg.name diskgroup_name , io.disk_number , d.name disk_na…
query to find top sort segment usage.
Description: This query belongs to find the top sort segment usage on oracle. Script: col sid format 999999 col spid format a6 col tablespace format a10 col use…
Diagnostic test to validate the WORKFLOW NOTIFICATION MAILER – Java Mailer Setup
This diagnostic test will validate the WORKFLOW NOTIFICATION MAILER – Java Mailer Setup and do an initial data collection of frequently requested information. 1…
Here are the 10 amazing reasons to choose Oracle Cloud!
On-demand cloud computing services are gaining in popularity. Oracle Cloud supports technologies such as IoT, Machine Learning, AI, and human interfaces. Oracle…
Active database cloning from target to source – release 19c.
Creation of Duplicate database using the RMAN Starting from 11G you can proceed with the duplicate database in 2 ways – Active cloning and backup-based cloning.…
How to compile forms in Apps R12.1.3
Frmcmp compiler used to compile forms and library application in R12 Syntax: frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name…
Different Ways to select all check box in Report
1. Overview This document talks about there is a three-way to select All checkbox In Classic or Interactive Report using jQuery. 2. Technologies and Tools Used…
Incremental Search on Interactive Report and Interactive Grid
1. Overview This Document is used to implement Incremental search on Interactive report and Interactive grid 2. Technologies and Tools Used The following techno…
RESULT CACHE FUNCTION
1. Overview This Document is about to store the function result into the server result cache. 2. Technologies and Tools Used The following technologies have bee…
Validate Duplicate Values In the Interactive Grid Using JavaScript
1. Overview This blog talks about finding duplicate values in the Interactive Grid using JavaScript. 2. Technologies and Tools Used The following technologies h…
Check out the 11 new “Always Free Services” from Oracle Cloud Infrastructure
Are you excited to learn more about “Always Free Services” from Oracle Cloud Infrastructure? Come, let’s discuss these efficient and amazing free services to Or…
GI RU stuck with error “Unable to lock Central Inventory”
GI Release Update 19.9.0.0.201020″(31750108) patch on GI Home of one of servers. I used opatchauto utility to apply this patch. Following command was run for th…
Oracle APEX: The Secret Sauce Delivering Business Value
The webinar started with a welcome note by Pritam Jaipuriar, Head of Sales, Doyensys, depicting the objective of the whole webinar session. The webinar is about…
Find the Invalid Email Address using Oracle SQL and PL/SQL
Objective: To find the validity of the email address using Oracle Pl/sql and to find the invalid email address from a object like table using Oracle Sql. Using…
Recover a dropped table
Recover a dropped table in Oracle 11g Steps to recover a dropped table in Oracle 11g when flashback mode is off After dropping table and before restoring it fro…
Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation
While trying to open one pluggable database, I got the following errors: Background: While installing Apex 20.1 in one PDB, and while being very close to the in…
How to Modify an Oracle Database Windows Service?
How we can change some parameters for one database winodws service. Background: I have a database called PROD with version 19.3, running on Windows. Its…
OPatch error : “Unable to lock Central Inventory”
While applying Patch 31210848 “Microsoft Windows 32-Bit & x86-64 Bundle Patch 12.2.0.1.200714” on database 12.2.0.1on Windows platform I got the following error…
EBS 12.2 Upgrade Readiness Checker Tool – Database Tier (EURC-DT)
Oracle is designing many brand new tools to help customers and to increase the productivity of Oracle E-Business Suite (EBS) DBAs. One such tool is EBS 12.2 Upg…
Refresh the Parent Page on Closing the Modal Dialog in Oracle APEX
Introduction: Refresh the Parent Page on Closing the Modal Dialog in Oracle APEX.. Cause of the issue: The User has a requirement to refresh the Parent Page Int…
Validating the Duplicate values using JavaScript in Oracle APEX
Introduction: To avoid duplicate values in Interactive Grid in Oracle APEX. Cause of the issue: In newly created APEX Page, there is user requirement to validat…
AR Customer Ledger with Unpaid Invoices
AR Customer Ledger with Unpaid Invoices SELECT arps.org_id, hou.NAME company, rctl.customer_trx_id, TO_CHAR (arps.trx_date, ‘MON-RRRR’) fiscal_year_month, arps.…
ORA – bootstrap Error
ORA-00704 bootstrap process failure After Upgrading ORACLE_HOME (from 11.1.0.7.0 to 12.1.0.2.0), I was started my database by using startup command, then got be…
ADJRIINITPASSWD.sql Failed
ADJRIINITPASSWD.sql Fails With An ORA-01031 Error: Error: Unable to execute statement < Begin ad_jar.get_jripasswords(:l_storepass, :l_keypass); End; > len = 63…
Why Oracle Apex deemed as a customer’s first choice in low-code app development?
Oracle Application Express (APEX) is a low-code web application platform that allows you to work with Oracle databases. Oracle APEX was referred to as HTML DB e…
How to Choose the Best Oracle Service Provider?
The future of databases is cloud-based. In the next few years, nearly all businesses will move to the cloud. If you are considering harnessing Oracle Database C…
Set Availability Status Using PLSQL
1. Overview This document will explains, how to disable the apex application during the release or it is under maintenance by using PLSQL. 2. Technologies and T…
FRM-92102 Errors when Accessing a Forms Module
When attempting to access E-Business Suite Forms on a cloned E-Business Suite instance the following error occurs: FRM-92102 A network Error has occurred. The F…
Sometimes the Formsapp.ear deployment fails on Application startup after applying Patches
Error while executing the perl script txkChkFormsDeployment.pl We have determined that you need to redeploy Forms (using txkChkFormsDeployment.pl). But could no…
ACFS FILE SYSTEM IN OCI
ACFS FILE SYSTEM IN OCI Oracle ASM Cluster File System (ACFS) is a general purpose cluster file system implemented as part of ASM. It can be used to store almos…
Life At Doyensys – Yeswanth R
We at Doyensys, believe in the fact that every employee possesses their own set of strength and efficiency. It is those values of our employees that has kept us…
Migrating a Normal disk group to flex disk group in ASM oracle cloud (19C)
Description: Flex Diskgroups are the new features in oracle 12c R2 for quotas, cloning and filegroups. Oracle ASM provides two-way mirroring by default for newl…
How Oracle Cloud Infrastructure influences AI-Powered Text Analysis?
Have you ever thought of getting a doubt and going to the library and a whole process of searching in between books and referring to the pages to clarify the do…
Preview an Image Before upload in Oracle Apex
Overview This document is about to preview an image before upload in oracle apex. Technologies and Tools Used The following technologies have been used to achie…
Excel Template in oracle Apex for Excel Upload Page using JavaScript and Oracle pl/sql
Objective: The Excel Upload Page in Oracle Apex Involves Excel Upload template design. Usually the templates will be stored in Shared Components Workspace File…
How to setup password less ssh login in linux server
How to setup password less ssh login in linux server SSH is an open-source and most trusted network protocol that is use to login to remote server. It is use to…
autoconfig failing – jtfictx.sh
ERROR: While running autoconfig i am getting below error, autoconfig failing – jtfictx.sh Solution: SQL> exec ctxsys.ctx_adm.set_parameter(‘file_access_role’, ‘…
Perl lib version v5.8.3 doesn’t match executable version v5.10.0
Error: Perl lib version v5.8.3 doesn’t match executable version v5.10.0 Solution: export ORACLE_HOME=/u01/oracle_home/db/tech_st/12.1.0.2 export PERL5LIB=$ORACL…
Useful query to get user id, responsibility id and application id in EBS.
Useful query to get user id, responsibility id and application id in EBS. To know about User Id use below Query:- SQL> select user_id from fnd_user where user_n…
How to enable or disable the event oracle.apps.icx.security.session.created
How to enable or disable the event oracle.apps.icx.security.session.created 1. Login to E-Business and navigate to Workflow Administrator Web Application…
Upload Blob Content without Page Submit
Overview This document talks about uploading Blob Content without Page Submit. This source code used in this document has been taken and modified from the follo…
Creating Customer in Oracle Fusion
creating-customer-in-oracle-fusion
AR Period Close Process and Open Close Accounting Periods in Oracle Fusion
This blog will describe about the AR period close process in Oracle Fusionar-period-close-process-and-open-close-accounting-periods-in-oracle-fusion
How to Create New Responsibility In Oracle apps R12 ?
Navigation: System Administrator ? Security ? Responsibility ? Define Enter the details Responsibility Name: IM CO AP Period End Application: Paya…
Vendor Delivery Details
The below query gives the Vendor delivery performance details with po approval TAT and delivery TAT. SELECTpo_number,vendor_name,po_creation_date,po_approved_da…
Payment process request technical details
Overview Under Funds disbursement page, users can submit Payment Process Requests (PPR) to generate payments. There is an option to submit a single Payment Proc…
List of Suppliers which have not made payments since 2 years
Introduction: AP-query to get List of Suppliers which have not made payments since 2 years in Oracle EBS either invoice or payment. Query: select distinct a.ven…
Remove Junk Characters In Receipt Number
User was unable to apply the 6 receipt to the invoices for UK and they were getting the below error , “Error message: FRM-40654: Record has been updated .Requer…
Unable to apply invoice to receipt
business noticed that the receipt application is missing and the missed transaction level balance is not updated .. means transaction is not applied any receipt…
19c Performing a Oracle Data Guard Manual Switchover
Enviroment Details Primary Standby DB SID INDIA INDIA DB ROLE Primary Physical Standby DB Unique Name INDIA CHINA Server IP 192.168.25.159 192.168.25.158 DB Ver…
To Set Dynamically Normal/Dialogue Page Title in Oracle Apex
1. Overview This document explains how to set dialogue page title dynamically. 2. Technologies and Tools Used The following technologies have been used to set p…
GST Query for Payables
GST Query for Payables SELECT jeh.period_name period_name, gll.NAME ledger_name, a.concatenated_segments accounting_string, jeh.doc_sequence_value doc_nu…
UTL file for AR invoice Outbound to EBS
UTL file for AR invoice Outbound to EBS CREATE OR REPLACE PROCEDURE APPS.xx_mintifi_sales_inv_ext ( p_from_date IN DATE, p_to_date IN DATE, p_org_…
Ways Retailers Can Turn the Pandemic into Opportunities
Businesses around the world are facing a lot of disruptions due to Covid-19. Every industry is somehow affected by the pandemic, and retail is no different. Eve…
TERMINATE THE CONCURRENT PROGRAMS WHILE STUCKED IN A OPP (Output Post Processor) in R12.1.3
1.Find which programs are stucked in OPP using below query. set lines 200; set pages 300; SELECT a.request_id, substr(e.user_concurrent_program_name,1,80) Progr…
Set Dynamic Title for Modal Dialogue
1. Overview This document talks about the example of changing modal dialogue title dynamically using JavaScript. 2. Technologies and Tools Used The following te…
Oracle Announces Inter-Region Latency Dashboard
Oracle has announced the availability of the inter-region latency dashboard for Oracle Cloud Infrastructure (OCI) to give the customers a view of performance me…
Network Visualizer For Oracle Cloud Infrastructure
Recently Oracle announced a network visualizer that makes a visual model of your Oracle virtual network. It is composed of virtual cloud networks (VCNs), subnet…
Oracle Apex Navigation – Warn on Unsaved Changes (5.1 Below Versions)
Introduction When the user entering some data into the form and for some reason ,clicks a button or tab that will automatically navigate away from the form with…
Oracle Apex – Text Field Customizations
Text Field Introduction to Text Field The Text field item will renders as an HTML Form Element. It defines as that what is entered into a text field shows up as…
Why a single and integrated Oracle HCM and ERP is the need of hour?
As the pandemic began last year, several organizations found themselves in a fix. At a time when health and well-being took precedence, work from home became th…
Doyensys Announces Monthly Awards
Doyensys thrives on a high-performance culture, and we believe that recognizing the outstanding work of our employees is a natural extension of it. Our monthly…
Oracle Apex – Disable Button After Click
1. Overview This document talks about how to stop the user to click a APEX page submit button more than once in Oracle APEX 2. Technologies and Tools Used The f…
Life At Doyensys – Velmurugan R
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 emplo…
Oracle Announces Cloud Lift Migration Service For Easy Migration To Cloud
Ask any enterprise who has tried moving their key workloads to the cloud, and they will tell you how complicated it can get. Apart from the technical challenges…
Applying Redhat patching
This is for applying redhat patches and after reboot the server login to the server sudo yum update -y sudo yum check -update | wc -l the count should be below…
Application went to Admin after configuration changes in weblogic 12c
1.When we have done any changes in SetDomainEnv.sh 2. We have to restart the servers to reflect the changes. 3. Some times after the restart of the servers the…
Change DB Alert Log metric on 13C:
Oracle Enterprise Manager database plugin version 12.1.0.4, there is a new metric “DB Alert Log” available. This metric replaces the existing “Alert Log” metric…
Resolve ORA-01111, ORA-01110, ORA-01157
Mailn reasons for a file being created as UNNAMED or MISSING in the standby database, including insufficient disk space on standby site (or) Improper parameter…
EM 13.2: opatch lsinventory Command Fails With Error “RawInventory gets a null Vector of one-off entries
1. Error Message:- I faced with that error message while I was trying to apply 13.2.0.0.0 patch [oracle@TESTOEM]$export ORACLE_HOME=/u01/app/oracle/product/agen…
Convert Oracle 12c database from Non-ASM to ASM (standalone)
Now from 12c database you can move/relocate datafiles ONLINE menaing users can still able to access the database and objects while the move/relocate is in proce…
ORA-02020: Too Many Database Links In Use
PROBLEM: While querying against a database link, got below error. select sysdate from dual@DBLINK * ERROR at line 1: ORA-02020: too many database links in use &…
Balance forward billing is enabled for this customer but disabled at the account site level” is raised when creating transactions for Balance Forward enabled customers
Symptoms: You have defined a setup for balance Forward billing, wherein you have: 1) Defined a Billing Cycle 2) Associated the Billing Cycle to a Payment Term 3…
Cannot close AR period due to one incomplete adjustment number showing on the subledger period close exception report.
Workaround You have to either Reject/Approve the Adjustment or change the GL Date to resolve all the adjustments prior to closing period. To remove adjustment f…
Unable to Void a Payment. The Void button on Payments workbench is greyed out
Solution: A. For payments that are cleared or reconciled in status: 1. In the Payments workbench click on Payment Overview. 2. In the Payments Overview window n…
STEPS TO INSTALL oci-cli TOOL FOR UPLOAD FILES TO ORACLE CLOUD INFRASTRICTURE.
PYTHON: If you’re using Oracle Linux 7, you can use yum to install the CLI. sudo yum install python36-oci-cli The CLI will be installed to the Python site packa…
SETTING A PROFILE FOR ENABLE DIAGNOSTICS OPTION TO A SPECIFIC USER IN R12
Below the steps for enable DIAGNOSTICS option to a specific user in R.12. 1.Login as a sysadmin user in front end. 2.In the EBS dashboard , choose SYSTEM ADMINI…
Opening Files from Server in Oracle Forms
Opening Files from Server in Oracle Forms. Introduction: Script to open the Pdf or Image files from Server in Oracle Forms. Cause of the issue: In Oracle Forms…
Dynamic Alert Message in Oracle Forms
Dynamic Alert Message in Oracle Forms. Introduction: The Alert Message need to be changed at run time based on the condition criteria. Cause of the issue: In Or…
API to Approve the POs
API to Approve the POs. Introduction: API to Approve the POs. Cause of the issue: In PO Migration from one unit to another unit, the old unit POs need to be app…
ORA-08104: this index object is being online built or rebuild
” ORA-08104: this index object 4357688 is being online built or rebuilt ” error in index Rebuild. Details of error are as follows. SQL> ALTER INDEX MSDBA.TEST_I…
How to Create Database Links in Oracle 12C
A database link allows you to reference objects in a remote database. Typically, the remote database will be another Oracle database, but it can be any ODBC com…
The All-New Oracle Cloud Infrastructure Flexible Network Load Balancer
Without load balancing, the cloud experience of end-users can crumble. It acts as the gateway between the users and the cloud infrastructure and is responsible…
The system has encountered an error while processing the request in R12.2
Error : The system has encountered an error while processing the request. Changes made: Single node environment and Cloning was done. Cause : Login to E-…
Script to delete concurrent program and the xml templates and data definitions
Begin fnd_program.delete_program(‘program short name’,’applicaton shot name’); fnd_program.delete_executable(‘program short name’,’applicaton shot name’); commi…
Query to list concurrent program name with Parameters
SELECT fcpl.user_concurrent_program_name , fcp.concurrent_program_name , par.column_seq_num , par.end_user_column_name , par.form_left_prompt prompt , par.enabl…
Query To Find Dependent Objects Of An Invalid Object
SELECT owner, object_type, object_name FROM dba_objects WHERE status = ‘INVALID’ AND object_name IN (SELECT referenced_name FROM dba_dependencies WHERE name = ‘…
GL Batches Query
SELECT jb.NAME, gh.period_name, gh.je_source, gh.je_category, gh.currency_code, gc.concatenated_segments, gl.entered_cr, gl.entered_dr, gl.accounted_cr, gl.acco…
unable to apply/unapply any receipt applications with the receipt.
User was unable to apply/unapply any receipt applications with this receipt.we had applied this data fix in Test Instance and the issue has been fixed.
How to Use Apex Collection
Overview Apex Collections (APEX_COLLECTION) is a package that comes with Oracle Apex and is one of the most important features that comes with Oracle APEX. Each…
Oracle unveils Next-Gen Autonomous Data Warehouse
In what can be seen as a significant step towards customer empowerment with regards to data, Oracle unveiled the next-generation update of Autonomous Data Wareh…
Goldengate Replication for a US-based Client
Goldengate is an Oracle product that allows organizations to replicate and transform data between databases. It synchronizes data in real-time and also works in…
Wingman Contest: Doyensys’ Ode to Women in Our Lives
Women play a central role in our lives, and for many of us, they are the essence of our beings. They wear multiple hats, and depending upon the situation, trans…
Could not initialize the Service Manager FNDSM__ Verify that has been registered for concurrent processing
Cause The issued was found to have been caused by the FND_NODES table having incorrect node entries (old node from the source instance) and that no Service Mana…
SQL Profiles & Baselines
To check SQL Profile : select NAME,SIGNATURE ,STATUS,FORCE_MATCHING from dba_sql_profiles; ENABLE/DISABLE/DROP EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE(‘coe_5273fz2c…
Scripts to identify performance related issues.
one script to Identify all performace issue related to sql query Set echo off set trimspool on set define on column filename new_val filename select to_char(sys…
Undo related queries
Undo Related Queries To check retention guarantee for undo tablespace select tablespace_name,status,contents,logging,retention from dba_tablespaces where tables…
Long running requests
Long running Concurrent Requests:- 1.How to Determine Which Manager Ran a Specific Concurrent Request? col USER_CONCURRENT_QUEUE_NAME for a100 select b.USER_CON…
How to add legal entity to bank account
How to add legal entity to bank account Solution: 1. Using below navigation, please check if Workflow background engine is up and running: System Administrator…
How to change read write the Permissions on Concurrent Log and Output Files
How to change read write the Permissions on Concurrent Log and Output Files Solution Add umask 002 in .bash_profile(Linux). And then bounce the services.
How to Handle the Expense Report Status ‘Pending System Administrator Action’
When an Expense Report has a status of ‘Pending System Administrator Action’ a notification has usually been sent to the System Administrator for action to be t…
Document payable was failed because of rejection level setting
When there is a genuine issue with a particular invoice in Payment Process Request(PPR), all other invoices are getting rejected with reason ‘Document payable w…
Generating and extracting XML using oracle SQL
1.Overview The definition of SQL/XML is driven in part by the SQLX Group. Oracle supports several SQL/XML features which are subject to change as the standard e…
RESULT CACHE FUNCTION
1. Overview This Document is about to store the function result into the server result cache. 2. Technologies and Tools Used The following technologies have bee…
Private Temporary Tables
1. Overview This document is about the new features in Oracle 18c is Private Temporary Tables. 2. Technologies and Tools Used The following technologies have be…
Global Temporary Tables
1. Overview This Document is about the data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. T…
Listagg of IR Column Break Report
This document is to display listagg of IR column break report. Technology and Tool Used : Oracle Apex Javascript Use Case : If a requirement arise from user to…
Download Latest Business Object Template
Recommended way to download latest templates from Fusion Application before using and loading the dat files in HCM. For Steps download and follow the below docu…
Diagnostic Tests for HCM Data Loader
HCM Data Loader Error Analysis Report The HCM Data Loader Error Analysis Report is a diagnostic test. It provides technical information that can help to resolve…
Key Points To Remember before loading Grade Work Structure in Fusion HCM
Things to remember before loading Grade.dat file 1. SourceSystemOwner should be defined in Oracle fusion Application System 2. Effective Start Date and Set Code…
Life At Doyensys – Nirmal Kumar V
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 emplo…
Display User Rating Icons Dynamically in Oracle APEX Report
1. Overview This document talks about how to Display User Rating Icons Dynamically in Oracle APEX Report. 2. Technologies and Tools Used The following technolog…
Dynamic Image Carousel Slider in Oracle APEX
1. Overview This document talks about how to do Dynamic Image Carousel Slider in Oracle APEX. 2. Technologies and Tools Used The following technologies has been…
Configuration of Bash_profile
Configuration of Bash_profile TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export ORACLE_SID=…
Enable/Disable IR Download button based on User Role
Overview By default, the IR region allows to either enable the Download button to all users or disable the Download button to all users. Suppose if there is a r…
What is an recursive sub-query factoring?
1. Overview This document talks about an example of a recursive subquery factoring clause. 2. Technologies and Tools Used The following technologies have been u…
How to split comma/colon separated string using Oracle APEX API
1. Overview This blog talks about an example of splitting any special character string to an apex collection table using apex API. 2. Technologies and Tools Use…
Integrating React Native with SQLite
1. Overview This document explains how to integrate React native with SQLite DB. 2. Technologies and Tools Used The following technologies and tools have been u…
Set Session State Value for APEX Application Item
1. Overview This blog talks about the setting session state value for application item using the JavaScript function in Oracle APEX. 2. Technologies and Tools U…
Set Session State Value for Oracle APEX Page Item
1. Overview This document talks about the setting session state value for page item using the JavaScript function in Oracle APEX. 2. Technologies and Tools Used…
Submission of Concurrent request from OAF
Consider a scenario like we need to submit a concurrent request when submit button in clicked. Code to submit concurrent request should be added in AM so that i…
Interactive Report Cell Highlight based on condition using Jquery Dynamically
This document is to give background color to cell or change font color of the cell from query using Jquery. Technology and Tool Used : o SQL o JQuery Use Case :…
Set Scroll to last saved location after page submit
This document is to set the scroll to last saved location. Technology and Tool Used : Oracle Apex Javascripts Use Case : If a requirement arise from user to set…
Change WEB Port on 12.2
Change WEB Port on 12.2 The steps to change the webport to 8000. Step-1:Start only Weblogic admin using adadminsrvctl.sh start on run file system Login to Enter…
Attributes for Finished Goods Item
Field Name Level Values User Item Type Master FINISHED GOOD Item Status Org Active Inventory Item Master Yes Stockable Org Yes Transactable Org Yes Reservable O…
When the Transactable Item Flag can be enabled
The Transactable Flag for an Item can be enabled only if the Item has Stockable Flag Enabled.
Returnable Flag for an Item
The Returnable Flag should be Enabled, If the Item is returnable after successfully completion of order.
High Water Mark management in Oracle Database
Description: Each table is made up of extents and each extent is made up of oracle blocks – a common block size is 8k. So you have a table with 10 extents (80K)…
Valueset maintaince in fusion
Value set maintenance
Oracle 12c-Step by Step Manual Data Guard Switchover
Oracle 12c-Step by Step Manual Data Guard Switchover Prepared by Ranesh Details Primary Side Standby Side Server Name Primary Pysical Standby DB Name Warangal M…
Roll Forward Physical Standby Database using RMAN incremental backup
Roll Forward Physical Standby Database using RMAN incremental backup Current_scn from primary database and standby database. PRIMARY [oracle@ranes…
Oracle 12c Physical Standby Database Creation using Rman
Oracle 12c Physical Standby Database Creation using Rman Prerequisites for standby built for primary side. Ø Configure network files for both side (Prima…
ROLLBACK—-Oracle Database Patch
ROLLBACK [oracle@ranesh 30886680]$ opatch apply Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved.…
EBS–12.1.1 Installation.
EBS Installation 12.1.1 Step- Edit Yum.repository and keep ol6_latest and ol6_addon ebabled=1 cd /etc/yum.repos.d yum install wget.x86_64 wget http://pub…
EBS UPGRADE –12.1.1 TO 12.1.3 —
[applmgr@ebs applmgr]$ sqlplus apps/apps—connect to applmgr and apps/apps SQL*Plus: Release 10.1.0.5.0 – Production on Tue Mar 31 22:35:56 2020 Copyright (c) 19…
Upgrade excel4wands apps from 5 to 21.1
Follow these steps to perform an upgrade. 1. Confirm that both the Excel4apps and Excel4apps Reports Wand applications have been registered on you system. a. Lo…
Up-grading 12c to 19c
Steps For Upgrading Oracle Database To 19c Using DBUA Database preinstall 19c 19c software install Pre-upgrade check Run the pre-upgrade fixup script Run utlrp.…
Kill inactive apex sessions in amazon RDS
set serveroutput on; begin for i in ( select sid, serial# from gv$session where status=’INACTIVE’ and type=’USER’ and program=’APEX Listener’ and last_call_et/6…
CLOUD EBS INSTALLTION
CLOUD EBS INSTALLTION login as: opc Authenticating with public key “rsa-key-………” from agent Last login: Thu Jan 07:59:41 2020 from 103.57……129 [root@document ~]…
Query to find to Soft Parse and Hard Parse Ratio
select ‘Soft Parses ‘ “Ratio” ,round( ((select sum(value) from v$sysstat where name = ‘parse count (total)’) – (select sum(value) from v$sysstat where name = ‘p…
Autoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh Error: adgentns.pl exiting with status 2
Autoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh Error: adgentns.pl exiting with status 2 /u01/apps/apps_st/appl/ad/12.0.0/bin/adgentns.p…
OPMNCTL startall Fails with “unexpected exit: status 4200”
While trying to start the opmnctl services in idm we are getting 4200 error code as below applmgr@*****:~ $ applmgr@*****:~ $ /*****/fmw/idm/instances/IDM_inst1…
Life At Doyensys – Uday Kumar Koneti
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 emplo…
Doyensys Steps Up the Game Once Again With a Global Leader in Energy and Process Automation Solutions
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 establish…
How Doyensys Reduced the Downtime of a Business-Critical Project?
Since 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 anchor…
Outbound Interface using PL/SQL
Outbound Interface using PL/SQL Follow the steps PLSQL Stored Procedure (utl_file Method) to design the Outbound Interface in Oracle Apps PROCEDURE XX_PA…
FBDI Upload Data from EBS
FBDI Upload Data from EBS supplier-invoice-mapping doyensys_ebs_fusion_integration_fbdi_v2
Steps to create BIP reports in oracle fusion
steps-for-creating-bip-reports-in-fusion Oracle Fusion has divided the Oracle Reporting system in 2 Parts. BIP (Business intelligence publisher) BIP :- BIP is t…
FBDI for Journals from EBS
The 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 Entit…
Workflow From Scratch
Download the Standard Workflow for creating a new workflow item type: To download the workflow file we can download using wfload or from Oracle Workflow…
Performance Tuning
Tip 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 wit…
PO Interface Based on Project ,Task, Expenditure Type
PO interface based on project, Task, Expenditure type Staging.sql CREATE TABLE APPS.XX_NEW_PO ( ROWNUMBER NUMBER, SUPPLIER_NUMBER VARCHAR2(30 BYTE…
Query to check if DMZ is enabled
Query 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’, ‘Unkno…
Query To Get Archive Log Apply Rate Speed of a Standby Database
Query To Get Archive Log Apply Rate Speed of a Standby Database set linesize 180 col Values for a70 col Recovery_start for a21 select to_char(START_TIME,…
Query to check user session statistics
Query to check user session statistics col pid format 9999 heading ‘PID’ col spid format a6 heading ‘SERVER|PID’ col sid format 9999 heading ‘SID’ col serial# f…
Globalization
Globalization The following are list of types under Globalization on the Shared Components page. Globalization Attributes Text Messages Translate Applica…
Application Logic
The application Logic is one of the module in Shared components,It consists of different types of features as below Application Definition Attributes Applicatio…
Sending Email Using UTL SMTP
1. Overview This document talks about the utl_smtp package is used to send e-mails from any database to a valid recipient/recipients with or without attachments…
Oracle Apex Custom Tool Tip for Report Columns
1. Overview This document talks about how to show the custom tooltip in report columns 2. Technologies and Tools Used The following technology has been used to…
Oracle Apex Flexible Region Plugin
1.Overview This Flexible Region Plugin can be used for various business requirements to see the data in multiple dimensions. The user can able to dynamically ch…
Oracle Apex Custom Tool Tip for Report Columns
1.Overview This document talks about how to show the custom tooltip in report columns 2.Technologies and Tools Used The following technology has been use…
Oracle Apex Custom Notifications
1.Overview This document talks about how to use the apex error notifications & to manage into custom error messages. 2.Technologies and Tools Used The following…
Download Blob Files Using PLSQL
1.Overview This document talks about the utl_smtp package is used to download the BLOB Files in Oracle apex reports 2.Technologies and Tools Used The following…
Metadata Script
1. Overview This document will be helpful to generate DDL scripts of objects using Oracle Plsql. 2. Technologies and Tools Used Oracle Plsql code. 3. Use…
Adding A Favicon To Apex
1.Overview This document talks about a Favicon (Favorite Icon), also known as a Shortcut Icon, Web site Icon, Tab Icon or Bookmark Icon, is a file containing on…
Connecting ASP.NET with Oracle Database
Overview: This document talks about how to connect ASP.NET project with Oracle Database. Technologies and Tools Used: The following technologies has been used t…
Caps Lock (On/Off) Indicator with JavaScript in Oracle APEX
Overview: This document talks about how to indicate a message for whether the Caps Lock is on or off while inserting a password in login page by using JavaScrip…
Single row view in Apex report
1. Overview This document will be helpful to change report from multi row view to single row view in IG report. 2. Technologies and Tools Used Javascript 3. Use…
How to Call Jasper Report in Oracle Apex Using JavaScript
Overview This document explains how to call Jasper report in Oracle Apex using JavaScript. Technologies and Tools Used The following technologies have been used…
Convert simple CSV and XML data to rows and columns
Overview The APEX_DATA_PARSER package allows you to easily convert simple CSV and XML formatted data into rows and columns from SQL. You must have APEX 19.1 or…
Auto-Hiding Navigation Menu & Expand navigation menu on mouse over in Oracle apex
Overview This document explains how to hide the left navigation menu on entry to the page in Oracle apex and expand navigation menu on mouse over. Technologies…
Steps to Avoid Hard Code in Error Message in Oracle
Overview As part of any application development, error / exception handling is a key process which make the application more interactive and provide a user frie…
Points to Consider before migrating Organization HDL file
Below is the sample HDL file for Organization.dat file METADATA|Organization|EffectiveStartDate|EffectiveEndDate|Name|ClassificationCode|LocationCode(SourceSyst…
Customizing alert box and blur background
1. Overview This document talks about how to customize the alert box and blur the background screen. 2. Technologies and Tools Used The following technol…
Interactive Grid Validations
1. Overview This document talks about how to validate interactive grid columns dynamically using JavaScript. 2. Technologies and Tools Used The following…
Dynamic Column Label Without Page Submit in Oracle Apex
This document is to set dynamic name to columns without submitting the page. Technology and Tool Used : Oracle Apex Javascripts Use Case : If a requirement aris…
SQL for Inactive Customer Open balance
SQL for Inactive Customer Open balance select * from apps.ap_expense_report_headers_all where report_header_id = ”; select * from hz_cust_accounts where account…
SQL to Extract Chart Of Accounts Mapping Records
SQL to Extract Chart Of Accounts Mapping Records- SELECT DISTINCT GL_FV.flex_value source_flex_value, CFH.parent_flex_value, CFH.child_flex_value_low, CFH.child…
SQL for Customer Accounts with PO and Bill To Location
SQL for Customer Accounts with PO and Bill To Location SELECT hcsa.LOCATION, hca.account_number ,oeh.order_number,oeh.cust_po_number FROM apps.hz_cust_si…
SQL for Customer Account with Price List
SQL for Customer Account with Price List select hca.account_number ,hp.party_name , hps.party_site_number –,hl.city –,hl.state ,qplh.name price_list_name ,trim(…
SQL For Period Close Status snapshot for All Ledgers with All Subledgers
SQL For Period Close Status snapshot for All Ledgers with All Subledgers. SELECT (SELECT sob.NAME FROM apps.gl_sets_of_books sob WHERE sob.set_of_books_id = a.s…
Points to Consider before Loading Location HDL file in HCM
Here below is the format of the Location HDL file. METADATA|Location|SetCode|ActiveStatus|EffectiveStartDate|EffectiveEndDate|ShipToSiteFlag|BillToSiteFlag|Offi…
Steps to start admin server on patch file system in r12.2
To start admin server on patch environment forcepatchfs option should be used as below. Source environment $. /data01/fs1/EBSapps/appl/APPS_Jay1.env cd $ADMIN_S…
PCITI Annual Award Celebration at Doyensys, 2020-2021
PCITI Annual Award Celebration at Doyensys recognizes employees who demonstrate exemplary behavior of our values. Doyensys stands by its core values that have h…
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…
Troubleshooting 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 co…
Understanding 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 Fil…
Alternate 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 li…
QUERY 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 ————…
MANAGING 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…
Announcing 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…
ORA-1653: unable to extend table SYS.AUD$ by 5314958 in tablespace SYSTEM
Issue: DB reported slowness with the following error in DB ORA-1653: unable to extend table SYS.AUD$ by 5314958 in tablespace SYSTEMORA-1653: unable to extend t…
Key points to look about TDE Wallet on Bare metel during backup failure.
Database backups fail if the TDE wallet is not in the proper state. The following scenarios can cause this problem If the database was started using SQL*Plus, a…
Timeout Error Encountered for pasteBinary.sh While Running “adop phase=fs_clone”
When adop phase=fs_clone throws below error : Enabling EBS_LOGON trigger Error while executing [filesystem]/fs2/inst/apps/[context_name]/appltmp/alter_ebs_logon…
Could not perform the Post Patch instructions of an ETCC recommended patch 26825525.. don’t worry !!
SPECIAL INSTRUCTION for formsapp.ear as part of 10.1.2 forms component in R12 : To complete the application of Patch, please follow these instructions for Appli…
Cloning With Adcfgclone.pl Fails While Creating New WLS Domain On Target
When attempting to run adcfgclone.pl, the following error occurs : ApplyAppsTier<<date>>.log shows: START: Creating new WLS domain. Running /U01/app/applmgr/UAT…
adop prepare phase failed while running Autoconfig due to ADOP_VALID_NODES
ADOP Prepare phase failed with below error while running autoconfig on Patch Edition. Error: ERROR at line 1: ORA-20001: Synonym does not point to an editioning…
[ERROR] ETCC not run in the database node
12.2 adop cleanup fails with the following error : ERROR : ———————– Validating system setup. Node registry is valid. [ERROR] ETCC not run in the database node T…
EBS R12 login console blank Page – no Error messages
When we get a blank page after we enter the credentials and it doesn’t show any error or message on the page Please check the OAcore’s application.log and if th…
SQL QUERY TO FIND THE CUSTOM FORMS , FORM PERSONALIZATION AND CUSTOMIZED CONCURRENT PROGRAMS
custom forms: select COUNT(*) from apps.fnd_form_vl where form_name like ‘XX%’ custom form personalization: SELECT ffcr.form_name, ffft.user_function_name “User…
ORDS (Oracle Rest Data Service) Installation for Standalone Database
MAKE DIRECTORY: mkdir /u01/ords cd /u01/ords unzip ords.3.0.9.348.07.16.zip sqlplus / as sysdba select value from v$parameter where name like ‘%service_name%’;…
Find the list of Patches from a Merged Patch
SQL> SELECT applied_patch_id, patch_name, patch_type,LAST_UPDATE_DATE from applsys.ad_applied_patches where PATCH_NAME=’1809065289′; APPLIED_PATCH_ID PATCH_NAME…
Autoconfig Pre-requisites after cloning in R12.2
These steps are used to avoid the autoconfig phas error in R12.2 Steps:login as applsys user conn applsys/*********** Backup the following Tables. create table…
ORA-01017: invalid username/password; logon denied
ORA-01017: invalid username/password; logon denied ERROR: ORA-01017: invalid username/password; logon denied First of all you need to edit your sq…
Alert log monitor from a table not from ‘alert.log’ file.
Description: This script mainly used for monitoring database alert log from a table. Instead of login in the Unix and start doing vi and tail to see the content…
Script to monitor database size Growth in day/week/month/year wise.
Description : This script is very useful for calculate and report to database growth in day/week/month/year wise. Script: SELECT (select min(creation_time) from…
Oracle Database 18c new features
Oracle Database 18c new features Versions 18.1.0 18.2.0 18.3.0 General Features in 18C we can configure ORACLE_HOME in read-only mode. we can CANCEL any…
ORA-10458 ,ORA-01196,ORA-01110
FAILURE IN PRIMARY DATABASE: ORA-10458: standby database requires recovery ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: d…
rpmdb: Thread/process 4330/140521027696384 failed: Thread died in Berkeley DB library
Error: rpmdb: Thread/process 4330/140521027696384 failed: Thread died in Berkeley DB library YUM FAILED [root@ranesh yum.repos.d]# yum update rpmdb: Thread/proc…
adstrtal.sh: Database connection could not be established
adstrtal.sh: Database connection could not be established [applmgr@ranesh scripts]$ sh adstrtal.sh apps/oracle You are running adstrtal.sh version 120.24.120200…
How to change apps& sysadmin password in R12.2
How to change apps& sysadmin password in R12.2 Important Note: These steps must be carried out on the run file system. Step 1. Shut down the application tier se…
Find Application URL From Database and Context File in Oracle App R12.2
Find Application URL From Database and Context File in Oracle App R12.2 solution 1: SQL> select home_url from icx_parameters; HOME_URL ——————————————————…
Error: libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory
Error: libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory [root@ebs ~]# Exception in thread “main” java.lang.UnsatisfiedLinkErr…
War file not getting deployed in JBoss
Its look like newly copied war may not inheritable permission, add permission and check
JBoss 7 admin console stuck at loading
While starting standlone.bat add hostname of server or IP standalone.bat -b 192.168.0.1 or hostname
JBAS015899: JBoss AS 7.1.1.Final “Brontes” starting
Java 8 wasn’t compatible with JBoss AS7 so I prefered to upgrade the JBoss version rather than downgrade the Java version
WebLogic Server 12.2 EM and Console Slow Response
Remove the below parameter in startup script -Dweblogic.UseEnhancedIncrementAdvisor=false
Node Manager associated with machine Admin server is not reachable
1)Check if Machine is configured in console against Node where Managed Server is running. 2) Check Node Manager IP and port number configured for that Machine.…
How to take thread dumb in JVM
1)Verify java installed. 2) find the required process of PID sing below command can take thread dumb. jstack -l <pid> >> threaddumps.log &n…
Unable to delete the BPA, which is in “Incomplete status”
Issue Description: Unable to delete the Blanket Purchase Agreement whose header details created. However, no line details are created. Error Message: This actio…
Fixed Assets Invoice Cancel SQL script
Overview: This query is use to extract fixed assets invoices which is cancelled in Oracle Application R12. SELECT hou.name Org_Name, xep.name Entity, asp.segmen…
Script To Cancel Or Delete Work Confirmation In Oracle Apps R12
Overview: This Datafix script is used to delete the work confirmation and the associated receipt data. In this script it will reduce the amount/quantity deliver…
API to Update Supplier Payment Terms
We will be discuss about the api to update vendor payment terms update in ap_suppliers. This is the standard API to update vendor details in ap_suppliers. =====…
Supplier Deactivate through API
This document explain how to deactivate supplier through API. SET serveroutput on; DECLARE p_api_version NUMBER; p_init_msg_list VARCHAR2(200); p_commit VARCHAR…
Script to update the recoverable Tax
Script to update the recoverable Tax Introduction: Script to update the recoverable Tax. Cause of the issue: In PO Migration from one unit to another unit, the…
Script to update the PO Attachment from Back End
Script to update the PO Attachment from Back End Introduction: Script to update the Purchase Order Attachment from the back end. Cause of the issue: The Purchas…
Submit PO Output for Communication Report from Back end
Submit PO Output for Communication from Back end Introduction: Script to Submit the PO Output for Communication Report from the back end. Cause of the issue: In…
Query to find the Onhand Qty Stock Details for Non-Serial Items
Script to Extract the Onhand Qty Details for Non-Serial Items Introduction: Script to Extract the Onhand Qty Details for Non-Serial Items. Cause of the issue: I…
API to Update the Terms and Condition in PO
API to update the terms and Condition details in PO from back end Introduction: API to update the terms and Condition details in PO from back end. Cause of the…
Credit check Functionality in EBS
credit-check-process credit-check-process
Analysis of Customer wise Items count of sales orders based on period
This query is to analyse the type of items that a customer is buying in specific period through out his orders. In the below example we have taken only the drop…
Using pivot option in sql and naming aliases
This is a simple SQL Query used to show how the pivot option is used. Here in this example the columns JAN, FEB and MAR would be having single quotes and the ot…
CONTEXT FILE PARAMETERS TO BE CHANGED FOR SSL(HTTPS) IN R12.2
Stop the application services. 2. Take backup of the context file 3. Run Autoconfig. 4. Start the Application services. 5. Evaluate the Instance is working as d…
Autconfig Takes a Very Long Time To Run “adupdlobs.pl”
When running autoconfig during adcfgclone.pl the adupdlobs.pl taken more than 30 min but it not completed. Also please use the below script to validate. SELECT…
getting ebs R12.2 web logic url from os level
This os level command used to get the oracle EBS R12.2 web logic url. echo “http://”$(cat $CONTEXT_FILE | grep s_webhost | cut -d ‘>’ -f2 | cut -d ‘<‘ -f1)”.”$(…
How to get PO Amendment details for Revised PO’s
This query will extract the PO amendment details for the revised PO’s SELECT po_number, po_date, approved_date, buyer_name, revision_number,po_header_descriptio…
On-Hand Quantity with Serial Number and Locator details
The query gives the onhand quantity details with serial number and locator details select ohd.item,ohd.item_desc,ohd.org_code,ohd.org_name,ohd.sub_inventory,ohd…
Sales Order Dispatch Details – Query
The query provides the item dispatch details information of the sales order SELECToola.line_number,oola.line_id,ooha.orig_sys_document_ref ,ooha.order_source_id…
Finished Good – BOM (Bill Of Materials) explode for all levels
This package will explode BOM details at all levels of a Finished Good and write the data to a file in the Directory CREATE OR REPLACE PACKAGE XX_FINISHED_GOOD_…
Query to fetch Level-1 BOM Details for an Inventory Item
SELECT msi.segment1 “Parent material coding”,msi.inventory_item_id,msi.description “Parent item description”,msi1.segment1 “Sub item code”,msi1.inventory_item_i…
Query for Payments on Hold
The below is the query to get all the payments on hold for a particular operating unit. SELECTpo.comments po_notes,pf1.full_name buyer,ah.hold_flag paymnet_hold…
Query for AP Invoices on Hold
The below is the query to get all the invoices on hold for a particular operating unit. SELECTpo.comments po_notes,pf1.full_name buyer,ah.hold_date,ah.hold_look…
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option in Oracle 12C
Details of error are as follows. ALTER INDEX MSDBA.TEST_INDEX DISABLE Error at line 1 ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option OR…
FULL TABLE SCAN VS INDEX SCAN PERFORMACE in Oracle 12C
Let’s take the employees database, and slightly modify the employees tables: mysql> ALTER TABLE employees ADD INDEX idx_first (first_name),…
How to Add and drop Disks to ASM Disk Group in Oracle 12C
I will explain How to Add Disks to ASM Disk Group in Oracle with ALTER DISKGROUP DATA ADD DISK Command in this post. You can add disks to ASM Disk group as foll…
How to Use TABLE_EXISTS_ACTION During IMPDP in Oracle Datapump
I will explain How to Use TABLE_EXISTS_ACTION During IMPDP in Oracle Datapump in this post. Table_exists_action: While Import process is running if any table ex…
configure disk devices using Oracle ASMLIB in Oracle 12C
To manage Oracle database’s storage, Oracle recommends The Automatic Storage Management (ASM) to be used regardless of database’s configuration: single-instance…
How to Use CONTENT ( DATA_ONLY , METADATA_ONLY ) Parameter in Oracle Datapump
I will explain How to Use CONTENT ( DATA_ONLY , METADATA_ONLY ) Parameter in Oracle Datapump CONTENT: This parameter enables you to filter what is export…
How to Flashback Database to Guaranteed Restore Point on Oracle 12C
Flashback must be turned on in order to be able to use Guaranteed Restore Point. To enable Flashback, we need to use the FRA parameter like following. SQL> show…
RECOVER DATAFILE: ORA-01157: cannot identify/lock data file %s – see DBWR trace file
Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohib…
Rman Performance of Block change Tracking in Oracle 12c
Block Change Tracking : * Block Change Tracking Feature is used to speed up the RMAN incremental backup. *After Enabling this feature the records…
Flashback Data Archive in Oracle 12C
Flashback Data Archive feature is very much loved by Oracle DBA’s and it is come with Oracle 11g. The purpose of Flashback Data Archive is to store all DML and…
How to check Stuck Threads in logs
At the time of stuck threads we will get alerts we can see the servers are in warning state at the the time we can login to the particular warning server grep -…
Supported Yum install for VNC setup
vncserver yum install vnc* service iptables stop chkconfig iptables off setenforce 0 yum install gnome* yum install gnome-desktop* yum install kde-desktop* yum…
How import customized program to Linux application from Window.
How import customized program to Linux application from Window. Step1 – Download Win SCP tool from Google. ‘ You will get output as per below. Left side is Desk…
How to rectify the error – Ora 150(This error occur due to abnormal shutdown on application).
Error facing – While facing the 150 error(This error occur due to abnormal shutdown on application). Please stop the application with sh ADSTPALL.sh and use bel…
How to Start the Application in EBS
How start the Application in EBS? Step 1- Go into oracle log-in In EBS you will get the ENV file with default installation and you need to go with that E…
How to connect Developing tool Toad from oracle.
How to connect Developing tool Toad from oracle. Once installation is completed and EBS comes into the front End. Through the TNS number we can connect the Deve…
Steps for Partition of SDA
Step 1 [root@subash ~]# df -h Filesystem Size Used Avail Use% Mounted on devtmpfs 5.4G 0 5.4G 0% /dev tmpfs 5.4G 0 5.4G 0% /dev/shm tmpfs 5.4G 13M 5.4G 1% /run…
How to access SQL Development tool in oracle
To access SQLDevelopment in oracle Cd $ORACLE_HOME [oracle@subhash1 db_1]$ ls –lrt [oracle@subhash1 db_1]$ cd sql [oracle@subhash1 db_1]$ cd sqldeveloper/ [orac…
Connecting network to the client side
How to connect network in client Side Step 1> From source side : Check the hostname, Network id, Port number. Step 2> Ping the network id – Ping 192.168.1.25 St…
Life At Doyensys – Kishore Kumar R
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 emplo…
Segregation of Duties: A Tool by Doyensys to Ensure Compliance
Segregation of Duties (SOD) is a concept that advocates the division of responsibilities within organizations. It is enforced by the Sarbanes Oxley Act (SOX) Ac…
ADOP Failed with Fatal Error
Issue : The form encounters a fatal error: “Form: APXINWKB FRM-30085: Unable to adjust form for output.” The messages is usually associated with a compile warni…
How to access HTTPS/SSL URL via utl_http using the orapki wallet command
How to access HTTPS/SSL URL via utl_http using the orapki wallet command Goal: Our goal is to call/access the HTTPS/SSL url from within PL/SQL The instruction p…
Install and Configure Oracle APEX with ORDS and Apache Tomcat
Install and Configure Oracle APEX with ORDS and Apache Tomcat Introduction: In this post, we will discuss about the step by step procedure to install Oracle App…
DATAGUARD MONITORING
DATAGUARD MONITORING ==================== Check DB role(PRIMARY/STANDBY): ================================ SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_M…
RMAN Issues and Solutions – (ORA-00020) and (ORA-00245)
RMAN Issues and Solutions – (ORA-00020) and (ORA-00245) Error-1: RMAN failed to connect target database with ORA-00020: maximum number of processes (150)…
Untitled
Oracle Flashback Query allows us to view and repair historical data. We can perform queries on the database as of a certain time or specified system change numb…
Oracle Partitioned Index
There are two types of partitioned Indexes in Oracle Local Partitioned Index and Global Partitioned Index a. Local Partitioned Indexes Local index is a separate…
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 t…
Creating Bank account,receipt method
md120_greece_bank_account-_-creation-2
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/”…
SIPEC – 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 po…
When 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 migrati…
Item 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=…
When 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. Howev…
Life 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 emplo…
Find 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.att…
AR 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…
AR 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 par…
Life At Doyensys – Jilani Basha Shaik
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 emplo…
ORA-20100: Error: FND_FILE failure. Unable to create file in the directory
Problem details: The Concurrent program is getting completed successfully, able to view output & logfile. But in the log file, it shows below error. Oracle erro…
Sales Order GST Tax Category Setup for Sales Order Transaction
Sales Order GST Tax Category Setup for Sales Order Transaction I will try to explain about Sales Order GST Tax SETUP using Oracle Financial for India and will d…
KIT Item Setup for Sales Order Transaction
KIT ITEM and BOM Setup for Sales Order Transaction. I will try to explain about KIT SETUP using Inventory & BOM and will do a simple Sales Order Transaction usi…
Security Rule setup in Oracle Fusion
security-rule-setup-in-fusion This post explains how to configure the security rule in Oracle cloud.
Module Wise Lookup Details in Fusion
select a.lookup_type Lookup_type_name,a.meaning Lookup_type_meaning,flv.lookup_code lookup_code_name,flv.meaning lookup_code_meaning, flv.description,flv.enable…
Life At doyensys – Mohammad Mehboob Alam
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 emplo…
Regional Display Selector Freezing In Oracle Apex
Regional Display Selector Freezing In Oracle Apex The Region Display Selector is a Region component that provides page-level navigation control for other…
Concurrent request receiving Could Not Lock Request when canceling
After submitting concurrent request, the phase of the request is RUNNING and never completing. When we search for the database session, it is not having any ses…
Creating a New GST Location and Supplier Site
md120__create-gst-location-and-supplier-site-for-odisha
Data Guard New Features in Oracle 18c and 19c
Data Guard New Features in Oracle 18c and 19c Data Guard Oracle Data Guard ensures high availability disaster recovery and data protection for enterprise data D…
New Features in Oracle Database 19c
General Multimodel partitioning with Hybrid partitioning allowing some partitions in the database and some as external partitions even in hdfs New ALTER SYSTEM…
IG column validation
1. Overview This document will be helpful to validate the Interactive Grid column values without editing the IG region. 2. Technologies and Tools Used The follo…
How to handle divisor is equal to zero error
While execution the query with arithmetic calculation exception will throw divisor is equal to zero error.In this situation we can use below logic. CREATE OR RE…
API to Assign Collector for the Customers
create or replace PACKAGE BODY XX_Ar_Collector_Assign_Pkg AS PROCEDURE update_collectors(errbuf OUT VARCHAR2, retcode OUT NUMBER, p_oracle_user_id VARCHAR2) IS…
When Doyensys Stepped up to Resolve the Business Challenges of a Billion Dollar Company
Doyensys is always up for new challenges and interesting projects that come our way. It is a belief that such opportunities give us a platform to demonstrate ou…
Call requisition import program back from back end
declare l_request_req_id NUMBER; begin BEGIN l_request_req_id := apps.fnd_request.submit_request (application => ‘PO’ –Application, , program => ‘REQIMPORT’ –Pr…
India Tax Insert script
CREATE OR REPLACE PROCEDURE_iso_gst_tax_prc (p_trx_number VARCHAR2) AS CURSOR c IS SELECT prla.requisition_header_id, prla.requisition_line_id, prla.source_orga…
Pipeline function to return Week Start Date and End Date
Pipeline function to return Week Start Date and End Date of a particular month based on inputs parameter Overview: This document talks about how to return Week…
Interactive Report Filter Query
1. Overview This document will be helpful to find the query in the IR report when the filter condition is applied dynamically. (Source code should be in SQL for…
Integrating APEX with Oracle E-Business Suite hosting in the same hostname
Follow the steps given below to call APEX application from EBS, Step 1: Create an Oracle Apex Application and go to Shared Components => Application Items, then…
Fade Out Alert Message In Oracle Apex
Fade Out Alert Message In Oracle Apex The fadeOut() method gradually changes the opacity, for selected elements, from visible to hidden (fading effect).…
Reasons for an AP invoice not selected in a Payment Batch
AP invoice should not be selected by any other PPR The payment schedule’s relevant date should be between the PPR’s Pay From and Pay Through dates. The r…
The Doyensys and TTK Healthcare Journey
TTK Healthcare is an established name in the Indian healthcare industry with a leading presence in consumer products, pharmaceuticals, bio-medical devices, food…
User Wise Menu, Responsibility, Function Extraction
SELECT men.* FROM( SELECT main_query.responsibility_name “Responsibility”, main_query.user_menu_name “Main Menu Name”, main_query.entry_sequence “Seq”, main_que…
PO Dumps Extraction
SELECT pov.segment1 supplier_number, povs.vendor_site_code supplier_site, pov.vendor_name supplier_name, poh.segment1 po_number, hrls.location_code ship_to_loca…
Tax Insert Function for IRISO
/*Tax*/ FUNCTION add_gst_tax_req (p_req_id NUMBER) RETURN VARCHAR2 AS CURSOR c IS /* SELECT prla.requisition_header_id, prla.requisition_line_id, prla.source_or…
Web ADI for Integrating PO using Code Combination Separator
By using batch mode and COA setups with separator defined in system custom Web ADI been developed in EBS application and integrated with custom template using P…
Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c
Data Guard Physical Standby Setup Using the Data Guard Broker in Oracle Database 18c Data Guard is the name for Oracle’s standby database solution, used for dis…
DBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c
DBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c The DBMS_JOB package has been deprecated since 12cR2. Oracle 19c takes the demise of the D…
To find Multiple Hash Plans for SQLID
This Query will provide much information about the multiple hash plans… select SQL_ID , PLAN_HASH_VALUE , sum(EXECUTIONS_DELTA) EXECUTIONS , sum(ROWS_PROCESSED_…
Oracle E-Business Suite R12 Applications Certification
Brief about exam: There were 75 Questions and 90 minutes(1 hour 30 minutes) was alloted to complete this exam. We can complete this exam within 1 hour 15 mins a…
ITIL v3 Preparation
Basic understanding: The Information Technology Infrastructure Library (ITIL) mainly deals with services, is a set of concepts and practices for Information Tec…
To Find Index Fragmentation and Usage
Find Index Fragmentation and Usage To Find Index Fragmentation ~~~~~~~~~~~~~~~~~~~~~~~~~~~ analyze index <index_name> validate structure; select round((del_lf_r…
Troubleshoot RMAN-06214 error
Troubleshoot RMAN-06214 error RMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If error still occurs, then try the below RMAN> CROSSCHECK COPY OF CONTROLF…
Fix for ORA-03113 end-of-file on communication channel
Fix for ORA-03113: end-of-file on communication channel Oracle Database Server 12c Here is how to fix ORA-03113: end-of-file on communication channel [oracle@ho…
On Hand Quantity Interface
CREATE OR REPLACE PACKAGE BODY APPS.XXWEBADI_MTL_ONHANDQTY_PKG AS PROCEDURE XXWEBADI_MTL_ONHAND_QTY_INS ( errbuff OUT VARCHAR2, retcode OUT NUMBER ) IS LV_BATCH…
IAS Cache initialization failed (Doc ID 1484840.1)
E-Business Suite Applications Technology Stack, HTTP / IAS Server related issues Users report cache initialization errors in OA Framework related pages. The oac…
mod_oc4j: Failed to find a failover oc4j process for session request for destination
Error Noticed in the log file $LOG_HOME/ora/10.1.3/Apache Solution: 1. Noticed the When we have started the Application Services the load average was 1. 2. When…
Oracle EBS-Blank Page Appslogin/AppsLocal Login Page in R12 – http 500 internal server error
Error : http 500 internal server error: java.lang.NoClassDefFoundError at oracle.apps.fnd.sso.AppsLoginRedirect.doGet(AppsLoginRedirect.java:623) at javax.servl…
adapcctl.sh exiting with status 150
adapcctl.sh: exiting with status 150 adapcctl.sh: exiting with status 150 After resolve adoafmctl.sh: exiting with status 204, when i try to start application t…
ORA-609-opiodr aborting process unknown ospid
ORA-609 : opiodr aborting process unknown ospid Solution: Increase the values for INBOUND_CONNECT_TIMEOUT at both listener and server side sqlnet.ora file as a…
ORA-20100 File o2127370.tmp creation failed
ORA-20100: ORA-20100: File o2127370.tmp creation failed. Concurrent request failed with the following error in log file. Error ——– ORA-20100: ORA-20100: File o2…
AutoConfig: Parallel Run Option on R12.1.1
AutoConfig: Parallel Run Option on R12.1.1 The “Parallel Run” feature enables AutoConfig to be executed simultaneously across multiple nodes of an Oracle E-Busi…
Difference between Oracle EBS R12.1.3 and Oracle EBS R12.2.4
We have recently upgraded Oracle EBS 12.1.3 to Oracle EBS R12.2.4. There are lot of differences. 1)In R12.2 we have to kind of filesystems fs1(run filesystem) a…
AP Invoice Attachments Extraction
select distinct aia.invoice_id, aia.Voucher_Number, d.file_name, d.url from fnd_attached_documents fad, ap_invoices_all aia, fnd_documents d where 1=1 and aia.i…
iStore Setup and Customization Tips
ISTORE SETUP CATALOG CREATION Go to the below responsibility:- iStore Administrator 1. Navigate to Catalog Tab to see Hierarchy. 2. Click Section image in Acces…
Oracle EBS R12 PO Receipt Inbound Interface with WEB ADI
PO Receipt WEB ADI Interface: This is a interface, in Oracle EBS using web ADI, push raw data in custom staging table and then custom program does all validatio…
Populating TDS Tax Category through Form Personalizations
Objective: Populate TDS Tax Category for multiple lines through the custom procedure for an invoice before doing the validation and at the time of Action button…
Recognizing Doyensys’ Corona Warriors
The ongoing pandemic and the following lockdown came upon us almost unexpectedly. It brought a transformative change in our lives. The world came to a grinding…
ORA-01153–solution
Want to enable flashback on DR but getting the error. Reason is because MRP process is running. So we stop MRP process and then try enabling flashback. After th…
displays all unusable indexes
SET VERIFY OFF LINESIZE 200 COLUMN owner FORMAT A30 COLUMN index_name FORMAT A30 COLUMN table_owner FORMAT A30 COLUMN table_name FORMAT A30 SELECT owner, index_…
Autoconfig Error: adgentns.pl exiting with status 2 after Clone/Refresh
Error: adgentns.pl exiting with status 2 [CVM Error Report] The following report lists errors encountered during CVM Phase /UATappl/apps/apps_st/appl/ad/12.0.0/…
Warning: VKTM detected a time drift in 11gR2
ALERT LOG: Warning: VKTM detected a time drift. Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details. Ca…
Chelsea man sentenced in Augusta machete attack
We pride ourselves on being a “judgment free” community. We promote a family-based experience to share life’s highs and lows together and be supportive of resid…
ORA-00214: control file version inconsistent
ORA-00214: control file version inconsistent Due to the power outage, one of my production database giving the following error. When I try to startup the databa…
Corrupted Redo log Files
Corrupted Redo log Files The unplanned power outage, my development database was not starting up because of Redo log files corrupted. Let’s have a look redo log…
How Doyensys helped a US-based Floral Retailer in its Business Growth
At Doyensys, we firmly believe that commitment and consistency in our services can make a substantial difference in the businesses of our clients. When a US-bas…
Petmate : A Success Story
Petmate is a leading and trusted pet care solutions firm based in the US. They started in 1959 with kennels and subsequently progressed into making collars, lea…
Important Data Guard Process
Remote File Server (RFS) Process: The RFS process runs on the standby database and is responsible for communication between the primary and the standby database…
DataGuard Issue – Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property Workaround: Check DG configuration: DGMGRL> show configuration Configuration…
APP-SQLAP-10771: Could not reserve record.
Error: APP-SQLAP-10771: Could not reserve record. Unable to pay the AP invoice in full, Got above error while performing the action –> pay in full Solution: Dat…
Some useful scripts – V1
Some useful fnd scripts which available in $FND_TOP/sql directory FNDATPRG.sql Purge audit trail tables before a given date FNDCPDC2.sql Delete a concurrent pro…
Enable trace at User Level by using this trigger
CREATE OR REPLACE TRIGGER “123456_TMP_LOGONTRIG” AFTER LOGON ON DATABASE begin if ora_login_user = ‘123456’ then execute immediate ‘Alter session set events ”10…
Claim Space from Table/User Level
select owner,table_name,blocks,num_rows,avg_row_len,round(((blocks*8/1024)),2)||’MB’ “TOTAL_SIZE”, round((num_rows*avg_row_len /1024/1024),2)||’Mb’ “ACTUAL_SIZE…
How to generate heap dump in weblogic using hprof
Using HPROF: You can use HPROF: Heap and CPU Profiling Agent. A complete dump of the current live objects in the heap can be obtained with: -java -agentlib:hpro…
How to find PID using port on windows.
netstat -a -n -o | find “port number”
How to change Oracle Database NLS DATE FORMAT
Here is the below statement. alter system set nls_date_format=’dd.mm.yyyy hh24:mi:ss’ scope=spfile
How to Run sql statements in all PDBS
Oracle catcon.pl program is used to run a SQL scripts or SQL statements in all PDBS . $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS/****A…
How to find last modified table in oracle.
Here is the query below. set linesize 500; select TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, to_char(TIMESTAMP,’YYYY-MON-DD HH24:MI:SS’) from all_tab_m…
How to catch DDL statements oracle database.
CREATE TABLE AUDIT_DDL ( DDL_DATE date, OSUSER varchar2(255), CURRENT_USER varchar2(255), HOST varchar2(255), TERMINAL varchar2(255), IP_ADDRESS VARCHAR2(100),…
Upgrade Java plug-in (JRE) to the latest certified version
If you have already migrated to Java JRE with Oracle EBS 11i you may want to update EBS to the latest update from time to time. For example, if your EBS environ…
Apply Phase Options ABANDON and RESTART
Options ABANDON and RESTART adop phase=apply patches=12121212 abandon=yes Used to specify whether to restart the previous run of adop. May be useful if the prev…
command to check log file size more than 1 gb
find / -size +1G -mtime +180 -type f -print
command to check oracle users in linux
getent passwd | grep oracle getent passwd | grep dba
script-find-last-time-objects-analyzed-oracle
prompt ====================================== prompt ANALYZE – DATE – REGULAR TABLES prompt ====================================== col owner format a20 prompt s…
Script for check all the enabled auditing on Database
Script for check all the enabled auditing on Database –Check the parameter is enabled or disable for Audit select name || ‘=’ || value PARAMETER from sys.v_$par…
Query to check list of concurrent error
SELECT b.request_id, a.user_concurrent_program_name, b.phase_code AS completed, b.status_code AS error, u.user_name requestor, TO_CHAR (b.actual_start_date, ‘MM…
How to find Components version in R12
Apache Version $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v Go to reports path Then type: – string -a APXAPRVL.rdf|grep Header Perl Version $IAS_ORACLE_HO…
Displays Last Analyzed Details for a given Schema
— — Displays Last Analyzed Details for a given Schema. (All schema owners if ‘ALL’ specified). — SET PAUSE ON SET PAUSE ‘Press Return to Continue’ SET PA…
Java Web Start installation
Simply installing Java 1.5 from Sun is the easiest way to get the newest Java and Java Web Start. Windows: To get 1.5, go to the Java 1.5 website. Just go throu…
General Ledger Category Payroll Extract
Below is the query to extract Payroll data from General Ledger, historical data for a week. select gjl.je_line_num, gcc.concatenated_segments, nvl(gjl.entered_d…
Internal Requisition/ Internal Sales Order Integration
This integration will integrate IR/ISO based on upload file from APEX application that has been created as custom.Once file been uploaded lot based data based o…
Fusion Document Sequence
Fusion document sequence This document tells how to create a document sequence in Fusion and process setep’s
Expense Report Processing for Terminated Employee
Expense Report Processing for Terminated Employee To enter an Expense report for an employee, the employee has to be Active. The expense code look…
How to Process 1099 Invoices In Oracle EBS Applications
1099 Invoices Processing Every Year January the subject of 1099 processing shoots to the top of the priority list for many AP Managers. Remembering exactly what…
Oracle Employee Approval Signing Limits in Oracle EBS Applications
Oracle Employee Approval Signing Limits in Oracle EBS Applications There is no API and other Method To Enter Signing Limits Metalink Note (171837.1) The only op…
Oracle EBS – Tables involved in Procure to Pay Process
Tables Involved in P2P –Inventory select * from mtl_system_items_b msib where msib.segment1=’TEST’; select * from mtl_onhand_quantities_detail where inve…
Cash Management Tables in Oracle EBS
Cash Management base Tables CE_BANK_ACCOUNTS: CE_BANK_ACCOUNTS contains Legal Entity Level bank account information. Each bank account must be affiliated…
Tables Involved in Cash Management Reconciliation
Tables Involved CM Reconciliation Process 1) Run the program- Bank Statement Loader to load data in following Open Interface tables CE_STATEMENT_HEADERS_INT_ALL…
Expense Details Report
Aim: The below query is used to extract the Expense Details for the employees with the payment details, Current Approver, Status of the Expense Report, expense…
Key Tables involved in Order 2 Cash Process Flow
Tables involved in O2C Process in Oracle EBS –ORDER MAIN TABLES select flow_status_code, booked_flag, a.* from oe_order_headers_all a where order_number…
Account Analysis Drill Down Report
Aim: The below is the query for Account analysis drill down report for the Accural Account and it provides the detailed information with GL and PO Details in Or…
Post Ledger configuration validation
1 Validating Ledger Setups with script SELECT GLV.LEDGER_CATEGORY_CODE, GLV.NAME, GLV.SHORT_NAME, GLV.DESCRIPTION, GLV.CHART_OF_ACCOUNTS_ID, GLV.PERIOD_SET_NAME…
Inventory Aging Report 11i
Aim : The below is the query to get the Inventory Aging Report and the aging has been calculated with seven different bucket periods, with sub inventory details…
Query to get the details of Unpaid and Partially Paid Invoices
Below is the query to fetch the details of unpaid and partially invoices SELECT Ledger_name, po_number, ORDER_DATE, TRANSACTION_DATE, VENDOR_NAME, CATEGORY_SEG,…
India GST Register Report
Below is the query to get the GST applied for Invoices, Credit memos and Debit memos WITH Parameter AS (SELECT to_date(:P_Transaction_Start_Date,’YYYY/MM/DD HH2…
GL Drilldown Query
SELECT glcc.concatenated_segments segments, gjl.period_name, gjh.name journal_name, gjb.name batch_name, gjh.je_source journal_source, gjh.je_category journal_c…
Query for AP Matched Invoice Query
SELECT POV.VENDOR_NAME , AIA.INVOICE_TYPE_LOOKUP_CODE AS INVOICE_TYPE , AIA.INVOICE_NUM , AIA.INVOICE_DATE , AID.ACCOUNTING_DATE AS GL_DATE , AIA.INVOICE_CURREN…
AR Unearned Invoice Report query
SELECT customer, account_number, invoice_no, line_no, accounting_rule_name, functional_amount FROM ( SELECT replace(hp.party_name,’,’,’ ‘) customer, hca.account…
Ar Aging Bucket Report query
SELECT “Transaction Type Name”, party_name, party_site_number, “Payment Terms”, gl_date, due_date, total_days, CASE WHEN total_days > 0 THEN amt_due_remaining E…
User Provisioning from SSO to EBS is Failing after a Maintenance
Issue: SSO is unable to establish a connection to EBS as the APPS password is wrongly updated. —— Error: ——- [2015-11-25T11:45:23.966-05:00] [wls_ods2] [ERROR]…
Retry Errored Workflow Activities in Oracle EBS
You can retry all errored activities for the specific item type, or you can choose to retry only activities for a particular work item of that item type, activi…
OPP Fails To Pick Up Concurrent Requests With Error ‘Unable to find an Output Post Processor service to post-process request
CAUSE : ———- Incorrect data is present in the OPP queue table AQ$FND_CP_GSM_OPP_AQTBL_S, which occurs when the concurrent managers are not shutdown correctly. A…
Redolog Switch Rate by Date and Hour
set linesize 300; set pagesize 1000; spool rac_redo_switch_rate.log set heading off; select ‘******************************************************’ from dual;…
EBS User account unable to Autheticate in an SSO Integrated environment
Issue: —— In an EBS-SSO integrated environment – The user Account is active in EBS and the SSO account is provisioned, but still unable to authenticate from the…
Resending Failed Workflow Notifications
Check the status of WF Mailer : ———————————– SQL> select component_status from apps.fnd_svc_components where component_id = (select component_id from apps.fnd_s…
Netting Agreements Details Table
This is the table where all the netting agreement would be storing. Script: select agreement_name, agreement_id from apps.fun_net_agreements_all;
API to Check the AP invoice Accounting status
This API is used to check the Accounting status of AP invoices. Script: DECODE(apps.AP_INVOICES_PKG.GET_POSTING_STATUS( aia.invoice_id ), ‘P’, ‘Partial’,…
Query to Extract GST TAX Type Details Extraction
This Query is used to extract all the TAX Type that are available in the system, Especially used when Migrating the data and reporting purpose. Script: S…
Script to Find Lower Threshold Tax slab Vendors Registered Details
This Query is useful to fetch the vendor details that are having certificates for lower Tax Deduction rates or Exceptional Tax Deduction case vendors. Sc…
Query to Extract GSTIN Number
This applies to India localization. To Extract the GSTIN number and pan number attached to the vendors. Script: SELECT distinct jprl.registration_number jprl.se…
Supplier Site Update
This API is to update the supplier site level details. This would not applicable to ap_vendor_pub_pkg.update_vendor_site_public( p_api_version => 1, x_re…
Creating Dependent Parameter in Fusion BI Report
If you want to make any parameter dependent on other parameter in oracle fusion BI reports then below is the sample sql example provided while creating LOV for…
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-20001: Statistics Advisor: Invalid task name for the current user During the 12c database creation process , you can see ORA-20001 error in the alert log fi…
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired The error is raised when the following statement is executed against the Oracle Da…
ORA-16826: apply service state is inconsistent with the DelayMins property
ORA-16826: apply service state is inconsistent with the DelayMins property Workaround: Check DG configuration: DGMGRL> show configuration Configuration – new_DG…
To find the user process_id from EBS Front End R12
Navigate to System Administrator–> Security –> User –> Monitor Note the User Name and Oracle Process ID Now run this sql as &PID=Oracle Process ID &USER_NAME=Us…
UPGRADE ORACLE APEX FROM 5.0.X TO 18.1
Current Setup : Apex Version : Oracle Apex 5.0 Webserver : ORDS Running on Apache Tomcat 9 DB Version : Oracle 12.2 • Step 1: Download Apex 18.1 from Oracle Web…
After Upgrade to 12C utlrp got hang
We were performing database upgrade from oracle 11g to oracle 12c with Oracle Apps 12.1.3. We faced an issue where database upgrade took < 30 mins. However, it…
Query to get Requisition without PO
Introduction: This script will provide all Requisitions Details from backend for without Po’s. Script: SELECT (SELECT NVL (short_code, NAME) FROM apps.hr_operat…
Adcfgclone failing with Error: AFTER PASTEBINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2
Adcfgclone failing with Error: AFTER PASTE BINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2 Oracle Support notes: =================…
Steps to Implement Transparent Data Encryption(TDE) using fast offline conversion for Oracle Databases
Prerequisite: Make sure you have applied the patch 23315889(fast offline conversion patch) if you are on Oracle 11g Database or latest CPU patches are applied w…
DBCA Configure Database option is greyed out in Oracle
Database Configuration Assistant was not showing the database and Configure Database Options and it was greyed out(disabled). We tried setting up ORACLE_SID and…
Gather Schema Statistics – Program error with Locks and Duplicate columns
Oracle E-Business Suite Release 12 uses cost–based optimization in order to choose the most efficient execution plan for SQL statements.Gather Schema Statistics…
How to open Concurrent Out file in excel format
An *.out file is a compiled executable file created by various source code compilers in Unix-like operating systems, such as Linux and AIX. *.out files are most…
No Write Permission on ACFS Mount Point
I managed to create the ACFS Mount Point after resolving the issue “ACFS-9459: ASVM/ACFS is not supported on this os version”. But, after creating the ACFS Moun…
Concurrent request failed with the following error password verify function error
Issue : Concurrent request failed with the following error password verify function error Error: java.sql.SQLException: ORA-28001: the password has expired appl…
ADCFGCLONE fails in Autoconfig with gentns error in DB node
Issue: ADCFGCLONE fails in Autoconfig with gentns error in DB node. Error : StackTrace: java.lang.NullPointerException at oracle.apps.ad.tools.configuration.Dat…
ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ
ISSUE:XML reports complete in warning. Error: ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ ORA-06512: at “APPS.FND_CP_O…
Add Multiple user/Responsibility through backend
With the following we can add multiple user name and multiple responsibilities through backend. set define off; declare res_user_name varchar2(100); res_app_sn…
Forms memory consumption
The Following query is to get the memory consuming forms sessions. #!/bin/sh ALLPROCS=`ps -ef|grep “f60webmx webfile=” | grep -v grep | tr -s ” ” | cut -f3 -d”…
Mandatory checklist – post clone of EBS
The following query will give the values of some important parameters to be considered post clone. SELECT e.profile_option_name Profile, e.profile_option_id, f.…
To display all data for a particular block while opening the EBS form.
Overview Sometimes having a requirement to display all block data whenever form is open. In order to achieve please follow below step, Open Form builder> Open y…
Life At doyensys – Saravana Kumar KP
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 emplo…
How Doyensys Migrated a Client’s E-Business Suite to Cloud
As an organisation, Doyensys believes in pushing the boundaries and setting examples for others to follow. Our team of hard-working and talented Doyens is alway…
Query to find Custom objects , custom forms , custom form personalization , custom concurrent programs.
Description: Query to find Custom objects , custom forms , custom form personalization , custom concurrent programs. custom objects: ——————– select * from dba_o…
Check the Details of which scheduled jobs are finished with error.
Description: Check the Details of which scheduled jobs are finished with error in database level. Query: set head on; set feed off; set pages 0; set verify off;…
Backup oracle home and inventory
How to Backup ORACLE_HOME binaries and Oracle INVENTORY ORACLE_HOME and INVENTORY need to backup before Database / OS level patching Table of Contents _________…
ORA-29283: invalid file operation: path traverses a symlink [29433]
DB : Oracle 19.5 OS : RHEL 7 Expdp is failing due to the below error in my 19c database Export: Release 19.0.0.0.0 – Production on Thu Apr 30 06:06:42 2020 Vers…
UC: Time Drift Detected
Issue:- alert found into the alert logfile. Warning: VKTM detected a forward time drift. Time drifts can result in unexpected behavior such as time-outs. Please…
DBConsole service won’t start
The web-based Enterprise Manager tool was introduced in Oracle 10g and has significant functionality improvements over previous versions. How to solve an Enterp…
ORA-65259: partial synchronization of application is disallowed
ORA-65259: partial synchronization of application is disallowed You have started application Sync but you find it is taking more time to complete this action. B…
![DBCA fails with errors: [FATAL] [DBT-50000] Unable to check for available memory](/media/images/dbca-1-300x228.jpg)
DBCA fails with errors: [FATAL] [DBT-50000] Unable to check for available memory
DBCA fails with errors: [FATAL] [DBT-50000] Unable to check for available memory Recently I have installed Oracle 19c Database binary to windows machine. And af…
Cannot communicate with Cluster Ready Services
ISSUE:- [oracle@server1:+ASM1] sudo crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4535: Cannot communicate with Cluster Ready Servi…
Life At doyensys – Sethu Ponnambalam
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 emplo…
How to Format Corrupted Block Not Part of Any Segment
Step 1 – Identify corrupt datafile The corruption may be reported at the application level, such as DBV and RMAN, or the alert.log. Step 2 Run DBV/Rman validate…
Life At doyensys – Beena V Thomas
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 emplo…
Life At Doyensys – GOKULKUMAR TR
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 emplo…
Oracle Cloud launches OSOC for Enterprise Network Complexity
Oracle has launched its new Oracle SD-WAN Orchestration Cloud (OSOC) especially to simplify the enterprise network complexity through multi-cloud integration an…
Doyensys achieves the Gold Standard of Great Place to Work, yet again
In the recently held 50 Great Mid-size Places to Work Awards, Doyensys received recognition yet again. Winning in this category for two years in a row is no mea…
Oracle held its second Gen 2 cloud region in Hyderabad, India
In an effort to support the fast growing customer demand for enterprise cloud services in India, Oracle has launches its second cloud region in India at Hyderab…
QR Code Creator – Oracle Apex
QR Code Creator QR Code is defines that a machine-readable code consisting of an array of black and white squares, typically used for storing URLs or other info…
Top 10 Benefits of the Oracle Autonomous Database
In data management, Oracle is leading a major role and also now become a pioneer in the most important space of autonomous capabilities. Over 20 years, Oracle h…
Life At Doyensys – Prasanna P
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 emplo…
Life At Doyensys – Nikethan
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 emplo…
Employee Engagement during Lockdown
Engaging the employees and providing the right working environment to them is at the core of HR activities at Doyensys. Since its inception, the management was…
Life At Doyensys – Pushparaj
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 emplo…
How Doyensys supported the first-timers for a smooth transition to WFH
We, at Doyensys, recognized that everybody may not be attuned to working from home. In the first week of lockdown, we organized training sessions for our talent…
Life At Doyensys – Prakash Ramamurthy
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 emplo…
Features of Application Migration Services in OCI
Oracle Cloud has been growing tremendously and playing a vital role in the reduction of your CAPEX and OPEX by migrating any application to its state of the art…
Why Oracle JAVA 14 Brings Innovation and Predictability to Developers
On March 17, 2020, Oracle announced the availability of Java 14 as part of its endeavour to enhance innovation by delivering new enhancements to developers and…
24 hours – 24 speakers: Join Apex @ Home on 26th April
Anyone who has the slightest exposure to Oracle Apex will vouch for its power and convenience for developing some great-looking apps. It is a platform, which ru…
Administrating Oracle Clusterware Components.
Administrating Oracle Clusterware Components The Oracle Clusterware includes two important components: Voting disk and Oracle Cluster Registry (OCR), The voting…
Steps for Data guard Switch-over and Switchback in Oracle 12c Database.
Business continuity (Disaster Recovery) has become a very critical factor for every business. When implementing a DR solution there is always a primary and seco…
API Script to create Receipts in oracle receivables
Hi Team, This API script is useful in oracle receivables. Thi is useful to create oracle receipts in oracle for the customers that are paid for their invoices i…
API Script to load building properties in PN module
Hi Team, This script is useful in property management module in oracle. This is script to loading building properties for property management module in oracle t…
Script to change oracle Receivables customer name change
Hi Team, This is developed and tested in oracle successfully. This script is useful to change the customer name change in oracle receivables if the user created…
GETTING APPLICATION USER PASSWORD IN R12
Step 1 : CREATE OR REPLACE PACKAGE get_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2; END get_pwd; / Step 2 : CREATE OR REPLACE P…
RC-00110: FATAL: ERROR OCCURRED WHILE RELINKING OF APPLYDBTECHSTACK
RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack Problem: I faced the following error while cloning one of our recently upgraded EBS version…
Oracle cloud offers Data Science and Machine Learning Services
Oracle announced the availability of its Cloud Data Science Platform, which has new seven services, with OCI Data Science at the core that delivers a robust, sc…
Covid 19 – A Message from Co-Founder & President
Amidst the current scenario of COVID-19 pandemic, we would like to assure you that Doyensys is trying to do everything possible to continue to provide our servi…
Unknown fonts while installing oracle database
Unknown fonts while installing oracle database Cause ===== Missing dejavu-lgc-sans-fonts or dejavu rpm Solution ======== Install dejavu-lgc-sans-fonts and then…
How is Doyensys handling the COVID-19 crisis
In these trying times of coronavirus pandemic, Doyensys is leaving no stone unturned to ensure the safety of our employees. We are committed to our responsibili…
EBS VERSION 12.2.5 CLONE -Login Page Blank
After cloning EBS R12 successfully, when I am going to login EBS clone it did not show anything on the page. Login page is totally blank. I have restarted all t…
TO Assign Responsibility for the user in backend
DECLARE v_session_id INTEGER := userenv(‘sessionid’); v_user_name VARCHAR2(30) := upper(‘&Enter_User_Name’); BEGIN fnd_user_pkg.createuser(x_user_name => v_user…
To check Incompatibility between program
SELECT a2.application_name, a1.user_concurrent_program_name, DECODE (running_type, ‘P’, ‘Program’, ‘S’, ‘Request set’, ‘UNKNOWN’ ) “Type”, b2.application_name “…
Doyensys is committed to help the employees during these times of coronavirus pandemic
The coronavirus outbreak has changed life as we know it. From enforcing travel restrictions to advising work from home, the governments are taking this challeng…
API for Property Manager module lease load
Hi All, This API useful to load lease data into oracle Property Manager module in oracle apps .pm_lease_code_func
Query to find total by accounts in AR receivables
Hi All, This query useful to get all the total amount by accounts in AR receivables. This will be useful in audit purpose for an account validation oracle-recei…
API to apply Credit memo on AR invoice
Hi All, API to apply Credit memo on invoice will be useful whenever situation occur if we have created AR invoices wrongly in oracle. For that credit memo has t…
Create SOAP adapter Connection in OIC
1. When integrating services with Oracle Integration Cloud service the first thing you need to do is create a connection. Connections define how to connect to a…
Create REST adapter Connection in OIC
1. When integrating services with Oracle Integration Cloud service the first thing you need to do is create a connection. Connections define how to connect to a…
Query get AR Period Status Open or not
Hi This is query useful to find out any operating units receivables period open or not in oracle application. For user it is very useful to load to apply receip…
Create FTP adapter Connection in OIC
1. When integrating services with Oracle Integration Cloud service the first thing you need to do is create a connection. Connections define how to connect to a…
Create ERP adapter Connection in OIC
1. When integrating services with Oracle Integration Cloud service the first thing you need to do is create a connection. Connections define how to connect to a…
Create DB adapter Connection in OIC
When integrating services with Oracle Integration Cloud service the first thing you need to do is create a connection. Connections define how to connect to a sp…
Query to Get AR Invoice Balance Due Amount
this query useful to extract the Query_to_Get_ARInvoice_Balance_Due_Amount invoice details of balance due that was paid by customer query_to_get_invoice_balance…
Supplier Site Assignment Import Using FBDI – Fusion Applications
This blog describes the step by step process of Supplier Site Assignment migration in Fusion Application using File Based Data Import. Using this process we can…
LEAST PRIVILEGE AND SEPARATION OF DUTY
To support the principles of least privilege and separation of duty, the SYSOPER administrative privilege allows an administrator to perform limited tasks such…
Oracle Database Vault
The Oracle Database Vault security controls protect application data from unauthorized access and comply with privacy and regulatory requirements. We can deploy…
Object Storage vs Block Storage
Block storage is the oldest and simplest form of data storage. Block storage stores data in fixed-sized ‘blocks’. By itself, a block typically only houses a por…
VO Row Iterator in OAF
OAApplicationModule am = oapagecontext.getApplicationModule(oawebbean); OADBTransaction oadbtransaction = am.getOADBTransaction(); OAViewObject XXDraftASNLineEO…
Life At Doyensys – Rajan Chandru
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 emplo…
Life At Doyensys – Sasi Anandh NM
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 emplo…
How To Troubleshoot OID DIP Sync Mapping Problems
Consider the following scenarios: Scenario 1: DIP Import Sync from Active Directory (AD) to OID works for most entries, but fails when a new organizationalunit…
Admin Server Startup Issue in EBS (R12.2) Must Run On Primary Node
Issue: Error starting Admin Server When we are starting Admin Server, getting below error sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start logs: $EBS_DOMAIN_HOME/s…
Integrate Oracle ADF with Oracle E-Business Suite 12.2 ASCP Instance for SPWA – Supply Planning Work Area
What is Oracle ADF? Oracle Application Development Framework (Oracle ADF) is an end-to-end application framework that builds on Java EE standards and open-sourc…
RC-50204: Error: – Web Listener Port in use: Port Value = 8009
ERROR: RC-50204: Error: – Web Listener Port in use: Port Value = 8009 CAUSE: When cloning we have faced this error. This is due to some other process is using t…
How to START and STOP the TOMCAT Services
1.Start the Tomcat a.source the java path $ cat tomcat_java.env export JAVA_HOME=/rupdb01/oracle/tomcat/java71_64 export PATH=/rupdb01/oracle/tomcat/java71_64/j…
Convert physical standby to snapshot standby database
Snapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database. i. e we can convert the physical standby database…
Life At Doyensys – G.K.VENKATESH KUMAR
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 emplo…
SQL PROFILE IN ORACLE
SQL PROFILE IN ORACLE SQL profile is a collection of additional statistical information stored in the data dictionary that helps the optimizer to generate the b…
Creating sqlplan Baselines
Creating sqlplan Baselines Create sql tuning set ————————- begin DBMS_SQLTUNE.CREATE_SQLSET(SQLSET_NAME => ‘&&sql_id’, DESCRIPTION => ‘SQL TUNE SET2’); END; / —…
Oracle 11g Resize Redo Log Size on Data Guard and Primary Database
Current Status Of Redo Logs Primary Side SQL> select group#,sum(bytes/1024/1024)”Size in MB” from v$log group by group#; GROUP# Size in MB ——- ———- 1 750 2 750…
How Oracle Is Helping to Fight Against a Mosquito Borne Disease
Certain deadly diseases in the world don’t have any proper vaccination. One such disease is the mosquito-borne disease, Chikungunya. Chikungunya is a deadly dis…
Doyensys at Collaborate 2020
Update: Collaborate 2020 will not be occurring as scheduled on April 19-23, in light of the recent Coronavirus pandemic. We shall keep you posted about further…
Oracle Cloud Achieves New Milestone
Oracle Cloud joins the IO500, as per the announcement by Oracle. Andrew Reichman who is the senior director of Oracle Cloud’s product management reflected this…
Doyensys Receives the Award for The Best Workplace in IT and IT-BPM!
Doyensys received recognition for one of the best Mid-Size Indian workplaces in 2019 along with one of the best workplaces for women in 2019 from Great Place to…
Doyensys is now listed on Oracle Cloud Marketplace!
We are now happy to announce that Doyensys is now listed in Oracle Cloud Marketplace, an online marketplace committed to cloud business applications and profici…
Doyensys is all set to release a series of Six books that’ll help your organisation!
Doyensys has been working on a series of books that will help improve your organisations by providing solutions to simplify your way of handling things. These b…
[INFOGRAPHIC]How can oracle fusion applications support the growth of small and medium businesses
Oracle fusion applications have been conceptualised with a focus on small and medium enterprises. These set of applications prepare them to manage current chall…
Doyensys Papers Selected to be Presented at Sangam 2019!
Doyensys is happy to participate in Sangam, the largest Oracle users group conference, that will be held in Hyderabad on 6th – 7th December at Hyderabad Interna…
Doyensys participates in Sangam, the largest Oracle users group conference!
Doyensys is happy to participate in Sangam, largest Oracle users group conference, that will be held in Hyderabad from 6th – 7th December at Hyderabad Internati…
4 Database Innovations by Larry Ellison
“Just one more thing,” once said by the Oracle Chairman and the CTO Larry Ellison in the prestigious Oracle Open World. In the event, he has even announced that…
Oracle rolls out Analytics for Fusion ERP
Oracle Analytics Cloud is a secure public cloud service which provides a complete set of capabilities to perform and explore collaborative analytics for us, our…
Benefits of Oracle Fusion Applications
Oracle is currently the first name that comes to mind when we talk about DBMS (Database Management Systems). Not only that, it is right behind Microsoft in reve…
Oracle Open World 2019
The Oracle Open World event takes place annually, and it is the biggest symposium for all companies who use Oracle technology for application development and so…
Doyensys wins ‘Great place for women to work’ award!
Women have made remarkable progress in every aspect breaking the shackles of a patriarchal society and emerged victoriously. We, at Doyensys, give great importa…
Doyensys organises Selfie Competition!
Doyensys hosted a selfie competition recently as a part of our activity scheme encouraging Doyens to come together and develop a friendly workplace environment.…