Requisition tab error

[Roshan]

A user is having the attached error upon accessing the Requisition tab found in Purchase Requestors - SBH menu. The commands are a bit complicated, can you please clarify?

error_view_requisition.txt
Thanks and Regards,
Roshan

[ErmanArslansOracleBlog]

Check your weblogic logs, oacore server status and oacore server logs.
Ensure that there are no customizations in the relevant areas.

For debuggin;

Enable debug log
 
A. Set the following profiles(at the User level is best where possible)
FND: Debug Log Enabled  : Yes
FND: Debug Log Filename  : leave it as null
FND: Debug Log Level  : Statement
FND: Debug Log Module  : %
 
Bounce OACORE and Http server
 
Truncate the table APPLSYS.FND_LOG_MESSAGES
 
truncate table applsys.fnd_log_messages;
 
Reproduce the error and then stop when the error is produced and close the browser
 
Check the table APPLSYS.FND_LOG_MESSAGES for error or clues.
 
select * from fnd_log_messages where TIMESTAMP > (sysdate - 1/60) order by log_sequence desc;
 

[Roshan]

Thanks a lot !!

[Roshan]

Please find attached the log.

FND_LOG_Messages.xls

[ErmanArslansOracleBlog]

The related document may not be available.

Please check with these commands;

SQL> set serveroutput on

SQL> exec jdr_utils.printdocument('/oracle/apps/icx/por/reqmgmt/webui/ReqSummaryPG');

[Roshan]

How do you know the related document is not available?

Why it is only for /oracle/apps/icx/por/reqmgmt/webui/ReqSummaryPG I need to  execute?

[ErmanArslansOracleBlog]

Roshan,

Your role is Apps Dba or not?

[Roshan]

My role is Apps DBA. Thanks.

[ErmanArslansOracleBlog]

Then please read.
You should not ask these questions.
You are asking exec jdr_utils.printdocument to me.

Read the documents.
Please understand the purpose of this forum.

[Roshan]

I have executed the commands:
SQL> set serveroutput on

SQL> exec jdr_utils.printdocument('/oracle/apps/icx/por/reqmgmt/webui/ReqSummaryPG');

on clone instance of PROD(PREPROD) and it has executed successfully, giving me output:

<?xml version='1.0' encoding='UTF-8'?>
<jrad:page xmlns:jrad="http://xmlns.oracle.com/jrad" xmlns:oa="http://xmlns.oracle.com/oa" xmlns:ui="http://xmlns.oracle.com/uix/ui" version="10.1.3_1305" xml:lang="en-US" file-version="$Header: ReqSummaryPG.xml 120.7 2011/12/12 06:14:00 rkandima ship $">
   <jrad:content>
      <oa:pageLayout id="PageLayoutRN" amDefName="oracle.apps.icx.por.reqmgmt.server.ReqMgmtAM" controllerClass="oracle.apps.icx.por.reqmgmt.webui.ReqSummaryCO" autoFooter="false" helpTarget="help_iproc" windowTitle="Oracle iProcurement: Requisitions"
                     title="Requisitions" rendered="${oa.FunctionSecurity.ICX_POR_REQMGMT_SUMMARY}">
         <ui:corporateBranding>
            <oa:image id="corporateBrandingImage" source="/OA_MEDIA/FNDSSCORP.gif" shortDesc="Corporate Branding Image"/>
         </ui:corporateBranding>
         <ui:contents>
            <oa:defaultSingleColumn id="ResultsRN" headerDisabled="false" text="Views">
               <ui:contents>
                  <oa:defaultSingleColumn id="ViewRN" extends="/oracle/apps/icx/por/reqmgmt/webui/ReqStatusViewModeRN" headerDisabled="true"/>
                  <oa:spacer id="ResultsSpacer" height="15"/>
                  <oa:tableLayout id="TipTableLayout">
                     <ui:contents>
                        <oa:rowLayout id="TipRow" hAlign="start">
                           <ui:contents>
                              <oa:image id="BlueDot" source="changeditemicon_status.gif" shortDesc="Blue Dot Image"/>
                              <oa:spacer id="Spacer4" width="5"/>
                              <oa:staticStyledText id="Tip" prompt="Indicates requisition with a pending change request." styleClass="OraInstructionText"/>
                           </ui:contents>
                        </oa:rowLayout>
                     </ui:contents>
                  </oa:tableLayout>
                  <oa:separator id="VerticalSeparator"/>
                  <oa:table id="ResultsTableRN" extends="/oracle/apps/icx/por/reqmgmt/webui/ResultsTableRN" shortDesc="This table displays a listing of  requisitions, their creation date as well as status."/>
               </ui:contents>
            </oa:defaultSingleColumn>
         </ui:contents>
         <ui:productBranding>
            <oa:image id="BrandingImage" source="PORBRAND.gif" shortDesc="IP Product Branding"/>
         </ui:productBranding>
         <ui:copyright>
            <oa:messageStyledText id="Copyright" extends="/oracle/apps/fnd/framework/webui/OAFooter.CopyRight"/>
         </ui:copyright>
         <ui:privacy>
            <oa:link id="Privacy" extends="/oracle/apps/fnd/framework/webui/OAFooter.Privacy"/>
         </ui:privacy>
         <ui:pageStatus>
            <oa:tableLayout id="SearchButtonRG" extends="/oracle/apps/icx/por/reqmgmt/webui/ReqStatusViewPageNavigationRN"/>
         </ui:pageStatus>
      </oa:pageLayout>
   </jrad:content>
</jrad:page>
PL/SQL procedure successfully completed.

but on PROD instance, I am getting same error messages in the log attached.

Error.txt

[ErmanArslansOracleBlog]

Do you have this file?
$JAVA_TOP/oracle/apps/icx/por/reqmgmt/server/ReqMgmtAM.xml

[ErmanArslansOracleBlog]

Do you have customizations on this screen?

If so;

Check the profile option : "Disable Self-Service Personal" for site, application(Human Resource), responsibility and user level.
This should be set to "No"  if you have customizations.

If you have "No" for this profile option and if you have customizations on the problematic page, then set this profile option to YES on your user (user level) and bounce the APPS LISTENER.
Retry your failing operation. If you wont get any errors, then your customizations are wrong.

[Roshan]

Yes.

[applprod@erpprodapps server]$ ls -al ReqMgmtAM.xml
-rw-r--r-- 1 applprod applprod 16880 Sep 30 02:56 ReqMgmtAM.xml
[applprod@erpprodapps server]$ pwd
/u01/oracle/PROD/fs2/EBSapps/comn/java/classes/oracle/apps/icx/por/reqmgmt/server

ReqMgmtAM.xml

[Roshan]

I cannot set Disable "Self-Service Personal" to yes at user level. It is disabled. Only at site level I can do it. Do I set it at site level?

[ErmanArslansOracleBlog]

We can make enable it , but no need.
Set it in site level in a TEST environment and follow my action plan.

[Roshan]

We have set "Disable Self-Service Personal" to Yes on production instance and test instance. On production instance the requisition executed with no errors. Meaning there are errors in the customization?

[ErmanArslansOracleBlog]

Yes

29 Şub 2016 12:24 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

We have set "Disable Self-Service Personal" to Yes on production instance and test instance. On production instance the requisition executed with no errors. Meaning there are errors in the customization?

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Requisition-tab-error-tp603p622.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

[Roshan]

Thanks a lot for your help.
We deleted the personalization using exec  jdr_utils.deletedocument('/oracle/apps/icx/por/reqmgmt/webui/customizations/user/1566/ReqSummaryPG');

and the issue was resolved.