Parameters that affect the session timeout functionality of forms.

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:     parameters that affect the session timeout functionality of forms


Solution:

Basically there are three parameters that affect the session timeout
functionality of forms.

1.FORMS60_TIMEOUT
2.heartbeat
3.session.timeout (zone.properties)

For example
Say you want the timeout to happen after 3 hours.

In this case you should set the FORMS60_TIMEOUT to 3 hours. i.e., 180 minutes and heartbeat to more than 3 hours, 185 minutes.

In this case the heartbeat will occur after the duration of the timeout causing a Form di
sconnect to occur.

If you never wish for the timeout to occur, then you should accomplish the
following:
Set the FORMS60_TIMEOUT to 180 minutes and heartbeat to 60 minutes.
In this case heartbeat will send the request to the 60 minutes to tell that the
client
session is alive and the FORMS60_TIMEOUT will reset to 180 minutes after the
heartbeat ‘ping’ is received. In this way the timeout end time will never be reached unless a
client session abnormally aborts.

Note that you can also specify a timeout setting for idle connections in the
zone.properties file.

Get Oracle Certifications for all Exams
Free Online Exams.com

Unable to generate a document number for a manual receipt

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:     Unable to generate a document number for a manual receipt

Solution:

1. Upload detailed screnshots with the receipt class and method setup, document sequence, category and assignment.

There is a common problem that when you RENAME a receipt method, the document sequence category is not updated.

When you create a new receipt class and method, Receivables automatically insert a document category - which you can find in system administrator - application - document - category.

The receipt method NAME = document category CODE

But this category CODE becomes READONLY - as it works like a primary key and gets referred by other tables.
On the other hand, in Receivables you can rename the receipt method NAME - because in Receivables the receipt method ID is used in forms.
Due to the fact that the category code cannot be updated, there is no available internal API function to do that so the AR development can't propagate the change.

Get Oracle Certifications for all Exams
Free Online Exams.com

How to get the current patchset level for PSB

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:     How to get the current patchset level for PSB

Solution:

select substr(aa.application_short_name,1,20) "Product", a.patch_level
"Patch Level" from fnd_product_installations a, fnd_application aa
where a.application_id = aa.application_id
and aa.application_short_name like '%PSB%';

select substr(aa.application_short_name,1,20) "Product", a.patch_level
"Patch Level" from fnd_product_installations a, fnd_application aa
where a.application_id = aa.application_id
and aa.application_short_name like '%PSA%';

Get Oracle Certifications for all Exams
Free Online Exams.com

Create Budget Revisions - Unable to Open form ORA-01403: no data found, FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502.

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:    Create Budget Revisions - Unable to Open form  ORA-01403: no data found, FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502.


On 12.0.6 in Production:
When trying to create a budget revision,
the following error occurs:

ERROR
-----------------------
ORA-01403 : no data found.
FRM-40735 : when button pressed trigger raised unhandled exception ORA-06502


Symptoms:
The issue can be reproduced at will with the following steps:
1. PSB responsibility--Budget Revisions--Define.
2. Query the existing budget revisions--Get the error.



Solution:

1. Please download and apply Patch 8635281:R12.PSB.A on a test instance on which the issue can be reproduced.
2. This patch provides the latest roll up patch for PSB.
3. After patch application, bounce the apache and applications and retest the issue.
There is a number of issues fixed on the latest PSB roll up patch provided by Patch 8635281.
Users need to apply the latest roll up patch to get the latest form version. Applying the latest roll up patch for PSB resolved the issue for user.

This is also mentioned in the following bug for the roll up patch:
Bug 8635281 PUBLIC SECTOR BUDGETING ROLLUP PATCH - JUL 2009.

References:

Bug 8635281 PUBLIC SECTOR BUDGETING ROLLUP PATCH - JUL 2009.

Get Oracle Certifications for all Exams
Free Online Exams.com

Worksheet operations - Freeze / unfreeze options

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:     Worksheet operations - Freeze / unfreeze options

Symptoms:
We are using the standard menu ps budget user for users and ps budget super user for super users.

In the ps budget user menu , the freeze and unfreeze worksheet options have been enabled. Eventhough enabled the users are unable to perform the operations. The options are frozen and not available for selection

Log into PS Budget user responsibility. Select any worksheet and try to select freeze / unfreeze option



Solution:


When a parent budget group moves a worksheet to the next budget stage, both the parent and child worksheets are frozen. The parent budget group must unfreeze its own worksheet before making any modifications to the worksheet. The parent budget group can unfreeze the child worksheets by redistributing the worksheet.

The current funcitionality we are enconutering is contrary to what documentation says. When a worksheet is moved to next stage , only the next level in the hierarchy can unfreeze.

Get Oracle Certifications for all Exams
Free Online Exams.com

ORA-04063: package body "APPS.PSB_GL_INTERFACE_PVT" 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-04063: package body "APPS.PSB_GL_INTERFACE_PVT" has errors
On 12.0.6 in Production:
When attempting to Approve the Budget revisions workflow then system showing
the following error occurs:

ERROR
-----------------------
To SYSADMIN
Sent 04-Nov-2009 09:14:55
ID 18070


An Error occurred in the following Workflow.

Item Type = PSBBR
Item Key = 235
User Key =1001

Error Name = -4063
Error Message = ORA-04063: package body "APPS.PSB_GL_INTERFACE_PVT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PSB_GL_INTERFACE_PVT"
Error Stack =
PSBBR.Post_Revisions_To_GL()
Wf_Engine_Util.Function_Call(PSB_SUBMIT_REVISION_PVT.POST_REVISIONS_TO_GL, PSBBR, 235, 210932, RUN)

Activity Id = 210932
Activity Label = SUBMIT_REVISION:POST_REVISIONS_TO_GL-1
Result Code = #EXCEPTION
Notification Id =
Assigned User =

Symptoms:
The issue can be reproduced at will with the following steps:
1. Create a budget revision and approve the budget revision



Solution:

To implement the solution, please execute the following steps:
1) Please download and review the readme for Patch.7639620.
2) Please apply Patch.7639620 in a test environment.
3) Please confirm the following file versions:
PSBVOGLB.pls 120.24.12000000.13
psbotgl.odf ----------120.0.12000000.5

4) Please retest the issue.

Get Oracle Certifications for all Exams
Free Online Exams.com

Is it possible to personalize by changing the mandatory field 'Title' to a different name on negotiation creation page?

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: Is it possible to personalize by changing the mandatory field 'Title' to a different name on negotiation creation page? Symptoms: I want change the title field name but the personalization not working with this field Solution: There is no standard way to do this. Only option would be to use customizations. You may engage Oracle consulting services for this. You may only personalize fields that are not mandatory. Title is a mandatory field and as such cannot be personalized.

Get Oracle Certifications for all Exams
Free Online Exams.com