Posts

Can Not Change Supplier Type in Create Supplier Page

Image
While Create Supplier the attribute 'Supplier type = Standard supplier' is disabled and can not be changed. Cause :  As part of the functional design for R12, only users who have access to  the function POS_HT_SP_EMP_SUPPLIER can create/update employee suppliers. By  default the creation/update of employee suppliers is disabled. Solution :  As part of the functional design for R12, only users who have access to the function POS_HT_SP_EMP_SUPPLIER can create/update employee suppliers. By default the creation/update of employee suppliers is disabled. The customer needs to implement a few setup steps to grant access to it. This can be done by either: 1. Include the function POS_HT_SP_EMP_SUPPLIER with the grant flag checked in the menu of the customized responsibility which the customer plans to have access to both standard and employee vendors. 2. Check the grant flag for the function POS_HT_SP_EMP_SUPPLIER in the menu POS_HT_SP_FULL...

PLS-00201: identifier must be declared

Today I tried to compile an Invalid Object and faced the below. Issue :  SQL> ALTER PACKAGE OWAPUB.OWA_OPT_LOCK COMPILE BODY; Warning: Package Body altered with compilation errors. SQL> show error Errors for PACKAGE BODY OWAPUB.OWA_OPT_LOCK: LINE/COL ERROR -------- ----------------------------------------------------------------- 40/12    PL/SQL: Statement ignored 40/12    PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared 72/5     PL/SQL: Statement ignored 72/5     PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared 102/6    PL/SQL: Statement ignored 102/6    PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared 144/6    PL/SQL: Statement ignored 144/6    PLS-00201: identifier 'SYS.DBMS_SYS_SQL' must be declared SQL> Reason : In this case, the PLS-00201 error indicates that the referenced package (SYS.DBMS_SYS_SQL...

Junk Characters in R12 Concurrent PDF Report

Image
When submitting a Conc.Request in Purchase Order, the request gets completed normally but the output(PDF File) contains junk characters instead of English characters. For Eg: Reason for this issue is IX_LIBRARY setup is not done properly. Proper setting of IX_PRINTING and IX_RENDERING variables will solve the issue. To set these variables, navigate to $APPL_TOP and add these variables in custom environment file. Also edit the environment file as well with the details of this custom environment file After these changes, take a bounce and re-submit the request and this time the output is proper. **************************** நன்றி ****************************

Optimize connection buffer size issue in Winscp

Image
Today when I tried to transfer an rdf file from my local system to Custom_Top of EBS Server, I faced the below issue After googling a bit found a solution for this. The solution is documented below Once the setting is saved, login and now transfer the file. This time the file should get transferred without any issue. Ref : https://winscp.net/eng/docs/ui_login_advanced **************************** நன்றி ****************************

Symbolic link creation failed in R12.2 PREPARE Phase

Image
In my environment, Prepare phase of R12.2 patching cycle failed. On examining the log found a unique issue, tried a small workaround, it worked like a charm. Actually I was not sure that my workaround will help me, but I give it a try and it worked. Issue:  FMW JDK version in use: 1.7.0_85 /u01/PROD/apps/fs1/FMW_Home/Oracle_EBS-app1/jdk is not a symbolic link, creating it... Running ln -s /u01/PROD/apps/fs1/EBSapps/comn/util/jdk64 /u01/PROD/apps/fs1/FMW_Home/Oracle_EBS-app1/jdk  ERROR: Command failed, exit code 1 After seeing this issue I went to respective directory and I can see the directory named jdk. Actually that jdk should have been created as a sym link but here it is created as a normal directory. I couldn't find the reason for that, after all the permissions and ownership are right as it should be. So I decided to move that particular file and restart the prepare phase again. Now this time, jdk was created as a proper symlink and the prepare phas...

APPS Login page is not coming

Image
One fine morning after the backup has finished in Production environment, thought to have a health checkup. DB was fine. When tried to login to APPS the login page is throwing the below issue, Apps Login Issue with Unable to generate forwarding URL. Exception: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE Quick search on google yields some hits on my issue. Solution 1: The root cause of the issue is with GUEST User and Password not in sync. Running the below query, confirmed that GUEST user and password was not in sync select fnd_web_sec.validate_password('GUEST','ORACLE') from dual; FND_WEB_SEC.VALIDATE_PASSWORD('GUEST','ORACLE') -------------------------------------------------------------------------------- N Also, confirmed with the below error on the oacore log javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE Fix: 1. Shu...

DR Configuration

The following are the list of tasks for DR configuration. Primary Server Enable Force Logging Enable Archive log  Set remote_login_passwordfile=EXCLUSIVE Adding parameters in pfile Adding parameters in tnsnames.ora file TNSPING check Create Password file RMAN backup for stand-by Instance Stand-by Server OH Creation Set remote_login_passwordfile=EXCLUSIVE Adding parameters in pfile Adding parameters in tnsnames.ora file TNSPING check Copy Password file Create NFS mount point Duplicate database for standby using RMAN Primary Server Below steps should be performed on Primary Instance. Enable Force Logging SQL> ALTER DATABASE FORCE LOGGING; Database altered. SQL> select force_logging from v$database; FOR --- YES Enable Archive Log You can follow the steps mentioned in this post to enable archive log in your database. Change the directories as per your environment.  Click Here Set remote_login_passwordfile=EXCLUS...