Tuesday, October 4, 2011

How to Create Or Modify A Payment Format Using XML Builder

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: R12: How to Create Or Modify A Payment Format Using XML Builder


Symptoms:
How does one create an XML file from Oracle Payments Funds Disbursement Payment Instruction Extract, Version 1.0 that can be loaded into the Template Builder to enable creation or modification of Payment Formats?


Solution:



1) Responsibility:
Funds Disbursement Setup Administrator
or
Payments Setup Adminstrator

Navigate to:
Oracle Payments Set Up main page > Formats - Formats - Go to Task
Create a new Format and attach the template "Extract Identity"
Data Extract = Oracle Payments Funds Disbursement Payment Instruction Extract, Version 1.0
Navigate to:
Oracle Payments Set Up main page > Payment Process Profiles - Go to Task
Create a Payment Process Profile (PPP) and assign the format you just created on the Payment Instruction Format tab.
2) Responsibility:
Cash Management
Query up an existing Bank Account
Select the account and click on the Manage Payment Documents button
Create a new set of Payment Documents and assign the format you created above.
3) Responsibility:
Payables
Enter an invoice, and validate/approve it.
Run the Accounting Process for the Invoice.
Create a new Payment Process Request (PPR) to pay the invoice.
Use the new PPP and set of Payment Documents that you created above.
The output for this PPR should be in XML format, and will include all the field tags generated by the Data Extract.
4) In Microsoft Word (or other Format editor):
Load the XML template file, then open the template that you wish to modify.
Select the fields from the extract that you wish to add to your template.
The new Template (when finished) can be attached to a new Payment Format which can be used on a new PPP and Payment Document.
________________________________________
Collaborate with and learn from your peers, industry experts and Oracle Support Product Specialists using the "My Oracle Support" Payables Community!
You can access the main Oracle Communities page at http://communities.oracle.com (If you are enrolled, the Payables community will be listed on your left. If you're not already enrolled in the Payables community, you can do so by clicking on the link Edit Subscriptions).

OR

from "My Oracle Support" as follows:

1. Log into My Oracle Support (Flash or Classic).
2. Click the "Community" link at the top of the page.
3. Click [Enter Here] on the following page.
4. Select the community from the "My Communities" list on the top-left


References:


R12: How to Create Or Modify A Payment Format Using XML Builder [ID 465389.1]

Get Oracle Certifications for all Exams
Free Online Exams.com

Format payment instruction "Electronic payment" does not contain amount in words for Total, i.e. InstructionTotals/TotalPaymentAmount/Value

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: Format payment instruction "Electronic payment" does not contain amount in words for Total, i.e. InstructionTotals/TotalPaymentAmount/Value

Solution:



1. Navigate to Payments Setup Administrator responsibility (or equivalent).
2. Oracle Payments Setup Main Menu > Codes > Payment Process Profiles row.
3. Click on the Go To Task icon.
4. Query up your PPP > click on the Update pencil icon.
5. Click on the Payment Instruction Creation tab.
6. Under Payment Grouping region, make sure that Payment Currency is checked.
7. Click on the Apply button to save your change.

References:

R12: How to Create Or Modify A Payment Format Using XML Builder (Doc ID 465389.1)


Get Oracle Certifications for all Exams
Free Online Exams.com

PLL compilation error after applying patch 9338767

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: PLL compilation error after applying patch 9338767

On : 11.5.10.2 version, Installation and Configuration

After applying the Patch 9338767, pll compilation error occurs for the following pll's

ERROR
-----------------------
au resource POXPOREL.pll
au resource POXAPAPC.pll
au resource POXPOEPO.pll
au resource POXPOPOL.pll
au resource POXSCSI2.pll
au resource POXPOPOS.pll


/u02/auts/autsora/8.0.6/bin/f60gen module=/u02/auts/autsappl/au/11.5.0/resource/POXPOREL.pll userid=APPS/***** output_file=/u02/auts/autsappl/au/11.5.0/resource/POXPOREL.plx modul
e_type=library batch=yes compile_all=special

ERROR generating library "resource/POXPOREL.plx" from input file
/u02/auts/autsappl/au/11.5.0/resource/POXPOREL.pll

-------------------------------------------------------------------------
PDE-PLI038 Cannot open file for use as a PL/SQL library.
-------------------------------------------------------------------------

Symptoms:

The issue can be reproduced at will with the following steps:
1. Apply patch 9338767
2. Try to compile get the pll compilation errors

Apply patch 9338767 to fix "an issue in iProcurement(FRM 40654 Error) which occurs when user tries to save a Requisition line containing spaces at the end of the free text (E.g Note to Agent) entered while creating requisition". Patch fails with PLL compilation errors.




Solution:



compilation error is due to the corruption


Open each PLL associated with the form one at a time from the forms builder to identify which PLL is causing the problem.
It worked after replacing this pll with a non-corrupted one from our instance.

Note 862614.1 PDE-PLI038 Cannot Open File For Use As A PL/SQL Library

References:

Note 862614.1 PDE-PLI038 Cannot Open File For Use As A PL/SQL Library

Note 412963.1 Patch 4676589 Failed to Generate Libraries and Forms with Error PDE-PLI038
Note 761944.1 Troubleshooting PDE-PLI038 during patch application or execution of f60gen


Get Oracle Certifications for all Exams
Free Online Exams.com

OPP process on node 2 is not starting, failing with error "Exception in thread "main" java.lang.NoClassDefFoundError"

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem: OPP process on node 2 is not starting, failing with error "Exception in thread "main" java.lang.NoClassDefFoundError"


Symptoms:
Database : 2 nodes RAC : HP Ux
Application server : 2 node Shared Application tier : Linux

we have configured OPP on both the nodes , on node 1 it is starting properly and on node it is giving below error.

Exception in thread "main" java.lang.NoClassDefFoundError: oracle/apps/fnd/cp/gsm/GSMSvcComponentContainer
Caused by: java.lang.ClassNotFoundException: oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
Could not find the main class: oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer. Program will exit.

Attached the log files.

Issue :

OPP on node 2 and workflow agent listener is not starting both are getting above error.

The below are the details of env variables on both nodes.
AF_JRE_TOP =/APPL_TOP/EZWT/apps/tech_st/10.1.3/appsutil/jdk/jre
AFJVAPRG = /APPL_TOP/EZWT/apps/tech_st/10.1.3/appsutil/jdk/jre/java.sh

Log files:



Solution:



AF_CLASSPATH variable needs to be set properly in $APPL_TOP/admin/adovars.env.

The correct value as per Note.332152.1 & Note.260393.1 is:

AF_CLASSPATH=[JDK_TOP]/lib/dt.jar:[JDK_TOP]/lib/tools.jar:[JDK_TOP]/jre/lib/rt.jar:[JDK_TOP]/jre/lib/i18n.jar:
$JAVA_TOP/appsborg2.zip:$ORACLE_HOME/forms60/Java:$JAVA_TOP

Steps to be followed:

Reset the AF_CLASSPATH variable value in $APPL_TOP/admin/adovars.env to include $JAVA_TOP/appsborg2.zip
Source the environment again to point AF_CLASSPATH to the right .zip file
Restart the concurrent managers

References:

Note.332152.1 & Note.260393.1


Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-25448: rule APPLSYS.WF_DEFERRED_QUEUE_M$1 has errors

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:
ORA-25448: rule APPLSYS.WF_DEFERRED_QUEUE_M$1 has errors
ERROR: ORA-025448 : rule APPLSYS.WF_DEFFERED$1 has errors
ORA-00911: invalid character
ORA-24033 no recipients for message


Solution:



ORA-25448: rule APPLSYS.WF_DEFERRED_QUEUE_M$1 has errors
ERROR: ORA-025448 : rule APPLSYS.WF_DEFFERED$1 has errors
ORA-00911: invalid character
ORA-24033 no recipients for message
• You can use the following to remove and add the subscriber and rule back into the WF_DEFERRED queue. You can also modify it to create a script to do the same for all the queues listed in wfmqsubc.sql/wfjmsqc2.sql.

You need to run this from the APPLSYS schema.

declare
lagent sys.aq$_agent;
begin
lagent := sys.aq$_agent('WF_DEFERRED',null,0);
dbms_aqadm.remove_subscriber(queue_name=>'WF_DEFERRED', subscriber=>lagent);
end;
/
commit;

declare
lagent sys.aq$_agent;
begin
lagent := sys.aq$_agent('WF_DEFERRED',null,0);
dbms_aqadm.add_subscriber(queue_name =>'WF_DEFERRED',subscriber=>lagent,rule=>'1=1');
end;
/
commit;

• You can use the following to remove and add the subscriber and rule back into the WF_DEFERRED_QUEUE_M queue. You need to make this a script and run it with the following parameters from the APPS schema:

sqlplus apps/apps @script name APPSusr.

declare
dequeue_timeout exception;
pragma EXCEPTION_INIT(dequeue_timeout, -25228);

subscriber_exist exception;
pragma EXCEPTION_INIT(subscriber_exist, -24034);

type subscriber_tbl_type is table of varchar2(30) index by binary_integer;

i pls_integer := 1;
l_new_queue varchar2(30);
l_wf_schema varchar2(200);
l_subscriber varchar2(30);
l_agent sys.aq$_agent;
subscribers subscriber_tbl_type;
match boolean;

begin

l_wf_schema := wf_core.translate('WF_SCHEMA');

l_new_queue := l_wf_schema||'.WF_DEFERRED_QUEUE_M';

-- Add the first subscriber to initialize the table
subscribers(i) := upper('&1');
l_agent := sys.aq$_agent(subscribers(i),'',0);
begin
dbms_aqadm.remove_subscriber(queue_name=>l_new_queue,
subscriber=>l_agent);
dbms_aqadm.add_subscriber(queue_name=>l_new_queue,
subscriber=>l_agent,
rule=>'CORRID like '''||subscribers(i)||'%''');

exception
when subscriber_exist then
null; -- ignore if we already added this subscriber
end;
end;
/


References:


Java Mailer and Other 11.5.9/OWF G Current Issues in Applications 11i [ID 260393.1]
Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-25228: timeout or end-of-fetch during message dequeue from APPLSYS.WF_CONTROL

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:
ORA-25228: timeout or end-of-fetch during message dequeue from APPLSYS.WF_CONTROL




Solution:



ORA-25228: timeout or end-of-fetch during message dequeue from APPLSYS.WF_CONTROL
• FROM BUG: 3268697

It just means that there is no message in WF_CONTROL queue. As long as GSC components are working fine, it shouldn't be a problem.


References:


Java Mailer and Other 11.5.9/OWF G Current Issues in Applications 11i [ID 260393.1]
Get Oracle Certifications for all Exams
Free Online Exams.com

Recreate/Validate WF AQ (The scripts lists the queues they create and its details). Please try using ADADMIN to compile the APPS Schema before trying any of the scripts

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:
Recreate/Validate WF AQ (The scripts lists the queues they create and its details). Please try using ADADMIN to compile the APPS Schema before trying any of the scripts.


Solution:



Recreate/Validate WF AQ (The scripts lists the queues they create and its details). Please try using ADADMIN to compile the APPS Schema before trying any of the scripts.

 sqlplus APPSusr/APPSpwd @wfquec2.sql APPSusr FNDusr FNDpwd

Example Syntax:
sqlplus apps/apps @$FND_TOP/patch/115/sql/wfquec2.sql apps applsys apps
 sqlplus APPSusr/APPSpwd @wfjmsqc.sql FNDusr FNDpwd

Example Syntax:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfjmsqc.sql applsys apps

OR

sqlplus APPSusr/APPSpwd @wfjmsqc2.sql FNDusr FNDpwd
sqlplus apps/apps @$FND_TOP/patch/115/sql/wfjmsqc2.sql applsys apps
 sqlplus APPSusr/APPSpwd @wfevquec.sql FNDusr FNDpwd WF_DEFERRED APPSusr

Example Syntax:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfevquec.sql APPLSYS APPS WF_DEFERRED APPS
OR

sqlplus APPSusr/APPSpwd @wfevquc2 FNDusr FNDpwd qname APPSusr retry delay retention
sqlplus apps/apps @$FND_TOP/patch/115/sql/wfevquc2 APPLSYS APPS WF_DEFERRED APPS 5 3600 86400
 sqlplus APPSusr/APPSpwd @wfmqsubc.sql FNDusr FNDpwd

Example Syntax:

sqlplus apps/apps @$FND_TOP/patch/115/sql/wfmqsubc.sql applsys apps
 sqlplus APPSusr/APPSpwd @afwfqgnt.sql APPSusr APPSpwd FNDusr FNDpwd

Example Syntax:

sqlplus apps/apps @FND_TOP/patch/115/sql/afwfqgnt.sql apps apps applsys apps


References:

Java Mailer and Other 11.5.9/OWF G Current Issues in Applications 11i [ID 260393.1]


Get Oracle Certifications for all Exams
Free Online Exams.com