Unable to reverse budget journal after upgrade

Unable to reverse budget journal after upgrade 

+---------------------------------------------------------------------------+
General Ledger: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

GLPREV module: Reverse Journals
+---------------------------------------------------------------------------+

Current system time is 30-JUN-2015 12:17:21

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


>> glprgi() 30-JUN-2015 12:17:21

PREV0005: Invalid reversing period Jan-15



<x glprgi() 30-JUN-2015 12:17:21
SHRD0014: GLPREV - process exiting with failure.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

Output file size: 
0


Output is not being printed because:
The print option has been disabled for this report.


Finished executing request completion options.


Deleting output file.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 30-JUN-2015 12:17:21

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

APPLIES TO:
Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Nov-2013*** 

GLPREV module: Reverse Journals



SYMPTOMS

When attempting to reverse the Posted Budget Journals ,
the following error occurs.

ERROR
-----------------------
Error PREV0005: Invalid reversing period

The steps to reproduce the issue:

The issue can be reproduced at will with the following steps:
1.Create Budget Versions with 6 years duration starting from Current
Financial Year and require journals
2.Open all the 6 years of budget versions
3.Download General Ledgers -Journals Web ADI with Budget Journals - Multiple
Layout
4.Fill 6 years budget and Upload
5.Post all 6 years budget.
6.Reverse all 6 years budget.
7.Only the current year budget can be successfully reverse and the rest of
it fail

The customer has received the following error while running GLPREV module:
Reverse Journals for six years in advance :
PREV0005: Invalid reversing period APR-20xx
The error occurs in glprev.lpc

CAUSE

This works fine if the periods have status of Open or Future enterable.
For budget journals, the program, GLPREV is checking for open or future status for reversal period causing the error. These periods has a status of 'Never Opened' causing, Error PREV0005: Invalid reversing period.

SOLUTION

To implement the solution, please execute the following steps::

1. Download and review the readme and pre-requisites for the relevant patch to get on the latest version of the code.

For 12.0.x apply Patch:13400286:R12.GL.A
Note: If a password is required to download this patch, please open a service request to get the proper password.

For 12.1.x apply Patch:11830885:R12.GL.B

2. Apply the patch in a test environment.

3. Follow any post-installation requirements, including stopping and restarting Apache

4. Confirm the following file versions:

For 12.0.x - glprev.lpc 120.26.12000000.11
For 12.1.x - glprev.lpc 120.27.12010000.9

5. Retest the issue. If the issue is resolved, migrate the solution to other environments as appropriate.

Oracle E-Business Suite 12.2.4

 Features of Oracle E-Business Suite 12.2.4

Oracle E-Business Suite 12.2.4 Helps Organizations Further Optimize Business Processes, Reduce Costs, and Respond to Changing Market Conditions.
This Release includes and focus on customer-driven enhancements across virtually all functional areas and new cloud integrations

Also, this Release Update Pack (RUP) for the EBS 12.2 release codeline includes new features as well as statutory and regulatory updates, and error corrections for stability, performance, and security.

Some of the introducing enhancements listed as below:

Oracle Financials: Faster approval cycles from parallel approval of invoices. A single mass allocation formula is used to generate allocation journals for all ledgers in a ledger set. Integration with Oracle Revenue Management Cloud allows users to leverage the revenue compliance and recognition benefits of that product.

Oracle Lease :The following features of Oracle Lease and Finance Management have been added or changed

Enter Interim Payments for Assets, Fees and Services

Author Contracts with New and Re-Leased Assets

Author Variable Rate Contracts with Additional Interest Rate Conventions

Update Default Asset Salvage Values

Revise Variable Rate Contracts

Enhanced Security Deposit and Contract Termination Processing

Enhanced Pass Through Processing for Fees and Services

Oracle Projects: Enhancements includes Oracle Project Contracts and Oracle Project Billing allow US federal contractors to improve cash flow, increase transparency and audit, and automate billing.

Oracle Purchasing: Web ADI–enabled spreadsheet creation and modification of purchase order lines, schedules, and distributions improves buyer productivity when dealing with large orders.

Oracle iProcurement: A streamlined single-step checkout flow allows employees to quickly complete shopping activities and start the requisition approval process.

Oracle Procurement Contracts: Improved buyer efficiency from auditing of contract documents by reviewing details of policy deviations and net clause additions.

Oracle Services Procurement: Enhanced capabilities provide buyers with greater flexibility to support a broad range of complex order scenarios.

Oracle Channel Revenue Management: Improved volume offer capabilities and a streamlined user interface enable users to quickly adapt to changing business conditions.

Oracle Order Management: A new HTML user interface provides improved usability, greater flexibility, and a more modern user experience.

Oracle Yard Management: A new solution enables manufacturing, distribution, and asset-intensive organizations to manage and track the flow of trailers and their contents into, within, and out of the yards of distribution centers, production campuses, transportation terminals, and other facilities.

Oracle Manufacturing: Significant usability improvements in the Oracle Manufacturing Execution System (MES) help improve operator productivity by simplifying time entry and quality collection. New capabilities to manage the auto-dekit (disassembly) of serialized products supports customer returns and internal reuse of component parts.

Oracle Enterprise Asset Management: Enhancements to support linear assets in industries, such as oil and gas, utilities, and public sector, help improve productivity and retire costly integrations and custom code.

Oracle Service: Enhanced spare parts planner’s dashboard provides rich user interaction to improve planner productivity.

Oracle Value Chain Planning: Numerous enhancements across multiple products include deeper industry functionality, such as minimum remaining shelf-life enhancements for the pharmaceutical and consumer goods industries, multistage production synchronization for process industries, and integration between Oracle Service Parts Planning and Oracle Enterprise Asset Management for asset-intensive industries. New promotions planning analytics in Oracle Advanced Planning Command Center improve business insight.

Oracle Payroll: Payroll dashboard provides at-a-glance readiness checks, validation, and analytical views of the entire payroll cycle to help payroll administrators gain valuable insight into payroll processes, avoid costly errors, and improve productivity.

Oracle Self-Service Human Resources: Transaction dashboard helps employees and managers monitor the approval progress of self-service transactions, and review transaction details at any point after final approval.

Oracle Learning Management : Enhanced user interface simplifies the learner’s ability to search the training catalog, engage in learning activities, and share experiences with fellow learners.

The details for downloading and applying the Oracle E-Business Suite 12.2.4 Release Update Pack can be found in the Oracle E-Business Suite Release 12.2.4 Readme (Doc ID 1617458.1).

How to Create Menu in Oracle Apps

Oracle E-Business Suite  > Sysadmin

How to Create Menu in Oracle Apps

In this article I will explain how to create menu in Oracle Applications. Menu is attached with the responsibility to access the certain functions and sub functions.

the process of creating function and sub-function is same.

Navigation: Sysadmin > Application > Menu

You can also create menu by using Shift + F5 Functionality that is explained in Creating responsibility article.

Query any existing menu 

Click on new to create new menu.

Enter the menu Code in "Menu" Field

Then Enter User Menu Name as this name will show in the LOV for attaching menu to a responsibility.

Select Menu Type

Enter Description.

Enter the Prompt it will show in the responsibility.

Select Sub Menu 

Select Functions that is required.

Enter the description

Press Save button to save the work.

Copy the menu name

Attach the Menu with responsibility.

How to Create Responsibility in Oracle Apps

Oracle E-Business Suite  >Oracle Sysadmin

How to Create Responsibility in Oracle Apps

In this Article I will explain how to create new responsibility in Oracle Apps through system administrator (Sys admin).

For creating new responsibility we will copy the responsibility content from the responsibility that already create. For Example you want to create purchasing responsibility you can create it from " Purchasing , Vision Operations (USA)" or any purchasing responsibility.

I will explain very easy steps in which you can create new responsibility by using (Shfit + F5) key Combination.

Navigation:Sysadmin > Security > Responsibility > Define

Click on responsibility button to open the window.

First Navigate the responsibility from you want to copy and create you own responsibility.

Click on Torch to find the existing responsibility.

Select the existing responsibility.

Press Ok

Press New button to create the new responsibility.

The Blank Screen will appear where you need to enter all the information to create your responsibility like Name, application, responsibility key etc.

Enter the name of Responsibility Like " Apps Purchasing super User"

Then Press Tab

Then Press (Shift + F5) , Application name will automatically selected.

Then Press Tab.

Then Press (Shift + F5) , Responsibility Key will automatically selected. You just need to add anything to change the name of key as this is unique key so Just put (_1) at the end of existing key.

Then Press Tab.

Then Press (Shift + F5) 

Repeat this untill all the required fields are created. You need to Select  Data Group , Request Group and Menue.

Note: You can use your own Menu with the responsibility , next post  I will explain how to create menu.

For more details please visit http://www.oracle.com/

                                                 http://docs.oracle.com/

Setting Up Profile Option in Oracle Apps

Oracle E-Business Suite  >Oracle Sysadmin

How to Set Systems Profile Options in Oracle Apps

In this article I will explain how to set profile options (System Profile options) for any responsibility or user or on any level.

Navigation:Sysadmin >Profile > System

How to Set Profile Option in Oracle Apps

Click on System to open the window

How to Set Profile Option in Oracle Apps

You can set the profile options on different level as per your requirement.

Select the level or levels for which you want to set the profile option. The levels available are as follows:

Select the Responsibility to setup profile options

Then select the Profile option from the list of value. Mostly for module configurations following profile options are used.

• HR:Business Group
• GL Ledger
• MO: Operating Unit
• MO: Default Operating Unit
• HR: Security Profile
• MO: Security Profile

Select the Business Group for profile HR: Business Group Value

Select the profile value at Site level or responsibility level.

Site Level : Across instance

Responsibility Level : Only for selected responsibility.

Press Save Button to save the work.

For more details please visit http://www.oracle.com/

                                                 http://docs.oracle.com/

How to create new User in Oracle Apps

Oracle E-Business Suite  >Oracle Sysadmin

Create a New User in Oracle

Responsibility: System Administrator

Navigation: Security > User > Define

Create User in Oracle Apps

Navigate to the User creation window

Create User in Oracle Apps

Enter User Name Like " APPS USER1"

Enter password - ( Enter passward and press tab and then re-enter the same password)

Select the person from the list of values - This person is employee and attached with the user that you are going to create.

Enter Customer, Supplier , E-Mail  and Fax optionally enter.

Then Click on Responsibilities to add responsibilities.

Select the required responsibilities and Press OK.

You Can grant the access for limited period by entering effective date and entering days.

For more details please visit http://www.oracle.com/

                                                 http://docs.oracle.com/

Define Location in Oracle Apps

Oracle E-Business Suite  >Oracle HRMS

Define Location in Oracle Apps

I will explain how to create location in Oracle R12.

Navigation: Human Resource > Work Structure > Location

Define Location in Oracle

Click on the Location 

Define Location in Oracle

Enter the Location Name

Select the Address Style for the Location address. You can create your own location address style earlier I have explain how to create location style DFF.

Complete the location address with all required information and press OK.

Save the work.

Define Location in Oracle

Click on Shipping Details

Define Location in Oracle

Select the Check boxes as per the requirement.

Then save the work

For more details please visit http://www.oracle.com/

                                                 http://docs.oracle.com/

Defining Legal Entity in Oracle Apps : Oracle General Ledger

Oracle E-Business Suite  >Oracle Financial> Oracle General Ledger (GL)

Defining Legal Entity in Oracle Apps 

I will explain here how to create legal entity (LE) in Oracle Applications.

Define Legal Entity in Oracle Apps

Navigation: GL >Setup > Financials >Accounting Setup Manager > Accounting Setup

Define Legal Entity in Oracle Apps

Click Accounting Setup Tab

Define Legal Entity in Oracle Apps

Click on Legal Entity Tab

Define Legal Entity in Oracle Apps

Click on Create Legal Entity button to create.

Define Legal Entity in Oracle Apps

Enter Territory 

Enter Legal Entity Name

Enter Organization Name

Enter all the required fields

Select the Address 

Then Press Apply..

Define Legal Entity in Oracle Apps

Enjoy!!! Legal entity is created.

For more details please visit http://www.oracle.com/
                                                 http://docs.oracle.com/

How to Define Business Group in Oracle Apps

Oracle E-Business Suite  >Oracle HRMS

Defining Business Group in Oracle Apps

In this article I will explain how to define business group in Oracle applications.

Navigate: Human Resource>Work Structure>Organization > Description

How to Define business group in Oracle apps

Click on " New (A)" Tab

Enter the business group name and assign the location created in the previous step and save the changes

How to Define business group in Oracle apps

Enter the busniess Gourp Name

Select " Business Group" in Type

Enter Date From 

Select the Location

Save the work before proceed.

How to Define business group in Oracle apps

How to Define business group in Oracle apps

Select business Group in Organization Classifications and Check the Enable check Box and save your work.

Select the Business Group Info value from the List of Values and Press OK Button to proceed.      

How to Define business group in Oracle apps

Enter all the mandatory information in the fields.

Select the Key Flex Field as 

• Grade Flexfield
• Group Flexfield
• Job Flexfield
• Costing Flexfield
• Position Flexfield
• Competence Flexfield

You need to create all these key flexfield before creating Business Gourp. 

Click OK Button, then you will be prompted to save the changes. Press on YES button. The details will get saved.

How to Define business group in Oracle apps

For more guidance please write _____________

For more details please visit http://www.oracle.com/

                                                 http://docs.oracle.com/