Monday, May 7, 2012
Concurrent Manager is not started in EBS Clone
While cloning we some time face the issue that test or development instance still showing production server name entries in test's standard manager or even table FND_CONCURRENT_QUEUES have the production entries.
We had this issue and we solved it by using the below steps:-
1. Shutdown all the managers.
2. Run the CMCLEAN.SQL (don't forget to commit).
134007.1 Ext/Pub CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables
=>See if you have wrong entries in target node columns of FND_CONCURRENT_QUEUES table
3. update FND_CONCURRENT_QUEUES set target_node='Test' where target_node='Prod'
commit;
=>See if you have wrong entries in node_name columns of FND_CONCURRENT_QUEUES table
update FND_CONCURRENT_QUEUES set node_name='target node' where node_name='source node'
commit;
4. Start the Standard manager and verify the table entrie with below query.
select * from FND_CONCURRENT_QUEUES
==> Below steps will also help out more in troubleshooting Concurrent Manager issues
When we cloned outinstance, We had an issue with concurrent manager and not started
We stoped the concurrent manager
$COMMON_TOP/admin/scripts/HOST_NAME
. adcmctl.sh stop apps/password
When I have checked the ICM logfile there is an error entry as
Could not initialize the Service Manager FNDSM_HOSTNAME_SID. Verify that HOSTNAME has been registered for concurrent processing.
The cause of this issue was FND_NODES table having incorrect node entries (old node from the Source Instance) and that no Service Manager was found for the existing node.
To solve this problem, need to perform the below steps
1. Stop all middle tier services including the concurrent managers.
2. Stop the database.
3. Start the database.
4. Connect SQLPLUS as APPS user and run the following :
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
5. Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers and webtiers to repopulate the required system tables.
6. Connect to SQLPLUS as APPS user and run the following statement :
select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like 'FNDSM%';
If the above SQL does not returning any value then please do the following:
Go to $FND_TOP/patch/115/sql
Connect SQLPLUS as APPS user and run the following script :
SQL> @afdcm037.sql;
This script will create libraries for FNDSM and create managers for preexisting nodes.
Check again that FNDSM entries now exist:
select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like 'FNDSM%';
7. Go to cd $FND_TOP/bin
$ adrelink.sh force=y "fnd FNDLIBR"
$ adrelink.sh force=y "fnd FNDSM"
$ adrelink.sh force=y "fnd FNDFS"
$ adrelink.sh force=y "fnd FNDCRM"
8. Run the CMCLEAN.SQL script from the referenced note below (don't forget to commit).
9. Start the middle tier services including your concurrent manager.
Now cloned instance concurrent managers became active. Above is applicable to both 11i and R12 instances.
How to Open or Close Period in Purchasing - R12
Generally we have the business requirement to open or close the periods in oracle purchasing which can be done by using the below steps in R12.
1. Navigate to Purchase Super User à Setup
à Financials Accounting àControl Purchasing Periods
1. Navigate to Purchase Super User à Setup
à Financials Accounting àControl Purchasing Periods
After searching your required period from above screen Save it. Please also consult the ID #
Sunday, May 6, 2012
How to mount cdrom in Linux if not working since installation
while making stage of 12.1.3 in OEL 5.5 getting below error
./adautostg.pl: Permission denied
==> Reason of error:
there was not bootable cd
==> Steps to resolve this error:-
unmount
umount /media/R1211start/
now check mount /mnt/cdrom
mount: can't find /mnt/cdrom in /etc/fstab or /etc/mtab
add cdrom in fstab and mtab file and write below line in /etc/fstab
==>First check if cdrom entry are exist in /dev
cdrom entry is exist or not
ls /dev/cd*
make a backup copy of fstab file and then add below line in fstab file
cp /etc/fstab /etc/fstab.bkp
/dev/cdrom /media/cdrom auto ro,noauto,user,exec 0 0
mkdir -p /media/cdrom
unmount
umount /media/R1211start/
mount cd with right path
mount /dev/cdrom /media/cdrom
./adautostg.pl: Permission denied
==> Reason of error:
there was not bootable cd
==> Steps to resolve this error:-
unmount
umount /media/R1211start/
now check mount /mnt/cdrom
mount: can't find /mnt/cdrom in /etc/fstab or /etc/mtab
add cdrom in fstab and mtab file and write below line in /etc/fstab
==>First check if cdrom entry are exist in /dev
cdrom entry is exist or not
ls /dev/cd*
make a backup copy of fstab file and then add below line in fstab file
cp /etc/fstab /etc/fstab.bkp
/dev/cdrom /media/cdrom auto ro,noauto,user,exec 0 0
mkdir -p /media/cdrom
unmount
umount /media/R1211start/
mount cd with right path
mount /dev/cdrom /media/cdrom
The GL date is not in an open period
Normally EBS end users will be getting the below error while receiving in Oracle Inventory:-
==> Error:
==> Solution:-
1. Ensure the Receipt Date falls into a GL Period that has Status=Open or Future:
2. Ensure the Purchasing Period is Open:
3. Please note that the Inventory period must also be Open:
GL Period:
PO Period:
==> Referecen Metalink ID [ID 552244.1
==> Error:
APP-PO-14230: The GL date is not in an open period==> Steps to Reproduce:
Or- APP-PO-14376: Please enter a GL date within an open purchasing period
- Navigate to Enter Receipts form:
- Save a receipt.
==> Solution:-
1. Ensure the Receipt Date falls into a GL Period that has Status=Open or Future:
Setup / Financials / Accounting / Open and Close periods
-OR- Setup / Open and Close periods
2. Ensure the Purchasing Period is Open:
Setup / Financials / Accounting / Control Purchasing Period
3. Please note that the Inventory period must also be Open:
Accounting close cycle / Inventory Accounting Periods(Note )To determine the Status of the periods, substitute the pertinent start and end dates in the sql below:
GL Period:
select set_of_books_id, period_name, decode(closing_status,'O','Open', 'C','Closed', 'F','Future', 'N','Never', closing_status) gl_status, start_date, end_date
from gl_period_statuses
where trunc(start_date) > sysdate-40 --adjust date as needed and trunc(start_date) < sysdate+1 and application_id = 101
order by application_id,start_date desc
PO Period:
select set_of_books_id, application_id, period_name, decode(closing_status,'O','Open', 'C','Closed', 'F','Future', 'N','Never', closing_status) po_status, start_date, end_date
from gl_period_statuses
where trunc(start_date) > sysdate-40 --adjust date as needed and trunc(start_date) < sysdate+1 and application_id = 201
order by application_id,start_date desc
==> Referecen Metalink ID [ID 552244.1
Sunday, April 29, 2012
RVTTH-115b users are not able to receive inventory items
While receiving items in oracle inventory, users were getting below error:-
We had solved this by applying below patches.
Patch 9187692
Metalink ID # 301524.1
While making Move Order Posting is not allowed in certain account code combinations
Error:-
While making move order users were getting below message against certain account code combination.
INV - 05670 -POSTING IS NOT ALLOWED FOR THIS ACCOUNT
Cause:-
Target GL account code combination's allow posting check box was disabled.
Solution:-
Enable allow posting check and allow budgeting check boxes of the required code combination.
Navigation:
General Ledger Super User > Setup > Accounts > Combinations
Query the Account field using the values from "First four segments of CCID&
quot; column in step.
Make sure "Allow Budgeting" and "Allow Posting" check boxes
are checked.
Reference Metalink Note IDs:-
Can Not Update Allow Posting and Budgeting Qualifiers for a Specific Account Segment [ID 1041105.6]
How to Find the Accounting Code Combination That Does Not Have 'Allow Budgeting' or 'Allow Posting' Checked? [ID 256405.1]
GLXJEENT When Try To Enter A Code Combination On Enter Journals Form Get "Posting is not allowed for this account" [ID 294441.1]
Saturday, April 7, 2012
How to set an employee and buyer in EBS to avoid PO form messages
If your EBS user id is not set as an employee or worker you may get the below message while accessing PO form.
"You are not setup as an employee or worker. To access this form you need to be an employee or worker."
Please follow below navigation for solution:
1- Human Resources -> People -> Enter and Maintain
Provide all mandatory details in People form.
Select Person Types as Employee(Use Action lov to get this)
Save the changes.
2- If you do not have Oracle HRMS add the employee and buyer in Purchasing Super User --> Setup -->employee or buyer from same navigation.
3- Try to open the puchase order form, hopefully it will open now.
For further, follow below metalink ID.
363774.1
"You are not setup as an employee or worker. To access this form you need to be an employee or worker."
Please follow below navigation for solution:
1- Human Resources -> People -> Enter and Maintain
Provide all mandatory details in People form.
Select Person Types as Employee(Use Action lov to get this)
Save the changes.
2- If you do not have Oracle HRMS add the employee and buyer in Purchasing Super User --> Setup -->employee or buyer from same navigation.
3- Try to open the puchase order form, hopefully it will open now.
For further, follow below metalink ID.
363774.1
Subscribe to:
Posts (Atom)








