MICR stands for Magnetic Ink Character Recognition code which is a character-recognition technology used by Bank to process checks. The MICR line is at the bottom of the check which has a check number, bank code, and account number and control character. Banks in the United States of America use MICR / E13-B fonts. Oracle […]
Install and Setup MICR font in Oracle BI Publisher Fusion Read More »
Who columns in a table allows users to track changes made to the data in Oracle Apps. It also helps to differentiate between changes made by forms and changes made by concurrent programs. Below is the list of standard who columns, CREATED_BY The created_by is a number(15) not null column in a table that keeps
Who Columns in Oracle Apps Read More »
SQL Developer provides an easy way to connect Oracle Database. Just start, enter database information like Host, Service, port, and click on connect. But, how to connect to the cloud database? Ports ranging from 1520-1530 are not available on secure Oracle public cloud. You need to connect the oracle database using a secure shell (SSH)
Connect to Oracle Cloud Database from SQL Developer Read More »
Oracle is a relational database management system by Oracle Corporation. It is one of the most widely used databases in OLTP, Data warehouse. Oracle released a good number of versions since 1979 and the latest version is 19C which is available for on-premise as well as in the cloud. Many of the users are still
How to Check Oracle Database Version? Read More »
SQL Server is a relational database management system by Microsoft Corporation. You need the Microsoft SQL Server Management tool to connect and work with SQL Server. But, you can also use SQL Developer to connect SQL Server using JDBC Driver called jTDS 3rd party JDBC driver. In this article, I will show how to connect
How to Connect to SQL Server from SQL Developer Read More »
As per this document, FND_CMN_SERVER_CONN_ERROR comes when ‘An application error occurred while establishing a connection to the {SERVER}. Where, {SERVER} – Data Quality server, UCM server, or Oracle Business Intelligence server. Below is the complete error message. Failed processing original documents i1i in the Oracle Fusion UCM SOAP [env:Server] JBO-FND:::FND_CMN_SERVER_CONN_ERROR: <MESSAGE><NUMBER>FND-4</NUMBER> <TEXT>An error occurred while
[Solved] FND_CMN_SERVER_CONN_ERROR in ErpIntegrationService (Oracle Fusion) Read More »
FND-CP-ESP: Child: exec:: Permission denied error comes when you submit host-based concurrent program in Oracle apps and apps is not able to execute the shell script for the program. This is the way you design the host program in Oracle Apps. Create the shell script (test.prog), Make sure .prog is the extension of the script.
FND-CP-ESP: Child: exec:: Permission denied Read More »
Planning Data Pull request completes in error “User not defined or not assigned to the responsibility – ‘APS COLLECTIONS’”, when the user who submitted the request does not exists in source instance or does not have APS collection responsibility is assigned Check if the user exists in Oracle EBS Source side and has APS collection
Oracle frequently releases patches necessary to maintain your EBS Environment Healthy and Up-To-Date. These include Recommended patches (RPC), Technology Stack patches, Performance patches, Security Patches, etc. Sometimes, you also identify a patch while searching on support.oracle.com(Metalink), when you face issues with Oracle apps and would like to see if that patch is applied to your
How to check if a patch is applied in Oracle Apps (11i, R12) Read More »
The ORA-00000 normal, successful completion in Oracle means there is no error in SQL Queries or whatever transactions performed are successful. You can simply ignore this message. As per Oracle error message guide, Cause: An operation has completed normally, having met no exceptions. Action: No action required Let’s reproduce ORA-00000, Create an anonyms block as shown below.
ORA-00000 normal, successful completion Read More »