Solistech Solutions Blogs | Oracle Support

This blog contains the sql to fetch details of conc

SELECT distinct fcpt.user_concurrent_program_name , fcp.concurrent_program_name short_name , fat.application_name program_application_name ,

Splitting comma separated value strings into rows i

A delimiter-separated string can be converted to a set of rows in Oracle SQL, with the combination of the regex function REGEX_SUBSTR and recursion via CONNECT BY. Thi

Timecard Information Tables with queries in Oracle

Here are the queries that can be helpful

API To Delete whole time card for the week in OTL i

This script will delete a TIMECARD for e

API To Delete timecard Detail(row wise) in OTL

This script will delete a TIMECA

How To Clear The Cache Using Functional Administrat

Let‘s see how to clear the cache using a functional administrator. This functionalit

Steps to Bounce Apache server till R12.1

In this blog post, you will see the steps of bouncing the Apache server till R12.1We need to run t

How To Enable/Disable The Forms Personalization Men

See all the steps to enable/disable the forms personalization menu in this blog post.The “Personalize” menu is visible to all the users by default.

A Closer Look at the Types of AP invoice Holds

In our last blog, we saw what an AP Invoice Hold was. Today we will see the different types of Invoice holds which are placed fro

What is AP Invoice Holds and Invoice on Hold Report

AP Invoice Hold is a kind of Blockage placed on an invoice to prevent the Payment or the creation of Accounting entries for the concerned invoice. There ar

Empowering Your Business with Expertise and Reliabi

Unleash the Power of Continuous IT Support! Discover how we can assist you with Cloud Database Administration (DBA) to ensure seamless operations and optimize your clo

How to Find the Approval Limit for a Person While A

In this blog post, we will see how to find the Approval limit for the user in Purchasing for Requisition using SQL Query.

What are the Steps to Disable an Operating Unit?

In this blog post, we will see the Steps to Disable an operating unit. Disabling an working operating unit is not advisable as the operating unit name would be

How to Fetch Details of XML/BI Publisher Template a

In this blog post, we will see the SQL query to get details of XML/BI Publisher Template and Data Definition

How To Get Sales Order Number With SQL

In this blog post, we will see the SQL query to find the Sales Order Number from an Internal Requisition or Shipment Number. Find the Sales Order Number

How to check profile option value using SQL query

In this blog post, we take look at the SQL queries to fetch profile option values of a profile option at site, applicati

How to resolve Oracle block corruption using BLOCKR

Oracle Database stores data in the form of tables, which are further categorized as Block, Exte

SQL query to fetch Employee and Supervisor hierarch

In this blog post, we take a look at the SQL queries that can be used to fetch Employee and Supervisor hierarchy in Oracle Apps R12.

How to Solve ETL Job Hung Session Issue

ETL(Extract, Transform, and Load) job goes in a hung state. There will be no connection to the DB from these jobs. Each day the job

Steps to execute CANCEL or FINALLY CLOSE a REQUISI

In this blog post, you will see the scripts to execute CANCEL or FINALLY CLOSE a REQUISITION through API step by step.

How to execute the Initialization steps before runn

In this blog post, we will see what initialization steps need to be executed before running API and how to do them. Oracle E-Busin

Data flow Between Oracle Order Management and Oracl

In this blog post, we will focus on the invoices created in AR from the Order Management as source only. Oracle Order Management is Workflow driven and almost

Set up - Delivery (Transit) Lead Times for items to

In this blog, we will see the steps to set up details of Delivery (Transit) Lead Times for items to ship to customers in Order Management. There are two

Explained; Oracle Table Partitioning and its Types

In this blog post, we look at what Oracle table partitioning is and its types. There are a few test cases given here for better understanding and to produce a differen

SQL Query to fetch PO Receipt and its related Purch

In this blog post, we will see how to fetch PO Receipt and its related Purchase order and Vendor details in R12 using SQL query. Query:

AP: Invoice Validation Status Explained

The validation status of an invoice is displayed at the invoice header level in Forms, but this information is not stored in the corresponding table AP_INVOICES_ALL .

How to fix error ORA-39014, ORA-39029, ORA-31672 a

In this blog post, you will find easy steps to resolve errors ORA-39014, ORA-39029, ORA-31672 and similar errors. P

How to fix Autoconfig error: ORA-06512: at “APPS.

In this blog post, we will see how to resolve Autoconfig error: ORA-06512: at “APPS.ALR_FND_PROFILE_OPTIO_0_84_UAR

How to resolve unposted adjustments while closing A

In this blog post, you will see what you can do when you cannot close AR due to unposted Adjustment Accounting Issue: AR period cannot

How to fetch the Approval Limits for PO and Requisi

In this blog post, we will see the SQL query to find the Approval Limits for PO and Requisi

In-process reports server jobs are failing in Oracl

Product: Oracle Fusion Middleware (Reports Server) Title: In-process reports server jobs are failing

How to clear reservations in inventory using PL/SQL

In this blog post, we will show you how to use PL/SQL script to clear reservation

How To Delete a Single OPEN Purchase Order Using PL

In this blog post, we will see how we can delete a Purchase Order through API. This script will delete a Single Purchase Order which is

Performance Tuning Partition Tables Using Parallel

Keywords: Parallel query Database Versions:

RMAN Backup Restore Into Datapump Dump File

A rare scenario had occurred, where the existing table data was corrupted and unable to drop and restore the table to recover it under the same name. We had to find an

How account generator picks the default Code combin

The Account Generator processes in Oracle Purchasing build a charge, budget, accrual, and variance account for each purchase order, release, and requisition distributi

How to identify reversed journal details of a journ

A reversal entry is a journal entry made in an accounting period, which reverses selected entries made in the immediately preceding period. Two benefits of us

How to identify applied corrupted receipt and un-a

Receivables let you reverse a receipt when a customer stops payment on a receipt or if a receipt comes from an account with non-sufficient funds. One can also reverse

How to solve Error ORA-56935: Existing datapump job

Problem Description: Master table "SYS"."SYS_IMPORT_SCHEMA_01" successfully

How to resolve Error ORA-609: opiodr aborting proce

Problem Description: When a client makes a connection with Oracle Database, there are multiple steps invo

What to do when Export Full=Y fails with error PLS-

Problem Description:During the database export with FULL=Y option fails with error PLS-00201: identifier �

Customer and Supplier Bank Accounts in Oracle Appl

The data model for storing Bank and Bank Account information has changed for Release 12. Banks and their Branches are stored as Parties (HZ_PARTIES). They are linked t

In-Process Reports Server Failing To Start

Product: Oracle Fusion Middleware (Reports Server) Title: In-process reports server failing to start Version:

Descriptive Flex-fields (DFF) Oracle Apps

Descriptive Flex-fields (DFF) allows us to add additional fields to the form/page to track additional information needed by the business that was not available in Orac

Setups to Send Purchase Order in XML format to Trad

In this blog post, the below process provides the steps necessary for sending a Purchase Order in XML format to a Trading Partner.

RMAN Backup Process and Requirements

This blog post shows the process for RMAN point-in-time recovery. This is done on a 19c multi-tenant platform. Assuming the below cases. Below t

Corrupting Oracle Data Block in Manual & Recover us

Data Block Corruption:Data block corruptions occur whenever data is not in its expected state. The block may have contents that are not in

Unable To Close AR Period Due To Invalid Adjustment

Problem: Subledger Close Period Exception reports show that there is an Invalid Adjustment which is preventing AR Period Close. In order to id

How To Open Monthly Periods For Different Modules A

Keywords: Opening period, Status of open period Problem Statement: Navigation to open Period on various periods

Real Time Statistics Issue

Keywords: Real-Time Statistics, Oracle, 19c, Real-Time Stats, Gather Stats, num rows, bulk load Database Versions:

PO Balances are Negative in AP-PO Accrual Reconcili

Keywords: AP-PO Accrual Reconciliation Report, E-Business Suite, PO, AP, 12.1.3 Problem Statement: The PO amount in acco

ORA-38760: Database instance failed to turn on flas

Keywords: ORA-38760 flashback database Database Versions: Oracle Database 10.2.0.4 and later Incident D

Creating Accounting Error: The SLA Entry Does Not B

Keywords : Reversed Receipts, Creating Accounting Error, Journal Unbalance Problem Statement: Create a

PO Balances are not showing in AP-PO Accrual Reconc

Keywords: AP-PO Accrual Reconciliation Report, E-Business Suite, PO, AP, 12.1.3 Problem Statement: The

ORA-01578, ORA-01110: Oracle Data Block Corruption

Keywords: Oracle Database, Data block corruption, AUDIT_ TABLE Corrupt, shrink space error, ORA-01578, ORA-01110, Database Versions:

Unable to start OACore in Application Node

Keywords: E-Business Suite, Weblogic, oacore_server, txkSetAppsConf.pl, adProvisionEBS.pl, E-Business Suite Versions: 12.2

Error Code ER09: Unable to Post Journal

Keywords: Journals, E-Business Suite, E-Business Suite Versions: 11.5.10/12.1/12.2 Incident Details / Proble

Solaris to Linux Migration Transportable Tablespace

Title: Solaris to Linux Migration Transportable Tablespace import fails ORA-39126: Worker unexpected fatal error. Keywor

APP-AR-11279 Error in E-Business Suite Accounts Rec

Title: APP-AR-11279: This combination of receipt method and account already exists. Please enter a different account. Keywords

Oracle Database Instance Failed to Start in Windows

Solution Overview Solistech has developed an in-house disaster recovery solution for

Presentation of Oracle FSG Reports

Problem: Customer experiencing an issue where the tabs at the bottom of the FSG reports usually had a prefix

Invoice Approval Workflow Termination

Problem: Customer stating that the Concurrent Request titled Invoice

Renaming Data-file accidentally created in wrong f

Problem: The user created 8 new datafiles in the USERS tablespace, r