Splitting of Shipment Lines
Splitting of order lines, this can be done during shipping last part of sales order, generally we come across this scenario, when we want to ship partial quantity when there…
Read MoreQuery to get inactive count as per machine name and sql id
Please use the below query. SELECT count(prev_sql_id),prev_sql_id,sql_text FROM v$session LEFT OUTER JOIN v$sql ON v$session.prev_sql_id = v$sql.sql_id WHERE status=’INACTIVE’ and machine like ‘%servername%’ HAVING COUNT(prev_sql_id)>5 GROUP BY prev_sql_id,sql_text…
Read MoreORA-07445: exception encountered: core dump [kggchk()+52] [SIGSEGV] [ADDR:0x444C5E6E0] [PC:0x117171614] [Application data integrity precise] [3]
Please find the below steps to resolve the same. ADI [Application Data Integrity] memory feature is enabled by default in Solaris SPARC Download and apply Patch 35464935. OR Set the…
Read MoreCVE-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 Critical SQL Injection Vulnerability). Fastly has…
Read MoreFastly – 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 files. 1. Instructions…
Read Morewhat 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 select from pseudocolumns, but you…
Read MoreDisplay OTBI analysis as Infolets in Fusion (SaaS)
Objective: To show OTBI analysis as a infolet in infolet section in a form of widget in springboard section in SaaS Home Screen. User getting the latest info in a…
Read MoreHow to connect ATP Database from SQL Developer
Objective: The intent of this content to show how to connect ATP Database from SQL Developer tool. To connect the ATP database we need wallet. Wallet file need to be…
Read MoreSQL DBA: Backups
Description: Copy of the database that is used to recover the data after the system failure. Backups are used as safeguards for databases because data may be lost due to…
Read MoreHow 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 oracle fusion platform. Cause of the issue:- In…
Read More