Tuesday, May 6, 2014
Error confirm shipping in Shipping Transaction Forms because Real shipping date is out of current inventory period
Symtomps: When try to confirm shipping in shipping transactrion form ,an error appear: Some deliveries for shipping transaction have errors or warnings. In error details you can read the main reason: Real shipping date is out of current inventory period.
Cause: Inventory Period in which you need to shipping is closed or in Future state. You should open it, before doing shipping transaction operation.For do it:
Responsability:Inventrory.
Function: Inventory Accounting Periods(for desire warehouse).
tip:For access function directly you can use CTRL+L keystone,
Monday, March 31, 2014
The Concurrent requests are in Pending status / No Concurrent Manager defined to execute the request
After an Oracle Cloning Procedure from PROD to TEST (that it's not necessary shutdown PROD), without reason, concurrent managers were down, so it's produces these Symtomps:
- All service request were in PENDING status. Never ending.
- All workflows whom launched service requests didn't work.
-..
You can see details below:
Solution: Restarts concurrent Manager in OAS(Oracle Application System) through OS terminal using script
adcmctl.sh located in ..../admin/scripts/
1. Stop Concurrent manager.
#adcmctl.sh stop apps/apps
2. Start Concurrent manager.
#adcmctl.sh start apps/apps
3.Check Concurrent Manager status:
#adcmctl.sh status apps/apps
You are running adcmctl.sh version 115.31
Internal Concurrent Manager is Active.
adcmctl.sh: exiting with status 0
4.Check whether Concurret Manager Processes are working.
#ps -ef | grep FNDLIBR
After to apply this solution all service requests have to finish appropiately.
I found solution in this link: https://anandoracle.wordpress.com/2012/07/11/the-concurrent-requests-are-in-pending-status-appears-no-concurrent-manager-defined-to-execute-the-request/
Monday, March 10, 2014
Change date preferences from System Profile function directly
Although the best way for changing date preferences for an especific user is using the Preference link at logging page, see below:
but sometimes user has defined default quick load to form directly so he cannot access to the preferences page. In this case, your Administrator can change from:
Responsability: System Administrator
Function:System | Profile.
Filter: User (user desired), Profile: ICX: Date Format Mask , keep Enable Profiles with no values
Important: Change System Profile Value is a very powerful tool, however an incorrect use can cause side effects.
but sometimes user has defined default quick load to form directly so he cannot access to the preferences page. In this case, your Administrator can change from:
Responsability: System Administrator
Function:System | Profile.
Filter: User (user desired), Profile: ICX: Date Format Mask , keep Enable Profiles with no values
Important: Change System Profile Value is a very powerful tool, however an incorrect use can cause side effects.
Monday, October 28, 2013
ERROR while extract data from File | Export menu option : ... unable to extend segment LOB.APPLSYS.SYS_LOBxxxx in tablespace APPS_TS_MEDIA
Symtomps: When you try to Export (Menu option File| Export )appears this error:".. unable to extend segment LOB.APPLSYS.SYS_LOBxxxx in tablespace APPS_TS_MEDIA ..."
Conclusion: The tablespace APPS_TS_MEDIA is full. Just add a new datafile to the tablespace and fix it.
How:
1.Go to sqlplus logging as SYSDBA:
$sqlplus sys as sysdba/YYYY
note:where YYYY is password sysdba
2. To know what tablespace correspond with which datafile you can use this use sql query:
select file_name,tablespace_name from dba_data_files where file_name like'%media%'
result:
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
/u02/oracle/iosaproddata/a_media01.dbf
APPS_TS_MEDIA
More information about datafiles and tablespace see link below:
http://appsvista.blogspot.com.es/2011/01/tablespace-files.html
3.SQL> ALTER TABLESPACE APPS_TS_MEDIA ADD DATAFILE '/u02/oracle/iosaproddata/a_mediaX.dbf' SIZE 1024M AUTOEXTEND OFF;
note: where X is a new number for datafile. In my case: if you list(ls -la /u02/oracle/iosaproddata/ ) data folder and get this output:
$ls -la /u02/oracle/iosaproddata/
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_int01.dbf
-rw-r----- 1 oratest oinstall 1610620928 Dec 13 11:58 a_media01.dbf
-rw-r----- 1 oratest oinstall 62922752 Dec 13 11:58 a_nolog01.dbf
-rw-r----- 1 oratest oinstall 524296192 Dec 13 11:58 a_queue01.dbf
-rw-r----- 1 oratest oinstall 524296192 Dec 13 11:58 a_queue02.dbf
drwxr-xr-x 2 oratest oinstall 4096 Feb 19 2011 archive
-rw-r----- 1 oratest oinstall 1572872192 Dec 13 11:58 a_ref01.dbf
-rw-r----- 1 oratest oinstall 1572872192 Dec 13 11:58 a_ref02.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_summ01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_summ02.dbf
-rw-r----- 1 oratest oinstall 134225920 Dec 13 11:58 a_tools01.dbf
-rw-r----- 1 oratest oinstall 2147491840 Dec 13 11:58 a_txn_data01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data02.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data03.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind02.dbf
the last .dbf file is a_media01.dbf, soX should be 2, so sqlplus sentece would be:ALTER TABLESPACE APPS_TS_ARCHIVE ADD DATAFILE '/u02/oracle/iosaproddata/a_media02.dbf' SIZE 1024M AUTOEXTEND OFF;
Conclusion: The tablespace APPS_TS_MEDIA is full. Just add a new datafile to the tablespace and fix it.
How:
1.Go to sqlplus logging as SYSDBA:
$sqlplus sys as sysdba/YYYY
note:where YYYY is password sysdba
2. To know what tablespace correspond with which datafile you can use this use sql query:
select file_name,tablespace_name from dba_data_files where file_name like'%media%'
result:
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
/u02/oracle/iosaproddata/a_media01.dbf
APPS_TS_MEDIA
More information about datafiles and tablespace see link below:
http://appsvista.blogspot.com.es/2011/01/tablespace-files.html
note: where X is a new number for datafile. In my case: if you list(ls -la /u02/oracle/iosaproddata/ ) data folder and get this output:
$ls -la /u02/oracle/iosaproddata/
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_int01.dbf
-rw-r----- 1 oratest oinstall 1610620928 Dec 13 11:58 a_media01.dbf
-rw-r----- 1 oratest oinstall 62922752 Dec 13 11:58 a_nolog01.dbf
-rw-r----- 1 oratest oinstall 524296192 Dec 13 11:58 a_queue01.dbf
-rw-r----- 1 oratest oinstall 524296192 Dec 13 11:58 a_queue02.dbf
drwxr-xr-x 2 oratest oinstall 4096 Feb 19 2011 archive
-rw-r----- 1 oratest oinstall 1572872192 Dec 13 11:58 a_ref01.dbf
-rw-r----- 1 oratest oinstall 1572872192 Dec 13 11:58 a_ref02.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_summ01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_summ02.dbf
-rw-r----- 1 oratest oinstall 134225920 Dec 13 11:58 a_tools01.dbf
-rw-r----- 1 oratest oinstall 2147491840 Dec 13 11:58 a_txn_data01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data02.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data03.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind02.dbf
the last .dbf file is a_media01.dbf, soX should be 2, so sqlplus sentece would be:ALTER TABLESPACE APPS_TS_ARCHIVE ADD DATAFILE '/u02/oracle/iosaproddata/a_media02.dbf' SIZE 1024M AUTOEXTEND OFF;
Friday, October 25, 2013
Setup an user as a buyer
When an user try to operate with purchasing and it doesn`t really work, usually it is happen because that user has not been configured as buyer. For setup an user as a buyet follow these instructions.
Responsability: GLOBAL PURCHASING.
Function:(Setup|Personnel|Buyers).
Add the user as buyer as you see in the picture below:
Wednesday, February 13, 2013
Add a new Customer Class
It's usual to add new customer class in Receivable module . Usually you use Customer class for join in the same group countries with similar characteristics.
you can choose a customer class in a specific customer in this picture:
For adding new customer classs :
Responsibility: Receivables Manager. (Setups| System| Quick Codes | Receivables).
More information in oracle support: How to add a new Customer Class [ID 1407903.1]
you can choose a customer class in a specific customer in this picture:
For adding new customer classs :
Responsibility: Receivables Manager. (Setups| System| Quick Codes | Receivables).
More information in oracle support: How to add a new Customer Class [ID 1407903.1]
Thursday, January 17, 2013
ERROR: ... unable to extend index APPLSYS.FND_LOGINS by 16 in tablespace APPS_TS_ARCHIVE
Symtomps: When you run a Request appears this error:".. unable to extend index APPLSYS.FND_LOGINS by 16 in tablespace APPS_TS_ARCHIVE ..."
Conclusion: The tablespace APPS_TS_ARCHIVE is full. Just add a new datafile to the tablespace and fix it.
How:
1.Go to sqlplus logging as SYSDBA:
$sqlplus sys as sysdba/YYYY
note:where YYYY is password sysdba
2.ALTER TABLESPACE APPS_TS_ARCHIVE ADD DATAFILE '/u02/oracle/iosaproddata/a_archive0X.dbf' SIZE 1024M AUTOEXTEND OFF;
note: where X is a new number for datafile. In my case: if you list(ls -la /u02/oracle/iosaproddata/ ) data folder and get this output:
$ls -la /u02/oracle/iosaproddata/
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_archive01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_archive02.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_archive03.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_archive04.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_int01.dbf
-rw-r----- 1 oratest oinstall 1610620928 Dec 13 11:58 a_media01.dbf
-rw-r----- 1 oratest oinstall 62922752 Dec 13 11:58 a_nolog01.dbf
-rw-r----- 1 oratest oinstall 524296192 Dec 13 11:58 a_queue01.dbf
-rw-r----- 1 oratest oinstall 524296192 Dec 13 11:58 a_queue02.dbf
drwxr-xr-x 2 oratest oinstall 4096 Feb 19 2011 archive
-rw-r----- 1 oratest oinstall 1572872192 Dec 13 11:58 a_ref01.dbf
-rw-r----- 1 oratest oinstall 1572872192 Dec 13 11:58 a_ref02.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_summ01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_summ02.dbf
-rw-r----- 1 oratest oinstall 134225920 Dec 13 11:58 a_tools01.dbf
-rw-r----- 1 oratest oinstall 2147491840 Dec 13 11:58 a_txn_data01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data02.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_data03.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind01.dbf
-rw-r----- 1 oratest oinstall 1073750016 Dec 13 11:58 a_txn_ind02.dbf
the last .dbf file is a_archive04.dbf, soX should be 5, so sqlplus sentece would be:ALTER TABLESPACE APPS_TS_ARCHIVE ADD DATAFILE '/u02/oracle/iosaproddata/a_archive05.dbf' SIZE 1024M AUTOEXTEND OFF;
Subscribe to:
Posts (Atom)