Infolinks

Showing posts with label R12 CHANGES IN AP. Show all posts
Showing posts with label R12 CHANGES IN AP. Show all posts

Saturday, 21 July 2012

Oracle R12.1 New Feature - Delayed Scheduling

Oracle R12.1 New Feature - Delayed Scheduling

Delayed scheduling is a new functionality in R12.1. A new profile is introduced for this functionality
Profile option: OM: Delay Scheduling = Yes
If the above profile is set to Yes then the scheduling of a line is performed only when the changes made are committed to the database, as opposed to simply navigating out of the line record.
Note: In fact, this new feature works only when the auto scheduling is done & the below profile is set.
Profile option: OM: AutoSchedule = Yes
This new feature enhances the overall performance of the sales order window, as only one MRP Call will be made during saving rather than individual MRP calls for each line.
So, for example if you have over 100 order lines and if we save after entering them then Scheduling of all the order lines happens at a single instance.

Oracle R12.1 New Feature - Cascade Header Changes to line

Oracle R12.1 New Feature - Cascade Header Changes to line

Before R12.1 the profile OM: Sales Order Form: Cascade header Changes to line only worked for one order at a time.
That means if a mass change on some sales orders is done, the cascading functionality did not work.
Example: if you do mass change on 10 sales orders by changing the payment term, the cascading of payment terms didn’t apply on the order lines, in fact we have to cascade the payment term changes for each order one by one.
R12.1 New functionality:
Profile option OM: Sales order Form: Cascade Header Changes to line is also applicable to the mass change functionality. So, changed values at order header level for multiple orders can be cascaded to the order lines.
The profile option didn’t change but, from R12.1 the profile option will also handle cascading for multiple orders.

OM: Sales order Form: Cascade Header Changes to line
Profile Option Values and their meaning
·         Ask me:        User will be prompted whether to cascade the changes to line level or not
·         Automatic:     Header changes are automatically cascaded to line level
·         Manual:         Header changes have to be manually cascaded to line level

Oracle BI publisher training with OA Frame work

Oracle BI publisher training with OA Frame work

You may have known different ways of generating the XML data while using the same RTF layout template. In this example, you will generate a BI Publisher report using OA Framework. In OA Framework, you do not need to use a data template or an Oracle Report to generate a BI Publisher report. Instead, the XML data is sourced from something known as view objects.

In this example, you will develop a very simple page with a button on it. When you click the Show BI Report button, the BI Publisher report will be displayed to the user on the screen. Behind the scenes, the following events will happen when the button is clicked:


1. Trap button click event The OA Framework page is attached to a controller class, and its method processFormRequest is executed when the button is clicked.
2. Retrieve data Inside the processFormRequest, you execute a query on a view object. A view object query retrieves the data from customer and invoice tables used in this example.
3. Generate XML In OA Framework, the view objects have a method named writeXML that can dump the entire data returned by their SQL Query into XML. Therefore, you invoke writeXML on the view object and its output is written to a byte output stream.
4. Generate PDF output The BI Publisher API named TemplateHelper.processTemplate is executed, to which the template name and result of writeXML() are passed as input parameters. 

The complete list of parameters passed to the BI Publisher API for this example is shown in Table 8-2.

Table 8-2: Parameters Passed to the BI Publisher API
Description: b24-bluearrowOpen table as spreadsheet
BI Publisher API Parameter
Value Passed
AppsContext
In OA Framework, the application module has a method that returns a handle to the current database session; using this, you can return the AppsContext object.
Template
The short code of the template, which in this example will be XX_CUST_INV_TEMPLATE.
Template Application Short Name
The application short name, which in this example is CUSTOM, but in your case will be the relevant custom application short name on your instance.
Data Input Stream
The XML generated using ViewObject.writeXML() is converted into byte array input stream, which is passed as parameter to the TemplateHelper API.
Language and Territory
The language and the locale, which you can get from the current OA Framework session using oadbtransaction.getCountry and oadbtransaction .getUserLocale.
Data Output Stream
A new ByteArrayOutput stream, which you create; the template helper API writes the BI Publisher output contents (PDF in this case) into the ByteArrayOutput. The byte array received from TemplateHelper is written into the ServletResponse of the user’s browser session. This makes it possible for the user to see the BI Publisher output.

5. Display PDF output The BI Publisher API returns a stream for PDF output, which is then redirected to the browser.

Oracle Apps R12 New Features Online training - Ship Confirm Message

Oracle Apps R12 New Features Online training - Ship Confirm Message

Order Management Ship Confirm Message Configuration feature provides a method to control how certain business rules are handled. It can be configured in such a way that they can be handled as errors or they can be handled as warnings at ship confirm stage.

Error messages will stop you from progressing, while a warning message will not.
Example:
We will learn this based on an example:
What are Roles for a user & how are Grants assigned to these users?

Roles: Shipping Execution provides data access controls called roles that control users' access to the Actions list and Tools menu in the Shipping Transactions form.

Grants: Roles are assigned to users using grants that control access to view or edit specific shipping data or actions.

Now create 2 Roles (MCU_Error_Role & MCU_Warning_Role) and 2 Users (ERROR_USER & WARNING_USER). Assign these roles to the corresponding users respectively.

Navigation:
OM ->Setup-> Shipping Setup>Grants and Role Definition>Define Roles

Create Role: MCU_Error_Role
The role is configured to error for Breaking Ship Sets for order lines at ship confirm.



Create Role: MCU_Warning_Role
The role is configured to just show a warning message and progress further for Breaking Ship Sets of order lines at ship confirm.



Create the following users:



Assign these two roles to the newly created users



When the users login individually and process an order they get the following message at the time of ship confirm:

This user is set up for Breaking Ship Sets to be an error, the below message displays with no option to continue.


A warning message is produced. If the user selects OK, the Delivery will be confirmed and the Ship Set Broken.



Conclusion: So, Based on the user who logged the application, a ship confirm message can be made either to error out or a just show a warning message to control the business flow.

Thursday, 7 June 2012

R12 General Ledger changes


General Ledger


1.1 New Tables

Table Name


Feature Area


FUN_SEQ_ASSIGNMENTS
Setup Forms and Programs
FUN_SEQ_CONTEXTS
Setup Forms and Programs
FUN_SEQ_ENTITIES
Setup Forms and Programs
FUN_SEQ_HEADERS
Setup Forms and Programs
FUN_SEQ_REQUESTS
Setup Forms and Programs
FUN_SEQ_RULES
Setup Forms and Programs
FUN_SEQ_VERSIONS
Setup Forms and Programs
GL_ACCESS_SET_ASSIGNMENTS
Setup Forms and Programs
GL_ACCESS_SET_NORM_ASSIGN
Setup Forms and Programs
GL_ACCESS_SETS
Setup Forms and Programs
GL_AUTOREV_CRITERIA_SETS
Journal Entry
GL_BC_PACKETS_HISTS
Budgets and related objects
GL_BUDORG_BC_OPTIONS
Budgets and related objects
GL_COA_MAPPINGS
Consolidation and Eliminations
GL_DEFAS_ACCESS_SETS
Setup Forms and Programs
GL_DEFAS_ASSIGNMENTS
Setup Forms and Programs
GL_DEFAS_RESP_ASSIGN
Setup Forms and Programs
GL_JE_INCLUSION_RULES
Setup Forms and Programs
GL_JE_LINES_RECON
Reconciliation
GL_JE_SEGMENT_VALUES
Journal Entry
GL_LE_VALUE_SETS
Setup Forms and Programs
GL_LEDGER_CONFIG_DETAILS
Setup Forms and Programs
GL_LEDGER_CONFIGURATIONS
Setup Forms and Programs
GL_LEDGER_NORM_SEG_VALS
Setup Forms and Programs
GL_LEDGER_RELATIONSHIPS
Setup Forms and Programs
GL_LEDGER_SEGMENT_VALUES
Setup Forms and Programs
GL_LEDGER_SET_ASSIGNMENTS
Setup Forms and Programs
GL_LEDGER_SET_NORM_ASSIGN
Setup Forms and Programs
GL_LEDGER_SET_REQUESTS
Setup Forms and Programs
GL_LEDGERS
Setup Forms and Programs
GL_LEGAL_ENTITIES_BSVS
Setup Forms and Programs
GL_MGT_SEG_UPGRADE
Other Issues
GL_MGT_SEG_UPGRADE_H
Other Issues
GL_SEG_VAL_HIERARCHIES
Setup Forms and Programs
GL_SEG_VAL_NORM_HIERARCHY
Setup Forms and Programs
GL_SUMMARY_BC_OPTIONS
Budgets and related objects

 

1.2 Changed Tables

The set_of_books_id column has been renamed to ledger_id in all tables with some exceptions as mentioned below.  All setups secured by definition access sets have a new security_flag column in the relevant tables. 
Table Name


Feature Area


Brief Description of Change


GL_ALLOC_FORMULAS
MassAllocations, Budgets and Encumbrances
Add currency_conversion_type to support foreign currency allocations
GL_AUTO_ALLOC_SETS
MassAllocations, Budgets and Encumbrances
Add chart_of_accounts_id, period_set_name and accounting_period_type to enable sharing of AutoAllocations across ledgers sharing the same chart of accounts and calendar
GL_AUTOMATIC_POSTING_OPTIONS
Posting
Add ledger_id to enable AutoPost across ledgers
GL_AUTOMATIC_POSTING_SETS 
Posting
Add chart_of_accounts_id, period_set_name and accounting_period_type to enable sharing of AutoPost Criteria Sets across ledgers sharing the same chart of accounts and calendar
GL_AUTOREVERSE_OPTIONS
Journal Entry
Add criteria_set_id to support AutoReverse criteria sets stored in the master table GL_AUTOREV_CRITERIA_SETS
GL_BALANCES
Balances and Related Objects
Add quarter_to_date_dr_beq, quarter_to_date_cr_beq, project_to_date_dr_beq and project_to_date_cr_beq to store entered ledger currency balances
GL_CODE_COMBINATIONS
Setup Forms and Programs
Add alternate_code_combination_id to support replacement for disabled accounts functionality implemented by Journal Import
GL_CONSOLIDATION
Consolidation and Eliminations
Add coa_mapping_id to enable consolidations to use chart of accounts mappings
GL_INTERFACE
Journal Import
Add ledger_id and retain set_of_books_id for backward compatibility
GL_JE_BATCHES
Journal Entry
Drop set_of_books_id and add chart_of_accounts_id, period_set_name and accounting_period_type to support batches containing journals for multiple ledgers sharing the same chart of accounts and calendar
GL_JE_HEADERS
Journal Entry
Add columns to store the accounting and reporting sequences
GL_PERIOD_STATUSES
Setup Forms and Programs
Add ledger_id and retain set_of_books_id for backward compatibility
GL_RECURRING_HEADERS
Recurring Journals and Budgets
Add currency_conversion_type to support foreign currency recurring journals
GL_SYSTEM_USAGES
Setup Forms and Programs
Add efb_upgrade_flag and reconciliation_upg_flag to track successfully completed optional post-update programs

 

2.3 Obsolete Tables

 

None of the obsolete tables have been dropped.  Some obsolete tables have been renamed with the suffix _11i.  Some obsolete tables are highlighted below.
Table Name


Feature Area


Replaced By


GL_IEA_AUTOGEN_MAP
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_CLEARING_ACCOUNTS
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_IMPORT_REGISTRY
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_INTERFACE
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_RECUR_BATCHES
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_RECUR_LINES
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_SEGMENT_MAP
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_SEGMENT_RULE_MAP
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_TRANSACTION_LINES
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_TRANSACTION_TYPES
Global Intercompany System
Advanced Global Intercompany System feature
GL_IEA_TRANSACTIONS
Global Intercompany System
Advanced Global Intercompany System feature
GL_INTERCOMPANY_ACC_SETS
Global Intercompany System
Advanced Global Intercompany System feature
GL_INTERCOMPANY_ACCOUNTS
Global Intercompany System
Advanced Global Intercompany System feature
GL_MC_BOOK_ASSIGNMENTS
Setup Forms and Programs
GL_LEDGER_RELATIONSHIPS
GL_MC_CONVERSION_RULES
Setup Forms and Programs
GL_JE_INCLUSION_RULES
GL_MC_REPORTING_OPTIONS
Setup Forms and Programs
GL_LEDGER_RELATIONSHIPS
GL_OASIS_FIN_ASSIGNMENTS
Financial Intelligence

GL_OASIS_FIN_ITEMS
Financial Intelligence

GL_OASIS_FIN_METRICS
Financial Intelligence

GL_OPEN_INTERIM
Balances and Related Objects
GL_POSTING_INTERIM
GL_SETS_OF_BOOKS
Setup Forms and Programs
GL_LEDGERS
GL_SHARES_ACTIVITY
Financial Intelligence

GL_SHARES_OUTSTANDING
Financial Intelligence

GL_SYSTEM_SETUP
Setup Forms and Programs
Relevant columns were moved to the GL: Number of formulas to validate for each MassAllocation batch, GL: Number of formulas to validate for each Recurring Journal batch and GL: Archive Journal Import Data profile options
GL_TRANSLATION_RATES
Revaluation, Translation and Conversion Rates
GL_DAILY_RATES
RG_DSS_DIM_SEGMENTS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_DIMENSIONS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_HIERARCHIES
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_HIERARCHY_DETAILS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_REQUESTS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_SEG_RANGE_SETS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_SEG_RANGES
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_SYSTEM_SEG_ORDER
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_SYSTEM_VARIABLES
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_SYSTEMS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_VAR_DIMENSIONS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_VAR_SELECTIONS
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_VAR_TEMPLATES
Financial Analyzer
Enterprise Planning and Budgeting product
RG_DSS_VARIABLES
Financial Analyzer
Enterprise Planning and Budgeting product

 

2.4 New Views

A number of new views have been added to support UIs and processing of new features.  Some of the views are mentioned below.
View Name


Feature Area


GL_ACCESS_SET_LEDGERS
Setup Forms and Programs
GL_ALC_LEDGER_RSHIPS_V
Setup Forms and Programs
GL_AUTOREV_CRITERIA_SETS_V
Journal Entry
GL_BUDGET_ASSIGNMENTS_UNIQUE_V
Budgets and Related Objects
GL_BUDORG_BC_OPTIONS_V
Budgets and Related Objects
GL_DEFAS_ASSIGNMENTS_V
Setup Forms and Programs
GL_DEFAS_RESP_ASSIGN_V
Setup Forms and Programs
GL_ENTERED_CURRENCIES_V
Balances and Related Objects
GL_HISTORICAL_RATES_PERIOD_V
Revaluation, Translation and Conversion Rates
GL_JE_LINES_RECON_V
Journal Entry
GL_LEDGER_LE_BSV_SPECIFIC_V
Setup Forms and Programs
GL_LEDGER_LE_V
Setup Forms and Programs
GL_LEDGER_NAMES_V
Setup Forms and Programs
GL_LEDGER_NORM_BSVS_V
Setup Forms and Programs
GL_LEDGER_SET_ASSIGNMENTS_V
Setup Forms and Programs
GL_LEDGER_SET_NORM_ASSIGN_V
Setup Forms and Programs
GL_LEDGER_SETS_V
Setup Forms and Programs
GL_LEDGERS_PUBLIC_ALL_V
Setup Forms and Programs
GL_LEDGERS_PUBLIC_V
Setup Forms and Programs
GL_LEDGERS_V
Setup Forms and Programs
GL_REC_BATCHES_LOV_V
Recurring Journals and Budgets
GL_SECONDARY_LEDGER_RSHIPS_V
Setup Forms and Programs
GL_SETS_OF_BOOKS
Setup Forms and Programs
GL_SUMMARY_BC_OPTIONS_V
Summarization
GL_SUMMARY_TEMPLATES_V
Summarization
GL_TRANSLATION_RATES
Revaluation, Translation and Conversion Rates

2.5 Changed Views

 

All views used to support Discoverer workbooks have been updated as necessary to uptake the data model changes.  Views that retrieve balances have been updated as necessary to retrieve entered ledger currency balances.  A large number of other views have also been updated to uptake various data model changes.  Some changed views are highlighted below.
View Name


Feature Area


Brief Description of Change


GL_SETS_OF_BOOKS_V
Setup Forms and Programs
Modify to refer to GL_LEDGERS instead of GL_SETS_OF_BOOKS
GL_TAX_CODES_V
Setup Forms and Programs
Modify to uptake new eTax data model



2.6 Obsoleted Views

 

A number of views related to Global Intercompany System and Oracle Financial Analyzer have been obsoleted.  Some other obsolete views are mentioned below.
View Name


Feature Area


Replaced By


GL_ALL_JE_CATEGORY_NAME_VIEW
Setup Forms and Programs

GL_ALLOC_BATCHES_ACTIVE_V
MassAllocations, Budgets and Encumbrances

GL_AUTOPOST_OPTIONS_CURRENT_V
Posting

GL_CONS_FLEXFIELD_MAP_HIGH
Consolidation and Eliminations

GL_CONS_FLEXFIELD_MAP_LOW
Consolidation and Eliminations

GL_JE_BATCHES_AP_V
Journal Entry

GL_JE_HEADERS_LOV_V
Journal Entry

GL_MC_BOOKS_ASSIGNMENTS_V
Setup Forms and Programs

GL_MRC_REPORTING_SOB_PROFILE_V
Setup Forms and Programs

GL_PERIOD_STATUSES_REV_BUD_V
Setup Forms and Programs

GL_TRANS_BUDGET_PERIODS_V
Revaluation, Translation and Conversion Rates

GL_TRANS_PERIODS_BSV_V
Revaluation, Translation and Conversion Rates

GL_TRANSLATION_RATES_CURR_V
Revaluation, Translation and Conversion Rates

GL_TRANSLATION_RATES_PERIODS_V
Revaluation, Translation and Conversion Rates

GL_TRANSLATION_RATES_V
Revaluation, Translation and Conversion Rates

GL_TRANSLATION_TRACKING_V
Revaluation, Translation and Conversion Rates

RG_REPORT_STANDARD_AXES_V
Financial Statement Generator