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'

Query to get cloned date of an oracle instance

https://dbissues.blogspot.com/2018/11/last-cloned-date-of-oracle-instance.html

select CREATED
from V$DATABASE;

Output Post Processor is Down with Actual Process is 0 And Target Process is 1

https://dbissues.blogspot.com/2018/08/output-post-processor-is-down-with.html

If you see OPP is Down with Actual Process is 0 And Target Process is 1 then do the following

SOLUTION:

1. Shutdown concurrent server via command adcmctl.sh under $COMMON_TOP/admin/scripts/<context_name>

2. To ensure concurrent manager down; check there is no FNDLIBR process running.

ps -ef | grep applmgr | grep FNDLIBR

3. Run adadmin to relink FNDSVC executable.
a. Invoke adadmin from command prompt
b. Choose option 2 (2. Maintain Applications Files menu)
c. Choose option 1 (1. Relink Applications programs )
d. Then type “FND” When prompted; ( Enter list of products to link (‘all’ for all products) [all] : FND )
e. Ensure adrelink is exiting with status 0

4. Start Concurrent Managers using adcmctl.sh