First find the GL Ledger ID :
select * from Gl_Ledgers_vNow select and find the period to confirm :
SELECT * FROM GL_PERIOD_STATUSES GLP
WHERE GLP.APPLICATION_ID = '200'/* PAYABLES */
AND GLP.SET_OF_BOOKS_ID = '2149'
AND GLP.CLOSING_STATUS = 'O'
AND GLP.PERIOD_NAME = 'SEP-22'Once done update the period :
UPDATE GL_PERIOD_STATUSES GLP
SET GLP.CLOSING_STATUS = 'C'
WHERE GLP.PERIOD_NAME = 'SEP-22'
AND GLP.APPLICATION_ID = '200'/* PAYABLES */
AND GLP.SET_OF_BOOKS_ID = '2149';A newly configured Solaris 10 server, successfully configured a ntp client. But when trying to start ntp service its getting failed and going into maintenance mode.
Due to this there a 15 minutes of time difference between this server and other servers.
bash-3.00$ svcs ntp
maintenance 16:12:09 svc:/network/ntp:defaultAfter checking in detail :
bash-3.00$ svcs -x ntp
svc:/network/ntp:default (Network Time Protocol (NTP))
State: maintenance since Sun Jan 08 08:12:07 2012
Reason: Start method failed repeatedly, last exited with status 1.
See: http://sun.com/msg/SMF-8000-KS
See: xntpd(1M)
See: ntpdate(1M)
See: ntpq(1M)
See: /var/svc/log/network-ntp:default.log
Impact: This service is not running.In logfile:
[ Aug 11 13:11:15 Executing start method ("/lib/svc/method/xntp") ]
/sbin/sh: /lib/svc/method/xntp: not found
[ Aug 11 13:11:15 Method "start" exited with status 1 ]To resolve the same encounter error here is a solution :
Actually there is a library and daemon file is missing on server where ntp is not starting.
So here just we need to copy these two files from a server where ntp is working fine.
“xntp” and “xntpd”
If you copy only “xntp” then another error will be recorded in ntp log file like:
[ Jan 15 16:02:56 Executing start method ("/lib/svc/method/xntp") ]
/lib/svc/method/xntp: /usr/lib/inet/xntpd: not found
[ Jan 15 16:05:54 Method "start" exited with status 1 ]
[ Jan 15 16:12:02 Leaving maintenance because disable requested. ]
Here check if you already have “xntpd” file at its place then not required to copy. If doesn’t exists then copy these two files on server where you’re facing issue.
1) /lib/svc/method/xntp
2) /usr/lib/inet/xntpd
After copy :
root@proderp # cd /lib/svc/method/
root@proderp # chmod 555 xntp
root@proderp # chgrp bin xntp
root@proderp # cd /usr/lib/inet/
root@proderp # chmod 555 xntpd
root@proderp # chgrp bin xntpdAfter copying, changing permission and ownership disable and enable ntp service it should work :
root@proderp # svcadm disable svc:/network/ntp:default
root@proderp # svcadm enable svc:/network/ntp:default
root@proderp # svcs ntp
STATE STIME FMRI
online 16:12:09 svc:/network/ntp:default
While altering parameter in parameter file got below error :
ALTER SYSTEM SET processes = 800 SCOPE=SPFILE;
ALTER SYSTEM SET processes = 800 SCOPE=SPFILE
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use
This error comes, if the database is running with pfile instead of spfile.
1. Check whether DB is running with pfile or spfile:
SQL> show parameter pfile
NAME TYPE VALUE
------ -------- ------------------------------
spfile string
Here value is showing BLANK, Means database is running with pfile. So with pfile , if we are trying to alter any init parameter in database, it will throw error.
To fix it, create an spfile from the pfile and restart the database.
2. Create spfile from pfile ;
create spfile from pfile;
3. Check whether spfile has been created in $ORACLE_HOME/dbs location :
cd $ORACLE_HOME/dbs
ls -ltr spfile*
4. Restart the database :
shutdown immediate;
startup
When we start the database, if both pfile(init$ORACLE_SID.ora) and spfile(spfile$ORACLE_SID.ora) are present at dbs location, Then bydefault spfile will be used for db startup.
5. Check whether spfile is used or not :
show parameter pfile :
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/app/oracle/product/12chome/spfiledbaclass.ora
6. Now run alter statement :
ALTER SYSTEM SET processes = 800 SCOPE=SPFILE
System altered.
To reset an Oracle EBS application user password, use the FNDCPASS utility via command line to change it instantly, or use the System Administrator responsibility in the GUI for individual users. For APPS/APPLSYS passwords in R12.2, specialized steps involving adstpall.sh and WLS datasource updates are required
Methods to Reset Oracle EBS Passwords :
FNDCPASS Utility (Command Line – Recommended for Admins):
Use this method to change APPS or specific user passwords from the server terminal :
FNDCPASS apps/<apps_pwd> 0 Y SYSTEM/<system_pwd> USER <username> <new_password>
Example to change user “OPERATOR” password: FNDCPASS apps/apps 0 Y system/manager USER OPERATOR welcome1.
System Administrator Responsibility (GUI)
Log in to EBS as a user with System Administrator privileges (e.g., SYSADMIN).
Navigate to Security > User > Define.
Query the user, enter the new password in the Password field, and save.
PL/SQL Method (Back-end):
Use FND_USER_PKG.ChangePassword to change passwords using SQL*Plus, logged in as the APPS user.
R12.2 APPS/APPLSYS Password Change :
– Shut down services using $INST_TOP/admin/scripts/adstpall.sh.
– Run FNDCPASS to change the APPLSYS password.
– Run AutoConfig.
– Update WLS Data Source in WebLogic Console and restart services.
Metalink id:
===========
R12: Request Logs Contain the Message “REP-0004: Warning: Unable to open user preference file”
[ID 1120529.1]
Symptoms:
============
All concurrent requests that run REPORTS are printing the following warning in the request log.
REP-0004: Warning: Unable to open user preference file.
Cause:
==========
This message occurs when the concurrent process attempts to open the Oracle Reports executable and your local preference file cannot be found or opened. This is just a warning, so the request will continue to run even if this occurs.
Solution:
===========
To resolve the warning, copy the prefs.ora file from your Reports Builder $ORACLE_HOME/tools/admin/ directory into the Applications $HOME directory.
Example :
Copy of the file prefs.ora in the directory /u01/prod/apps/tech_st/10.1.2/tools/admin to the directory /home/appprod/.
appdev@ctssd $ pwd
/u01/erpapp/10.1.2/tools/admin
appdev@ctssd $ cp prefs.ora /export/home/apptest
Note: Bounce apache service.
After doing above steps issue resolved.