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//... folder.

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.

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.dbfsoX  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]

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;