Oracle Report Output giving junk characters

Hi All.


Here is the new issue that I found during migration from AIX servers to Red Hat 5.6.
I upgraded the 11.5.9 to 12.1.3 and during the customer check we found that all custom oracle  reports (1200) giving the junk characters on free text area. The data comes OK.
I asked the developer to check it. When he opened the rdf file with Oracle Reporter and rewrited the free text, the output become good.


I checked in google and found that the CHARSET may be different between AIX and Red Hat. CHARSET in AIX was 31 and in Redhat 38. 


How to find the right CHARSET:
1. In Oracle Reports check the new created free text.
2. Create a new report with free text and convert it to REX file. Look for CHARSET and see what you CHARSET need to be.


So I need to change all reports manually to the right CHARSET.
Here the Linux script that I created to change the CHARSET in all (1200) custom reports.


for f in *.rdf
do
RDF_FILE=$f
RDF_FILE=`echo $RDF_FILE | awk -F"." '{ print $1 }'`

chmod 777 $RDF_FILE.rdf
#Convert rdf file to rex 
rwconverter userid=apps/apps source=$RDF_FILE.rdf dest=$RDF_FILE.rex stype=rdffile dtype=rexfile overwrite=yes batch=yes
#Remove junk characters
cat $RDF_FILE.rex | tr -d "\015" > $RDF_FILE.rextmp
#Change Charset to 38
sed -e 's/CHARSET = 0/CHARSET = 38/' -e 's/CHARSET = 31/CHARSET = 38/' -e 's/CHARSET = 178/CHARSET = 38/' -e 's/CHARSET = 871/CHARSET = 38/' < $RDF_FILE.rextmp> $RDF_FILE.rex
#Convert rex file to rdf
rwconverter userid=apps/apps source=$RDF_FILE.rex dest=$RDF_FILE.rdf stype=rexfile dtype=rdffile  overwrite=yes batch=yes
rm -f $RDF_FILE.rex
chmod 777 $RDF_FILE.rdf
done;


Hope it will help you.


Good Luck ...

RX-only: Receipt Register failed after baseline 11i upgrade

Hi All.


Here the new issue
When running RX-only: Receipt Register report, get the following error in the log file:

RXARRCRG module: RX-only: Receipt Register
+---------------------------------------------------------------------------+

Current system time is 12-SEP-2011 22:29:06

+---------------------------------------------------------------------------+

**Starts**12-SEP-2011 22:29:06
ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'RECEIPT_REGISTER'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
.

The SQL statement being executed a
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+


Action Plan to implement the solution:


1. Please run the following commands:
FNDLOAD apps/<password> 0 Y UPLOAD $FA_TOP/patch/115/import/farx.lct
$AR_TOP/patch/115/import/US/arorx.ldt - CUSTOM_MODE=FORCE

FNDLOAD apps/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct
$AR_TOP/patch/115/import/US/arocp.ldt - CUSTOM_MODE=FORCE

Replace <password> with the password for apps user

2. Re-Test issue


Good Luck ...

System Administrator responsibility disappear from user menu

Hi All.


This is the first time that I see this issue.After the ATG rup 7 upgrade the System Administrator responsibility disappear from SYSADMIN user menu. It was OK until I run the required post installation step for ATG rup 7 Workflow Directory Services User/Role Validation concurrent.


Another issue when I'm stopping concurrent manager I get the following error:
Shutting down concurrent managers for PROD ...
Please enter a valid responsibility. The responsibility System Administrator does not exist or is not active. Check that the correct application short name is specified for your responsibility.

adcmctl.sh: exiting with status 1


If you also got this error , do the following:
According the Document ID 466135.1 - Responsibilities Missing After They Have Been Assigned to a User


1. Run the following script to check if there is a discrepancy between the tables:

select ura.user_name, ura.role_name 
from wf_local_user_roles ur, wf_user_role_assignments ura 
where ur.user_name = ura.user_name 
and ur.role_name = ura.role_name 
and ura.relationship_id = -1 
and ((ur.effective_start_date is null or ur.effective_start_date <> 
ura.effective_start_date) 
or (ur.effective_end_date is null or ur.effective_end_date <> ura.effective_end_date));

If the above script returns any rows then:

2. You must take a backup of the two tables :

WF_LOCAL_USER_ROLES
and
WF_USER_ROLE_ASSIGNMENTS


3. Run the following update script to correct the discrepancy :

UPDATE WF_USER_ROLE_ASSIGNMENTS set effective_end_date = to_date(null) 
where rowid in (select ura.rowid 
                from wf_local_user_roles ur, wf_user_role_assignments ura 
                where ur.user_name = ura.user_name 
                  and ur.role_name = ura.role_name 
                  and ura.relationship_id = -1 
                  and ((ur.effective_start_date is null or ur.effective_start_date <>ura.effective_start_date) 
                  or (ur.effective_end_date is null or ur.effective_end_date <>ura.effective_end_date)));


4. Run the "Workflow Directory Services User/Role Validation" concurrent program to resolve the
     issue with following parameters : 10000,Yes,Yes,Yes

5. Re-test the issue.


Good luck...

Cash Positioning Issue

Hi All.


When attempting to Cash Positioning: Existing worksheet go button
the following error occurs an error:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122


Step to reproduce:
Go to CM responsibility --> Cash positioning

Press "Go" button

Got the following error: You have encountered an unexpected error. Please contact the System Administrator for assistance

After changing FND: Diagnostics profile to YES, I can see the full error:

 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT WorksheetHeadersEO.WORKSHEET_HEADER_ID, 

WorksheetHeadersEO.WORKSHEET_NAME,

WorksheetHeadersEO.COLUMNS_DISPLAYED,

WorksheetHeadersEO.CREATED_BY,

decode(WorksheetHeadersEO.CREATED_BY,

1, 'DeleteDisabled',

'DeleteEnabled') DELETE_SWITCHER,

decode(WorksheetHeadersEO.CREATED_BY,

1, 'UpdateDisabled',

'UpdateEnabled') UPDATE_SWITCHER

FROM CE_CP_WORKSHEET_HEADERS WorksheetHeadersEO) QRSLT  WHERE (EXISTS (SELECT 1 FROM ((SELECT 1 FROM CE_CP_WS_BA_V WBA WHERE WBA.worksheet_header_id = QRSLT.worksheet_header_id AND WBA.xtr_user_flag = 'N')UNION ALL (SELECT 1 FROM CE_CP_WORKSHEET_LINES WL WHERE WL.CASHPOOL_ID IS NOT NULL)))) ORDER BY WORKSHEET_NAME

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865)

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988)

at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)

at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)

at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:750)

at oracle.apps.ce.cashpositions.webui.WorksheetSearchCO.processFormRequest(WorksheetSearchCO.java:130)

at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:810)

at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)

at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1159)

at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)

at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)

at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)

at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)

at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)

at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)

at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1022)

at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:988)

at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:843)

at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)

at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)

at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2700)

at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1707)

at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)

at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)

at _oa__html._OA._jspService(_OA.java:84)

at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)

at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)

at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)

at oracle.jsp.JspServlet.internalService(JspServlet.java:186)

at oracle.jsp.JspServlet.service(JspServlet.java:156)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)

at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)

at org.apache.jserv.JServConnection.run(JServConnection.java:294)

at java.lang.Thread.run(Thread.java:662)

## Detail 0 ##

java.sql.SQLException: ORA-00904: "QRSLT"."WORKSHEET_HEADER_ID": invalid identifier

Action plan:

1.  Please download and review the readme for Patch 4715697 .

2. Please apply Patch 4715697 in a TEST environment.
3. Please confirm the following file versions:
ce java/cashpositions/server WorksheetSummaryVOImpl.java 115.7
4. Restart apache server and clear the apache cash

5. Please retest the issue.

Good luck ...

How to personalize Notifications List

Hi All

Here the step by step guide for Notifications List personalization : 

This will require a personalization
1. Login as System Administrator Profiles>SYSTEM>Personalize Self-Service Defn =Yes
A. Disable Self-Service Personal = NO 
B. FND: Personalization Region Link Enabled = Yes 

2. Navigate to the Workflow User Responsibility> Bring up the Worklist
You should see the personalizations optons  for instance mine is at the bottom of the page and says Personalize Page.

3. Click it and go to the section that says Table: Notification list.

4. Click the pencil on the line. See the Records Displayed. Now you can change the values according your request.

Good Luck...

Variable not defined: '_XDONFSEPARATORS'.

Hi All


After upgrade to BaseLine 11i  we started to get the following error for some XML Publisher reports:


[UNEXPECTED] [31118:RT56796901] java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(XSLT10gR1.java:673)
        at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:421)
        at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:240)
        at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)
        at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
        at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
        at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
        at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)
        at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5926)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3458)
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3547)
        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:290)
        at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:157)
Caused by: oracle.xdo.parser.v2.XPathException: Variable not defined: '_XDONFSEPARATORS'.
        at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
        at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)
        at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)
        at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)
        at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)
        at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)
        ... 18 more




Here the Action Plan:


1. Go to XML Publisher Administrator responsibility .
2. Veiw --> Request--> Submit New Request.
3. Run "XML Publisher Template Re-Generator" concurrent  with Re-Generation Criteria "ALL".
4. Re-test the issue.


Good Luck...

Concurrent Standard Manager issue.

Hi All,

I got this issue after adcfgclone procedure + changing apps password in TEST instance.

Starting concurrent program OEOIMP for concurrent request 54565534 (MODULE=Order Import)

Routine AFPCSQ encountered an ORACLE error. ORA-01005: null password given; logon denied

.

Review your error messages for the cause of the error. (=<POINTER>)

Shutting down Concurrent Manager : 07-SEP-2011 14:03:03

ORA-01012: not logged on

According the metalink the the action plan is to re-run the FNDCPASS procedure for changing apps password. But it doesn't helped.

Seems that the issue in concurrent manager queue.

Here the action plan for fix the issue:

1. Stop APPS tier.

2. Run adpreclone for appsTier in cloned instance.

3. Run adcfgclone appsTier again in cloned instance (it will re-create the queues).

4. Start APPS tier.

5. Re-check the issue.

Good Luck...