How to Check File Version in Oracle Database - Oracle EBS R12

https://dbissues.blogspot.com/2019/09/how-to-check-file-version-in-oracle.html

Oracle Apps: Check file version:

Check version of the File
Two ways to check version of file.
1. Adident
2. Strings
ADIDENT Utility in ORACLE application is used to find version of any file.
1st Method
Syntax : adident Header filename.
e.g If you want to find out the version of appvndrb.pls
$ cd AP_TOP/patch/115/sql
$ adident Header appvndrb.pls
o/p :
appvndrb.pls:
$Header appvndrb.pls 120.78.12010000.83 2010/04/27 21:00:55 vinaik ship
2nd Method :
Using Strings:
Syntax : strings -a Top_name/location of file/filename | grep ‘$Header’
e.g $ strings -a $AP_TOP/patch/115/sql/appvndrb.pls | grep ‘$Header’
o/p : /* $Header: appvndrb.pls 120.78.12010000.83 2010/04/27 21:00:55 vinaik ship $ */
OR
$ cd $AP_TOP/patch/115/sql
$ strings -a appvndrb.pls | grep ‘$Header’

"frm-18108 failed to load the following objects" & "Frm-10102: Cannot attach PL/SQL library" - Oracle EBS R12

https://dbissues.blogspot.com/2019/06/frm-18108-failed-to-load-following.html

Errors:

frm-18108 failed to load the following objects

Frm-10102: Cannot attach PL/SQL library

Unable to open Template.fmb. Getting following error

FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library APPDAYPK. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library GLOBE. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library FNDSQF. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library JA. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library JE. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library JL. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library VERT. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library GHR. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library PQH_GEN. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library PSAC. This library attachment will be lost if the module is saved.

--------------------------------------------------------------------------------------------------------------------------

Solution:

Copy Resource Folder on your Local Drive from path

/apps/test/TEST/fs1/EBSapps/appl/au/12.0.0

Copy .fmb Files Folder in Resource Folder Copied before on your Local Drive from path

/apps/test/TEST/fs1/EBSapps/appl/au/12.0.0/forms

1. My Computer>Properties
2. Click on the Advanced System Settings tab
3. Click on the Environment Variables button
4.Add the FORMS_PATH variable to the set of User Variables .
5. Click on the New button and enter the Variable Name and Variable Value

a). Variable Name = FORMS_PATH
b)Variable Value = full path to your pll and fmb files

Example:
C:\resource;C:\resource\US

Reference: Form Builder Errors On Startup FRM-10102: Cannot attach PL/SQL library APPCORE (Doc ID 2003579.1)

--------------------------------------------------------------------------------------------------------

Add registry in below path

Navigate to: C:\Windows > regedit

HKEY_LOCAL_MACHINE --> SOFTWARE-->Wow6432Node -->Oracle--> KEY_DEvSuiteHome1->FORMS_PATH (EDIT)

C:\resource;C:\resource\US

Reference: http://shaguloracle.blogspot.com/2017/02/frm-10102-cannot-attach-plsql-library.html

PLSQL Error: ORA-06413 connection not open - Oracle EBS R12

https://dbissues.blogspot.com/2019/06/plsql-error-ora-06413-connection-not.html

ORA-06413 connection not open

1. create x86 directory without brackets

2. Copy Paste the Installed PLSQL in this directory. If not work, then re-install in this directory.

3. Open the Folder Pasted and Open Plsqldev Application

-----------------------------------------

This error due to oracle reserved character "(",")" and in Windows 64 bit there is an folder "Program Files (x86)" is creation problem. ... Open Registry file(Copy) in text editor replace "(x86)" to "x86" Save file and import it in registry and restart you computer. Now "ORA-06413: Connection not open" error go away.

ODAC (ODBC) Connection 32 & 64 bit - Oracle EBS R12

https://dbissues.blogspot.com/2019/06/odac-connection-32-64-bit-oracle-ebs-r12.html

Please Copy Paste the Below URL in your Browser and follow

https://support.office.com/en-us/article/connect-to-an-oracle-database-power-query-d7fbd231-a705-4eb7-83b3-a66bfb678395?ui=en-US&rs=en-US&ad=US

OR

32bit
https://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html


64bit
https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

Press CTRL+F and type ODBC

REP-0118 unable to create a temporary file - Oracle EBS R12

https://dbissues.blogspot.com/2019/06/rep-0118-unable-to-create-temporary.html

When opening Report Builder, the below error occurs

“REP-0118 unable to create a temporary file”

Error pops up when we install Oracle Report and open it for first time.Cause – Issue with Temp file path and you don’t have access to this folder.

Fix – Navigate to Registry entry (Run -> Regedit -> and search (Ctrl+f) with “REPORTS_TMP”. Modify the path to your path or get the write access for this folder.

Oracle User Session Start time and End time

https://dbissues.blogspot.com/2019/05/oracle-user-session-start-time-and-end.html

select *  from fnd_logins c order by c.login_id desc

How to Pass org_id condition in Table value set?

https://dbissues.blogspot.com/2019/04/how-to-check-orgid-conditions-in-value.html

org_id =:$PROFILES$.ORG_ID

org_id =  fnd_global.org_id

mo_global.check_access(org_id) = 'Y'