XML publisher Reports in Oracle apps – Unable to find the published output for this request

I got the above error and I was checking the report and RTF template both was fine but still I was not able to figure out what went wrong and then checked the Concurrent everything seeemed to be fine. But still I was not able to figure out.

Then while submitting the report I noticed the Layout was not captured. So I checked the name of deployed concurrent short name and Data Definition name and both are correct. Then I checked the style required and then the layout was captured. I compared with the working reports style checked was not there. However this actually Issue raised due to change of Text report to XML report.

 

General Checklist of reports not published in Oracle apps XML Publisher reports

When we have problem in XML reports we can check whether XML is correct and layout is correct. We can do that by submitting the report and from diagnostics we can take output of XML and compare.

In development we can generate file to XML and cross verify

In XML Based report when we do have correct XML data and correct RTF Layout still we are facing problem we have to check that deployed concurrent short name and Data Definition name are correct.

Still facing the problem we have check the Concurrent output as XML and also Style is required.

General Checklist in XML Reports when there is no output.

1.XML data and RTF Template

2. Deployed concurrent short name and Data Definition name

3. Data Definition name and Template name in XML Publisher Administrator

3. Concurrent output as XML and also Style is required.

 

Share your thoughts

 

Process for Reversal of Payroll when Journal is Posted

We had a Issue that HR was testing Payroll for a user but unfortunately Finance had done costing and they have posted to GL.

I had many things running in my mind that whether we will be able to roll back all the process or what can be done to resolve this as Finance has posted and it should be also reversed. After that with help of my collegue we have done this.

Reversal in HRMS allows to reverse the Entries in Costing which nullifies the amount.

Example :

Basic Salary Pay Value 01.00.00000.000.32110.000.0000.0000 Credit

In the above table the first one which will be as credit to Employee. So once we done reversal and costing we will get the record as below so Now the credit amount and debit amount gets nullified

Basic Salary Pay Value 01.00.00000.000.32110.000.0000.0000 Debit

Only reversal can be used after post payroll process and retry will not work after post payroll process. The steps are as follows.

Step 1: Reversal of the Payroll

Select the employee whom we have to rollback/reverse

Nav : Fastpath –> Reverse Payroll Run –> Select the Employee –
Check the Employee and the reversal as shown below

Step 2: Make sure the Reversal has applied.

Global HRMS Manager –> View –> Assignment Process Results

 

Step 3 : Check the Costing Detail Report whether there is a reflection

select * from pay_costing_details_v where effective_date between :p_frm_date and :p_to_date and EMPLOYEE_NUMBER = ‘005225’

Step 4 : Costing process.

As costing entries were not yet created not we have costing process.

So run the costing process

Step 5: Check the Costing Detail Report

Once Costing Process is done now check the reverse of the entry has been created.

Cross check the same using costing detail report or by the below query

select * from pay_costing_details_v where effective_date between :p_frm_date and :p_to_date and EMPLOYEE_NUMBER = ‘005225’

Step 6: Transfer to GL process

Once this is done run transfer to GL process

Step 7: Import the Journal

Go to General Ledger and Import the Journal

General Ledger –> Import  –> Run

Step 8: Validate the journal entries and post it.

   

Oracle EBS – Changing Main Form’s Heading – Site Name Profile Option

Shivmohan Purohit's Oracle ERP BLOG

Many a time you want to change the Main window’s heading to show purpose of instance or any special info etc….

Set the profile option: to your needs and log in/out of Applications to pick up the changes.‘Site Name’

image

image

View original post

Providing Workflow Administrator Access to Users in Oracle Apps

To provide Workflow Administrator Access we should have SYSADMIN access.

Step 1: Login as SYSADMIN in oracle Applications

Go to Workflow Administrator Web Applications –> Administration –> Administrator Workflow

Now select the user whom the access has to be given


Once user is selected then click on Apply button. Once done you will get the above screen

Test it by going logging in as the user and go to the below path

Workflow Administrator Web Applications –> Administration –> Status monitor

Here you will see your user name is not restricted.

Thank you.

 

Unable to reserve the .lok file for Integrated WebLogic Server (IntegratedWebLogicServer) in Jdeveloper

If you face the error Unable to reserve the .lok file for Integrated WebLogic Serve then the first is you have to kill the process in Task Manager. Open Task Manager & check for java.exe process for higher memory consumption. End the process.

IF above does not help then go to C:\Users\RRA\AppData\Roaming\JDeveloper\system11.1.2.1.38.60.81\DefaultDomain . Delete the edit.lok file.

This error happens due to JDeveloper closes unexpected without shutting down IntegratedWebLogicServer

Thanks

Source

Environment Sourcing of Oracle apps in Windows

As most of the DBA’s prefer Linux Environment for Oracle apps. However some due to other support may go to windows. So as a developer perspective they have to navigate to different application which are called as tops for example $AU_TOP. However in windows to access this we have to do a step called Environment Sourcing in windows command to access the top.

So in order to do it. First we have to find out the environment variable file which will be installed during Installation and configuration time.

cd E:\test\testappl
envshell.cmd

Now once invoked the “envshell.cmd” code then we will be able to access the Application top.

Now try to go to AU_TOP by giving the below command

E:\test\testappl>cd %AU_TOP%

E:\test\testappl>cd %FND_TOP%

Thank you

 

FRM-92120 Registry.dat is missing

We have changed the IP address of the servers and then we checked in the server the forms was working. But when we checked in the system it was not working. We got a error as shown in the below screenshot.

After I checked the below steps helped me

Step : 1 Clearing Java cache:
Go to Control Panel |Java | General Tab | Temporary Internet Files > Settings…. > Delete Files… A popup with two item should be checked (Applications and Applets and Trace and Logfiles).  Leave the items selected and click OK.

Step : 2 Clearing IE cache:
Go to Tools | Internet Options > in the General tab under Browsing history, select Delete… and delete Temporary Internet files, Cookies and History.

 

App-Pay-33238: Error PTO_CARRY_OVER_FF Opening Absence Form – system cannot calculate accruals for this date because the employee’s payroll did not exist

As we this error in with our  and when I checked in oracle support I got this document number Doc ID 418621.1

 

When attempting to access the absence screen the following error occurs as per the below screenshot

Error:
APP-PAY-33238 An error has occurred in a user defined
function at line 65 of the formula PTO_PAYROLL_CARRYOVER.
The error text associated with the function call is: The
system cannot calculate accruals for this date because the
employee’s payroll did not exist for the full accrual term…

Please correct the problem with the function call, or
contact your system administrator or support representative.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:

Responsibility: XX HRMS Manager
1. People > Enter and maintain > Other Button
2. Choose the absence option

Cause

The payroll period needs to be extended. This is explained in the error message shown.

Solution

To implement the solution, please execute the following steps:

1. Go into a HRMS responsibility.

2. Navigate to Payroll > Description.

3. Extend the value in the number of years field as shown in the below screenshot.

4. Retest the issue.

5. Migrate the solution as appropriate to other environments.