Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Module-Specific Information

NoetixViews for Oracle General Ledger

In Oracle E-Business Suite Release 12, the term “set of books” has been replaced by “ledger”. The terms “set of books” and “ledger” refer to the same concept. Also, in Release 12, the term “base currency” has been replaced with “primary currency” and the term “foreign currency” has been replaced with “transaction currency.”

The Noetix business views and pre-built answers for Oracle General Ledger provide a reporting solution for the major aspects of this Oracle E-Business Suite module, such as finding information about the journal entries entered corresponding to the actual, budget, and encumbrance transactions, and reviewing account balances. These views also provide setup information about summary accounts, accounting hierarchies, and budget organizations.

The following sections provide an overview of NoetixViews for Oracle General Ledger.

Support for Subject Areas

Noetix views for General Ledger can be mainly categorized into the following subject areas:

  • Journals

  • Balances

  • Budgets

  • Subledger distributions

  • Other areas

Journals

Noetix views that return information about journals provide information about actual and encumbrance journal batches, journal entries, and journal entry lines. In these views, for actual journals, the information is available in the primary, transaction, and statistical currencies. For encumbrance journals, the information is available in the primary currency.

To view the actual journal entry line information in the primary currency, use the GL Journal Entry Lines view. To view the actual journal entry line information in all currencies, use the GL All Je Lines view.

One of the reporting scenarios where these views can be helpful is for finding information about journal entry lines, journal entries, or journal batches that have been not posted for the current period. Another reporting scenario is to find the journal entries and journal entry lines of a journal batch entered in the transaction currency.

Balances

Noetix views that return information about balances show the detail and summary balances.

The detail balance views provide information about actual balances, budget balances, encumbrance balances, and balance comparison for detail accounts. The actual and budget balances are available in the primary, transaction, and statistical currencies; encumbrance balances in the primary currency; and balance comparison in the primary and statistical currencies. Balance comparison views provide comparison between the budget and actual balances and between the budget, actual, and encumbrance balances. Balance views also provide information about funds available for the summary and detail accounts in the primary and transaction currencies.

The summary balance views provide information about the actual balances of the summary accounts in the primary currency and the balance comparison for the summary accounts in the primary currency. The rollup account and budget balance views provide summarized actual and budget balances respectively of detail accounts grouped by the natural account and balancing account segments in the primary currency. The rollup parent balances and rollup parent budget views provide the rollup actual and budget balances of all the child or detail accounts corresponding to a parent account in the primary currency.

To view the actual balance information in the primary currency, use the GL Balances view. To view actual balance information in all currencies, use the GL All Balances view.

Some reporting scenarios where the balance views can be helpful are for finding information about the:

  • Debt-to-equity ratio

  • Working trial balance for a period

  • Return on total assets for a year

  • Revenue and expenditure balances for a given period

Budgets

Noetix views that return information about budgets provide details of budget names and budget organizations. These views also provide information about actual balances, budget balances, and balance comparison associated with the budget organizations for the summary and detail accounts in the primary currency.

Some reporting scenarios where the budget views can be helpful are for finding information about the:

Variance balance for a budget organization in an accounting period

Return on total assets for a year

Subledger Distributions

Noetix views that return information about subledger distributions provide details of journal entry lines sourced from the accounting event of transaction distributions. These transaction distributions include Oracle Payables invoices and invoice payments; Oracle Receivables transactions, Receivables adjustments, Receivables standard receipts, Receivables miscellaneous receipts, purchase order (PO), and requisition encumbrances; and blanket purchase agreements, PO encumbrances, and requisition encumbrances that have been transferred to General Ledger.

Some reporting scenarios where the budget views can be helpful are for finding information about the:

  • Journal distributions details of standard receipts for an accounting period

  • Journal distributions of invoices for an accounting period

  • Journal details for PO distributions of a department or account in an accounting period

For more information about subledger distributions, see NoetixViews for Oracle Subledger Accounting.

Other Areas

Noetix views that come under this category include views that return information about:

Journal entries imported from subledgers, such as Payables, Purchasing, and Receivables. The views that return the information about journal entries include the word “Import” in them. For example, GL Import Journals.

The chat of accounts defined in Oracle E-Business Suite. The view that returns this information is GL Chart Of Accounts.

The detail accounts that roll up to the summary accounts. The view that returns this information is GL Summary Accounts.

The authorization limits information for a user. The view that returns this information is GL Journal Auth Limits.

The currency conversion rates. The views that return this information are GL Daily Exchange Rates and GL Period Exchange Rates.

The accounting periods and statuses. The view that returns this information is GL Status Of Periods.

Some reporting scenarios where these views can be helpful are for finding information about the:

  • Employees who are authorized to approve journal batches of a given value

  • Earliest open period and latest open period

  • Daily conversion rate for a date range

Subject Areas and Views

The following table lists the subject areas of General Ledger and the corresponding Noetix views.

Subject Areas of General Ledger and the Corresponding NoetixViews

Subject area

Noetix view

Basic setup: Information about chart of accounts, account summary, account hierarchies, budget names, budget

organizations, calendar periods,

conversion rates and rate types, and authorization limits.

GL Budget Names

GL Budget Organizations

GL Chart Of Accounts

GL Daily Exchange Rates

GL Journal Auth Limits

GL Parent Child Values

GL Period Exchange Rates

GL Status Of Periods

GL Summary Accounts

Journals:Information about actual

journal batches, journal entries,

and journal entry lines for the primary, transaction, and statistical currencies; encumbrance journal batches, journal entries, and encumbrance journal entry lines for the primary currency; and archived actual journal entry lines for the primary currency.

GL All Encumb Je Lines

GL All Je Lines

GL Archived Je Lines

GL Encumb Journal Batches

GL Encumb Journal Entries

GL Foreign Je Lines

GL Journal Entries

GL Journal Entry Batches

GL Journal Entry Lines

Balances: Information about actual

balances in the primary, transaction, and statistical currencies; budget balances in the primary, transaction, and statistical currencies; encumbrance balances in the primary currency; and balance comparison in the primary and statistical currencies.

GL All Balances

GL All Budgets

GL Archived Balances

GL Average Daily Balances

GL Balances

GL Budget Actuals Encumb

GL Budget To Actuals

GL Budgets

GL Encumbrance Balances

GL Foreign Balances

GL Foreign Summaries

GL Funds Available

GL Org Balances

GL Org Budget To Actuals

GL Org Budgets

GL Parent Budget To Actuals

GL Parent Child Balances

GL Parent Child Budgets

GL Rollup Account Balances

GL Rollup Account Budgets

GL Rollup Parent Balances

GL Rollup Parent Budgets

GL Stat Balances

GL Stat Budget To Actuals

GL Stat Budgets

GL Summary Balances

GL Summary Budget To Actuals

GL Summary Budgets

Transaction from external systems: Information about journal entries imported from Oracle Payables, Oracle Purchasing, Oracle Receivables, and other sources.

GL Import Journals

GL Import Payables

GL Import Purchasing

GL Import Receivables

Transaction from subledgers:

Information about transactions for Payables invoices, Payables invoice payments, Receivables adjustments, Receivables miscellaneous receipts, Receivables standard receipts, Receivables transactions, purchase order (PO) and requisition encumbrances, blanket purchase agreements, PO encumbrances, and requisition encumbrances that have been transferred to General Ledger.

For Oracle E-Business Suite Release 12 and later (Using Subledger Accounting):

 

GL Je SLA AP Inv Dist

GL Je SLA AP Pmt Dist

GL Je SLA AR Adj Dist

GL Je SLA AR Misc Rcpt Dist

GL Je SLA AR Std Rcpt Dist

GL Je SLA AR Tran Dist

GL Je SLA PO All Encumb

GL Je SLA PO Blnkt Encumb

GL Je SLA PO Encumb

GL Je SLA PO Req Encumb

 

For Oracle E-Business Suite version before Release 12:

 

GL AP Inv Je Line Details

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je Blanket PO Encumb

GL Je Tran All PO Encumb

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran AR Tran Dist

GL Je Tran PO Encumb

GL Je Tran PO Req Encumb

Support for Parent-Child Hierarchies in Global Views

Noetix Views (NoetixViews) supports the parent-child hierarchies defined on segments of the Accounting Flexfield. Global views that include the Accounting Flexfield can be used with parent-child hierarchies to create reports. For reports with account balances, the parent-child hierarchies help to create a total balance for all the detail accounts in the hierarchy, and then enable drill down one level at a time to the individual account balances. A report based on General Ledger journal lines can start at a hierarchy's top level with rolled up amounts of all the accounts in the hierarchy and drill down to the individual journal entry lines. Similar reporting can be done using views that return subledger distributions. A report can return a rolled up amount and the user can drill down to the individual distribution transactions.

Standard and Cross Operations Extension (XOP) views also support parent-child hierarchies. These views are available for only General Ledger and can be used for only finding information about the parent and child accounts at summary or detail level. However, they do not support building reports where you can drill down through a parent-child hierarchy of an accounting segment or support building reports where you can find the entire child or leaf flex values corresponding to a parent flex value.

Parent-Child Views for Segment Hierarchy

The reporting solution provided for the Accounting Flexfield parent-child hierarchies support in global views consist of two views, parent-child hierarchies and parent-child essentials.

The parent-child hierarchies views support all the hierarchies defined on a segment and are used to build reports that enable drill down one level at a time to the individual segment values in the leaf nodes of the hierarchies. In Business Intelligence (BI) tools that support hierarchies, this drill down capability is automatically enabled by the Angles for Oracle Generator for that tool.

The parent-child essentials views can be used for building reports in which you want to display all the leaf or child flex values corresponding to a parent flex value. This parent flex value can be the top most parent (also known as the root of a parent-child hierarchy), any lower level parent, or even a leaf value (in which case it returns itself). Also, a pseudo-parent value is available in the parent-child essentials views. The ALL VALUES pseudo-parent returns all the flex values of the segment even those not included in a hierarchy.

The parent-child hierarchy and essentials views return records only for detail account identifiers as the corresponding fact views return information only for the detail account identifiers.

Generation of Parent-Child Views for Segment Hierarchy

The parent-child hierarchies and parent-child essentials views are generated for each segment of each chart of accounts in Oracle E-Business Suite. These views can be used only with the global Noetix views and are generated for a segment only if a flex value set is defined on that segment. However, the parent-child hierarchies and parent-child essentials views will populate hierarchy data only if one or more parent-child hierarchies are defined on a segment.

A Concurrent Manager program is created in the Oracle E-Business Suite instance when parent-child views are generated in NoetixViews. If modifications are made to a segment hierarchy structure in Oracle E-Business Suite, the Concurrent Manger should be run to capture the changes. This includes changes to existing hierarchies and new hierarchies added to a segment that had at least one previous hierarchy. The NoetixViews Stage 4 generation process must be run to capture hierarchies defined on segments that previously did not have any hierarchies.

If Noetix Help File is available for your NoetixViews instance, the generated parent-child hierarchies and essentials views can be found under a global role for which they are generated. For example, the GLG0 LEDGER role will list all the parent-child hierarchies and essentials views generated for the role. The parent-child hierarchies and essentials views are named as N Acct <chart of accounts ID> <segment name> H (Example: N Acct 101 Account H) and N Acct <chart of accounts ID> <segment name> D (Example: N Acct 101 Account D) respectively.

After the parent-child views are generated, they must be configured in the BI tools using the respective Angles for Oracle Generator. In the BI tools, these views are used with other functional views to create reports. The functional views that are joined to the parent-child views are called fact views. In BI tools that support hierarchies, fact views can be used with a parent-child hierarchies view to build reports that return transaction data or provide summarized data at different levels of a parent-child hierarchy. The following fact views are defined by Noetix with joins to the parent-child views:

  • GL All Balances

  • GL All Encumb Je Lines

  • GL All Je Lines

  • GL Balances

  • GL Budget To Actuals

  • GL Encumbrance Balances

  • GL Journal Entry Lines

  • XLA SLA Hub Journal Lines

However, any global view that includes columns for the Accounting Flexfield and returns data for any Oracle E-Business Suite module can be joined to the parent-child views through joins that are created with the use of the Noetix Views Workbench (NoetixViews Workbench). For information, see the Noetix Views Workbench Help.

Features of Parent-Child Hierarchies View

The parent-child hierarchies views support a maximum of 20 levels for a segment hierarchy including the root and leaf flex values. For each level, the view returns segment flex value, flex value description, and flex values along with description. The root columns return information corresponding to the top-level node in a hierarchy. The leaf columns return information corresponding to the lowest-level child in a hierarchy. The leaf parent columns return information corresponding to the parent of the lowest-level child in a hierarchy.

When parent-child hierarchies views are configured in Oracle Business Intelligence (Oracle BI) and IBM Cognos Business Intelligence (Cognos BI) by using the respective Noetix Generators for these tools, additional hierarchical drill objects are created in the presentation model corresponding to the segment values and descriptions. These objects are named Description, Description With Value, and Value respectively. They are available under a dimension object created for each parent-child hierarchies view. The Description, Description With Value, and Value objects when used in a report return descriptions for all the segment values, segment descriptions with segment values, and segment values, respectively. Based on the reporting requirement, a reporting user can use one of the hierarchies drill objects in their report.

The parent-child hierarchies views follow the naming convention “<segment name> Parent-Child Hierarchies” in the presentation model of the BI tools. The corresponding dimension object under which the hierarchical drill objects are created is named as “<segment name> Account Parent-Child Hierarchies$DIM.” For example, the “Account Parent-Child Hierarchies” view is created for the Account segment, and the “Account Parent-Child Hierarchies$DIM” object is created for the hierarchical objects available for the Account segment.

In Noetix Platform and Oracle Discoverer, the parent-child hierarchies views is named as “<segment name> Parent-Child Hierarchies (<chart of accounts name>)”, where <chart of accounts name> represents the chart of accounts corresponding to the segment. For example, the “Account Parent-Child Hierarchies (Operations Accounting Flex)” view is created for the Account segment of the Operations Account Flex chart of accounts. The hierarchical drill objects for a parent-child hierarchies view is not available in Noetix Platform or Oracle Discoverer as it is in the other BI tools.

For information about how to use the parent-child hierarchies view, see Using BI Tools in “Using BI Tools.”

Features of Parent-Child Essentials View

The parent-child essentials views are designed to be used with other views that include the Accounting Flexfield and to which it has a join. This view provides information about the parent and leaf flex values and descriptions. The parent columns return values corresponding to the top-level node in a hierarchy and all the lower-level parents. The leaf columns return flex values for each lowest-level child within the hierarchy of a parent. A record returned consists of each combination of a parent and its lowest-level child flex values. The parent could also be an intermediate parent. The pseudo parent value ALL VALUES consider all the possible flex values of the segment as its children even those that are not part of a hierarchy. Use this pseudo parent value when you want to return the code combinations for every flex value of the segment. Each child flex value of the segment has a pseudo parent of the same value assigned to it. Use the flex value for the parent when you want to return the code combinations for a single child flex value. The parent-child essentials views can be used in conjunction with the parent-child hierarchies views to create drill-through reports.

The parent-child essentials views are named as “<segment name> Parent-Child Essentials” in the presentation model of the BI tools. For example, the “Account Parent-Child Essentials” view is created for the Account segment.

In Noetix Platform and Oracle Discoverer, the parent-child essentials views are named as “<segment name> Parent-Child Essentials (<chart of accounts name>)”, where <chart of accounts name> represents the chart of accounts corresponding to the accounting segment. For example, the “Account Parent-Child Essentials (Operations Accounting Flex)” view is created for the Account segment of the Operations Accounting Flex chart of accounts.

For information about how to use the parent-child essentials views, see Using BI Tools in “Using BI Tools.”

Support for Flexfields

The following tables list the flexfields in General Ledger and the Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle General Ledger

Descriptive flexfield

Noetix view

GL Accounts

GL All Balances

GL All Budgets

GL AP Inv Je Line Details

GL Balances

GL Budget Actuals Encumb

GL Budget To Actuals

GL Budgets

GL Chart Of Accounts

GL Encumbrance Balance

GL Foreign Balances

GL Foreign Summaries

GL Funds Available

GL Org Balances

GL Org Budget To Actuals

GL Org Budgets

GL Rollup Account Balances

GL Rollup Account Budgets

GL Rollup Parent Balances

GL Rollup Parent Budgets

GL Stat Balances

GL Stat Budget To Actuals

GL Stat Budgets

GL Summary Accounts

GL Summary Balances

GL Summary Budget To Actuals

GL Summary Budgets

 

GL All Encumb Je Lines

GL All Je Lines

GL AP Inv Je Line Details

GL Archived Je Lines

GL Encumb Journal Batches

GL Encumb Journal Entries

GL Foreign Je Lines

GL Journal Entries

GL Journal Entry Batches

GL Journal Entry Lines

Define Budget Organization: Assignments

GL Org Balances

GL Org Budget To Actuals

GL Org Budgets

Define Budget Organization: Organization

GL Budget Organizations

GL Org Balances

GL Org Budget To Actuals

GL Org Budgets

Define Budget

GL Budget Names

Budget Versions

GL Stat Budgets

Flexfield Segment Values

GL Parent Child Values

Enter Journals: Journals

GL All Encumb Je Lines

GL All Je Lines

GL AP Inv Je Line Details

GL Archived Je Lines

GL Encumb Journal Entries

GL Foreign Je Lines

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je Blanket PO Encumb

GL Je SLA AP Inv Dist

GL Je SLA AP Pmt Dist

GL Je SLA AR Adj Dist

GL Je SLA AR Misc Rcpt Dist

GL Je SLA AR Std Rcpt Dist

GL Je SLA AR Tran Dist

GL Je SLA PO All Encumb

GL Je SLA PO Blnkt Encumb

GL Je SLA PO Encumb

GL Je SLA PO Req Encumb

GL Je Tran All PO Encumb

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran AR Tran Dist

GL Je Tran PO Encumb

GL Je Tran PO Req Encumb

GL Journal Entries

GL Journal Entry Lines

Enter Journals: Lines

GL All Encumb Je Lines

GL All Je Lines

GL AP Inv Je Line Details

GL Archived Je Lines

GL Foreign Je Lines

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je Blanket PO Encumb

GL Je SLA AP Inv Dist

GL Je SLA AP Pmt Dist

GL Je SLA AR Adj Dist

GL Je SLA AR Misc Rcpt Dist

GL Je SLA AR Std Rcpt Dist

GL Je SLA AR Tran Dist

GL Je SLA PO All Encumb

GL Je SLA PO Blnkt Encumb

GL Je SLA PO Encumb

GL Je SLA PO Req Encumb

GL Je Tran All PO Encumb

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran AR Tran Dist

GL Je Tran PO Encumb

GL Je Tran PO Req Encumb

GL Journal Entry Lines

Period Rates

GL Period Exchange Rates

PO Distributions

GL Je Blanket PO Encumb

GL Je Tran PO Encumb

GL Period Statuses

GL Status Of Periods

PO Headers

GL Je Blanket PO Encumb

GL Je Tran PO Encumb

PO Lines

GL Je Blanket PO Encumb

GL Je Tran PO Encumb

Daily Rates

GL Daily Exchange Rates

Requisition Distributions

GL Je Tran PO Req Encumb

Requisition Headers

GL Je Tran PO Req Encumb

Requisition Lines

GL Je Tran PO Req Encumb

PO Line Locations

GL Je Blanket PO Encumb

GL Je Tran PO Encumb

 

Key Flexfields Supported in NoetixViews for Oracle General Ledger

Key flexfield

Noetix view

Accounting Flexfield

GL All Balances

GL All Budgets

GL All Encumb Je Lines

GL All Je Lines

GL AP Inv Je Line Details

GL Archived Balances

GL Archived Je Lines

GL Average Daily Balances

GL Balances

GL Bly Budget To Actuals

GL Budget Actuals Encumb

GL Budget To Actuals

GL Budgets

GL Chart Of Accounts

GL Encumbrance Balances

GL Foreign Balances

GL Foreign Je Lines

GL Foreign Summaries

GL Funds Available

GL Import Journals

GL Import Payables

GL Import Purchasing

GL Import Receivables

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je Blanket PO Encumb

GL Je SLA AP Inv Dist

GL Je SLA AP Pmt Dist

GL Je SLA AR Adj Dist

GL Je SLA AR Misc Rcpt Dist

GL Je SLA AR Std Rcpt Dist

GL Je SLA AR Tran Dist

GL Je SLA PO All Encumb

GL Je SLA PO Blnkt Encumb

GL Je SLA PO Encumb

GL Je SLA PO Req Encumb

GL Je Tran All PO Encumb

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran PO Encumb

GL Je Tran PO Req Encumb

GL Journal Entry Lines

GL Org Balances

GL Org Budget To Actuals

Accounting Flexfield (Continued)

GL Org Budgets

GL Parent Budget To Actuals

GL Parent Child Balances

GL Parent Child Budgets

GL Rollup Account Balances

GL Rollup Account Budgets

GL Rollup Parent Balances

GL Rollup Parent Budgets

GL Stat Balances

GL Stat Budget To Actuals

GL Stat Budgets

GL Summary Accounts

GL Summary Balances

GL Summary Budget To Actuals

GL Summary Budgets

System Items

GL Je Tran AR Tran Dist

Noetix Views in General Ledger Workflow

The following diagram explains the process flow of General Ledger and the corresponding subject areas supported by Noetix views.

For more information about the Noetix supported subject areas and the views corresponding to each subject area, see Support for Subject Areas.

Noetix Roles for Oracle General Ledger

NoetixViews for Oracle General Ledger includes standard, Cross Operations Extension (XOP), and global roles. A standard role contains a set of views are generated corresponding to a specific ledger. For an XOP role, a set of views is generated corresponding to one or more ledgers depending on the chart of accounts settings in your Oracle E-Business Suite instance. For a global role, a set of views is generated for all the ledgers configured in your Oracle E-Business Suite instance. A user can access all the views corresponding to an assigned role. Contact your Noetix System Administration User if you have any queries regarding the roles granted to you.

Tips/Other Considerations

The following points help you to optimally use the views for General Ledger:

After migrating the Oracle E-Business Suite instance version from 11.5.10.2 to Release 12 and purging your data for the first time, you must regenerate the GL Archived Balances and GL Archived Je Lines views. Otherwise, these views will return an error message. You do not need to regenerate these views after running the purge process subsequently.

Use the GL Summary Balances and GL Summary Budgets views to know the balances of only the summary accounts. To see the detail accounts associated to a summary account, use the GL Summary Accounts view.

Some views do not support granularity statements as they return information from multiple journal sources. These views are listed as follows:

GL Import Journals

GL Import Payables

GL Import Purchasing

GL Import Receivables

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran AR Tran Dist

Some of the standard Accounting Flexfield segment columns populated in the global form of the Noetix views for General Ledger are not available in the global form of the GL Rollup Account Balances and GL Rollup Account Budgets views. The segment columns that are not available in these views are listed as follows:

Acct$CD$Accounting KFF

Acct$CV$Accounting KFF

Acct$Code Combination Id

Acct$QD$Cost Center

Acct$QV$Cost Center

Acct$Segment Name List

Acct$Structure Name

The following views are only available in the standard and XOP forms:

GL Parent Budget to Actuals

GL Parent Child Balances

GL Parent Child Budgets

GL Rollup Parent Balances

GL Rollup Parent Budgets

Some views support row-level security based on the security set for a Noetix query user. In these views, row-level security is applied based on the flexfield security rules and ledgers assigned to the user in Oracle E-Business Suite and Noetix Views Administrator (NoetixViews Administrator). When row-level security is applied, the Noetix query user’s access to data within Noetix views corresponding to a role is further restricted. The following views support row-level security based on the row-level security settings assigned to a query user:

GL All Balances

GL All Budgets

GL All Encumb Je Lines

GL All Je Lines

GL AP Inv Je Line Details

GL Archived Balances

GL Archived Je Lines

GL Balances

GL Budget To Actuals

GL Budgets

GL Encumbrance Balances

GL Foreign Balances

GL Foreign Je Lines

GL Foreign Summaries

GL Funds Available

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je SLA AP Inv Dist

GL Je SLA AP Pmt Dist

GL Je SLA AR Adj Dist

GL Je SLA AR Misc Rcpt Dist

GL Je SLA AR Std Rcpt Dist

GL Je SLA AR Tran Dist

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran AR Tran Dist

GL Journal Entry Lines

GL Org Balances

GL Org Budget To Actuals

GL Org Budgets

GL Parent Budget To Actuals

GL Parent Child Budgets

GL Rollup Account Balances

GL Rollup Account Budgets

GL Rollup Parent Balances

GL Rollup Parent Budgets

GL Stat Balances

GL Stat Budget To Actuals

GL Stat Budgets

GL Summary Balances

GL Summary Budget To Actuals

GL Summary Budgets

NoetixViews for Oracle Subledger Accounting

Oracle Corporation has introduced the subledger accounting service in Oracle E-Business Suite Release 12. This service provides users the means of streamlining the process of subledger bookkeeping and thereby improving the administration of global and country-specific business.

Prior to Release 12, the data processed from the individual modules (for example, Oracle Payables or Oracle Receivables) could be posted to Oracle General Ledger according to the rules set up for the specific modules. In Release 12, a common accounting engine has been established to conduct all posting activities to General Ledger. The subledger tables, which store the accounting data in the common accounting engine, have been standardized across products, and they maintain every accounting detail of the subledger events. The common accounting engine then estimates to what level the details are to be summarized and finally posts them to General Ledger according to the user-defined accounting rules.

To support the subledger accounting functionality in Release 12, insigihtsoftwarehas designed and developed a set of cross-functional and module-specific views. The corresponding, cross-functional views for Oracle E-Business Suite 11i will continue to exist in Release 12 for tracking historical accounting data that has not been migrated to Oracle Subledger Accounting. Users of 11i will continue to use the older, cross-functional views to access accounting data.

Features of Noetix Views for Subledger Accounting

The views developed for Subledger Accounting are available in only the global form and provide these benefits:

Comprehensive coverage of functional areas.

Support for role-level and row-level security.

Support for joins based on one or more standard columns.

Controlled access to accounting information based on the Oracle E-Business Suite roles and responsibilities.

Support for drill-down reporting based on parent-child hierarchy information pertaining to the Accounting Flexfield.

A centrally located hub view that helps retrieve consolidated accounting information for all the distributions across all subledger applications. Noetix views that return subledger application-specific distribution details can be joined with the hub view to retrieve the distribution-specific accounting information in Subledger Accounting. The view can also be used to drill down from the journal entry lines in Subledger Accounting to the individual source distributions.

Support for drill down from account balances and journals in General Ledger to the individual source transaction distributions.

Based on the functional use and applicability, the views developed for Subledger Accounting have been broadly classified into a Subledger Accounting-specific solution and a subledger application-specific solution.

Subledger Accounting-Specific Solution

The Subledger Accounting-specific solution links distributions in various modules to journal entry lines in Subledger Accounting and finally to account balances and journals in General Ledger. The Subledger Accounting-specific solution consists of views that return information about subledger application-specific distributions, journal entry lines in Subledger Accounting, and journal entries and account balances in General Ledger. These views are available as part of the NoetixViews module for General Ledger and are managed through the SUBLEDGER ACCOUNTING Noetix role.

The hub view is linked to 21 subledger application-specific distribution views that return information about the original transaction distribution details. The hub view is also linked to views that return information about account balances and journals from General Ledger. Oracle E-Business Suite users who have access to General Ledger can make use of the hub view along with the subledger application-specific distribution views and General Ledger views for a complete understanding of the source distributions and their accounting details.

The Subledger Accounting-specific views also provide support for role-level and row-level security. The role-level security is enforced on Noetix query users based on the SUBLEDGER ACCOUNTING Noetix role. The row-level security is enforced on Noetix query users based on the security settings configured for the ledgers and flexfield security rules in General Ledger and NoetixViews.

For the support of multi-currency, all the views that return transaction distribution details corresponding to Oracle Projects return transaction currency values. Additional columns are available in these views for returning project functional currency values (with the PFC suffix) and project currency values (with the PC suffix). In all other views, both primary and transaction currency values are returned.

The views that are available as part of the Subledger Accounting-specific solution and their coverage areas are as follows:

The following views return the details of the account balances and journal entries in General Ledger:

XLA GL All Balances

XLA GL Journal Lines

The XLA SLA Hub Journal Lines view returns the details of the journal entry lines in Subledger Accounting that correspond to the distributions in subledger applications.

The following views return the details of the distributions in individual subledger applications:

XLA AP Invoice Dist

XLA AP Payment Dist

XLA AR Adjustment Dist

XLA AR Bills Rcv Dist

XLA AR Misc Receipt Dist

XLA AR Std Receipt Dist

XLA AR Transaction Dist

XLA Accrual Write Off Dist

The XLA Accrual Write Off Dist view will be generated only if Oracle Bills of Material is available in your Oracle E-Business Suite instance.

XLA FA Transaction Dist

The XLA FA Transaction Dist view will be generated only if Oracle Assets is available in your Oracle E-Business Suite instance.

XLA FV Budget Auth Trans, XLA FV Budget RPR Trans, and XLA FV Fund Distributions

These views will be generated only if Oracle U.S. Federal Financials is available in your Oracle E-Business Suite instance and NoetixViews application instance.

XLA FV Treas Confirmation

The XLA FV Treas Confirmation view will be generated only if U.S.Federal Financials is available in your Oracle E-Business Suite instance.

XLA GMF Cst Subledger Dist

The XLA GMF Cst Subledger Dist view will be generated only if Oracle Process Manufacturing Financials is available in your Oracle E-Business Suite instance.

XLA INV Transaction Dist

The XLA INV Transaction Dist view will be generated only if Oracle Inventory is available in your Oracle E-Business Suite instance.

XLA PA Budget Dist

The XLA PA Budget Dist view will be generated only if Projects is available in your Oracle E-Business Suite instance.

XLA PA Cost Dist

The XLA PA Cost Dist view will be generated only if Projects is available in your Oracle E-Business Suite instance.

XLA PA Revenue Dist

The XLA PA Revenue Dist view will be generated only if Projects is available in your Oracle E-Business Suite instance.

XLA PO Receiving Dist

The XLA PO Receiving Dist view will be generated only if Oracle Purchasing is available in your Oracle E-Business Suite instance.

XLA PO Requisition Dist

The XLA PO Requisition Dist view will be generated only if Purchasing is available in your Oracle E-Business Suite instance and budgetary control is enabled for the ledgers.

XLA WIP Resource Dist

The XLA WIP Resource Dist view will be generated only if Oracle Work in Process is available in your Oracle E-Business Suite instance.

The relationship between the hub view and other views is as follows.

Subledger Application-Specific Solution

The subledger application-specific solution provides reporting capability for individual Oracle E-Business Suite modules. The subledger application-specific solution consists of distribution views and a single hub view for each subledger application. Each hub view provides details about the Subledger Accounting journal entry lines for a subledger application. Depending on the reporting requirements, a distribution view that covers a specific functional area can be joined to the hub view to retrieve distribution-specific accounting details from Subledger Accounting. The distribution and hub views available in the subledger application -specific solution are provided as part of the individual NoetixViews modules corresponding to the relevant subledger application.

The subledger application-specific views support role-specific and module-specific security. The role-level security is enforced on Noetix query users through the individual Noetix roles. The row-level security is enforced on Noetix query users based on the organizational unit-specific and application-specific security settings configured in the Oracle E-Business Suite modules and NoetixViews.

For the support of multi-currency, all the views that return transaction distribution details corresponding to Projects return transaction currency values. Additional columns are available in these views for returning project functional currency values (with the PFC suffix) and project currency values (with the PC suffix). In the views for all other modules, both primary and transaction currency values are returned.

The views that are available as part of the subledger application-specific solution and their coverage areas are as follows:

The following views return details of the distributions in individual subledger applications:

AP SLA Invoice Dist

AP SLA Payment Dist

AR SLA Adjustment Dist

AR SLA Bills Rcv Dist

AR SLA Misc Receipt Dist

AR SLA Std Receipt Dist

AR SLA Transaction Dist

FA SLA Transaction Dist

FV SLA Budget Auth Trans

FV SLA Budget RPR Trans

FV SLA Fund Distributions

FV SLA Treas Confirmation

GMF SLA Cst Subledger Dist

PA SLA Budget Dist

PA SLA Cost Dist

PA SLA Revenue Dist

PO SLA Requisition Dist

The following views return details of the journal entry lines in Subledger Accounting that correspond to distributions in the subledger applications:

AP SLA Hub Journal Lines

AR SLA Hub Journal Lines

FA SLA Hub Journal Lines

FV SLA Hub Journal Lines

GMF SLA Hub Journal Lines

PA SLA Hub Journal Lines

PO SLA Hub Journal Lines

Support for Subject Areas

The following table lists the subject areas related to Subledger Accounting that are supported by Noetix along with the corresponding view names.

Accounting subject area

Oracle

E-Business Suite module

Noetix view

Noetix hub view

Invoices and payments

Payables

For Subledger Accounting-specific solution:

XLA AP Invoice Dist

XLA AP Payment Dist

XLA Subledger Exceptions

For subledger application-specific solution:

AP SLA Invoice Dist

AP SLA Payment Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

AP SLA Hub Journal Lines

Transactions, adjustments, standard receipts, miscellaneous receipts, and bills receivable

Receivables

For Subledger Accounting-specific solution:

XLA AR Adjustment Dist

XLA AR Bills Rcv Dist

XLA AR Misc Receipt Dist

XLA AR Std Receipt Dist

XLA AR Transaction Dist

XLA Subledger Exceptions

For subledger application-specific solution:

AR SLA Adjustment Dist

AR SLA Bills Rcv Dist

AR SLA Misc Receipt Dist

AR SLA Std Receipt Dist

AR SLA Transaction Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

AR SLA Hub Journal Lines

Encumbered purchase orders (POs) and purchase requisitions

Purchasing

For Subledger Accounting-specific solution:

XLA PO Requisition Dist

For subledger application-specific solution:

PO SLA Requisition Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

PO SLA Hub Journal Lines

Asset transactions, inter asset transactions, depreciation, and deferred depreciation

Assets

For Subledger Accounting-specific solution:

XLA FA Transaction Dist

XLA FA Subledger Exceptions

For subledger application-specific solution:

FA SLA Transaction Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

FA SLA Hub Journal Lines

Project billing, costing, and revenue

Projects

For Subledger Accounting-specific solution:

XLA PA Budget Dist

XLA PA Cost Dist

XLA PA Revenue Dist

For subledger application-specific solution:

PA SLA Budget Dist

PA SLA Cost Dist

PA SLA Revenue Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

PA SLA Hub Journal Lines

Accrual write-offs, receiving transaction distributions in Purchasing, resource distributions in Work in Process, and transaction distributions in Inventory

Cost Management

For Subledger Accounting-specific solution:

XLA Accrual Write Off Dist

XLA PO Receiving Dist

XLA WIP Resource Dist

XLA INV Transaction Dist

XLA Subledger Exceptions

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

Purchase receiving subledgers, purchase and inventory material transactions, sales order issues, Return Material Authorizations (RMAs), and cost revaluation and batch processing transactions

Process Manufacturing Financials

For Subledger Accounting-specific solution:

XLA GMF Cst Subledger Dist

For subledger application-specific solution:

GMF SLA Cst Subledger Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

GMF SLA Hub Journal Lines

Budget execution transactions, budget reprogramming, and treasury confirmation

U.S. Federal Financials

For Subledger Accounting-specific solution:

XLA FV Budget Auth Trans

XLA FV Fund Distributions

XLA FV Budget RPR Trans

XLA FV Treas Confirmation

For subledger application-specific solution:

FV SLA Budget Auth Trans

FV SLA Fund Distributions

FV SLA Budget RPR Trans

FV SLA Treas Confirmation

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

FV SLA Hub Journal Lines

Journal entry lines and account balances

General Ledger

For Subledger Accounting-specific solution:

XLA GL All Balances

XLA GL Journal Lines

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

Support for Flexfields

The descriptive and key flexfields that are supported by the Subledger Accounting-specific solution and the subledger application-specific solution are listed in the tables in this section.

Descriptive Flexfields Supported in Subledger Accounting Views

Descriptive flexfield name

Flexfield table

Noetix view

Adjustment Information

AR Adjustments All

AR SLA Adjustment Dist

XLA AR Adjustment Dist

Asset Category

FA Additions B

FA SLA Transaction Dist

XLA FA Transaction Dist

Book Controls

FA Book Controls

FA SLA Transaction Dist

XLA FA Transaction Dist

Budget Lines

PA Budget Lines

PA SLA Budget Dist

XLA PA Budget Dist

Budget Transactions Detail

FV BE TRX DTLS

FV SLA Budget Auth Trans

FV SLA Fund Distributions

XLA FV Budget Auth Trans

XLA FV Fund Distributions

Budget Transactions Header

FV BE TRX HDRS

FV SLA Budget Auth Trans

FV SLA Fund Distributions

XLA FV Budget Auth Trans

XLA FV Fund Distributions

Budget Versions

PA Budget Versions

PA SLA Budget Dist

XLA PA Budget Dist

GL Accounts

GL Code Combinations

XLA GL All Balances

Enter Journals: Batches

GL JE Batches

XLA GL Journal Lines

Enter Journals: Journals

GL JE Headers

XLA GL Journal Lines

Enter Journals: Lines

GL JE Lines

XLA GL Journal Lines

Invoice

AP Invoices All

AP SLA Payment Dist

AP SLA Invoice Dist

XLA AP Invoice Dist

XLA AP Payment Dist

Invoice Distribution

AP Invoice Distributions All

AP SLA Invoice Dist

XLA AP Invoice Dist

Invoice Payments

AP Invoice Payments All

AP SLA Payment Dist

XLA AP Payment Dist

Items

MTL System Items B

XLA INV Transaction Dist

XLA WIP Resource Dist

Payment Information

AP Checks All

AP SLA Payment Dist

XLA AP Payment Dist

Payment Schedule Information

AR Payment Schedules All

AR SLA Adjustment Dist

XLA AR Adjustment Dist

Reprogramming Transactions

FV BE RPR Transactions

FV SLA Budget RPR Trans

XLA FV Budget RPR Trans

Requisition Headers

PO Requisition Headers All

PO SLA Requisition Dist

XLA PO Requisition Dist

Requisition Lines

PO Requisition Lines All

PO SLA Requisition Dist

XLA PO Requisition Dist

Transaction history

MTL Material Transactions

XLA INV Transaction Dist

XLA INV Transaction Dist

Transaction Information

RA Customer Trx All

AR SLA Transaction Dist

XLA AR Transaction Dist

TREASURY CONFIRMATION

FV Treasury Confirmations All

FV SLA Treas Confirmation

XLA FV Treas Confirmation

WIP Transaction History

WIP Transactions

XLA WIP Resource Dist

 

Key Flexfields Supported in Subledger Accounting Views

Key flexfield name

Noetix view

Accounting Flexfield

AP SLA Hub Journal Lines

AP SLA Invoice Dist

AP SLA Payment Dist

AR SLA Adjustment Dist

AR SLA Bills Rcv Dist

AR SLA Hub Journal Lines

AR SLA Misc Receipt Dist

AR SLA Std Receipt Dist

AR SLA Transaction Dist

FA SLA Hub Journal Lines

FV SLA Budget Auth Trans

FV SLA Budget RPR Trans

FV SLA Fund Distributions

FV SLA Hub Journal Lines

FA SLA Transaction Dist

GMF SLA Cst Subledger Dist

GMF SLA Hub Journal Lines

PA SLA Budget Dist

PA SLA Cost Dist

PA SLA Hub Journal Lines

PA SLA Revenue Dist

PO SLA Hub Journal Lines

PO SLA Requisition Dist

XLA Accrual Write Off Dist

XLA AP Invoice Dist

XLA AP Payment Dist

XLA AR Adjustment Dist

XLA AR Bills Rcv Dist

XLA AR Misc Receipt Dist

XLA AR Std Receipt Dist

XLA AR Transaction Dist

XLA FA Transaction Dist

XLA FV Budget Auth Trans

XLA FV Budget RPR Trans

XLA FV Fund Distributions

XLA FV Treas Confirmation

XLA GL All Balances

XLA GL Journal Lines

XLA GMF Cst Subledger Dist

XLA INV Transaction Dist

XLA PA Budget Dist

XLA PA Cost Dist

XLA PA Revenue Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

XLA SLA Hub Journal Lines

XLA WIP Resource Dist

Asset Key Flexfield

FA SLA Transaction Dist

Category Flexfield

FA SLA Transaction Dist

Location Flexfield

FA SLA Transaction Dist

Item Categories

PO SLA Requisition Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

System Items

AR SLA Transaction Dist

GMF SLA Cst Subledger Dist

PO SLA Requisition Dist

XLA AR Transaction Dist

XLA Accrual Write Off Dist

XLA GMF Cst Subledger Dist

XLA INV Transaction Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

XLA WIP Resource Dist

Stock Locators

XLA INV Transaction Dist

Noetix Roles for Subledger Accounting Views

The views provided as part of the Subledger Accounting-specific solution are managed through the SUBLEDGER ACCOUNTING Noetix role. The views provided as part of the subledger application-specific solution are managed through the Noetix roles corresponding to the individual NoetixViews modules. The following table lists the details of the Noetix roles and the corresponding views.

Noetix role label

Noetix view

FIXED ASSETS

FA SLA Hub Journal Lines

FA SLA Transaction Dist

OPM FINANCIALS

GMF SLA Cst Subledger Dist

GMF SLA Hub Journal Lines

PAYABLES

AP SLA Hub Journal Lines

AP SLA Invoice Dist

AP SLA Payment Dist

PROJECTS

PA SLA Budget Dist

PA SLA Cost Dist

PA SLA Hub Journal Lines

PA SLA Revenue Dist

PURCHASING

PO SLA Hub Journal Lines

PO SLA Requisition Dist

RECEIVABLES

AR SLA Adjustment Dist

AR SLA Bills Rcv Dist

AR SLA Hub Journal Lines

AR SLA Misc Receipt Dist

AR SLA Std Receipt Dist

AR SLA Transaction Dist

FEDERAL ADMINISTRATOR

FV SLA Budget Auth Trans

FV SLA Budget RPR Trans

FV SLA Fund Distributions

FV SLA Hub Journal Lines

FV SLA Treas Confirmation

SUBLEDGER ACCOUNTING

XLA Accrual Write Off Dist

XLA AP Invoice Dist

XLA AP Payment Dist

XLA AR Adjustment Dist

XLA AR Bills Rcv Dist

XLA AR Misc Receipt Dist

XLA AR Std Receipt Dist

XLA AR Transaction Dist

XLA FA Transaction Dist

XLA FV Budget Auth Trans

XLA FV Fund Distributions

XLA FV Budget RPR Trans

XLA FV Treas Confirmation

XLA GL All Balances

XLA GL Journal Lines

XLA GMF Cst Subledger Dist

XLA INV Transaction Dist

XLA PA Budget Dist

XLA PA Cost Dist

XLA PA Revenue Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

XLA SLA Hub Journal Lines

XLA WIP Resource Dist

Noetix Views in Subledger Accounting Workflow

The following diagram explains the process flow of Subledger Accounting and the important Noetix views that provide information at each point in the process flow.

For information about the hub and transaction distribution views and the corresponding subject areas, seeSupport for Subject Areas.

Useful Reporting Scenarios Supported by Subledger Accounting Views

This section explains some of the useful reporting scenarios that are supported by the Subledger Accounting views.

Projections or Corrections for Accounting Data

In this reporting scenario, you can use the hub views of subledger applications or the XLA SLA Hub Journal Lines view to obtain a preview of the accounts and amounts related to the Subledger Accounting distributions that are in the draft mode before transferring them to General Ledger. Also, you can use the hub and distribution views (both Subledger Accounting-specific and subledger application-specific) to check for any discrepancies in the accounts by comparing the accounts and amounts related to the Subledger Accounting journal entries against the accounts and amounts corresponding to the subledger application-specific distributions. If discrepancies are noticed, you can go back and correct the accounts and rerun the accounting process.

Transactions Not Transferred to Subledger Accounting

In this reporting scenario, distribution views and hub views corresponding to a subledger application can be used together for finding information about the transactions corresponding to the distributions that have not been transferred to Subledger Accounting. For example, you can use the AP SLA Invoice Dist view with the AP SLA Hub Journal Lines view to identify the transactions pertaining to invoice distributions that are not yet transferred to Subledger Accounting.

Subledger Accounting Exceptions

You may have set up multiple accounts in Subledger Accounting to segregate the accounting information related to subledger application-specific distributions on the basis of the accounting requirements. In this reporting scenario, you can find information about these accounts in Subledger Accounting by using the subledger application-specific hub views or the XLA SLA Hub Journal Lines view. For example, when a discount is applied to a sales order, two revenue lines will be created, one for the actual price of the item and the other for the discount. Since both lines refer to the same item, they will be accounted to the same account. However, if the discount line needs to be accounted to a different account, a new account is set up in Subledger Accounting for discounts. In this case, you can use the AR SLA Transaction Dist view or the XLA AR Transaction Dist view to obtain the details of the original distribution account. The details of the new distribution account set up for discounts can be obtained with the use of the AR SLA Hub Journal Lines view or the XLA SLA Hub Journal Lines view.

Consolidated Accounting Information

In this reporting scenario, you may want complete information about the distributions across all the subledger applications. The XLA SLA Hub Journal Lines view can be used for finding this information. If you want the consolidated accounting information for all the distributions in a specific subledger application, you can use the hub view available for that subledger application.

Also, the XLA SLA Hub Journal Lines view can be used for the analysis of the accounting data by accounting class. You can analyze the accounting data for a detailed understanding about the accounts and amounts pertaining to different accounting classes, such as accruals, exchange gains and losses, earned and unearned discounts, inventory valuations, and inventory adjustments.

Transaction and Subledger Journal Details by Account Balances and Types

In this reporting scenario, you can drill down to a subledger application's source distributions for an account type from its balances in General Ledger. For this purpose, you will require the XLA GL All Balances view, the XLA SLA Hub Journal Lines view, and the relevant XLA% distribution view.

You can use the following steps to create a drill-down report:

Identify the account type for which you want to find the transaction and Subledger Accounting journal details corresponding to a subledger application. For this, join the XLA GL All Balances and XLA SLA Hub Journal Lines views to obtain details of line amounts in Subledger Accounting journals by account type. The information needs to be filtered by an accounting period, a ledger, and a Subledger Accounting journal currency and grouped by account type.

Identify a subledger application corresponding to the account type selected in the previous step. For this, join the XLA GL All Balances and XLA SLA Hub Journal Lines views to obtain details of line amounts in Subledger Accounting journals by subledger applications for the account type identified in the previous step. The information needs to be filtered by the accounting period, ledger, and Subledger Accounting journal currency used in the previous step and grouped by subledger application and account type.

Join the XLA GL All Balances and XLA SLA Hub Journal Lines views with the XLA% distribution view for the subledger application identified in the previous step to obtain the transaction and Subledger Accounting journal details for the subledger application and account type. Filter the records by the accounting period, ledger, and Subledger Accounting journal currency used in the previous step.

Tips and Other Considerations

The following points help you to optimally use the views for Subledger Accounting:

For manually created journal entries in Subledger Accounting and General Ledger, the views provided as part of the subledger application-specific and Subledger Accounting-specific solutions will not return any records because these journal entries do not have any associated source distributions in subledger applications.

A drill down from Subledger Accounting to the source distributions of subledger applications is not possible for intercompany transactions because they are created within Subledger Accounting.

The following is applicable to the information that is returned for the secondary and reporting ledgers:

When transactions are based on secondary ledgers set up in Subledger Accounting or General Ledger, the XLA SLA Hub Journal Lines view will return records for both the primary and secondary ledgers with the associated account and currency information for these ledgers. However, the XLA% distribution views return information about only primary ledgers. Therefore, to provide support for drill-down reporting based on the secondary ledgers from the XLA SLA Hub Journal Lines view to the individual XLA% distribution views, the SLA Ledger Name column has been added to the XLA% distribution views. The SLA Ledger Name column will return information about the secondary ledgers in the distribution views.

The distribution views available in the subledger application-specific solution return records for only the primary ledgers. However, the subledger application-specific hub views will return records for both primary ledgers and secondary ledgers. Therefore, use only primary ledgers when the subledger application-specific hub views are used to drill down to the distributions views for the subledger applications.

When the secondary or reporting ledger conversion is set up at the journal level in Oracle E-Business Suite, the records pertaining to the secondary and reporting ledgers in the subledger application-specific hub views, XLA% distribution views, and XLA SLA Hub Journal Lines view will always return information in the base currency of the primary ledger. Therefore, when building reports and queries that are based on the secondary ledgers or reporting ledgers, you must not use the associated base currency information.

When the secondary or reporting ledger conversion is set up at the journal level in Oracle E-Business Suite, the following columns in the XLA SLA Hub Journal Lines view always return information for the primary ledger:

AcctSLA$QV% columns

Chart Of Accounts Name

GL Period Name

Ledger Name

SLA JE Amount

SLA JE Amount Base

SLA JE Amount Cr

SLA JE Amount Cr Base

SLA JE Amount Dr

SLA JE Amount Dr Base

The Ledger Category column in the view can be used for identification of the ledger type associated with the records.

In Subledger Accounting, the links between lines and distributions are not always maintained, and some calculations are done internally. Therefore, in some cases, you cannot join records in the XLA% distribution views to the corresponding lines in the XLA SLA Hub Journal Lines view. For example, when the value returned by the Accounting Line Type column of an XLA% distribution view is “AUTO GEN GAIN LOSS”, records will be dropped when you join the XLA% distribution view to the XLA SLA Hub Journal Lines view.

Sometimes, the number or records in the XLA% distribution views may not match the number of records in the XLA SLA Hub Journal Lines view. For credits and debits, sometimes, the summed-up credit amounts or debit amounts in the XLA% distribution views may not match the summed-up credit amounts or debit amounts in the XLA SLA Hub Journal Lines view. In some cases, when you drill down from a line in the XLA SLA Hub Journal Lines view to the corresponding records in an XLA% distribution view, the amounts may not match. For example, the XLA AR Std Receipt Dist view will return separate records for credits and debits when the value returned by the Accounting Line Type column is “RCT UNAPP DEBIT” or “RCT UNAPP CREDIT”. However, the XLA SLA Hub Journal Lines view will return only one record with the net amount.

The following is applicable to the migrated data:

While Subledger Accounting-specific views and subledger application-specific views return migrated data, a drill-down from Subledger Accounting to the source distributions may return incorrect information because the data may not have been migrated correctly or some view columns may not have been populated by design for migrated data. Therefore, you must not perform calculations on records returned by the views for migrated data.

The columns in the XLA% distribution views pertaining to Cost Management will always return null values for migrated data. Therefore, when you compare the records in the XLA SLA Hub Journal Lines view against the records in the XLA% distribution views for Cost Management, you will find differences in the line amounts and distribution amounts.

While building reports and queries based on the XLA SLA Hub Journal Lines view, XLA% distribution views, or subledger application-specific hub views, use the Migrated Data Flag column in the filter condition to find records pertaining to migrated data. These views may return incorrect information for the migrated data if the transactions were not migrated properly in Oracle E-Business Suite.

In some subledger applications, the distribution process does not result in separate records for credit and debit amounts. However, separate records are always created in Subledger Accounting for credit and debit amounts. When the XLA% distribution views for such subledger applications are joined with the XLA SLA Hub Journal Lines view, you must filter the records in the hub view using the Accounting Class column so that the summed-up amounts match. For example, in the XLA AP Invoice Dist view, records will be returned for only debit amounts. The XLA SLA Hub Journal Lines view will have corresponding records created for these debit amounts. These records can be identified through the use of the “Item Expense” accounting class code in the XLA SLA Hub Journal Lines view. However, in the XLA SLA Hub Journal Lines view, records will be returned for credit amounts as well. These records can be identified through the use of the “Liability” accounting class code. Therefore, when the views are joined, you should filter the records in the hub view by the “Item Expense” accounting class code to find the corresponding records from the XLA AP Invoice Dist view.

In the Journals window of General Ledger, when the base currency amount for a journal entry is zero, you cannot drill down to the View Journal Entry Lines page to see the corresponding lines in Subledger Accounting. However, you can use the XLA GL Journal Lines view to drill down from an account for which the base currency amount is zero to the XLA SLA Hub Journal Lines view. For such accounts, in the XLA SLA Hub Journal Lines view, the SLA JE Line Number column will return negative values. Therefore, you can use this column to filter out such accounts while joining the two views.

In Projects, after the distribution process, a single record is created for a raw cost transaction, while separate credit and debit records are created for a burdened cost transaction. After the Create Accounting program is run, separate credit and debit records will be created for both raw cost and burdened cost transactions in Subledger Accounting. Therefore, when you build reports and queries based on the hub view in which you want to filter out the records corresponding to the raw costs, you need to use the following filter conditions: Accounting Event Entity Code = 'EXPENDITURES', Accounting Event Class Name <> 'Total Burdened Cost', and Accounting Class = 'Cost'. To filter out the records corresponding to the burdened costs, you need to use the following filter conditions: Accounting Event Entity Code = 'EXPENDITURES', Accounting Event Class Name = 'Total Burdened Cost', and Accounting Class = 'Cost'.

Other Cross-Functional Views for Subledger Accounting

This section contains information about other cross-functional views that are available in NoetixViews to support the subledger accounting functionality. The details of the Noetix views and the subject areas covered by these views are available in the tables provided in this section. However, these views may perform poorly and provide less flexibility because the information returned cannot be easily used for fulfilling the reporting needs.

NoetixViews for Oracle Assets

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Adjustments

FA Adjustments SLA GL Je

FA GL Journal Adjustments

Yes

Transactions

FA All Trans SLA GL Je

FA GL Journals

Yes

Depreciation histories

FA Deprn Dtl Hist SLA GL Je

FA Depr Detail History

Yes

Depreciations

FA Deprn Dtls SLA GL Je

FA Depreciation Details

Yes

Invoice transactions

FA Invoice Trx SLA GL Je

FA GL Invoice Trans Je

Yes

Tax reserve adjustment transactions

FA SLA Tax Reserve Adjust

FA Tax Reserve Adjustment

Yes

 

NoetixViews for Oracle General Ledger

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Payables invoices

GL Je SLA AP Inv Dist

GL AP Inv Je Line Details GL Je AP Inv Dist Details

No

Payables invoice payments

GL Je SLA AP Pmt Dist

GL Je AP Pmt Dist Details

No

Receivables adjustments

GL Je SLA AR Adj Dist

GL Je Tran AR Adj Dist

Yes

Receivables miscellaneous receipts

GL Je SLA AR Misc Rcpt Dist

GL Je Tran AR Misc Dist

Yes

Receivables standard receipts

GL Je SLA AR Std Rcpt Dist

GL Je Tran AR Pymt Dist

Yes

Receivables transactions

GL Je SLA AR Tran Dist

GL Je Tran AR Tran Dist

Yes

Purchasing PO and requisition encumbrances

GL Je SLA PO All Encumb

GL Je Tran All PO Encumb

Yes

Purchasing blanket purchase agreements

GL Je SLA PO Blnkt Encumb

GL Je Blanket PO Encumb

Yes

Purchasing PO encumbrances

GL Je SLA PO Encumb

GL Je Tran PO Encumb

Yes

Purchasing requisition encumbrances

GL Je SLA PO Req Encumb

GL Je Tran PO Req Encumb

Yes

 

NoetixViews for Oracle Payables

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Invoices

AP Inv Dist SLA GL Je

AP Inv GL Tr Details

No

Payments

AP Pmt Dist SLA GL Je

AP Pmt Dist GL Tr Details

No

Trial balance

AP Trial Balance Details

AP Trial Balance

No

 

NoetixViews for Oracle Receivables

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Adjustments

AR Adj Dist SLA GL Je

AR Adjustment GL Je Dist

Yes

Miscellaneous receipts

AR Misc Rcpt Dist SLA GL Je

AR Misc Pymt GL Je Dist

Yes

Standard receipts

AR Std Rcpt Dist SLA GL Je

AR Cust Pymt GL Je Dist

Yes

Transactions

AR Tran Dist SLA GL Je

AR Cust Tran GL Je Dist

Yes

 

NoetixViews for Oracle U.S.Federal Financials

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Budget authority transactions, appropriations

FV Budget Auth SLA GL JE

FV Budget Appr GL JE

Yes

Fund distributions

FV Fund Distr SLA GL JE

FV Fund Distr GL JE

Yes

Expenditures

FV SLA AP Expenditures

FV AP Expenditures

Yes

Budgetary transactions

FV SLA Budget Trans

FV Budget Transactions

Yes

Commitments

FV SLA PO Commitments

FV PO Commitments

Yes

Obligations

FV SLA PO Obligations

FV PO Obligations

Yes

 

NoetixViews for Oracle Process Manufacturing Financials

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Test accounting distributions

GMF SLA Cost Subledger

GMF Test Subledger

Yes

Updated accounting distributions

GMF SLA Cost Subledger

GMF Update Subledger

Yes

The following table correlates views that return ledger-to-subledger, final data that has been posted to General Ledger with views that return subledger-to-ledger data that is either in draft form or in final form and posted to General Ledger.

 

Ledger-to-Subledger, Subledger-to-Ledger Noetix Views

Accounting subject area

 

Subledger-to-ledger view

Asset adjustments (all)

FA Adjustments SLA GL Je

Asset transactions (all)

FA All Trans SLA GL Je

Asset depreciation histories

FA Deprn Dtl Hist SLA GL Je

Asset depreciations

FA Deprn Dtls SLA GL Je

Asset invoice transactions

FA Invoice Trx SLA GL Je

Payables invoices

GL Je SLA AP Inv Dist

AP Inv Dist SLA GL Je

Payables invoice payments

GL Je SLA AP Pmt Dist

AP Pmt Dist SLA GL Je

Receivables adjustments

GL Je SLA AR Adj Dist

AR Adj Dist SLA GL Je

Receivables miscellaneous receipts

GL Je SLA AR Misc Rcpt Dist

AR Misc Rcpt Dist SLA GL Je

Receivables standard receipts

GL Je SLA AR Std Rcpt Dist

AR Std Rcpt Dist SLA GL Je

Receivables transactions (all)

GL Je SLA AR Tran Dist

AR Tran Dist SLA GL Je

Purchasing PO and requisition encumbrances

GL Je SLA PO All Encumb

Purchasing blanket purchase agreements

GL Je SLA PO Blnkt Encumb

Purchasing PO encumbrances

GL Je SLA PO Encumb

Purchasing requisition encumbrances

GL Je SLA PO Req Encumb

NoetixViews for Oracle Contract Lifecycle Management

The Noetix business views for Oracle Contract Lifecycle Management provide a comprehensive analysis for requisitions, draft purchase orders (POs), awards, and user defined attributes (UDAs).

The Noetix views for Contract Lifecycle Management are available in the standard, Cross Operations Extension (XOP), and global forms.

Support for Subject Areas

The Noetix views for Contract Lifecycle Management cater to the following subject areas to meet the needs of requestors, buyers, and contracting professionals:

Requisitions

Headers: The PO Requisitions, PO Req Notifications, and PO Requisitions UDA views provide information about purchase requisition headers, purchase requisition notifications, and UDAs pertaining to purchase requisition headers.

Lines: The PO Requisition Lines, PO Requisition Line Pos, and PO Requisition Lines UDA views provide information about purchase requisition lines, purchase requisition lines and resulting PO lines, and UDAs pertaining to purchase requisition lines.

Distributions: The PO Req Distributions, PO SLA Requisition Dist, and PO Req Distributions UDA views provide information about purchase requisition distributions, purchase requisition distributions in Oracle Subledger Accounting, and UDAs pertaining to purchase requisition distributions.

Awards

Headers: The PO Purchase Orders, PO PO Notifications, PO Document Actions, and PO Purchase Orders UDA views provide information about award headers, PO notifications, actions performed on purchasing documents, and UDAs pertaining to award headers.

Lines: The PO PO Lines and PO PO Lines UDA views provide information about award lines and their UDAs.

Shipments: The PO PO Shipments, PO All Shipments, and PO PO Shipments UDA views provide information about standard PO shipments, all types of PO shipments, and UDAs pertaining to PO shipments.

Distributions: The PO PO Distributions, PO SLA Hub Journal Lines, and PO PO Distributions UDA views provide information about PO award distributions, subledger accounting distributions, and UDAs pertaining to award distributions.

Releases: The PO Releases view provides information about the PO releases.

Actions and notifications: The PO Document Actions view provides information about the actions performed on PO documents. The PO PO Notifications view provides notification information about POs that are awaiting actions.

Draft purchase orders: The PO Draft Distributions, PO MOD Draft Distribution, and PO PAR Draft Distribution views provide information about the draft PO distributions for awards, award modifications, and post award requests.

Invoices and payments: The following views return information about Contract Lifecycle Management when POs created in Contract Lifecycle Management are invoiced and payments are made against these invoices:

AP Invoices

AP Invoice Distributions

AP Invoice Pay Schedules

AP Checks

AP Invoice Payments

AP Interest Invoices

PO Invoices

PO Invoice Payments

PO receipts: The PO Receipts and PO Uninvoiced Receipts views return information for contract lifecycle management when goods or items are received for a PO that is created in Contract Lifecycle Management.

User defined attributes: The following views provide information about UDAs for purchase requisition headers, purchase requisition lines, purchase requisition distributions, PO headers, PO lines, PO shipments, and PO distribution levels:

PO Requisitions UDA

PO Requisition Lines UDA

PO Req Distributions UDA

PO Purchase Orders UDA

PO PO Lines UDA

PO PO Shipments UDA

PO PO Distributions UDA

Additionally, the following views return information about Contract Lifecycle Management:

AP Pmt Dist SLA GL Je

AP SLA Invoice Dist

FV SLA PO Commitments

FV SLA PO Obligations

PO PO Shipments

PO Vendor Sites

PO Vendors

XLA Accrual Write Off Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

Noetix Roles for Contract Lifecycle Management Views

The views that provide information about Contract Lifecycle Management are managed through the Noetix roles corresponding to the NoetixViews modules to which they belong. The following table lists the Noetix roles and the corresponding views.

Noetix role label

Noetix view

FEDERAL ADMINISTRATOR

FV SLA PO Commitments

FV SLA PO Obligations

PAYABLES

AP Checks

AP Interest Invoices

AP Invoice Distributions

AP Invoice Pay Schedules

AP Invoice Payments

AP Invoices

AP Pmt Dist SLA GL Je

AP SLA Invoice Dist

PURCHASING

PO All Shipments

PO Blanket Price Breaks

PO Document Actions

PO Draft Distributions

PO Invoice Payments

PO Invoices

PO MOD Draft Distribution

PO PAR Draft Distribution

PO PO All Distributions

PO PO Distributions

PO PO Distributions UDA

PO PO Lines

PO PO Lines UDA

PO PO Notifications

PO PO Shipments

PO PO Shipments UDA

PO Purchase Orders

PO Purchase Order Details

PO Purchase Orders UDA

PO Receipts

PO Releases

PO Req Distributions

PO Req Distributions UDA

PO Req Notifications

PO Requisition Line Pos

PO Requisition Lines

PO Requisition Lines UDA

PO Requisitions

PO Requisitions UDA

PO SLA Hub Journal Lines

PO SLA Requisition Dist

PO Uninvoiced Receipts

PO Vendor Sites

PO Vendors

SUBLEDGER ACCOUNTING

XLA Accrual Write Off Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

Noetix Views in Contract Lifecycle Management Workflow

The workflow for Contract Lifecycle Management that represents the supported subject areas and Noetix views is as follows.

Useful Reporting Scenarios Supported by Contract Lifecycle Management Views

The following reporting scenarios are supported by the views in Contract Lifecycle Management:

To obtain information about purchase requisitions and their UDAs, you can join the PO Requisitions and PO Requisitions UDA views.

To obtain information about the total purchase requisition amount of conformed purchase requisitions for a period, you can use the PO Requisitions view.

To obtain information about purchase requisitions related to Military Interdepartmental Purchase Request (MIPR), you can join the PO Requisitions and PO Requisitions UDA views.

To obtain information about the amended purchase requisition lines and contracting office details, you can join the PO Requisition Lines and PO Requisition lines UDA views.

To obtain information about the purchase requisition distributions and their UDAs, you can join the PO Req Distributions and PO Req Distributions UDA views.

To obtain information about the funded value change for a period and total value of funds by operating unit for a period, you can use the PO Req Distributions view.

To obtain information about the award headers and their UDAs, you can join the PO Purchase Orders and PO Purchase Orders UDA views.

To obtain information about award lines and their UDAs, you can join the PO PO Lines and PO PO Lines UDA views.

To obtain information about awards for a vendor for a period, you can use the PO PO Lines view.

To obtain information about award shipments and their UDAs, you can join the PO PO Shipments and PO PO Shipments UDA views.

To obtain information about award distributions and their UDAs, you can join the PO PO Distributions and PO PO Distributions UDA views.

To obtain information about encumbered amount for a period and POs associated with a project, you can use the PO PO Distributions view.

To obtain information about draft POs and their UDAs, you can join the PO Draft Distributions and PO Purchase Orders UDA views.

To obtain information about POs and their release details, you can use the PO Releases view.

NoetixViews for Oracle Projects

NoetixViews for Oracle Projects provides a solution for maintaining control and visibility of projects. It displays project information at a single source point enabling you to track and manage a project through the project lifecycle.

NoetixViews for Oracle Projects includes approximately 50 views that cover various project types such as capital, contract, and indirect. The subject areas covered are projects, tasks, resources, budgets, expenditures, invoices, revenues, and status inquiry. These views belong to the basic, value-added or cross-functional type and additionally are categorized as detail or summary-level views.

Detail views present transaction details as entered in Oracle Projects. Usually, these transactions can be entered in various currencies. All detail views include one or more transaction currency amount, as well as converted project and project functional currency amounts. A currency-code column differentiates the currency types for the user.

Summary views require the summation of individual transaction amounts. Therefore, summary views show the amounts in a single currency. The project functional currency and currency-code columns are not displayed.

Background

In Oracle E-Business Suite 10.7, the Oracle Project Costing module had the facility to enter receipts in multiple currencies. Oracle expanded the multi-currency functionality within the Project Costing module with Oracle
E-Business Suite 11.0.3 and then further extended the multi-currency support to Oracle Project Billing with Oracle E-Business Suite 11.5.8, Family Pack J.

NoetixViews supports multi-currency feature in the areas of Project Accounting, Project Costing, and Project Billing.

Currency Types Supported in Noetix Views for Projects

NoetixViews for Oracle Projects supports three types of currencies:

Project functional currency: The currency derived from the ledger of an operating unit. If multi-currency is enabled, each project can be maintained in a specific currency called project currency.

Project currency: The currency to which all transactions of a project are converted for processing and summarization. This can be defined per project.

Transactional currency: Can be different from project functional and project currencies with respect to subject area. For example, expenditures can take place in one currency and the agreement between customers can be in another currency. In the case of expenditures, the transactional currency is termed as expenditure currency and in the case of agreements, it becomes agreement currency.

Results of Multi-Currency Activation in Noetix Views for Projects

Activating multi-currency columns in NoetixViews results in the following changes:

All transactional views have transaction-specific currency values in the base amount columns. Additional columns for project functional currency (with the PFC suffix) and project currency (with the PC suffix) may also be generated. These additional columns are not added for every occurrence of a transactional amount column.

Most of the PFC columns corresponding to the transaction-amount columns are generated. Some of the PC columns corresponding to the transaction-amount columns are also generated.

You cannot summarize on the transaction-amount columns with this option as the columns can be in multiple currencies. You must summarize the transaction-amount columns based on the corresponding PFC or PC columns.

An expense amount in Project Currency might not equal the Payables Functional Currency amount for the same transaction.

Information related to currency codes and exchange rates is generated.

If you use the multi-currency functionality of Oracle Projects at your site, you must activate multi-currency columns in your views. Otherwise, the amount columns in your views will contain values in project functional currencies, and not display information related to currency codes and exchange rates.

NoetixViews for Oracle Process Manufacturing

The Noetix business views and pre-built answers for Oracle Process Manufacturing provide a reporting solution for the major aspects of this Oracle E-Business Suite module, such as new product development, recipe management, production, process execution, cost, quality, and regulatory management. These views also provide setup information about items, reordering rules for items, and resources for routings.

NoetixViews for Oracle Process Manufacturing includes 63 views that cater to Oracle Process Manufacturing Inventory Management (covered by the views for Oracle Inventory for Oracle E-Business Suite Release 12 and later), Oracle Process Manufacturing Product Development, Oracle Process Manufacturing Planning (covered by the views for Oracle Advanced Supply Chain Planning for Oracle E-Business Suite Release 12 and later), Oracle Process Manufacturing Process Execution, and Oracle Process Manufacturing Financials.

The views can be categorized into the following:

Basic views, such as the setup views

Value-added views, such as the summary, detail, and transactional views

Cross-functional views

Support for Subject Areas

The following tables list the subject areas of individual modules of Process Manufacturing and the corresponding Noetix views.

Subject Areas of NoetixViews for Oracle Process Manufacturing Inventory Management

Subject areas

Noetix views

Item setup: Information about items, catalog element values, lots and sublots, production rules, and reorder rules.

GMI Item Catalogs

GMI Item Master

GMI Lots Sublots

GMI Production Rules

GMI Warehouse Rules

On-hand inventory: Information about stock locators, inventory transactions, on-hand inventory by location and lot, total on-hand inventory by process organization, and warehouse transfers.

GMI Inv Stock Locators

GMI Inv Transactions

GMI Onhand Inv By Location

GMI Onhand Inv By Lot

GMI Onhand Inv Rollup

GMI Warehouse Transfer

Unallocated inventory: Rollup and summary information about allocated and unallocated inventories.

GMI Inv Unallocated Rollup

GMI Unallocated Inventory

Month-end inventory: Information about the month-end inventory balances.

GMI Month End Inventory

Noetix views for Process Manufacturing Inventory Management are applicable for only Oracle E-Business Suite versions prior to Release 12, after which the views for Inventory provide the same functionality.

For Oracle E-Business Suite Release 12 and later, the following views for Inventory are available for Process Manufacturing.

Subject Areas of NoetixViews for Oracle Inventory Related to Process Manufacturing

Subject areas

Noetix views

Item setup: Information about customer items, item catalogs, process manufacturing attributes, item relationships, item lots, and stock locators.

INV Customer Items

INV Item Catalogs

INV Item Inventory Attributes

INV Item Process Attribute

INV Item Relationships

INV Items

INV Lot Details

INV Stock Locators

On-hand inventory: Information about unallocated inventory by lot and location and on-hand quantities rolled up to the inventory organization.

INV Item Onhand By Lot

INV Onhand Quantities

INV Onhand Rollup

INV Safety Stock

Unallocated inventory: Information about item unallocated inventory and total unallocated inventory by inventory organization.

INV Unallocated Inventory

INV Unallocated Rollup

Period close inventory: Information about period close inventory balances.

INV Period Close Details

Inventory reservations: Information about item reservations from various demand sources, such as purchase orders (POs), accounts, account aliases, process batches, jobs or schedules, and sales orders.

INV Reservations

Inventory transactions: Information about different inventory transactions, such as accounts, cycle counts, lots, POs, requisitions, and sales orders.

INV Account Transactions

INV Alias Transactions

INV Cycle Count Transactions

INV Lot Transactions

INV Physical Inv Transactions

INV PO Transactions

INV Requisition Transactions

INV Sales Order Transactions

INV Serial Number Trans

INV Transaction Details

INV Transactions

 

Subject Areas of NoetixViews for Oracle Process Manufacturing Product Development

Subject areas

Noetix views

Formulas: Information about formulas, such as the numbers, classes, owners, items, phantom items, required quantities, input and output quantities, and units of measurement (UOMs) for the item quantity.

GMD Formulas

Recipes: Information about recipes, customers, process losses, and validity rules.

GMD Recipe Customers

GMD Recipe Process Loss

GMD Recipe Validity Rules

GMD Recipes

Routings: Information about routings, associated operations, and resources.

GMD Routing Resources

GMD Routings

Quality management setup: Information on test cases, associated customers, test codes, and test values.

GMD Qc Customer Tests

GMD Qc Tests

Quality management: Information on samples taken from customers, inventories, monitoring sources, suppliers, and work in process and the resulting activities; test results; and quality conformance requirements.

GMD Qc Customer Samples

GMD Qc Inventory Samples

GMD Qc Monitoring Samples

GMD Qc Results

GMD Qc Specifications

GMD Qc Supplier Samples

GMD Qc WIP Samples

 

Subject Areas of NoetixViews for Oracle Process Manufacturing Planning

Subject areas

Noetix views

Action messages: Information about the material requirements planning (MRP) action message transactions and the pegging and transactions associated with each action number in an MRP run.

GMP Action Messages

GMP MRP Action Msg Pegging

Forecast: Information about forecasts.

GMP Forecast Details

Demand/Supply: Information at the summary level about the demand and supply sources of an item for all transactions in each MRP run.

GMP MRP Demand Supply Dtl

Planning: Information about pending inventory transactions that are not bucketed as supply and demand.

GMP MRP Mtrl Unbucketed

From Release 12, Advanced Supply Chain Planning must be used in place of Process Manufacturing Planning. Therefore, for Release 12 and later, the views for Advanced Supply Chain Planning should be used for planning-related data. For Oracle E-Business Suite Release 12 and later, refer to the following Noetix views for Advanced Supply Chain Planning to avail of functionality that is similar to what is provided by the views for Process Manufacturing Planning. However, these views are a part of NoetixViews for Oracle Advanced Supply Chain Planning and are not bundled with NoetixViews for Oracle Process Manufacturing.

Subject Areas of NoetixViews for Oracle Advanced Supply Chain Planning Related to Process Manufacturing

Subject areas

Noetix views

Exception, pegging details: Information about exception details and pegging details for plans.

MSC Exceptions

MSC Pegging Details

Forecast consumptions: Information about forecast consumptions of plans.

MSC Forecast Consumptions

Demand/Supply: Information about demands and supplies for plans.

MSC Demand Details

MSC Supply Details

Vertical Plan Details: Information about the vertical plans of the planned items.

MSC Vertical Plan Details

 

Subject Areas of NoetixViews for Oracle Process Manufacturing Process Execution

Subject areas

Noetix views

Firm planned order: Information about firm planned orders of items, recipes,
formulas, and routings.

GME Firm Planned Orders

Production Batch: Information about batches, such as deleted ingredients,
headers, materials, steps, activities, and associated resources.

GME Batch Deleted Details

GME Batch Headers

GME Batch Material Details

GME Batch Step Details

GME Batch Step Rsrc Actvty

 

Subject Areas of NoetixViews for Oracle Process Manufacturing Financials

Subject areas

Noetix views

Costing setup: Information about the association between cost and inventory organizations, standard burden or overhead costs, standard component costs, overhead codes and percentages for cost calculations, and resource costs.

GMF Cost Organization Assc

GMF Cost Warehouse Assoc

GMF Item Burden Costs

GMF Item Costs

GMF Overhead Percentages

GMF Resource Costs

Costing: Information about the rolled up costs and lot-level costs for production items.

GMF Item Costs Rollup

GMF Lot Cost Details

Subledger Accounting views (for Oracle E-Business Suite versions prior to Release 12): Information about test updates of accounting distributions of different transactions and information about accounting distributions of different transactions that are updated to the subledger.

 

Subledger Accounting view (for Oracle E-Business Suite Release 12 and later): Information about subledger transactions in draft and final modes.

GMF Test Subledger

GMF Update Subledger

 

 

 

 

 

 

 

GMF SLA Cost Subledger

The GMF Cost Organization Assc, GMF Overhead Percentages, and GMF Lot Cost Details views are available for only Release 12 and later. Also, the GMF Cost Warehouse Assoc view is obsolete in Release 12 and later and returns only historical data; use the GMF Cost Organization Assc view instead.

Support for Flexfields

The following tables list the descriptive flexfields in Process Manufacturing and the Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle Process Manufacturing Inventory Management

Descriptive flexfield

Noetix view

Item Catalog Groups

GMI Item Catalogs

Item Information

GMI Item Master

GMI Onhand Inv By Lot

GMI Onhand Inv Rollup

Lot/Sublot Information

GMI Lots Sublots

Production Rules

GMI Production Rules

Warehouse Information

GMI Warehouse Transfer

Warehouse Rules Information

GMI Warehouse Rules

 

Descriptive Flexfields Supported in NoetixViews for Oracle Inventory Related to Process Manufacturing

Descriptive flexfield

Noetix view

Item

INV Item Process Attribute

Lot

INV Lot Details

Lot Number

INV Lot Details

Lot Number Character

INV Lot Details

Lot Number Date

INV Lot Details

 

Descriptive Flexfields Supported in NoetixViews for Oracle Process Manufacturing Product Development

Descriptive flexfield

Noetix view

Formula Line Attributes

GMD Formulas

Operation Resources Flexfields

GMD Routing Resources

Quality Results

GMD Qc Results

Quality Specifications

GMD Qc Specifications

Quality Tests

GMD Qc Customer Tests

GMD Qc Tests

Recipe Flexfields

GMD Recipe Customers

GMD Recipe Process Loss

GMD Recipe Validity Rules

GMD Recipes

Routing Header Flexfield

GMD Routings

Samples

GMD Qc Customer Samples

GMD Qc Inventory Samples

GMD Qc Monitoring Samples

GMD Qc Supplier Samples

GMD Qc WIP Samples

 

Descriptive Flexfields Supported in NoetixViews for Oracle Process Manufacturing Process Execution

Descriptive flexfield

Noetix view

Batch Information

GME Batch Deleted Details

GME Batch Headers

GME Firm Planned Orders

Batch Steps Information

GME Batch Step Details

GME Batch Step Rsrc Actvty

Material Details

GME Batch Material Details

 

Descriptive Flexfields Supported in NoetixViews for Oracle Process Manufacturing Financials

Descriptive flexfield

Noetix view

Cost Detail Information

GMF Item Costs

GMF Item Costs Rollup

Cost Warehouse Association Master

GMF Cost Warehouse Assoc

Percentage Burden Codes Information

GMF Overhead Percentages

The following tables list the key flexfields in Process Manufacturing and the Noetix views that support these flexfields.

Key Flexfields Supported in NoetixViews for Oracle Inventory Related to Process Manufacturing

Key flexfield

Noetix view

Detailed Container Item

INV Customer Items

Item

INV Customer Items

INV Item Catalogs

INV Item Onhand By Lot

INV Item Process Attribute

INV Item Relationships

INV Lot Details

INV Onhand Rollup

INV Period Close Details

INV Stock Locators

Item Catalogs

INV Item Catalogs

Locator

INV Stock Locators

Master Container Item

INV Customer Items

Supply Locator

INV Item Process Attribute

Yield Locator

INV Item Process Attribute

 

Key Flexfields Supported in NoetixViews for Oracle Process Manufacturing Product Development

Key flexfield

Noetix view

Item

GMD Formulas

GMD Qc Customer Samples

GMD Qc Inventory Samples

GMD Qc Results

GMD Qc Specifications

GMD Qc Supplier Samples

GMD Qc WIP Samples

Formula

GMD Recipes

Product

GMD Recipes

Sample Locator

GMD Qc Customer Samples

GMD Qc Inventory Samples

GMD Qc Monitoring Samples

GMD Qc Supplier Samples

GMD Qc WIP Samples

Source Locator

GMD Qc WIP Samples

Storage Locator

GMD Qc Customer Samples

GMD Qc Inventory Samples

GMD Qc Monitoring Samples

GMD Qc Supplier Samples

GMD Qc WIP Samples

Test Kit

GMD Qc Results

Validity

GMD Recipe Validity Rules

 

Key Flexfields Supported in NoetixViews for Oracle Process Manufacturing Process Execution

Key flexfield

Noetix view

Ingredient

GME Batch Deleted Details

Item

GME Batch Material Details

GME Firm Planned Orders

Product

GME Batch Deleted Details

GME Batch Headers

Sample Locator

GME Batch Material Details

GME Firm Planned Orders

 

Key Flexfields Supported in NoetixViews for Oracle Process Manufacturing Process Financials

Key flexfield

Noetix view

Accounting Flexfield

GMF SLA Cost Subledger

Cost Category

GMF Overhead Percentages

GL Business Category

GMF Overhead Percentages

GL Category

GMF Overhead Percentages

GL Product Line Category

GMF Overhead Percentages

Item

GMF Item Burden Costs

GMF Item Costs

GMF Item Costs Rollup

GMF Lot Cost Details

GMF Overhead Percentages

GMF SLA Cost Subledger

Noetix Roles for Process Manufacturing

NoetixViews for Oracle Process Manufacturing includes only the following global roles:

OPM INVENTORY (for Oracle E-Business Suite versions prior to Release 12)

PRODUCT DEVELOPMENT

PROCESS EXECUTION

PROCESS PLANNING (for Oracle E-Business Suite versions prior to Release 12)

OPM FINANCIALS

Noetix Views in Process Manufacturing Workflow

The following diagram explains the process flow of Process Manufacturing and the important Noetix views that provide information at each point in the process flow.

Other Considerations

The following points would help you optimally use the views for Process Manufacturing:

NoetixViews for Oracle Process Manufacturing Inventory Management returns the transactional data for only Oracle E-Business Suite versions prior to Release 12. From Release 12, Inventory supports the Process Manufacturing functionality for inventory. Therefore, for these versions of Oracle E-Business Suite, NoetixViews for Oracle Inventory returns information relevant to Process Manufacturing Inventory Management transactions through the INV Transactions and INV Transaction Details views. For Release 12 and later, Noetix views for Process Manufacturing Inventory Management return only historic data. To view the historic data relevant to Process Manufacturing Inventory Management transactions, you can use the GMI Inv Transactions view.

As the concept of Subledger Accounting is introduced in Oracle E-Business Suite Release 12, some of the existing Noetix views for Process Manufacturing Financials in Release 12 return only historic data. These views are GMF Test Subledger and GMF Update Subledger. For Release 12 and later, cost and accounting transaction data is returned by the GMF SLA Cost Subledger view.

Noetix views for Process Manufacturing Planning return only historic data for Release 12 and later. From Release 12, Noetix views for Advanced Supply Chain Planning, such as MSC Demand Details, MSC Designator Details, MSC Exceptions, MSC Pegging Details, and MSC Supply Details, return similar information as provided by the transaction views for Process Manufacturing Planning.

In Oracle E-Business Suite, planning recommendations from Advanced Supply Chain Planning become purchase requisitions in Oracle Purchasing. Data for purchase requisitions can be viewed through the PO Requisitions view. Through regular transactions in Purchasing, these requisitions become purchase orders (POs), shipments, and receipts, the details of which can be viewed through the PO PO Lines, PO Purchase Orders, PO PO Shipments, PO Receipts, and PO Uninvoiced Receipts views.

The additional details of sales orders for items in Process Manufacturing are maintained in Oracle Order Management and can be viewed through the OE Deliveries, OE Drop Shipments, OE Orders, and OE Returns views.

The GMD Qc Monitoring Samples view requires Family Pack K (11i.OPM PF.K) to be generated for Oracle E-Business Suite versions prior to Release 12.

NoetixViews for Oracle Time and Labor

The Noetix business views and pre-built answers for Oracle Time and Labor return setup information for timecard processing, missing timecards, Batch Element Entry (BEE) batches, and various time management structures and policies and also summary and detailed information for self-service and professional timecard data entry.

Support for Time and Labor reporting is also provided by NoetixViews for Oracle Human Resources, NoetixViews for Oracle Projects, and NoetixViews for Oracle Purchasing.

Twenty views are available in standard and global versions. The views can be categorized as basic or value-added views, or as setup, summary, and detail views. For most of the views, the access of Noetix query users to data is dependent on the security profiles set up in Oracle Human Resources. Moreover, for the global version of these views, the security profiles can be applied or ignored while Noetix query users access data. For all the global views, the list of business groups for which data will be returned can be customized. For more information, contact the Noetix System Administration User.

Support for Subject Areas

The following table lists the subject areas of Time and Labor and the corresponding Noetix views.

Subject Areas of NoetixViews for Oracle Time and Labor

Subject areas

Noetix views

Basic Setup: Work plans, shifts, and rotation plans.

HXC Rotation Plans

HXC Work Plans

Earning policy setup

HXC Earning Policies

Time Store Setup: Time entry rules and time entry rule groups.

HXC Time Entry Rule Groups

Employee Assignments: Mapping of employee assignments with time management policies

HXC Assignment Time Info

Timecards: Latest information, missing entries, errors, and historical information for professional timecards; latest information, missing entries, time category hours, approval action history, and historical information for self-service timecards; and summary information for both types of timecards

HXC PUI Latest Timecards

HXC PUI Missing Timecards

HXC PUI Time Entry Errors

HXC PUI Timecard History

HXC SS Latest Timecards

HXC SS Missing Timecards

HXC SS Time Category Hours

HXC SS Timecard Action Hist

HXC SS Timecard History

HXC Timecard Summary

BEE Batches: Header-level information, line-level information, and error messages

HXC BEE Batch Headers

HXC BEE Batch Lines

HXC BEE Error Messages

Assignment and person historical information

HXC All Assignment Hist

HXC All Person Hist

Support for Flexfields

The following tables list the flexfields in Oracle Time and Labor and the corresponding Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle Time and Labor

Descriptive flexfield

Noetix view

Additional Timecards Information

HXC PUI Latest Timecards

HXC PUI Timecard History

OTL Additional Assignment Information

HXC Assignment Time Info

OTL Information Types

HXC SS Latest Timecards

HXC SS Timecard History

OTL Timecard Summary Detail

HXC PUI Latest Timecards HXC PUI Timecard History

 

Key Flexfields Supported in NoetixViews for Oracle Time and Labor

Key flexfield

Noetix view

Cost Allocation Flexfield

HXC BEE Batch Lines

HXC PUI Latest Timecards

HXC PUI Timecard History

Grade Flexfield

HXC All Assignment Hist

Job Flexfield

HXC All Assignment Hist

People Group Flexfield

HXC All Assignment Hist

Position Flexfield

HXC All Assignment Hist

Noetix Roles for Time and Labor

NoetixViews for Oracle Time and Labor includes standard and global roles. For your Oracle E-Business Suite setup, a set of standard views is generated for each business group, while a set of global views is generated for all business groups. You can use the views under any role that is assigned to you. Contact your Noetix System Administration User if you have any queries regarding the roles granted to you.

Noetix Views in Time and Labor Workflow

The following diagram explains the process flow of Oracle Time and Labor and the Noetix views that provide information at each point in the process flow.

Additionally, the HXC All Assignment Hist and HXC All Person Hist views have been provided for historical information and the enabling of joins between views. The HXC Timecard Summary view has been provided so that information pertaining to both self-service and professional timecards can be retrieved through a single view. These views do not fit into the Time and Labor workflow.

Tips and Other Considerations

The following points could help you optimally use the views for Time and Labor:

While querying the HXC PUI Missing Timecards and HXC SS Missing Timecards views, make sure that you filter the records by the From Date and To Date columns. Otherwise, the views may return incorrect data.

The summary view HXC Timecard Summary can be joined to the detail views HXC PUI Latest Timecards and HXC PUI Timecard History using the PUI Timecard ID column. It can also be joined to the detail views HXC SS Latest Timecards and HXC SS Timecard History using the SS Timecard ID column.

In the HXC SS Time Category Hours view, the columns pertaining to hours for time categories are prefixed with “TC$”. The number of such columns depends on the number of time categories defined at your site.

If you add a new time category after this view has been generated, you cannot see the details of the new time category in the view immediately. For including the newly added details, this view has to be regenerated. Contact your Noetix System Administration User for regenerating the view.

If you have access to the Noetix views for Purchasing at your site, you can view the information relevant to Time and Labor through the PO Closed Uninv Receipts, PO PO Lines, PO Receipts, and PO Uninvoiced Receipts views.

If you have access to the Noetix views for Human Resources at your site, you can view the information relevant to Time and Labor through the HR Emp Absence Hist view.

If you have access to Noetix views for Projects at your site, you can concatenate the SS Timecard ID and Time Entry Version Number columns of the HXC SS Timecard History view with a hyphen (“-”) and join them to the Exp Item External Sys Ref column of the PA All Expenditure Items view to retrieve information relevant to Time and Labor from Projects.

NoetixViews for Oracle Quality

The Noetix business views and pre-built answers for Oracle Quality return information about the core elements of the Quality module, such as collection elements, specifications, collection plans, and quality results.

These views can be categorized as basic and value-added, including seven basic views and three value-added views. Additionally, Noetix gives you the option of dynamically generating two sets of views for quality results. The number of these views depends upon the number of collection plans and collection plan types set up at your site and the options selected during generation of the views.

Support for Subject Areas

NoetixViews for Oracle Quality provides views that cater to the following subject areas:

Collection Elements

These views provide information about collection elements and the action rules associated with the collection elements. The following views are available:

QA Col Elem Action Rules

QA Collection Elements

Specifications

These views provide information about specifications and the elements associated with the specifications. The following views are available:

QA Quality Spec Elements

QA Quality Specifications

Collection Plans

These views provide information about collection plans, transactions and triggers associated with the collection plans and collection plan elements, and action rules associated with the collection plans. The following views are available:

QA Collection Plan Smry

QA Collection Plan Trans

QA Plan Elem Action Rules

Quality Results

These views provide information about the results entered for collection plans. There are three types of views:

View for all collection plan results: The QA Collection Plan Rslts view displays the results collected for all the collection plans.

Views for results collected during transactions in Oracle Work in Process: The QA WIP Completion Trx Rslts and QA WIP Move Trx Rslts views display results collected during completion and move transactions respectively, occurring in the Oracle Work in Process module. These views are generated for only those roles that correspond to inventory organizations that are enabled for Work in Process.

Site-specific views: Two sets of views can be dynamically generated on the basis of the collection plans and collection plan types set up at your site. The views based on collection plans are named as QA Rslt <plan name>, where <plan name> represents the collection plan name at your site. The views based on collection plan types are named as QA Rslt PType <plan type>, where <plan type> represents the name of the collection plan type at your site.

The views pertaining to Work in Process transactions and site-specific views will return information for newly added collection plans and collection plan elements only after being regenerated. Contact your Noetix System Administration User for regenerating the views.

Support for Flexfields

The following tables list the flexfields in Oracle Quality and the corresponding Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle Quality

Descriptive flexfield

Noetix view

Collection Elements

QA Col Elem Action Rules

QA Collection Elements

Collection Plan Elements

QA Plan Elem Action Rules

Collection Plans

QA Collection Plan Smry

QA Collection Plan Trans

QA Plan Elem Action Rules

Specification Elements

QA Quality Spec Elements

Specifications

QA Quality Specifications

 

Key Flexfields Supported in NoetixViews for Oracle Quality

Key flexfield

Noetix view

Item Categories

QA Quality Specifications

Items

QA Quality Specifications

QA WIP Completion Trx Rslts

Noetix Roles for Quality

NoetixViews for Oracle Quality includes standard and Cross Operations Extension (XOP) roles. For your Oracle E-Business Suite setup, a set of standard views is generated for each inventory organization, while a set of XOP views is generated for each combination of a chart of accounts and an item master organization. You can use the views under any role that is assigned to you. Contact your Noetix System Administration User if you have any queries regarding the roles granted to you.

The QA Rslt <plan name> view will not be generated under XOP roles.

Noetix Views in Quality Workflow

The following diagram explains the process flow in Oracle Quality and the Noetix views that provide information at each point in the process flow.

NoetixViews for Oracle Cash Management

The Noetix business views and pre-built answers for Oracle Cash Management provide a reporting solution for the major aspects, such as transactions, reconciliation, and automatic clearing.

Additionally, you can analyze information about the bank accounts, invoice checks and payments, and transactions prior to reconciliation using the views for Oracle Payables and Oracle Receivables that are available as part of Cash Management. Two basic views and a value added view are available for Noetix views for Oracle Payables. Similarly, two basic views are available for Noetix views for Oracle Receivables. The five views are available in the standard, Cross Operations Extension (XOP), and global forms.

Support for Subject Areas

NoetixViews for Cash Management cater to the following subject areas:

Banks

Bank Statements

Cash Transfers

Cash Flow

Banks

The AP Bank Accounts view for the Banks subject area provides information about the bank accounts, bank branches, and contact details in bank branches. Though a part of NoetixViews for Oracle Payables, this view is also available through the CASH MANAGEMENT role.

Bank Statements

The CE Bank Stmt Line Dtls and CE Reconciliation Lines views for the Bank Statements subject area provide information about the reconciled transactions and their impact on the bank account during a period. Additionally, information about the reconciled statement lines is provided.

Though a part of NoetixViews for Oracle Payables, the AP Checks and AP Invoice Checks views are also available through the CASH MANAGEMENT role so that the transactions prior to reconciliation are available. For the same reason, the AR Cash Receipts and AR Cash Receipts Combined views have been made available through the CASH MANAGEMENT role even though these views belong to NoetixViews for Oracle Receivables.

Cash Transfers

The CE Cash Transfers view for the Cash Transfers subject area provides information about the cash transfers among banks within or across legal entities. The cash transfers can be intra-company or inter-company. For an intra-company cash transfer, the source and destination bank accounts must be in the same legal entity. For an inter-company cash transfer, the source and destination bank accounts can be in different legal entities.

Cash Flow

The CE Cash Flow Details view for the Cash Flow subject area provides information about cash flows, source bank, destination bank, and clearing details. The cash flow may happen because of the manual entry of bank account transfers or the Sweep Transactions Generation, Generate Cash Leveling Transfers, or Bank Statement Cashflow Creation program. The view appears only for Oracle E-Business Suite Release 12 and later.

Support for Flexfields

The following tables list the flexfields in Oracle Cash Management and the corresponding Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle Cash Management

Descriptive flexfield

Noetix views

Statement Headers

CE Bank Stmt Line Dtls

Statement Lines

CE Bank Stmt Line Dtls

Cash Transfers

CE Cash Transfers

Bank Account

AP Bank Accounts

Bank Branch

AP Bank Accounts

Payment Information

AP Checks, AP Invoice Checks

Invoice

AP Invoice Checks

Invoice Payments

AP Invoice Checks

Payment Documents

AP Invoice Checks

Vendor

AP Invoice Checks

Receipt Information

AR Cash Receipts, AR Cash Receipts Combined

Customer information OLD

AR Cash Receipts, AR Cash Receipts Combined

Party Information

AR Cash Receipts, AR Cash Receipts Combined

Payment Schedule Information

AR Cash Receipts, AR Cash Receipts Combined

Accounting Calendar: Periods

AR Cash Receipts, AR Cash Receipts Combined

Customer Credit Profile Information OLD

AR Cash Receipts, AR Cash Receipts Combined

 

Key Flexfields Supported in NoetixViews for Oracle Cash Management

Key flexfield

Noetix views

Accounting Flexfield

AR Cash Receipts AR Cash Receipts Combined

Noetix Roles for Cash Management

NoetixViews for Oracle Cash Management has only a global role. The global role contains a set of views generated for all the business groups configured in the Oracle E-Business Suite instance. Noetix Views for Cash Management includes the CASH MANAGEMENT role.

Noetix Views and Cash Management Workflow

The following diagram explains the process flow of Cash Management and the corresponding subject areas supported by Noetix views.

For more information about the Noetix supported subject areas and the views corresponding to each subject area, see Support for Subject Areas.

Tips and Other Considerations

The following points would help you optimally use the views for Cash Management:

Noetix views for Cash Management do not cover the cash forecasting and cash positioning concepts.

The bank accounts-related information is maintained at the operating unit level for Oracle E-Business Suite versions prior to Release 12 and at the legal entity level for Oracle E-Business Suite Release 12 and later.

NoetixViews for Oracle Project Management

The Noetix business views and pre-built answers for Oracle Project Management provide a reporting solution to manage a project based on a single, integrated, accurate view of all project-related activities. NoetixViews for Oracle Project Management helps to track and manage the various project activities, such as creating, planning, and tracking of project workplans, budgets, and forecasts throughout the project life cycle. The views belong to the basic, value added, or cross functional types and additionally are categorized as set-up views.

Support for Subject Areas

NoetixViews for Oracle Project Management cater to the following subject areas:

Workplan

Resource

Budget

Manage Progress

Manage Issues

Schedules

Forecast

Project Sets

Workplan

The PA Proj User Define Attrs, PA User Defined Attrs, and PA Deliverable Actions views for the Workplan subject area help to review deliverables, work breakdown structures and dependencies, assigned resources, and project progress.

Resource

The PA WP Resource Usages view for the Resource subject area provides workplan resource usages, assigned resources, and staff resource requirements for projects.

Budget

The PA All Expenditure Items, PA Financial Plan Impacts, and PA Financial Plan Tasks views for the Budget subject area provide financial breakdown structures; published workplans; and generated, adjusted, submitted, and approved budgets for projects. Though a part of NoetixViews for Oracle Projects, the PA All Expenditure Items view is also available through the PROJECT MANAGEMENT role.

Manage Progress

The PA Tasks, PA Projects, PA Project Status Reports, and PA Workplan Details views for the Manage Progress subject area provide progress against tasks and deliverables. Though a part of NoetixViews for Oracle Projects, the PA Tasks and PA Projects views are also available through the PROJECT MANAGEMENT role.

Manage Issues

The following views for the Manage Issues subject area are used to track issues and display changes in the issues:

PA Control Item Actions

PA Control Item Comments

PA Control Item Impacts

PA Control Item Relations

PA Control Items

PA Supplier Deductions

PA Supplier Impact Dtls

Schedules

The PA WP Resource Usages and PA Project Exceptions views for the Schedules subject area provide information about workplans, schedules, and team schedule updates.

Forecast

The following views for the Forecast subject area provide information about the generated, reviewed, submitted, approved, and republished forecasts:

PA Project Status Reports

PA Workplan Details

PA Project Exceptions

PA Financial Plan Tasks

Project Sets

The PA Project Sets view for the Project Sets subject area provides information about the projects that are associated with a project set.

Support for Flexfields

The following table lists the flexfields in Project Management and the corresponding Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle Project Management

 

Descriptive flexfield

Noetix views

Human Resources

PA Tasks

PA Projects

Control Items Desc Flex

PA Control Items

Expenditure Items

PA All Expenditure Items

Project Status Report Sections

PA Project Status Reports

Project Sets

PA Project Sets

Projects

PA Tasks

PA All Expenditure Items

PA Projects

PA Workplan Details

Project and Task

PA Proj User Define Attrs

UDA EXT TL

PA Proj User Define Attrs

Tasks

PA Tasks

PA All Expenditure Items

PA Financial Plan Tasks

PA Workplan Details

Planning Transactions

PA WP Resource Usages

Noetix Views in Project Management Workflow

The following diagram explains the process flow of Project Management and the corresponding subject areas supported by Noetix views.

For more information about the Noetix supported subject areas and the views corresponding to each subject area, see Support for Subject Areas.

Noetix Roles for Project Management

NoetixViews for Oracle Project Management includes the standard, Cross Operations Extension (XOP), and global roles. A standard role contains a set of views generated for each operating unit. For an XOP role, a set of views is generated corresponding to one or more operating units depending on the chart of accounts settings in your Oracle E-Business Suite instance. A global role contains a set of views generated for the business groups in your Oracle E-Business Suite instance. A user can access all the views corresponding to an assigned role. Contact your Noetix System Administration User if you have any queries regarding the roles granted to you.

NoetixViews for Oracle Project Management uses the PROJECT MANAGEMENT role.

Replacement Views for Release 12

This section provides information about the views available for Oracle E-Business Suite 11i and their replacements in Oracle E-Business Suite Release 12. The 11i views that are available in Release 12 have been made obsolete and returns historical data. Also, some of the views available for 11i do not have replacement views in Release 12 because of the functional changes made in Release 12. The 11i replacement views for Oracle Subledger Accounting are discussed in Other Cross-Functional Views for Subledger Accounting in “NoetixViews for Oracle Subledger Accounting.”

Noetix Views for Projects

The table provided in this section lists the 11i views for Oracle Projects and their replacements for Release 12. The details also cover information about the availability of the 11i view in Release 12.

View for Oracle E-Business Suite 11i

Available for Release 12

Replacement view for Release 12

Change description

PB Revenue Distributions

Yes

PA Rev Dist SLA GL JE

The legacy view has been made obsolete because it will return only historical accounting data for Release 12.

PA Organizations

Yes

PA Organization History

The legacy view has been made obsolete because of granularity-related changes and will be removed in a future release.

PA Project Workplan

Yes

PA Workplan Details

The legacy view has been made obsolete because of functional changes and standardization of the view.

Noetix Views for Process Manufacturing Inventory Management

The table provided in this section lists the 11i views for Oracle Process Manufacturing Inventory Management and their replacements in Release 12. The details also cover information about the availability of the 11i view in Release 12.

The 11i views listed in this section are applicable for only Oracle E-Business Suite 11.5.10.2. For Release 12 and later, the views have been made obsolete because Oracle Process Manufacturing Inventory Management has been merged into Oracle Inventory; therefore, the views return only historical data.

View for Oracle E-Business Suite 11i

Available for Release 12

Replacement view for Release 12

GMI Inv Stock Locators

Yes

INV Stock Locators

GMI Inv Transactions

Yes

INV Transaction Details

GMI Inv Unallocated Rollup

Yes

INV Unallocated Rollup

GMI Item Catalogs

Yes

INV Item Catalogs

GMI Item Master

Yes

INV Items and INV Item Inventory Attributes

GMI Lots Sublots

Yes

INV Lot Details

GMI Month End Inventory

Yes

INV Period Close Details

GMI Onhand Inv By Location

Yes

INV Onhand Quantities

GMI Onhand Inv By Lot

Yes

INV Item Onhand By Lot

GMI Onhand Inv Rollup

Yes

INV Onhand Rollup

GMI Unallocated Inventory

Yes

INV Unallocated Inventory

GMI Production Rules

Yes

Not available

GMI Warehouse Rules

Yes

Not available

GMI Warehouse Transfer

Yes

Not available

Noetix Views for Process Manufacturing Planning

This section provides information about the 11i views for Oracle Process Manufacturing Planning and their replacements in Release 12.

The 11i views listed in this section are applicable for only Oracle E-Business Suite 11.5.10.2. For Release 12 and later, the Process Manufacturing Planning functionality is not supported, and, therefore, the views have been made obsolete and return only historical data. For Release 12 and later, use Noetix views for Oracle Advanced Supply Chain Planning instead of Noetix views for Process Manufacturing Planning.

The following views for Process Manufacturing Planning return historical data in Release 12:

GMP Action Messages

GMP Forecast Details

GMP MRP Action Msg Pegging

GMP MRP Demand Supply Dtl

GMP MRP Mtrl Unbucketed

Noetix Views for Process Manufacturing Financials

This section provides information about the 11i views for Oracle Process Manufacturing Financials and their replacements in Release 12.

The GMF Cost Warehouse Assoc view for Process Manufacturing Financials is applicable for only Oracle
E-Business Suite 11.5.10.2. For Release 12 and later, the view has been made obsolete and returns only historical data. For Release 12 and later, use the GMF Cost Organization Assc view.

Noetix Views for Inventory

This section provides information about the 11i views for Inventory and their replacements in Release 12.

The INV Demands view for Inventory is available for only Oracle E-Business Suite 11.5.10.2. For Release 12 and later, use the INV Reservations view.

Noetix Views for U.S. Federal Financials

This section provides information about the 11i views for Oracle U.S. Federal Financials and their replacements in Release 12.

The 11i views listed in this section have been made obsolete for Release 12. The following views for U.S. Federal Financials return historical data in Release 12:

AR FV Trans Code Mappings

FV Enhanced Trans Events

FV Transaction Codes

Noetix Views for Human Resources

This section provides information about the legacy views for Oracle Human Resources and their replacements for Release 12.

The HR AP 1099 Vendors view for Human Resources is available for only Oracle E-Business Suite 11.5.10.2. For Release 12 and later, use the HR AP 1099 Payments view.

Noetix Views for Enterprise Asset Management

This section provides information about the legacy views for Oracle Enterprise Asset Management and their replacements in Release 12.

The EAM WO Cost Details view for Enterprise Asset Management is applicable for only Oracle E-Business Suite 11.5.10.2. The view has been made obsolete in Release 12, and, therefore, it will return incorrect information for Release 12. For Release 12 and later, the functionality is provided through the EAM WO Actual Cost Details, EAM WO Estimated Cost Dtls, and EAM WO Oprn Cost Summary views.

Published:

Module-Specific Information

NoetixViews for Oracle General Ledger

In Oracle E-Business Suite Release 12, the term “set of books” has been replaced by “ledger”. The terms “set of books” and “ledger” refer to the same concept. Also, in Release 12, the term “base currency” has been replaced with “primary currency” and the term “foreign currency” has been replaced with “transaction currency.”

The Noetix business views and pre-built answers for Oracle General Ledger provide a reporting solution for the major aspects of this Oracle E-Business Suite module, such as finding information about the journal entries entered corresponding to the actual, budget, and encumbrance transactions, and reviewing account balances. These views also provide setup information about summary accounts, accounting hierarchies, and budget organizations.

The following sections provide an overview of NoetixViews for Oracle General Ledger.

Support for Subject Areas

Noetix views for General Ledger can be mainly categorized into the following subject areas:

  • Journals

  • Balances

  • Budgets

  • Subledger distributions

  • Other areas

Journals

Noetix views that return information about journals provide information about actual and encumbrance journal batches, journal entries, and journal entry lines. In these views, for actual journals, the information is available in the primary, transaction, and statistical currencies. For encumbrance journals, the information is available in the primary currency.

To view the actual journal entry line information in the primary currency, use the GL Journal Entry Lines view. To view the actual journal entry line information in all currencies, use the GL All Je Lines view.

One of the reporting scenarios where these views can be helpful is for finding information about journal entry lines, journal entries, or journal batches that have been not posted for the current period. Another reporting scenario is to find the journal entries and journal entry lines of a journal batch entered in the transaction currency.

Balances

Noetix views that return information about balances show the detail and summary balances.

The detail balance views provide information about actual balances, budget balances, encumbrance balances, and balance comparison for detail accounts. The actual and budget balances are available in the primary, transaction, and statistical currencies; encumbrance balances in the primary currency; and balance comparison in the primary and statistical currencies. Balance comparison views provide comparison between the budget and actual balances and between the budget, actual, and encumbrance balances. Balance views also provide information about funds available for the summary and detail accounts in the primary and transaction currencies.

The summary balance views provide information about the actual balances of the summary accounts in the primary currency and the balance comparison for the summary accounts in the primary currency. The rollup account and budget balance views provide summarized actual and budget balances respectively of detail accounts grouped by the natural account and balancing account segments in the primary currency. The rollup parent balances and rollup parent budget views provide the rollup actual and budget balances of all the child or detail accounts corresponding to a parent account in the primary currency.

To view the actual balance information in the primary currency, use the GL Balances view. To view actual balance information in all currencies, use the GL All Balances view.

Some reporting scenarios where the balance views can be helpful are for finding information about the:

  • Debt-to-equity ratio

  • Working trial balance for a period

  • Return on total assets for a year

  • Revenue and expenditure balances for a given period

Budgets

Noetix views that return information about budgets provide details of budget names and budget organizations. These views also provide information about actual balances, budget balances, and balance comparison associated with the budget organizations for the summary and detail accounts in the primary currency.

Some reporting scenarios where the budget views can be helpful are for finding information about the:

Variance balance for a budget organization in an accounting period

Return on total assets for a year

Subledger Distributions

Noetix views that return information about subledger distributions provide details of journal entry lines sourced from the accounting event of transaction distributions. These transaction distributions include Oracle Payables invoices and invoice payments; Oracle Receivables transactions, Receivables adjustments, Receivables standard receipts, Receivables miscellaneous receipts, purchase order (PO), and requisition encumbrances; and blanket purchase agreements, PO encumbrances, and requisition encumbrances that have been transferred to General Ledger.

Some reporting scenarios where the budget views can be helpful are for finding information about the:

  • Journal distributions details of standard receipts for an accounting period

  • Journal distributions of invoices for an accounting period

  • Journal details for PO distributions of a department or account in an accounting period

For more information about subledger distributions, see NoetixViews for Oracle Subledger Accounting.

Other Areas

Noetix views that come under this category include views that return information about:

Journal entries imported from subledgers, such as Payables, Purchasing, and Receivables. The views that return the information about journal entries include the word “Import” in them. For example, GL Import Journals.

The chat of accounts defined in Oracle E-Business Suite. The view that returns this information is GL Chart Of Accounts.

The detail accounts that roll up to the summary accounts. The view that returns this information is GL Summary Accounts.

The authorization limits information for a user. The view that returns this information is GL Journal Auth Limits.

The currency conversion rates. The views that return this information are GL Daily Exchange Rates and GL Period Exchange Rates.

The accounting periods and statuses. The view that returns this information is GL Status Of Periods.

Some reporting scenarios where these views can be helpful are for finding information about the:

  • Employees who are authorized to approve journal batches of a given value

  • Earliest open period and latest open period

  • Daily conversion rate for a date range

Subject Areas and Views

The following table lists the subject areas of General Ledger and the corresponding Noetix views.

Subject Areas of General Ledger and the Corresponding NoetixViews

Subject area

Noetix view

Basic setup: Information about chart of accounts, account summary, account hierarchies, budget names, budget

organizations, calendar periods,

conversion rates and rate types, and authorization limits.

GL Budget Names

GL Budget Organizations

GL Chart Of Accounts

GL Daily Exchange Rates

GL Journal Auth Limits

GL Parent Child Values

GL Period Exchange Rates

GL Status Of Periods

GL Summary Accounts

Journals:Information about actual

journal batches, journal entries,

and journal entry lines for the primary, transaction, and statistical currencies; encumbrance journal batches, journal entries, and encumbrance journal entry lines for the primary currency; and archived actual journal entry lines for the primary currency.

GL All Encumb Je Lines

GL All Je Lines

GL Archived Je Lines

GL Encumb Journal Batches

GL Encumb Journal Entries

GL Foreign Je Lines

GL Journal Entries

GL Journal Entry Batches

GL Journal Entry Lines

Balances: Information about actual

balances in the primary, transaction, and statistical currencies; budget balances in the primary, transaction, and statistical currencies; encumbrance balances in the primary currency; and balance comparison in the primary and statistical currencies.

GL All Balances

GL All Budgets

GL Archived Balances

GL Average Daily Balances

GL Balances

GL Budget Actuals Encumb

GL Budget To Actuals

GL Budgets

GL Encumbrance Balances

GL Foreign Balances

GL Foreign Summaries

GL Funds Available

GL Org Balances

GL Org Budget To Actuals

GL Org Budgets

GL Parent Budget To Actuals

GL Parent Child Balances

GL Parent Child Budgets

GL Rollup Account Balances

GL Rollup Account Budgets

GL Rollup Parent Balances

GL Rollup Parent Budgets

GL Stat Balances

GL Stat Budget To Actuals

GL Stat Budgets

GL Summary Balances

GL Summary Budget To Actuals

GL Summary Budgets

Transaction from external systems: Information about journal entries imported from Oracle Payables, Oracle Purchasing, Oracle Receivables, and other sources.

GL Import Journals

GL Import Payables

GL Import Purchasing

GL Import Receivables

Transaction from subledgers:

Information about transactions for Payables invoices, Payables invoice payments, Receivables adjustments, Receivables miscellaneous receipts, Receivables standard receipts, Receivables transactions, purchase order (PO) and requisition encumbrances, blanket purchase agreements, PO encumbrances, and requisition encumbrances that have been transferred to General Ledger.

For Oracle E-Business Suite Release 12 and later (Using Subledger Accounting):

 

GL Je SLA AP Inv Dist

GL Je SLA AP Pmt Dist

GL Je SLA AR Adj Dist

GL Je SLA AR Misc Rcpt Dist

GL Je SLA AR Std Rcpt Dist

GL Je SLA AR Tran Dist

GL Je SLA PO All Encumb

GL Je SLA PO Blnkt Encumb

GL Je SLA PO Encumb

GL Je SLA PO Req Encumb

 

For Oracle E-Business Suite version before Release 12:

 

GL AP Inv Je Line Details

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je Blanket PO Encumb

GL Je Tran All PO Encumb

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran AR Tran Dist

GL Je Tran PO Encumb

GL Je Tran PO Req Encumb

Support for Parent-Child Hierarchies in Global Views

Noetix Views (NoetixViews) supports the parent-child hierarchies defined on segments of the Accounting Flexfield. Global views that include the Accounting Flexfield can be used with parent-child hierarchies to create reports. For reports with account balances, the parent-child hierarchies help to create a total balance for all the detail accounts in the hierarchy, and then enable drill down one level at a time to the individual account balances. A report based on General Ledger journal lines can start at a hierarchy's top level with rolled up amounts of all the accounts in the hierarchy and drill down to the individual journal entry lines. Similar reporting can be done using views that return subledger distributions. A report can return a rolled up amount and the user can drill down to the individual distribution transactions.

Standard and Cross Operations Extension (XOP) views also support parent-child hierarchies. These views are available for only General Ledger and can be used for only finding information about the parent and child accounts at summary or detail level. However, they do not support building reports where you can drill down through a parent-child hierarchy of an accounting segment or support building reports where you can find the entire child or leaf flex values corresponding to a parent flex value.

Parent-Child Views for Segment Hierarchy

The reporting solution provided for the Accounting Flexfield parent-child hierarchies support in global views consist of two views, parent-child hierarchies and parent-child essentials.

The parent-child hierarchies views support all the hierarchies defined on a segment and are used to build reports that enable drill down one level at a time to the individual segment values in the leaf nodes of the hierarchies. In Business Intelligence (BI) tools that support hierarchies, this drill down capability is automatically enabled by the Angles for Oracle Generator for that tool.

The parent-child essentials views can be used for building reports in which you want to display all the leaf or child flex values corresponding to a parent flex value. This parent flex value can be the top most parent (also known as the root of a parent-child hierarchy), any lower level parent, or even a leaf value (in which case it returns itself). Also, a pseudo-parent value is available in the parent-child essentials views. The ALL VALUES pseudo-parent returns all the flex values of the segment even those not included in a hierarchy.

The parent-child hierarchy and essentials views return records only for detail account identifiers as the corresponding fact views return information only for the detail account identifiers.

Generation of Parent-Child Views for Segment Hierarchy

The parent-child hierarchies and parent-child essentials views are generated for each segment of each chart of accounts in Oracle E-Business Suite. These views can be used only with the global Noetix views and are generated for a segment only if a flex value set is defined on that segment. However, the parent-child hierarchies and parent-child essentials views will populate hierarchy data only if one or more parent-child hierarchies are defined on a segment.

A Concurrent Manager program is created in the Oracle E-Business Suite instance when parent-child views are generated in NoetixViews. If modifications are made to a segment hierarchy structure in Oracle E-Business Suite, the Concurrent Manger should be run to capture the changes. This includes changes to existing hierarchies and new hierarchies added to a segment that had at least one previous hierarchy. The NoetixViews Stage 4 generation process must be run to capture hierarchies defined on segments that previously did not have any hierarchies.

If Noetix Help File is available for your NoetixViews instance, the generated parent-child hierarchies and essentials views can be found under a global role for which they are generated. For example, the GLG0 LEDGER role will list all the parent-child hierarchies and essentials views generated for the role. The parent-child hierarchies and essentials views are named as N Acct <chart of accounts ID> <segment name> H (Example: N Acct 101 Account H) and N Acct <chart of accounts ID> <segment name> D (Example: N Acct 101 Account D) respectively.

After the parent-child views are generated, they must be configured in the BI tools using the respective Angles for Oracle Generator. In the BI tools, these views are used with other functional views to create reports. The functional views that are joined to the parent-child views are called fact views. In BI tools that support hierarchies, fact views can be used with a parent-child hierarchies view to build reports that return transaction data or provide summarized data at different levels of a parent-child hierarchy. The following fact views are defined by Noetix with joins to the parent-child views:

  • GL All Balances

  • GL All Encumb Je Lines

  • GL All Je Lines

  • GL Balances

  • GL Budget To Actuals

  • GL Encumbrance Balances

  • GL Journal Entry Lines

  • XLA SLA Hub Journal Lines

However, any global view that includes columns for the Accounting Flexfield and returns data for any Oracle E-Business Suite module can be joined to the parent-child views through joins that are created with the use of the Noetix Views Workbench (NoetixViews Workbench). For information, see the Noetix Views Workbench Help.

Features of Parent-Child Hierarchies View

The parent-child hierarchies views support a maximum of 20 levels for a segment hierarchy including the root and leaf flex values. For each level, the view returns segment flex value, flex value description, and flex values along with description. The root columns return information corresponding to the top-level node in a hierarchy. The leaf columns return information corresponding to the lowest-level child in a hierarchy. The leaf parent columns return information corresponding to the parent of the lowest-level child in a hierarchy.

When parent-child hierarchies views are configured in Oracle Business Intelligence (Oracle BI) and IBM Cognos Business Intelligence (Cognos BI) by using the respective Noetix Generators for these tools, additional hierarchical drill objects are created in the presentation model corresponding to the segment values and descriptions. These objects are named Description, Description With Value, and Value respectively. They are available under a dimension object created for each parent-child hierarchies view. The Description, Description With Value, and Value objects when used in a report return descriptions for all the segment values, segment descriptions with segment values, and segment values, respectively. Based on the reporting requirement, a reporting user can use one of the hierarchies drill objects in their report.

The parent-child hierarchies views follow the naming convention “<segment name> Parent-Child Hierarchies” in the presentation model of the BI tools. The corresponding dimension object under which the hierarchical drill objects are created is named as “<segment name> Account Parent-Child Hierarchies$DIM.” For example, the “Account Parent-Child Hierarchies” view is created for the Account segment, and the “Account Parent-Child Hierarchies$DIM” object is created for the hierarchical objects available for the Account segment.

In Noetix Platform and Oracle Discoverer, the parent-child hierarchies views is named as “<segment name> Parent-Child Hierarchies (<chart of accounts name>)”, where <chart of accounts name> represents the chart of accounts corresponding to the segment. For example, the “Account Parent-Child Hierarchies (Operations Accounting Flex)” view is created for the Account segment of the Operations Account Flex chart of accounts. The hierarchical drill objects for a parent-child hierarchies view is not available in Noetix Platform or Oracle Discoverer as it is in the other BI tools.

For information about how to use the parent-child hierarchies view, see Using BI Tools in “Using BI Tools.”

Features of Parent-Child Essentials View

The parent-child essentials views are designed to be used with other views that include the Accounting Flexfield and to which it has a join. This view provides information about the parent and leaf flex values and descriptions. The parent columns return values corresponding to the top-level node in a hierarchy and all the lower-level parents. The leaf columns return flex values for each lowest-level child within the hierarchy of a parent. A record returned consists of each combination of a parent and its lowest-level child flex values. The parent could also be an intermediate parent. The pseudo parent value ALL VALUES consider all the possible flex values of the segment as its children even those that are not part of a hierarchy. Use this pseudo parent value when you want to return the code combinations for every flex value of the segment. Each child flex value of the segment has a pseudo parent of the same value assigned to it. Use the flex value for the parent when you want to return the code combinations for a single child flex value. The parent-child essentials views can be used in conjunction with the parent-child hierarchies views to create drill-through reports.

The parent-child essentials views are named as “<segment name> Parent-Child Essentials” in the presentation model of the BI tools. For example, the “Account Parent-Child Essentials” view is created for the Account segment.

In Noetix Platform and Oracle Discoverer, the parent-child essentials views are named as “<segment name> Parent-Child Essentials (<chart of accounts name>)”, where <chart of accounts name> represents the chart of accounts corresponding to the accounting segment. For example, the “Account Parent-Child Essentials (Operations Accounting Flex)” view is created for the Account segment of the Operations Accounting Flex chart of accounts.

For information about how to use the parent-child essentials views, see Using BI Tools in “Using BI Tools.”

Support for Flexfields

The following tables list the flexfields in General Ledger and the Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle General Ledger

Descriptive flexfield

Noetix view

GL Accounts

GL All Balances

GL All Budgets

GL AP Inv Je Line Details

GL Balances

GL Budget Actuals Encumb

GL Budget To Actuals

GL Budgets

GL Chart Of Accounts

GL Encumbrance Balance

GL Foreign Balances

GL Foreign Summaries

GL Funds Available

GL Org Balances

GL Org Budget To Actuals

GL Org Budgets

GL Rollup Account Balances

GL Rollup Account Budgets

GL Rollup Parent Balances

GL Rollup Parent Budgets

GL Stat Balances

GL Stat Budget To Actuals

GL Stat Budgets

GL Summary Accounts

GL Summary Balances

GL Summary Budget To Actuals

GL Summary Budgets

 

GL All Encumb Je Lines

GL All Je Lines

GL AP Inv Je Line Details

GL Archived Je Lines

GL Encumb Journal Batches

GL Encumb Journal Entries

GL Foreign Je Lines

GL Journal Entries

GL Journal Entry Batches

GL Journal Entry Lines

Define Budget Organization: Assignments

GL Org Balances

GL Org Budget To Actuals

GL Org Budgets

Define Budget Organization: Organization

GL Budget Organizations

GL Org Balances

GL Org Budget To Actuals

GL Org Budgets

Define Budget

GL Budget Names

Budget Versions

GL Stat Budgets

Flexfield Segment Values

GL Parent Child Values

Enter Journals: Journals

GL All Encumb Je Lines

GL All Je Lines

GL AP Inv Je Line Details

GL Archived Je Lines

GL Encumb Journal Entries

GL Foreign Je Lines

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je Blanket PO Encumb

GL Je SLA AP Inv Dist

GL Je SLA AP Pmt Dist

GL Je SLA AR Adj Dist

GL Je SLA AR Misc Rcpt Dist

GL Je SLA AR Std Rcpt Dist

GL Je SLA AR Tran Dist

GL Je SLA PO All Encumb

GL Je SLA PO Blnkt Encumb

GL Je SLA PO Encumb

GL Je SLA PO Req Encumb

GL Je Tran All PO Encumb

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran AR Tran Dist

GL Je Tran PO Encumb

GL Je Tran PO Req Encumb

GL Journal Entries

GL Journal Entry Lines

Enter Journals: Lines

GL All Encumb Je Lines

GL All Je Lines

GL AP Inv Je Line Details

GL Archived Je Lines

GL Foreign Je Lines

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je Blanket PO Encumb

GL Je SLA AP Inv Dist

GL Je SLA AP Pmt Dist

GL Je SLA AR Adj Dist

GL Je SLA AR Misc Rcpt Dist

GL Je SLA AR Std Rcpt Dist

GL Je SLA AR Tran Dist

GL Je SLA PO All Encumb

GL Je SLA PO Blnkt Encumb

GL Je SLA PO Encumb

GL Je SLA PO Req Encumb

GL Je Tran All PO Encumb

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran AR Tran Dist

GL Je Tran PO Encumb

GL Je Tran PO Req Encumb

GL Journal Entry Lines

Period Rates

GL Period Exchange Rates

PO Distributions

GL Je Blanket PO Encumb

GL Je Tran PO Encumb

GL Period Statuses

GL Status Of Periods

PO Headers

GL Je Blanket PO Encumb

GL Je Tran PO Encumb

PO Lines

GL Je Blanket PO Encumb

GL Je Tran PO Encumb

Daily Rates

GL Daily Exchange Rates

Requisition Distributions

GL Je Tran PO Req Encumb

Requisition Headers

GL Je Tran PO Req Encumb

Requisition Lines

GL Je Tran PO Req Encumb

PO Line Locations

GL Je Blanket PO Encumb

GL Je Tran PO Encumb

 

Key Flexfields Supported in NoetixViews for Oracle General Ledger

Key flexfield

Noetix view

Accounting Flexfield

GL All Balances

GL All Budgets

GL All Encumb Je Lines

GL All Je Lines

GL AP Inv Je Line Details

GL Archived Balances

GL Archived Je Lines

GL Average Daily Balances

GL Balances

GL Bly Budget To Actuals

GL Budget Actuals Encumb

GL Budget To Actuals

GL Budgets

GL Chart Of Accounts

GL Encumbrance Balances

GL Foreign Balances

GL Foreign Je Lines

GL Foreign Summaries

GL Funds Available

GL Import Journals

GL Import Payables

GL Import Purchasing

GL Import Receivables

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je Blanket PO Encumb

GL Je SLA AP Inv Dist

GL Je SLA AP Pmt Dist

GL Je SLA AR Adj Dist

GL Je SLA AR Misc Rcpt Dist

GL Je SLA AR Std Rcpt Dist

GL Je SLA AR Tran Dist

GL Je SLA PO All Encumb

GL Je SLA PO Blnkt Encumb

GL Je SLA PO Encumb

GL Je SLA PO Req Encumb

GL Je Tran All PO Encumb

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran PO Encumb

GL Je Tran PO Req Encumb

GL Journal Entry Lines

GL Org Balances

GL Org Budget To Actuals

Accounting Flexfield (Continued)

GL Org Budgets

GL Parent Budget To Actuals

GL Parent Child Balances

GL Parent Child Budgets

GL Rollup Account Balances

GL Rollup Account Budgets

GL Rollup Parent Balances

GL Rollup Parent Budgets

GL Stat Balances

GL Stat Budget To Actuals

GL Stat Budgets

GL Summary Accounts

GL Summary Balances

GL Summary Budget To Actuals

GL Summary Budgets

System Items

GL Je Tran AR Tran Dist

Noetix Views in General Ledger Workflow

The following diagram explains the process flow of General Ledger and the corresponding subject areas supported by Noetix views.

For more information about the Noetix supported subject areas and the views corresponding to each subject area, see Support for Subject Areas.

Noetix Roles for Oracle General Ledger

NoetixViews for Oracle General Ledger includes standard, Cross Operations Extension (XOP), and global roles. A standard role contains a set of views are generated corresponding to a specific ledger. For an XOP role, a set of views is generated corresponding to one or more ledgers depending on the chart of accounts settings in your Oracle E-Business Suite instance. For a global role, a set of views is generated for all the ledgers configured in your Oracle E-Business Suite instance. A user can access all the views corresponding to an assigned role. Contact your Noetix System Administration User if you have any queries regarding the roles granted to you.

Tips/Other Considerations

The following points help you to optimally use the views for General Ledger:

After migrating the Oracle E-Business Suite instance version from 11.5.10.2 to Release 12 and purging your data for the first time, you must regenerate the GL Archived Balances and GL Archived Je Lines views. Otherwise, these views will return an error message. You do not need to regenerate these views after running the purge process subsequently.

Use the GL Summary Balances and GL Summary Budgets views to know the balances of only the summary accounts. To see the detail accounts associated to a summary account, use the GL Summary Accounts view.

Some views do not support granularity statements as they return information from multiple journal sources. These views are listed as follows:

GL Import Journals

GL Import Payables

GL Import Purchasing

GL Import Receivables

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran AR Tran Dist

Some of the standard Accounting Flexfield segment columns populated in the global form of the Noetix views for General Ledger are not available in the global form of the GL Rollup Account Balances and GL Rollup Account Budgets views. The segment columns that are not available in these views are listed as follows:

Acct$CD$Accounting KFF

Acct$CV$Accounting KFF

Acct$Code Combination Id

Acct$QD$Cost Center

Acct$QV$Cost Center

Acct$Segment Name List

Acct$Structure Name

The following views are only available in the standard and XOP forms:

GL Parent Budget to Actuals

GL Parent Child Balances

GL Parent Child Budgets

GL Rollup Parent Balances

GL Rollup Parent Budgets

Some views support row-level security based on the security set for a Noetix query user. In these views, row-level security is applied based on the flexfield security rules and ledgers assigned to the user in Oracle E-Business Suite and Noetix Views Administrator (NoetixViews Administrator). When row-level security is applied, the Noetix query user’s access to data within Noetix views corresponding to a role is further restricted. The following views support row-level security based on the row-level security settings assigned to a query user:

GL All Balances

GL All Budgets

GL All Encumb Je Lines

GL All Je Lines

GL AP Inv Je Line Details

GL Archived Balances

GL Archived Je Lines

GL Balances

GL Budget To Actuals

GL Budgets

GL Encumbrance Balances

GL Foreign Balances

GL Foreign Je Lines

GL Foreign Summaries

GL Funds Available

GL Je AP Inv Dist Details

GL Je AP Pmt Dist Details

GL Je SLA AP Inv Dist

GL Je SLA AP Pmt Dist

GL Je SLA AR Adj Dist

GL Je SLA AR Misc Rcpt Dist

GL Je SLA AR Std Rcpt Dist

GL Je SLA AR Tran Dist

GL Je Tran AR Adj Dist

GL Je Tran AR Misc Dist

GL Je Tran AR Pymt Dist

GL Je Tran AR Tran Dist

GL Journal Entry Lines

GL Org Balances

GL Org Budget To Actuals

GL Org Budgets

GL Parent Budget To Actuals

GL Parent Child Budgets

GL Rollup Account Balances

GL Rollup Account Budgets

GL Rollup Parent Balances

GL Rollup Parent Budgets

GL Stat Balances

GL Stat Budget To Actuals

GL Stat Budgets

GL Summary Balances

GL Summary Budget To Actuals

GL Summary Budgets

NoetixViews for Oracle Subledger Accounting

Oracle Corporation has introduced the subledger accounting service in Oracle E-Business Suite Release 12. This service provides users the means of streamlining the process of subledger bookkeeping and thereby improving the administration of global and country-specific business.

Prior to Release 12, the data processed from the individual modules (for example, Oracle Payables or Oracle Receivables) could be posted to Oracle General Ledger according to the rules set up for the specific modules. In Release 12, a common accounting engine has been established to conduct all posting activities to General Ledger. The subledger tables, which store the accounting data in the common accounting engine, have been standardized across products, and they maintain every accounting detail of the subledger events. The common accounting engine then estimates to what level the details are to be summarized and finally posts them to General Ledger according to the user-defined accounting rules.

To support the subledger accounting functionality in Release 12, insigihtsoftwarehas designed and developed a set of cross-functional and module-specific views. The corresponding, cross-functional views for Oracle E-Business Suite 11i will continue to exist in Release 12 for tracking historical accounting data that has not been migrated to Oracle Subledger Accounting. Users of 11i will continue to use the older, cross-functional views to access accounting data.

Features of Noetix Views for Subledger Accounting

The views developed for Subledger Accounting are available in only the global form and provide these benefits:

Comprehensive coverage of functional areas.

Support for role-level and row-level security.

Support for joins based on one or more standard columns.

Controlled access to accounting information based on the Oracle E-Business Suite roles and responsibilities.

Support for drill-down reporting based on parent-child hierarchy information pertaining to the Accounting Flexfield.

A centrally located hub view that helps retrieve consolidated accounting information for all the distributions across all subledger applications. Noetix views that return subledger application-specific distribution details can be joined with the hub view to retrieve the distribution-specific accounting information in Subledger Accounting. The view can also be used to drill down from the journal entry lines in Subledger Accounting to the individual source distributions.

Support for drill down from account balances and journals in General Ledger to the individual source transaction distributions.

Based on the functional use and applicability, the views developed for Subledger Accounting have been broadly classified into a Subledger Accounting-specific solution and a subledger application-specific solution.

Subledger Accounting-Specific Solution

The Subledger Accounting-specific solution links distributions in various modules to journal entry lines in Subledger Accounting and finally to account balances and journals in General Ledger. The Subledger Accounting-specific solution consists of views that return information about subledger application-specific distributions, journal entry lines in Subledger Accounting, and journal entries and account balances in General Ledger. These views are available as part of the NoetixViews module for General Ledger and are managed through the SUBLEDGER ACCOUNTING Noetix role.

The hub view is linked to 21 subledger application-specific distribution views that return information about the original transaction distribution details. The hub view is also linked to views that return information about account balances and journals from General Ledger. Oracle E-Business Suite users who have access to General Ledger can make use of the hub view along with the subledger application-specific distribution views and General Ledger views for a complete understanding of the source distributions and their accounting details.

The Subledger Accounting-specific views also provide support for role-level and row-level security. The role-level security is enforced on Noetix query users based on the SUBLEDGER ACCOUNTING Noetix role. The row-level security is enforced on Noetix query users based on the security settings configured for the ledgers and flexfield security rules in General Ledger and NoetixViews.

For the support of multi-currency, all the views that return transaction distribution details corresponding to Oracle Projects return transaction currency values. Additional columns are available in these views for returning project functional currency values (with the PFC suffix) and project currency values (with the PC suffix). In all other views, both primary and transaction currency values are returned.

The views that are available as part of the Subledger Accounting-specific solution and their coverage areas are as follows:

The following views return the details of the account balances and journal entries in General Ledger:

XLA GL All Balances

XLA GL Journal Lines

The XLA SLA Hub Journal Lines view returns the details of the journal entry lines in Subledger Accounting that correspond to the distributions in subledger applications.

The following views return the details of the distributions in individual subledger applications:

XLA AP Invoice Dist

XLA AP Payment Dist

XLA AR Adjustment Dist

XLA AR Bills Rcv Dist

XLA AR Misc Receipt Dist

XLA AR Std Receipt Dist

XLA AR Transaction Dist

XLA Accrual Write Off Dist

The XLA Accrual Write Off Dist view will be generated only if Oracle Bills of Material is available in your Oracle E-Business Suite instance.

XLA FA Transaction Dist

The XLA FA Transaction Dist view will be generated only if Oracle Assets is available in your Oracle E-Business Suite instance.

XLA FV Budget Auth Trans, XLA FV Budget RPR Trans, and XLA FV Fund Distributions

These views will be generated only if Oracle U.S. Federal Financials is available in your Oracle E-Business Suite instance and NoetixViews application instance.

XLA FV Treas Confirmation

The XLA FV Treas Confirmation view will be generated only if U.S.Federal Financials is available in your Oracle E-Business Suite instance.

XLA GMF Cst Subledger Dist

The XLA GMF Cst Subledger Dist view will be generated only if Oracle Process Manufacturing Financials is available in your Oracle E-Business Suite instance.

XLA INV Transaction Dist

The XLA INV Transaction Dist view will be generated only if Oracle Inventory is available in your Oracle E-Business Suite instance.

XLA PA Budget Dist

The XLA PA Budget Dist view will be generated only if Projects is available in your Oracle E-Business Suite instance.

XLA PA Cost Dist

The XLA PA Cost Dist view will be generated only if Projects is available in your Oracle E-Business Suite instance.

XLA PA Revenue Dist

The XLA PA Revenue Dist view will be generated only if Projects is available in your Oracle E-Business Suite instance.

XLA PO Receiving Dist

The XLA PO Receiving Dist view will be generated only if Oracle Purchasing is available in your Oracle E-Business Suite instance.

XLA PO Requisition Dist

The XLA PO Requisition Dist view will be generated only if Purchasing is available in your Oracle E-Business Suite instance and budgetary control is enabled for the ledgers.

XLA WIP Resource Dist

The XLA WIP Resource Dist view will be generated only if Oracle Work in Process is available in your Oracle E-Business Suite instance.

The relationship between the hub view and other views is as follows.

Subledger Application-Specific Solution

The subledger application-specific solution provides reporting capability for individual Oracle E-Business Suite modules. The subledger application-specific solution consists of distribution views and a single hub view for each subledger application. Each hub view provides details about the Subledger Accounting journal entry lines for a subledger application. Depending on the reporting requirements, a distribution view that covers a specific functional area can be joined to the hub view to retrieve distribution-specific accounting details from Subledger Accounting. The distribution and hub views available in the subledger application -specific solution are provided as part of the individual NoetixViews modules corresponding to the relevant subledger application.

The subledger application-specific views support role-specific and module-specific security. The role-level security is enforced on Noetix query users through the individual Noetix roles. The row-level security is enforced on Noetix query users based on the organizational unit-specific and application-specific security settings configured in the Oracle E-Business Suite modules and NoetixViews.

For the support of multi-currency, all the views that return transaction distribution details corresponding to Projects return transaction currency values. Additional columns are available in these views for returning project functional currency values (with the PFC suffix) and project currency values (with the PC suffix). In the views for all other modules, both primary and transaction currency values are returned.

The views that are available as part of the subledger application-specific solution and their coverage areas are as follows:

The following views return details of the distributions in individual subledger applications:

AP SLA Invoice Dist

AP SLA Payment Dist

AR SLA Adjustment Dist

AR SLA Bills Rcv Dist

AR SLA Misc Receipt Dist

AR SLA Std Receipt Dist

AR SLA Transaction Dist

FA SLA Transaction Dist

FV SLA Budget Auth Trans

FV SLA Budget RPR Trans

FV SLA Fund Distributions

FV SLA Treas Confirmation

GMF SLA Cst Subledger Dist

PA SLA Budget Dist

PA SLA Cost Dist

PA SLA Revenue Dist

PO SLA Requisition Dist

The following views return details of the journal entry lines in Subledger Accounting that correspond to distributions in the subledger applications:

AP SLA Hub Journal Lines

AR SLA Hub Journal Lines

FA SLA Hub Journal Lines

FV SLA Hub Journal Lines

GMF SLA Hub Journal Lines

PA SLA Hub Journal Lines

PO SLA Hub Journal Lines

Support for Subject Areas

The following table lists the subject areas related to Subledger Accounting that are supported by Noetix along with the corresponding view names.

Accounting subject area

Oracle

E-Business Suite module

Noetix view

Noetix hub view

Invoices and payments

Payables

For Subledger Accounting-specific solution:

XLA AP Invoice Dist

XLA AP Payment Dist

XLA Subledger Exceptions

For subledger application-specific solution:

AP SLA Invoice Dist

AP SLA Payment Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

AP SLA Hub Journal Lines

Transactions, adjustments, standard receipts, miscellaneous receipts, and bills receivable

Receivables

For Subledger Accounting-specific solution:

XLA AR Adjustment Dist

XLA AR Bills Rcv Dist

XLA AR Misc Receipt Dist

XLA AR Std Receipt Dist

XLA AR Transaction Dist

XLA Subledger Exceptions

For subledger application-specific solution:

AR SLA Adjustment Dist

AR SLA Bills Rcv Dist

AR SLA Misc Receipt Dist

AR SLA Std Receipt Dist

AR SLA Transaction Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

AR SLA Hub Journal Lines

Encumbered purchase orders (POs) and purchase requisitions

Purchasing

For Subledger Accounting-specific solution:

XLA PO Requisition Dist

For subledger application-specific solution:

PO SLA Requisition Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

PO SLA Hub Journal Lines

Asset transactions, inter asset transactions, depreciation, and deferred depreciation

Assets

For Subledger Accounting-specific solution:

XLA FA Transaction Dist

XLA FA Subledger Exceptions

For subledger application-specific solution:

FA SLA Transaction Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

FA SLA Hub Journal Lines

Project billing, costing, and revenue

Projects

For Subledger Accounting-specific solution:

XLA PA Budget Dist

XLA PA Cost Dist

XLA PA Revenue Dist

For subledger application-specific solution:

PA SLA Budget Dist

PA SLA Cost Dist

PA SLA Revenue Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

PA SLA Hub Journal Lines

Accrual write-offs, receiving transaction distributions in Purchasing, resource distributions in Work in Process, and transaction distributions in Inventory

Cost Management

For Subledger Accounting-specific solution:

XLA Accrual Write Off Dist

XLA PO Receiving Dist

XLA WIP Resource Dist

XLA INV Transaction Dist

XLA Subledger Exceptions

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

Purchase receiving subledgers, purchase and inventory material transactions, sales order issues, Return Material Authorizations (RMAs), and cost revaluation and batch processing transactions

Process Manufacturing Financials

For Subledger Accounting-specific solution:

XLA GMF Cst Subledger Dist

For subledger application-specific solution:

GMF SLA Cst Subledger Dist

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

GMF SLA Hub Journal Lines

Budget execution transactions, budget reprogramming, and treasury confirmation

U.S. Federal Financials

For Subledger Accounting-specific solution:

XLA FV Budget Auth Trans

XLA FV Fund Distributions

XLA FV Budget RPR Trans

XLA FV Treas Confirmation

For subledger application-specific solution:

FV SLA Budget Auth Trans

FV SLA Fund Distributions

FV SLA Budget RPR Trans

FV SLA Treas Confirmation

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

For subledger application-specific solution:

FV SLA Hub Journal Lines

Journal entry lines and account balances

General Ledger

For Subledger Accounting-specific solution:

XLA GL All Balances

XLA GL Journal Lines

For Subledger Accounting-specific solution:

XLA SLA Hub Journal Lines

Support for Flexfields

The descriptive and key flexfields that are supported by the Subledger Accounting-specific solution and the subledger application-specific solution are listed in the tables in this section.

Descriptive Flexfields Supported in Subledger Accounting Views

Descriptive flexfield name

Flexfield table

Noetix view

Adjustment Information

AR Adjustments All

AR SLA Adjustment Dist

XLA AR Adjustment Dist

Asset Category

FA Additions B

FA SLA Transaction Dist

XLA FA Transaction Dist

Book Controls

FA Book Controls

FA SLA Transaction Dist

XLA FA Transaction Dist

Budget Lines

PA Budget Lines

PA SLA Budget Dist

XLA PA Budget Dist

Budget Transactions Detail

FV BE TRX DTLS

FV SLA Budget Auth Trans

FV SLA Fund Distributions

XLA FV Budget Auth Trans

XLA FV Fund Distributions

Budget Transactions Header

FV BE TRX HDRS

FV SLA Budget Auth Trans

FV SLA Fund Distributions

XLA FV Budget Auth Trans

XLA FV Fund Distributions

Budget Versions

PA Budget Versions

PA SLA Budget Dist

XLA PA Budget Dist

GL Accounts

GL Code Combinations

XLA GL All Balances

Enter Journals: Batches

GL JE Batches

XLA GL Journal Lines

Enter Journals: Journals

GL JE Headers

XLA GL Journal Lines

Enter Journals: Lines

GL JE Lines

XLA GL Journal Lines

Invoice

AP Invoices All

AP SLA Payment Dist

AP SLA Invoice Dist

XLA AP Invoice Dist

XLA AP Payment Dist

Invoice Distribution

AP Invoice Distributions All

AP SLA Invoice Dist

XLA AP Invoice Dist

Invoice Payments

AP Invoice Payments All

AP SLA Payment Dist

XLA AP Payment Dist

Items

MTL System Items B

XLA INV Transaction Dist

XLA WIP Resource Dist

Payment Information

AP Checks All

AP SLA Payment Dist

XLA AP Payment Dist

Payment Schedule Information

AR Payment Schedules All

AR SLA Adjustment Dist

XLA AR Adjustment Dist

Reprogramming Transactions

FV BE RPR Transactions

FV SLA Budget RPR Trans

XLA FV Budget RPR Trans

Requisition Headers

PO Requisition Headers All

PO SLA Requisition Dist

XLA PO Requisition Dist

Requisition Lines

PO Requisition Lines All

PO SLA Requisition Dist

XLA PO Requisition Dist

Transaction history

MTL Material Transactions

XLA INV Transaction Dist

XLA INV Transaction Dist

Transaction Information

RA Customer Trx All

AR SLA Transaction Dist

XLA AR Transaction Dist

TREASURY CONFIRMATION

FV Treasury Confirmations All

FV SLA Treas Confirmation

XLA FV Treas Confirmation

WIP Transaction History

WIP Transactions

XLA WIP Resource Dist

 

Key Flexfields Supported in Subledger Accounting Views

Key flexfield name

Noetix view

Accounting Flexfield

AP SLA Hub Journal Lines

AP SLA Invoice Dist

AP SLA Payment Dist

AR SLA Adjustment Dist

AR SLA Bills Rcv Dist

AR SLA Hub Journal Lines

AR SLA Misc Receipt Dist

AR SLA Std Receipt Dist

AR SLA Transaction Dist

FA SLA Hub Journal Lines

FV SLA Budget Auth Trans

FV SLA Budget RPR Trans

FV SLA Fund Distributions

FV SLA Hub Journal Lines

FA SLA Transaction Dist

GMF SLA Cst Subledger Dist

GMF SLA Hub Journal Lines

PA SLA Budget Dist

PA SLA Cost Dist

PA SLA Hub Journal Lines

PA SLA Revenue Dist

PO SLA Hub Journal Lines

PO SLA Requisition Dist

XLA Accrual Write Off Dist

XLA AP Invoice Dist

XLA AP Payment Dist

XLA AR Adjustment Dist

XLA AR Bills Rcv Dist

XLA AR Misc Receipt Dist

XLA AR Std Receipt Dist

XLA AR Transaction Dist

XLA FA Transaction Dist

XLA FV Budget Auth Trans

XLA FV Budget RPR Trans

XLA FV Fund Distributions

XLA FV Treas Confirmation

XLA GL All Balances

XLA GL Journal Lines

XLA GMF Cst Subledger Dist

XLA INV Transaction Dist

XLA PA Budget Dist

XLA PA Cost Dist

XLA PA Revenue Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

XLA SLA Hub Journal Lines

XLA WIP Resource Dist

Asset Key Flexfield

FA SLA Transaction Dist

Category Flexfield

FA SLA Transaction Dist

Location Flexfield

FA SLA Transaction Dist

Item Categories

PO SLA Requisition Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

System Items

AR SLA Transaction Dist

GMF SLA Cst Subledger Dist

PO SLA Requisition Dist

XLA AR Transaction Dist

XLA Accrual Write Off Dist

XLA GMF Cst Subledger Dist

XLA INV Transaction Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

XLA WIP Resource Dist

Stock Locators

XLA INV Transaction Dist

Noetix Roles for Subledger Accounting Views

The views provided as part of the Subledger Accounting-specific solution are managed through the SUBLEDGER ACCOUNTING Noetix role. The views provided as part of the subledger application-specific solution are managed through the Noetix roles corresponding to the individual NoetixViews modules. The following table lists the details of the Noetix roles and the corresponding views.

Noetix role label

Noetix view

FIXED ASSETS

FA SLA Hub Journal Lines

FA SLA Transaction Dist

OPM FINANCIALS

GMF SLA Cst Subledger Dist

GMF SLA Hub Journal Lines

PAYABLES

AP SLA Hub Journal Lines

AP SLA Invoice Dist

AP SLA Payment Dist

PROJECTS

PA SLA Budget Dist

PA SLA Cost Dist

PA SLA Hub Journal Lines

PA SLA Revenue Dist

PURCHASING

PO SLA Hub Journal Lines

PO SLA Requisition Dist

RECEIVABLES

AR SLA Adjustment Dist

AR SLA Bills Rcv Dist

AR SLA Hub Journal Lines

AR SLA Misc Receipt Dist

AR SLA Std Receipt Dist

AR SLA Transaction Dist

FEDERAL ADMINISTRATOR

FV SLA Budget Auth Trans

FV SLA Budget RPR Trans

FV SLA Fund Distributions

FV SLA Hub Journal Lines

FV SLA Treas Confirmation

SUBLEDGER ACCOUNTING

XLA Accrual Write Off Dist

XLA AP Invoice Dist

XLA AP Payment Dist

XLA AR Adjustment Dist

XLA AR Bills Rcv Dist

XLA AR Misc Receipt Dist

XLA AR Std Receipt Dist

XLA AR Transaction Dist

XLA FA Transaction Dist

XLA FV Budget Auth Trans

XLA FV Fund Distributions

XLA FV Budget RPR Trans

XLA FV Treas Confirmation

XLA GL All Balances

XLA GL Journal Lines

XLA GMF Cst Subledger Dist

XLA INV Transaction Dist

XLA PA Budget Dist

XLA PA Cost Dist

XLA PA Revenue Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

XLA SLA Hub Journal Lines

XLA WIP Resource Dist

Noetix Views in Subledger Accounting Workflow

The following diagram explains the process flow of Subledger Accounting and the important Noetix views that provide information at each point in the process flow.

For information about the hub and transaction distribution views and the corresponding subject areas, seeSupport for Subject Areas.

Useful Reporting Scenarios Supported by Subledger Accounting Views

This section explains some of the useful reporting scenarios that are supported by the Subledger Accounting views.

Projections or Corrections for Accounting Data

In this reporting scenario, you can use the hub views of subledger applications or the XLA SLA Hub Journal Lines view to obtain a preview of the accounts and amounts related to the Subledger Accounting distributions that are in the draft mode before transferring them to General Ledger. Also, you can use the hub and distribution views (both Subledger Accounting-specific and subledger application-specific) to check for any discrepancies in the accounts by comparing the accounts and amounts related to the Subledger Accounting journal entries against the accounts and amounts corresponding to the subledger application-specific distributions. If discrepancies are noticed, you can go back and correct the accounts and rerun the accounting process.

Transactions Not Transferred to Subledger Accounting

In this reporting scenario, distribution views and hub views corresponding to a subledger application can be used together for finding information about the transactions corresponding to the distributions that have not been transferred to Subledger Accounting. For example, you can use the AP SLA Invoice Dist view with the AP SLA Hub Journal Lines view to identify the transactions pertaining to invoice distributions that are not yet transferred to Subledger Accounting.

Subledger Accounting Exceptions

You may have set up multiple accounts in Subledger Accounting to segregate the accounting information related to subledger application-specific distributions on the basis of the accounting requirements. In this reporting scenario, you can find information about these accounts in Subledger Accounting by using the subledger application-specific hub views or the XLA SLA Hub Journal Lines view. For example, when a discount is applied to a sales order, two revenue lines will be created, one for the actual price of the item and the other for the discount. Since both lines refer to the same item, they will be accounted to the same account. However, if the discount line needs to be accounted to a different account, a new account is set up in Subledger Accounting for discounts. In this case, you can use the AR SLA Transaction Dist view or the XLA AR Transaction Dist view to obtain the details of the original distribution account. The details of the new distribution account set up for discounts can be obtained with the use of the AR SLA Hub Journal Lines view or the XLA SLA Hub Journal Lines view.

Consolidated Accounting Information

In this reporting scenario, you may want complete information about the distributions across all the subledger applications. The XLA SLA Hub Journal Lines view can be used for finding this information. If you want the consolidated accounting information for all the distributions in a specific subledger application, you can use the hub view available for that subledger application.

Also, the XLA SLA Hub Journal Lines view can be used for the analysis of the accounting data by accounting class. You can analyze the accounting data for a detailed understanding about the accounts and amounts pertaining to different accounting classes, such as accruals, exchange gains and losses, earned and unearned discounts, inventory valuations, and inventory adjustments.

Transaction and Subledger Journal Details by Account Balances and Types

In this reporting scenario, you can drill down to a subledger application's source distributions for an account type from its balances in General Ledger. For this purpose, you will require the XLA GL All Balances view, the XLA SLA Hub Journal Lines view, and the relevant XLA% distribution view.

You can use the following steps to create a drill-down report:

Identify the account type for which you want to find the transaction and Subledger Accounting journal details corresponding to a subledger application. For this, join the XLA GL All Balances and XLA SLA Hub Journal Lines views to obtain details of line amounts in Subledger Accounting journals by account type. The information needs to be filtered by an accounting period, a ledger, and a Subledger Accounting journal currency and grouped by account type.

Identify a subledger application corresponding to the account type selected in the previous step. For this, join the XLA GL All Balances and XLA SLA Hub Journal Lines views to obtain details of line amounts in Subledger Accounting journals by subledger applications for the account type identified in the previous step. The information needs to be filtered by the accounting period, ledger, and Subledger Accounting journal currency used in the previous step and grouped by subledger application and account type.

Join the XLA GL All Balances and XLA SLA Hub Journal Lines views with the XLA% distribution view for the subledger application identified in the previous step to obtain the transaction and Subledger Accounting journal details for the subledger application and account type. Filter the records by the accounting period, ledger, and Subledger Accounting journal currency used in the previous step.

Tips and Other Considerations

The following points help you to optimally use the views for Subledger Accounting:

For manually created journal entries in Subledger Accounting and General Ledger, the views provided as part of the subledger application-specific and Subledger Accounting-specific solutions will not return any records because these journal entries do not have any associated source distributions in subledger applications.

A drill down from Subledger Accounting to the source distributions of subledger applications is not possible for intercompany transactions because they are created within Subledger Accounting.

The following is applicable to the information that is returned for the secondary and reporting ledgers:

When transactions are based on secondary ledgers set up in Subledger Accounting or General Ledger, the XLA SLA Hub Journal Lines view will return records for both the primary and secondary ledgers with the associated account and currency information for these ledgers. However, the XLA% distribution views return information about only primary ledgers. Therefore, to provide support for drill-down reporting based on the secondary ledgers from the XLA SLA Hub Journal Lines view to the individual XLA% distribution views, the SLA Ledger Name column has been added to the XLA% distribution views. The SLA Ledger Name column will return information about the secondary ledgers in the distribution views.

The distribution views available in the subledger application-specific solution return records for only the primary ledgers. However, the subledger application-specific hub views will return records for both primary ledgers and secondary ledgers. Therefore, use only primary ledgers when the subledger application-specific hub views are used to drill down to the distributions views for the subledger applications.

When the secondary or reporting ledger conversion is set up at the journal level in Oracle E-Business Suite, the records pertaining to the secondary and reporting ledgers in the subledger application-specific hub views, XLA% distribution views, and XLA SLA Hub Journal Lines view will always return information in the base currency of the primary ledger. Therefore, when building reports and queries that are based on the secondary ledgers or reporting ledgers, you must not use the associated base currency information.

When the secondary or reporting ledger conversion is set up at the journal level in Oracle E-Business Suite, the following columns in the XLA SLA Hub Journal Lines view always return information for the primary ledger:

AcctSLA$QV% columns

Chart Of Accounts Name

GL Period Name

Ledger Name

SLA JE Amount

SLA JE Amount Base

SLA JE Amount Cr

SLA JE Amount Cr Base

SLA JE Amount Dr

SLA JE Amount Dr Base

The Ledger Category column in the view can be used for identification of the ledger type associated with the records.

In Subledger Accounting, the links between lines and distributions are not always maintained, and some calculations are done internally. Therefore, in some cases, you cannot join records in the XLA% distribution views to the corresponding lines in the XLA SLA Hub Journal Lines view. For example, when the value returned by the Accounting Line Type column of an XLA% distribution view is “AUTO GEN GAIN LOSS”, records will be dropped when you join the XLA% distribution view to the XLA SLA Hub Journal Lines view.

Sometimes, the number or records in the XLA% distribution views may not match the number of records in the XLA SLA Hub Journal Lines view. For credits and debits, sometimes, the summed-up credit amounts or debit amounts in the XLA% distribution views may not match the summed-up credit amounts or debit amounts in the XLA SLA Hub Journal Lines view. In some cases, when you drill down from a line in the XLA SLA Hub Journal Lines view to the corresponding records in an XLA% distribution view, the amounts may not match. For example, the XLA AR Std Receipt Dist view will return separate records for credits and debits when the value returned by the Accounting Line Type column is “RCT UNAPP DEBIT” or “RCT UNAPP CREDIT”. However, the XLA SLA Hub Journal Lines view will return only one record with the net amount.

The following is applicable to the migrated data:

While Subledger Accounting-specific views and subledger application-specific views return migrated data, a drill-down from Subledger Accounting to the source distributions may return incorrect information because the data may not have been migrated correctly or some view columns may not have been populated by design for migrated data. Therefore, you must not perform calculations on records returned by the views for migrated data.

The columns in the XLA% distribution views pertaining to Cost Management will always return null values for migrated data. Therefore, when you compare the records in the XLA SLA Hub Journal Lines view against the records in the XLA% distribution views for Cost Management, you will find differences in the line amounts and distribution amounts.

While building reports and queries based on the XLA SLA Hub Journal Lines view, XLA% distribution views, or subledger application-specific hub views, use the Migrated Data Flag column in the filter condition to find records pertaining to migrated data. These views may return incorrect information for the migrated data if the transactions were not migrated properly in Oracle E-Business Suite.

In some subledger applications, the distribution process does not result in separate records for credit and debit amounts. However, separate records are always created in Subledger Accounting for credit and debit amounts. When the XLA% distribution views for such subledger applications are joined with the XLA SLA Hub Journal Lines view, you must filter the records in the hub view using the Accounting Class column so that the summed-up amounts match. For example, in the XLA AP Invoice Dist view, records will be returned for only debit amounts. The XLA SLA Hub Journal Lines view will have corresponding records created for these debit amounts. These records can be identified through the use of the “Item Expense” accounting class code in the XLA SLA Hub Journal Lines view. However, in the XLA SLA Hub Journal Lines view, records will be returned for credit amounts as well. These records can be identified through the use of the “Liability” accounting class code. Therefore, when the views are joined, you should filter the records in the hub view by the “Item Expense” accounting class code to find the corresponding records from the XLA AP Invoice Dist view.

In the Journals window of General Ledger, when the base currency amount for a journal entry is zero, you cannot drill down to the View Journal Entry Lines page to see the corresponding lines in Subledger Accounting. However, you can use the XLA GL Journal Lines view to drill down from an account for which the base currency amount is zero to the XLA SLA Hub Journal Lines view. For such accounts, in the XLA SLA Hub Journal Lines view, the SLA JE Line Number column will return negative values. Therefore, you can use this column to filter out such accounts while joining the two views.

In Projects, after the distribution process, a single record is created for a raw cost transaction, while separate credit and debit records are created for a burdened cost transaction. After the Create Accounting program is run, separate credit and debit records will be created for both raw cost and burdened cost transactions in Subledger Accounting. Therefore, when you build reports and queries based on the hub view in which you want to filter out the records corresponding to the raw costs, you need to use the following filter conditions: Accounting Event Entity Code = 'EXPENDITURES', Accounting Event Class Name <> 'Total Burdened Cost', and Accounting Class = 'Cost'. To filter out the records corresponding to the burdened costs, you need to use the following filter conditions: Accounting Event Entity Code = 'EXPENDITURES', Accounting Event Class Name = 'Total Burdened Cost', and Accounting Class = 'Cost'.

Other Cross-Functional Views for Subledger Accounting

This section contains information about other cross-functional views that are available in NoetixViews to support the subledger accounting functionality. The details of the Noetix views and the subject areas covered by these views are available in the tables provided in this section. However, these views may perform poorly and provide less flexibility because the information returned cannot be easily used for fulfilling the reporting needs.

NoetixViews for Oracle Assets

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Adjustments

FA Adjustments SLA GL Je

FA GL Journal Adjustments

Yes

Transactions

FA All Trans SLA GL Je

FA GL Journals

Yes

Depreciation histories

FA Deprn Dtl Hist SLA GL Je

FA Depr Detail History

Yes

Depreciations

FA Deprn Dtls SLA GL Je

FA Depreciation Details

Yes

Invoice transactions

FA Invoice Trx SLA GL Je

FA GL Invoice Trans Je

Yes

Tax reserve adjustment transactions

FA SLA Tax Reserve Adjust

FA Tax Reserve Adjustment

Yes

 

NoetixViews for Oracle General Ledger

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Payables invoices

GL Je SLA AP Inv Dist

GL AP Inv Je Line Details GL Je AP Inv Dist Details

No

Payables invoice payments

GL Je SLA AP Pmt Dist

GL Je AP Pmt Dist Details

No

Receivables adjustments

GL Je SLA AR Adj Dist

GL Je Tran AR Adj Dist

Yes

Receivables miscellaneous receipts

GL Je SLA AR Misc Rcpt Dist

GL Je Tran AR Misc Dist

Yes

Receivables standard receipts

GL Je SLA AR Std Rcpt Dist

GL Je Tran AR Pymt Dist

Yes

Receivables transactions

GL Je SLA AR Tran Dist

GL Je Tran AR Tran Dist

Yes

Purchasing PO and requisition encumbrances

GL Je SLA PO All Encumb

GL Je Tran All PO Encumb

Yes

Purchasing blanket purchase agreements

GL Je SLA PO Blnkt Encumb

GL Je Blanket PO Encumb

Yes

Purchasing PO encumbrances

GL Je SLA PO Encumb

GL Je Tran PO Encumb

Yes

Purchasing requisition encumbrances

GL Je SLA PO Req Encumb

GL Je Tran PO Req Encumb

Yes

 

NoetixViews for Oracle Payables

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Invoices

AP Inv Dist SLA GL Je

AP Inv GL Tr Details

No

Payments

AP Pmt Dist SLA GL Je

AP Pmt Dist GL Tr Details

No

Trial balance

AP Trial Balance Details

AP Trial Balance

No

 

NoetixViews for Oracle Receivables

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Adjustments

AR Adj Dist SLA GL Je

AR Adjustment GL Je Dist

Yes

Miscellaneous receipts

AR Misc Rcpt Dist SLA GL Je

AR Misc Pymt GL Je Dist

Yes

Standard receipts

AR Std Rcpt Dist SLA GL Je

AR Cust Pymt GL Je Dist

Yes

Transactions

AR Tran Dist SLA GL Je

AR Cust Tran GL Je Dist

Yes

 

NoetixViews for Oracle U.S.Federal Financials

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Budget authority transactions, appropriations

FV Budget Auth SLA GL JE

FV Budget Appr GL JE

Yes

Fund distributions

FV Fund Distr SLA GL JE

FV Fund Distr GL JE

Yes

Expenditures

FV SLA AP Expenditures

FV AP Expenditures

Yes

Budgetary transactions

FV SLA Budget Trans

FV Budget Transactions

Yes

Commitments

FV SLA PO Commitments

FV PO Commitments

Yes

Obligations

FV SLA PO Obligations

FV PO Obligations

Yes

 

NoetixViews for Oracle Process Manufacturing Financials

Accounting subject area

Subledger Accounting, cross-functional view

Legacy, cross-functional view

Legacy view generated in Release 12?

Test accounting distributions

GMF SLA Cost Subledger

GMF Test Subledger

Yes

Updated accounting distributions

GMF SLA Cost Subledger

GMF Update Subledger

Yes

The following table correlates views that return ledger-to-subledger, final data that has been posted to General Ledger with views that return subledger-to-ledger data that is either in draft form or in final form and posted to General Ledger.

 

Ledger-to-Subledger, Subledger-to-Ledger Noetix Views

Accounting subject area

 

Subledger-to-ledger view

Asset adjustments (all)

FA Adjustments SLA GL Je

Asset transactions (all)

FA All Trans SLA GL Je

Asset depreciation histories

FA Deprn Dtl Hist SLA GL Je

Asset depreciations

FA Deprn Dtls SLA GL Je

Asset invoice transactions

FA Invoice Trx SLA GL Je

Payables invoices

GL Je SLA AP Inv Dist

AP Inv Dist SLA GL Je

Payables invoice payments

GL Je SLA AP Pmt Dist

AP Pmt Dist SLA GL Je

Receivables adjustments

GL Je SLA AR Adj Dist

AR Adj Dist SLA GL Je

Receivables miscellaneous receipts

GL Je SLA AR Misc Rcpt Dist

AR Misc Rcpt Dist SLA GL Je

Receivables standard receipts

GL Je SLA AR Std Rcpt Dist

AR Std Rcpt Dist SLA GL Je

Receivables transactions (all)

GL Je SLA AR Tran Dist

AR Tran Dist SLA GL Je

Purchasing PO and requisition encumbrances

GL Je SLA PO All Encumb

Purchasing blanket purchase agreements

GL Je SLA PO Blnkt Encumb

Purchasing PO encumbrances

GL Je SLA PO Encumb

Purchasing requisition encumbrances

GL Je SLA PO Req Encumb

NoetixViews for Oracle Contract Lifecycle Management

The Noetix business views for Oracle Contract Lifecycle Management provide a comprehensive analysis for requisitions, draft purchase orders (POs), awards, and user defined attributes (UDAs).

The Noetix views for Contract Lifecycle Management are available in the standard, Cross Operations Extension (XOP), and global forms.

Support for Subject Areas

The Noetix views for Contract Lifecycle Management cater to the following subject areas to meet the needs of requestors, buyers, and contracting professionals:

Requisitions

Headers: The PO Requisitions, PO Req Notifications, and PO Requisitions UDA views provide information about purchase requisition headers, purchase requisition notifications, and UDAs pertaining to purchase requisition headers.

Lines: The PO Requisition Lines, PO Requisition Line Pos, and PO Requisition Lines UDA views provide information about purchase requisition lines, purchase requisition lines and resulting PO lines, and UDAs pertaining to purchase requisition lines.

Distributions: The PO Req Distributions, PO SLA Requisition Dist, and PO Req Distributions UDA views provide information about purchase requisition distributions, purchase requisition distributions in Oracle Subledger Accounting, and UDAs pertaining to purchase requisition distributions.

Awards

Headers: The PO Purchase Orders, PO PO Notifications, PO Document Actions, and PO Purchase Orders UDA views provide information about award headers, PO notifications, actions performed on purchasing documents, and UDAs pertaining to award headers.

Lines: The PO PO Lines and PO PO Lines UDA views provide information about award lines and their UDAs.

Shipments: The PO PO Shipments, PO All Shipments, and PO PO Shipments UDA views provide information about standard PO shipments, all types of PO shipments, and UDAs pertaining to PO shipments.

Distributions: The PO PO Distributions, PO SLA Hub Journal Lines, and PO PO Distributions UDA views provide information about PO award distributions, subledger accounting distributions, and UDAs pertaining to award distributions.

Releases: The PO Releases view provides information about the PO releases.

Actions and notifications: The PO Document Actions view provides information about the actions performed on PO documents. The PO PO Notifications view provides notification information about POs that are awaiting actions.

Draft purchase orders: The PO Draft Distributions, PO MOD Draft Distribution, and PO PAR Draft Distribution views provide information about the draft PO distributions for awards, award modifications, and post award requests.

Invoices and payments: The following views return information about Contract Lifecycle Management when POs created in Contract Lifecycle Management are invoiced and payments are made against these invoices:

AP Invoices

AP Invoice Distributions

AP Invoice Pay Schedules

AP Checks

AP Invoice Payments

AP Interest Invoices

PO Invoices

PO Invoice Payments

PO receipts: The PO Receipts and PO Uninvoiced Receipts views return information for contract lifecycle management when goods or items are received for a PO that is created in Contract Lifecycle Management.

User defined attributes: The following views provide information about UDAs for purchase requisition headers, purchase requisition lines, purchase requisition distributions, PO headers, PO lines, PO shipments, and PO distribution levels:

PO Requisitions UDA

PO Requisition Lines UDA

PO Req Distributions UDA

PO Purchase Orders UDA

PO PO Lines UDA

PO PO Shipments UDA

PO PO Distributions UDA

Additionally, the following views return information about Contract Lifecycle Management:

AP Pmt Dist SLA GL Je

AP SLA Invoice Dist

FV SLA PO Commitments

FV SLA PO Obligations

PO PO Shipments

PO Vendor Sites

PO Vendors

XLA Accrual Write Off Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

Noetix Roles for Contract Lifecycle Management Views

The views that provide information about Contract Lifecycle Management are managed through the Noetix roles corresponding to the NoetixViews modules to which they belong. The following table lists the Noetix roles and the corresponding views.

Noetix role label

Noetix view

FEDERAL ADMINISTRATOR

FV SLA PO Commitments

FV SLA PO Obligations

PAYABLES

AP Checks

AP Interest Invoices

AP Invoice Distributions

AP Invoice Pay Schedules

AP Invoice Payments

AP Invoices

AP Pmt Dist SLA GL Je

AP SLA Invoice Dist

PURCHASING

PO All Shipments

PO Blanket Price Breaks

PO Document Actions

PO Draft Distributions

PO Invoice Payments

PO Invoices

PO MOD Draft Distribution

PO PAR Draft Distribution

PO PO All Distributions

PO PO Distributions

PO PO Distributions UDA

PO PO Lines

PO PO Lines UDA

PO PO Notifications

PO PO Shipments

PO PO Shipments UDA

PO Purchase Orders

PO Purchase Order Details

PO Purchase Orders UDA

PO Receipts

PO Releases

PO Req Distributions

PO Req Distributions UDA

PO Req Notifications

PO Requisition Line Pos

PO Requisition Lines

PO Requisition Lines UDA

PO Requisitions

PO Requisitions UDA

PO SLA Hub Journal Lines

PO SLA Requisition Dist

PO Uninvoiced Receipts

PO Vendor Sites

PO Vendors

SUBLEDGER ACCOUNTING

XLA Accrual Write Off Dist

XLA PO Receiving Dist

XLA PO Requisition Dist

Noetix Views in Contract Lifecycle Management Workflow

The workflow for Contract Lifecycle Management that represents the supported subject areas and Noetix views is as follows.

Useful Reporting Scenarios Supported by Contract Lifecycle Management Views

The following reporting scenarios are supported by the views in Contract Lifecycle Management:

To obtain information about purchase requisitions and their UDAs, you can join the PO Requisitions and PO Requisitions UDA views.

To obtain information about the total purchase requisition amount of conformed purchase requisitions for a period, you can use the PO Requisitions view.

To obtain information about purchase requisitions related to Military Interdepartmental Purchase Request (MIPR), you can join the PO Requisitions and PO Requisitions UDA views.

To obtain information about the amended purchase requisition lines and contracting office details, you can join the PO Requisition Lines and PO Requisition lines UDA views.

To obtain information about the purchase requisition distributions and their UDAs, you can join the PO Req Distributions and PO Req Distributions UDA views.

To obtain information about the funded value change for a period and total value of funds by operating unit for a period, you can use the PO Req Distributions view.

To obtain information about the award headers and their UDAs, you can join the PO Purchase Orders and PO Purchase Orders UDA views.

To obtain information about award lines and their UDAs, you can join the PO PO Lines and PO PO Lines UDA views.

To obtain information about awards for a vendor for a period, you can use the PO PO Lines view.

To obtain information about award shipments and their UDAs, you can join the PO PO Shipments and PO PO Shipments UDA views.

To obtain information about award distributions and their UDAs, you can join the PO PO Distributions and PO PO Distributions UDA views.

To obtain information about encumbered amount for a period and POs associated with a project, you can use the PO PO Distributions view.

To obtain information about draft POs and their UDAs, you can join the PO Draft Distributions and PO Purchase Orders UDA views.

To obtain information about POs and their release details, you can use the PO Releases view.

NoetixViews for Oracle Projects

NoetixViews for Oracle Projects provides a solution for maintaining control and visibility of projects. It displays project information at a single source point enabling you to track and manage a project through the project lifecycle.

NoetixViews for Oracle Projects includes approximately 50 views that cover various project types such as capital, contract, and indirect. The subject areas covered are projects, tasks, resources, budgets, expenditures, invoices, revenues, and status inquiry. These views belong to the basic, value-added or cross-functional type and additionally are categorized as detail or summary-level views.

Detail views present transaction details as entered in Oracle Projects. Usually, these transactions can be entered in various currencies. All detail views include one or more transaction currency amount, as well as converted project and project functional currency amounts. A currency-code column differentiates the currency types for the user.

Summary views require the summation of individual transaction amounts. Therefore, summary views show the amounts in a single currency. The project functional currency and currency-code columns are not displayed.

Background

In Oracle E-Business Suite 10.7, the Oracle Project Costing module had the facility to enter receipts in multiple currencies. Oracle expanded the multi-currency functionality within the Project Costing module with Oracle
E-Business Suite 11.0.3 and then further extended the multi-currency support to Oracle Project Billing with Oracle E-Business Suite 11.5.8, Family Pack J.

NoetixViews supports multi-currency feature in the areas of Project Accounting, Project Costing, and Project Billing.

Currency Types Supported in Noetix Views for Projects

NoetixViews for Oracle Projects supports three types of currencies:

Project functional currency: The currency derived from the ledger of an operating unit. If multi-currency is enabled, each project can be maintained in a specific currency called project currency.

Project currency: The currency to which all transactions of a project are converted for processing and summarization. This can be defined per project.

Transactional currency: Can be different from project functional and project currencies with respect to subject area. For example, expenditures can take place in one currency and the agreement between customers can be in another currency. In the case of expenditures, the transactional currency is termed as expenditure currency and in the case of agreements, it becomes agreement currency.

Results of Multi-Currency Activation in Noetix Views for Projects

Activating multi-currency columns in NoetixViews results in the following changes:

All transactional views have transaction-specific currency values in the base amount columns. Additional columns for project functional currency (with the PFC suffix) and project currency (with the PC suffix) may also be generated. These additional columns are not added for every occurrence of a transactional amount column.

Most of the PFC columns corresponding to the transaction-amount columns are generated. Some of the PC columns corresponding to the transaction-amount columns are also generated.

You cannot summarize on the transaction-amount columns with this option as the columns can be in multiple currencies. You must summarize the transaction-amount columns based on the corresponding PFC or PC columns.

An expense amount in Project Currency might not equal the Payables Functional Currency amount for the same transaction.

Information related to currency codes and exchange rates is generated.

If you use the multi-currency functionality of Oracle Projects at your site, you must activate multi-currency columns in your views. Otherwise, the amount columns in your views will contain values in project functional currencies, and not display information related to currency codes and exchange rates.

NoetixViews for Oracle Process Manufacturing

The Noetix business views and pre-built answers for Oracle Process Manufacturing provide a reporting solution for the major aspects of this Oracle E-Business Suite module, such as new product development, recipe management, production, process execution, cost, quality, and regulatory management. These views also provide setup information about items, reordering rules for items, and resources for routings.

NoetixViews for Oracle Process Manufacturing includes 63 views that cater to Oracle Process Manufacturing Inventory Management (covered by the views for Oracle Inventory for Oracle E-Business Suite Release 12 and later), Oracle Process Manufacturing Product Development, Oracle Process Manufacturing Planning (covered by the views for Oracle Advanced Supply Chain Planning for Oracle E-Business Suite Release 12 and later), Oracle Process Manufacturing Process Execution, and Oracle Process Manufacturing Financials.

The views can be categorized into the following:

Basic views, such as the setup views

Value-added views, such as the summary, detail, and transactional views

Cross-functional views

Support for Subject Areas

The following tables list the subject areas of individual modules of Process Manufacturing and the corresponding Noetix views.

Subject Areas of NoetixViews for Oracle Process Manufacturing Inventory Management

Subject areas

Noetix views

Item setup: Information about items, catalog element values, lots and sublots, production rules, and reorder rules.

GMI Item Catalogs

GMI Item Master

GMI Lots Sublots

GMI Production Rules

GMI Warehouse Rules

On-hand inventory: Information about stock locators, inventory transactions, on-hand inventory by location and lot, total on-hand inventory by process organization, and warehouse transfers.

GMI Inv Stock Locators

GMI Inv Transactions

GMI Onhand Inv By Location

GMI Onhand Inv By Lot

GMI Onhand Inv Rollup

GMI Warehouse Transfer

Unallocated inventory: Rollup and summary information about allocated and unallocated inventories.

GMI Inv Unallocated Rollup

GMI Unallocated Inventory

Month-end inventory: Information about the month-end inventory balances.

GMI Month End Inventory

Noetix views for Process Manufacturing Inventory Management are applicable for only Oracle E-Business Suite versions prior to Release 12, after which the views for Inventory provide the same functionality.

For Oracle E-Business Suite Release 12 and later, the following views for Inventory are available for Process Manufacturing.

Subject Areas of NoetixViews for Oracle Inventory Related to Process Manufacturing

Subject areas

Noetix views

Item setup: Information about customer items, item catalogs, process manufacturing attributes, item relationships, item lots, and stock locators.

INV Customer Items

INV Item Catalogs

INV Item Inventory Attributes

INV Item Process Attribute

INV Item Relationships

INV Items

INV Lot Details

INV Stock Locators

On-hand inventory: Information about unallocated inventory by lot and location and on-hand quantities rolled up to the inventory organization.

INV Item Onhand By Lot

INV Onhand Quantities

INV Onhand Rollup

INV Safety Stock

Unallocated inventory: Information about item unallocated inventory and total unallocated inventory by inventory organization.

INV Unallocated Inventory

INV Unallocated Rollup

Period close inventory: Information about period close inventory balances.

INV Period Close Details

Inventory reservations: Information about item reservations from various demand sources, such as purchase orders (POs), accounts, account aliases, process batches, jobs or schedules, and sales orders.

INV Reservations

Inventory transactions: Information about different inventory transactions, such as accounts, cycle counts, lots, POs, requisitions, and sales orders.

INV Account Transactions

INV Alias Transactions

INV Cycle Count Transactions

INV Lot Transactions

INV Physical Inv Transactions

INV PO Transactions

INV Requisition Transactions

INV Sales Order Transactions

INV Serial Number Trans

INV Transaction Details

INV Transactions

 

Subject Areas of NoetixViews for Oracle Process Manufacturing Product Development

Subject areas

Noetix views

Formulas: Information about formulas, such as the numbers, classes, owners, items, phantom items, required quantities, input and output quantities, and units of measurement (UOMs) for the item quantity.

GMD Formulas

Recipes: Information about recipes, customers, process losses, and validity rules.

GMD Recipe Customers

GMD Recipe Process Loss

GMD Recipe Validity Rules

GMD Recipes

Routings: Information about routings, associated operations, and resources.

GMD Routing Resources

GMD Routings

Quality management setup: Information on test cases, associated customers, test codes, and test values.

GMD Qc Customer Tests

GMD Qc Tests

Quality management: Information on samples taken from customers, inventories, monitoring sources, suppliers, and work in process and the resulting activities; test results; and quality conformance requirements.

GMD Qc Customer Samples

GMD Qc Inventory Samples

GMD Qc Monitoring Samples

GMD Qc Results

GMD Qc Specifications

GMD Qc Supplier Samples

GMD Qc WIP Samples

 

Subject Areas of NoetixViews for Oracle Process Manufacturing Planning

Subject areas

Noetix views

Action messages: Information about the material requirements planning (MRP) action message transactions and the pegging and transactions associated with each action number in an MRP run.

GMP Action Messages

GMP MRP Action Msg Pegging

Forecast: Information about forecasts.

GMP Forecast Details

Demand/Supply: Information at the summary level about the demand and supply sources of an item for all transactions in each MRP run.

GMP MRP Demand Supply Dtl

Planning: Information about pending inventory transactions that are not bucketed as supply and demand.

GMP MRP Mtrl Unbucketed

From Release 12, Advanced Supply Chain Planning must be used in place of Process Manufacturing Planning. Therefore, for Release 12 and later, the views for Advanced Supply Chain Planning should be used for planning-related data. For Oracle E-Business Suite Release 12 and later, refer to the following Noetix views for Advanced Supply Chain Planning to avail of functionality that is similar to what is provided by the views for Process Manufacturing Planning. However, these views are a part of NoetixViews for Oracle Advanced Supply Chain Planning and are not bundled with NoetixViews for Oracle Process Manufacturing.

Subject Areas of NoetixViews for Oracle Advanced Supply Chain Planning Related to Process Manufacturing

Subject areas

Noetix views

Exception, pegging details: Information about exception details and pegging details for plans.

MSC Exceptions

MSC Pegging Details

Forecast consumptions: Information about forecast consumptions of plans.

MSC Forecast Consumptions

Demand/Supply: Information about demands and supplies for plans.

MSC Demand Details

MSC Supply Details

Vertical Plan Details: Information about the vertical plans of the planned items.

MSC Vertical Plan Details

 

Subject Areas of NoetixViews for Oracle Process Manufacturing Process Execution

Subject areas

Noetix views

Firm planned order: Information about firm planned orders of items, recipes,
formulas, and routings.

GME Firm Planned Orders

Production Batch: Information about batches, such as deleted ingredients,
headers, materials, steps, activities, and associated resources.

GME Batch Deleted Details

GME Batch Headers

GME Batch Material Details

GME Batch Step Details

GME Batch Step Rsrc Actvty

 

Subject Areas of NoetixViews for Oracle Process Manufacturing Financials

Subject areas

Noetix views

Costing setup: Information about the association between cost and inventory organizations, standard burden or overhead costs, standard component costs, overhead codes and percentages for cost calculations, and resource costs.

GMF Cost Organization Assc

GMF Cost Warehouse Assoc

GMF Item Burden Costs

GMF Item Costs

GMF Overhead Percentages

GMF Resource Costs

Costing: Information about the rolled up costs and lot-level costs for production items.

GMF Item Costs Rollup

GMF Lot Cost Details

Subledger Accounting views (for Oracle E-Business Suite versions prior to Release 12): Information about test updates of accounting distributions of different transactions and information about accounting distributions of different transactions that are updated to the subledger.

 

Subledger Accounting view (for Oracle E-Business Suite Release 12 and later): Information about subledger transactions in draft and final modes.

GMF Test Subledger

GMF Update Subledger

 

 

 

 

 

 

 

GMF SLA Cost Subledger

The GMF Cost Organization Assc, GMF Overhead Percentages, and GMF Lot Cost Details views are available for only Release 12 and later. Also, the GMF Cost Warehouse Assoc view is obsolete in Release 12 and later and returns only historical data; use the GMF Cost Organization Assc view instead.

Support for Flexfields

The following tables list the descriptive flexfields in Process Manufacturing and the Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle Process Manufacturing Inventory Management

Descriptive flexfield

Noetix view

Item Catalog Groups

GMI Item Catalogs

Item Information

GMI Item Master

GMI Onhand Inv By Lot

GMI Onhand Inv Rollup

Lot/Sublot Information

GMI Lots Sublots

Production Rules

GMI Production Rules

Warehouse Information

GMI Warehouse Transfer

Warehouse Rules Information

GMI Warehouse Rules

 

Descriptive Flexfields Supported in NoetixViews for Oracle Inventory Related to Process Manufacturing

Descriptive flexfield

Noetix view

Item

INV Item Process Attribute

Lot

INV Lot Details

Lot Number

INV Lot Details

Lot Number Character

INV Lot Details

Lot Number Date

INV Lot Details

 

Descriptive Flexfields Supported in NoetixViews for Oracle Process Manufacturing Product Development

Descriptive flexfield

Noetix view

Formula Line Attributes

GMD Formulas

Operation Resources Flexfields

GMD Routing Resources

Quality Results

GMD Qc Results

Quality Specifications

GMD Qc Specifications

Quality Tests

GMD Qc Customer Tests

GMD Qc Tests

Recipe Flexfields

GMD Recipe Customers

GMD Recipe Process Loss

GMD Recipe Validity Rules

GMD Recipes

Routing Header Flexfield

GMD Routings

Samples

GMD Qc Customer Samples

GMD Qc Inventory Samples

GMD Qc Monitoring Samples

GMD Qc Supplier Samples

GMD Qc WIP Samples

 

Descriptive Flexfields Supported in NoetixViews for Oracle Process Manufacturing Process Execution

Descriptive flexfield

Noetix view

Batch Information

GME Batch Deleted Details

GME Batch Headers

GME Firm Planned Orders

Batch Steps Information

GME Batch Step Details

GME Batch Step Rsrc Actvty

Material Details

GME Batch Material Details

 

Descriptive Flexfields Supported in NoetixViews for Oracle Process Manufacturing Financials

Descriptive flexfield

Noetix view

Cost Detail Information

GMF Item Costs

GMF Item Costs Rollup

Cost Warehouse Association Master

GMF Cost Warehouse Assoc

Percentage Burden Codes Information

GMF Overhead Percentages

The following tables list the key flexfields in Process Manufacturing and the Noetix views that support these flexfields.

Key Flexfields Supported in NoetixViews for Oracle Inventory Related to Process Manufacturing

Key flexfield

Noetix view

Detailed Container Item

INV Customer Items

Item

INV Customer Items

INV Item Catalogs

INV Item Onhand By Lot

INV Item Process Attribute

INV Item Relationships

INV Lot Details

INV Onhand Rollup

INV Period Close Details

INV Stock Locators

Item Catalogs

INV Item Catalogs

Locator

INV Stock Locators

Master Container Item

INV Customer Items

Supply Locator

INV Item Process Attribute

Yield Locator

INV Item Process Attribute

 

Key Flexfields Supported in NoetixViews for Oracle Process Manufacturing Product Development

Key flexfield

Noetix view

Item

GMD Formulas

GMD Qc Customer Samples

GMD Qc Inventory Samples

GMD Qc Results

GMD Qc Specifications

GMD Qc Supplier Samples

GMD Qc WIP Samples

Formula

GMD Recipes

Product

GMD Recipes

Sample Locator

GMD Qc Customer Samples

GMD Qc Inventory Samples

GMD Qc Monitoring Samples

GMD Qc Supplier Samples

GMD Qc WIP Samples

Source Locator

GMD Qc WIP Samples

Storage Locator

GMD Qc Customer Samples

GMD Qc Inventory Samples

GMD Qc Monitoring Samples

GMD Qc Supplier Samples

GMD Qc WIP Samples

Test Kit

GMD Qc Results

Validity

GMD Recipe Validity Rules

 

Key Flexfields Supported in NoetixViews for Oracle Process Manufacturing Process Execution

Key flexfield

Noetix view

Ingredient

GME Batch Deleted Details

Item

GME Batch Material Details

GME Firm Planned Orders

Product

GME Batch Deleted Details

GME Batch Headers

Sample Locator

GME Batch Material Details

GME Firm Planned Orders

 

Key Flexfields Supported in NoetixViews for Oracle Process Manufacturing Process Financials

Key flexfield

Noetix view

Accounting Flexfield

GMF SLA Cost Subledger

Cost Category

GMF Overhead Percentages

GL Business Category

GMF Overhead Percentages

GL Category

GMF Overhead Percentages

GL Product Line Category

GMF Overhead Percentages

Item

GMF Item Burden Costs

GMF Item Costs

GMF Item Costs Rollup

GMF Lot Cost Details

GMF Overhead Percentages

GMF SLA Cost Subledger

Noetix Roles for Process Manufacturing

NoetixViews for Oracle Process Manufacturing includes only the following global roles:

OPM INVENTORY (for Oracle E-Business Suite versions prior to Release 12)

PRODUCT DEVELOPMENT

PROCESS EXECUTION

PROCESS PLANNING (for Oracle E-Business Suite versions prior to Release 12)

OPM FINANCIALS

Noetix Views in Process Manufacturing Workflow

The following diagram explains the process flow of Process Manufacturing and the important Noetix views that provide information at each point in the process flow.

Other Considerations

The following points would help you optimally use the views for Process Manufacturing:

NoetixViews for Oracle Process Manufacturing Inventory Management returns the transactional data for only Oracle E-Business Suite versions prior to Release 12. From Release 12, Inventory supports the Process Manufacturing functionality for inventory. Therefore, for these versions of Oracle E-Business Suite, NoetixViews for Oracle Inventory returns information relevant to Process Manufacturing Inventory Management transactions through the INV Transactions and INV Transaction Details views. For Release 12 and later, Noetix views for Process Manufacturing Inventory Management return only historic data. To view the historic data relevant to Process Manufacturing Inventory Management transactions, you can use the GMI Inv Transactions view.

As the concept of Subledger Accounting is introduced in Oracle E-Business Suite Release 12, some of the existing Noetix views for Process Manufacturing Financials in Release 12 return only historic data. These views are GMF Test Subledger and GMF Update Subledger. For Release 12 and later, cost and accounting transaction data is returned by the GMF SLA Cost Subledger view.

Noetix views for Process Manufacturing Planning return only historic data for Release 12 and later. From Release 12, Noetix views for Advanced Supply Chain Planning, such as MSC Demand Details, MSC Designator Details, MSC Exceptions, MSC Pegging Details, and MSC Supply Details, return similar information as provided by the transaction views for Process Manufacturing Planning.

In Oracle E-Business Suite, planning recommendations from Advanced Supply Chain Planning become purchase requisitions in Oracle Purchasing. Data for purchase requisitions can be viewed through the PO Requisitions view. Through regular transactions in Purchasing, these requisitions become purchase orders (POs), shipments, and receipts, the details of which can be viewed through the PO PO Lines, PO Purchase Orders, PO PO Shipments, PO Receipts, and PO Uninvoiced Receipts views.

The additional details of sales orders for items in Process Manufacturing are maintained in Oracle Order Management and can be viewed through the OE Deliveries, OE Drop Shipments, OE Orders, and OE Returns views.

The GMD Qc Monitoring Samples view requires Family Pack K (11i.OPM PF.K) to be generated for Oracle E-Business Suite versions prior to Release 12.

NoetixViews for Oracle Time and Labor

The Noetix business views and pre-built answers for Oracle Time and Labor return setup information for timecard processing, missing timecards, Batch Element Entry (BEE) batches, and various time management structures and policies and also summary and detailed information for self-service and professional timecard data entry.

Support for Time and Labor reporting is also provided by NoetixViews for Oracle Human Resources, NoetixViews for Oracle Projects, and NoetixViews for Oracle Purchasing.

Twenty views are available in standard and global versions. The views can be categorized as basic or value-added views, or as setup, summary, and detail views. For most of the views, the access of Noetix query users to data is dependent on the security profiles set up in Oracle Human Resources. Moreover, for the global version of these views, the security profiles can be applied or ignored while Noetix query users access data. For all the global views, the list of business groups for which data will be returned can be customized. For more information, contact the Noetix System Administration User.

Support for Subject Areas

The following table lists the subject areas of Time and Labor and the corresponding Noetix views.

Subject Areas of NoetixViews for Oracle Time and Labor

Subject areas

Noetix views

Basic Setup: Work plans, shifts, and rotation plans.

HXC Rotation Plans

HXC Work Plans

Earning policy setup

HXC Earning Policies

Time Store Setup: Time entry rules and time entry rule groups.

HXC Time Entry Rule Groups

Employee Assignments: Mapping of employee assignments with time management policies

HXC Assignment Time Info

Timecards: Latest information, missing entries, errors, and historical information for professional timecards; latest information, missing entries, time category hours, approval action history, and historical information for self-service timecards; and summary information for both types of timecards

HXC PUI Latest Timecards

HXC PUI Missing Timecards

HXC PUI Time Entry Errors

HXC PUI Timecard History

HXC SS Latest Timecards

HXC SS Missing Timecards

HXC SS Time Category Hours

HXC SS Timecard Action Hist

HXC SS Timecard History

HXC Timecard Summary

BEE Batches: Header-level information, line-level information, and error messages

HXC BEE Batch Headers

HXC BEE Batch Lines

HXC BEE Error Messages

Assignment and person historical information

HXC All Assignment Hist

HXC All Person Hist

Support for Flexfields

The following tables list the flexfields in Oracle Time and Labor and the corresponding Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle Time and Labor

Descriptive flexfield

Noetix view

Additional Timecards Information

HXC PUI Latest Timecards

HXC PUI Timecard History

OTL Additional Assignment Information

HXC Assignment Time Info

OTL Information Types

HXC SS Latest Timecards

HXC SS Timecard History

OTL Timecard Summary Detail

HXC PUI Latest Timecards HXC PUI Timecard History

 

Key Flexfields Supported in NoetixViews for Oracle Time and Labor

Key flexfield

Noetix view

Cost Allocation Flexfield

HXC BEE Batch Lines

HXC PUI Latest Timecards

HXC PUI Timecard History

Grade Flexfield

HXC All Assignment Hist

Job Flexfield

HXC All Assignment Hist

People Group Flexfield

HXC All Assignment Hist

Position Flexfield

HXC All Assignment Hist

Noetix Roles for Time and Labor

NoetixViews for Oracle Time and Labor includes standard and global roles. For your Oracle E-Business Suite setup, a set of standard views is generated for each business group, while a set of global views is generated for all business groups. You can use the views under any role that is assigned to you. Contact your Noetix System Administration User if you have any queries regarding the roles granted to you.

Noetix Views in Time and Labor Workflow

The following diagram explains the process flow of Oracle Time and Labor and the Noetix views that provide information at each point in the process flow.

Additionally, the HXC All Assignment Hist and HXC All Person Hist views have been provided for historical information and the enabling of joins between views. The HXC Timecard Summary view has been provided so that information pertaining to both self-service and professional timecards can be retrieved through a single view. These views do not fit into the Time and Labor workflow.

Tips and Other Considerations

The following points could help you optimally use the views for Time and Labor:

While querying the HXC PUI Missing Timecards and HXC SS Missing Timecards views, make sure that you filter the records by the From Date and To Date columns. Otherwise, the views may return incorrect data.

The summary view HXC Timecard Summary can be joined to the detail views HXC PUI Latest Timecards and HXC PUI Timecard History using the PUI Timecard ID column. It can also be joined to the detail views HXC SS Latest Timecards and HXC SS Timecard History using the SS Timecard ID column.

In the HXC SS Time Category Hours view, the columns pertaining to hours for time categories are prefixed with “TC$”. The number of such columns depends on the number of time categories defined at your site.

If you add a new time category after this view has been generated, you cannot see the details of the new time category in the view immediately. For including the newly added details, this view has to be regenerated. Contact your Noetix System Administration User for regenerating the view.

If you have access to the Noetix views for Purchasing at your site, you can view the information relevant to Time and Labor through the PO Closed Uninv Receipts, PO PO Lines, PO Receipts, and PO Uninvoiced Receipts views.

If you have access to the Noetix views for Human Resources at your site, you can view the information relevant to Time and Labor through the HR Emp Absence Hist view.

If you have access to Noetix views for Projects at your site, you can concatenate the SS Timecard ID and Time Entry Version Number columns of the HXC SS Timecard History view with a hyphen (“-”) and join them to the Exp Item External Sys Ref column of the PA All Expenditure Items view to retrieve information relevant to Time and Labor from Projects.

NoetixViews for Oracle Quality

The Noetix business views and pre-built answers for Oracle Quality return information about the core elements of the Quality module, such as collection elements, specifications, collection plans, and quality results.

These views can be categorized as basic and value-added, including seven basic views and three value-added views. Additionally, Noetix gives you the option of dynamically generating two sets of views for quality results. The number of these views depends upon the number of collection plans and collection plan types set up at your site and the options selected during generation of the views.

Support for Subject Areas

NoetixViews for Oracle Quality provides views that cater to the following subject areas:

Collection Elements

These views provide information about collection elements and the action rules associated with the collection elements. The following views are available:

QA Col Elem Action Rules

QA Collection Elements

Specifications

These views provide information about specifications and the elements associated with the specifications. The following views are available:

QA Quality Spec Elements

QA Quality Specifications

Collection Plans

These views provide information about collection plans, transactions and triggers associated with the collection plans and collection plan elements, and action rules associated with the collection plans. The following views are available:

QA Collection Plan Smry

QA Collection Plan Trans

QA Plan Elem Action Rules

Quality Results

These views provide information about the results entered for collection plans. There are three types of views:

View for all collection plan results: The QA Collection Plan Rslts view displays the results collected for all the collection plans.

Views for results collected during transactions in Oracle Work in Process: The QA WIP Completion Trx Rslts and QA WIP Move Trx Rslts views display results collected during completion and move transactions respectively, occurring in the Oracle Work in Process module. These views are generated for only those roles that correspond to inventory organizations that are enabled for Work in Process.

Site-specific views: Two sets of views can be dynamically generated on the basis of the collection plans and collection plan types set up at your site. The views based on collection plans are named as QA Rslt <plan name>, where <plan name> represents the collection plan name at your site. The views based on collection plan types are named as QA Rslt PType <plan type>, where <plan type> represents the name of the collection plan type at your site.

The views pertaining to Work in Process transactions and site-specific views will return information for newly added collection plans and collection plan elements only after being regenerated. Contact your Noetix System Administration User for regenerating the views.

Support for Flexfields

The following tables list the flexfields in Oracle Quality and the corresponding Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle Quality

Descriptive flexfield

Noetix view

Collection Elements

QA Col Elem Action Rules

QA Collection Elements

Collection Plan Elements

QA Plan Elem Action Rules

Collection Plans

QA Collection Plan Smry

QA Collection Plan Trans

QA Plan Elem Action Rules

Specification Elements

QA Quality Spec Elements

Specifications

QA Quality Specifications

 

Key Flexfields Supported in NoetixViews for Oracle Quality

Key flexfield

Noetix view

Item Categories

QA Quality Specifications

Items

QA Quality Specifications

QA WIP Completion Trx Rslts

Noetix Roles for Quality

NoetixViews for Oracle Quality includes standard and Cross Operations Extension (XOP) roles. For your Oracle E-Business Suite setup, a set of standard views is generated for each inventory organization, while a set of XOP views is generated for each combination of a chart of accounts and an item master organization. You can use the views under any role that is assigned to you. Contact your Noetix System Administration User if you have any queries regarding the roles granted to you.

The QA Rslt <plan name> view will not be generated under XOP roles.

Noetix Views in Quality Workflow

The following diagram explains the process flow in Oracle Quality and the Noetix views that provide information at each point in the process flow.

NoetixViews for Oracle Cash Management

The Noetix business views and pre-built answers for Oracle Cash Management provide a reporting solution for the major aspects, such as transactions, reconciliation, and automatic clearing.

Additionally, you can analyze information about the bank accounts, invoice checks and payments, and transactions prior to reconciliation using the views for Oracle Payables and Oracle Receivables that are available as part of Cash Management. Two basic views and a value added view are available for Noetix views for Oracle Payables. Similarly, two basic views are available for Noetix views for Oracle Receivables. The five views are available in the standard, Cross Operations Extension (XOP), and global forms.

Support for Subject Areas

NoetixViews for Cash Management cater to the following subject areas:

Banks

Bank Statements

Cash Transfers

Cash Flow

Banks

The AP Bank Accounts view for the Banks subject area provides information about the bank accounts, bank branches, and contact details in bank branches. Though a part of NoetixViews for Oracle Payables, this view is also available through the CASH MANAGEMENT role.

Bank Statements

The CE Bank Stmt Line Dtls and CE Reconciliation Lines views for the Bank Statements subject area provide information about the reconciled transactions and their impact on the bank account during a period. Additionally, information about the reconciled statement lines is provided.

Though a part of NoetixViews for Oracle Payables, the AP Checks and AP Invoice Checks views are also available through the CASH MANAGEMENT role so that the transactions prior to reconciliation are available. For the same reason, the AR Cash Receipts and AR Cash Receipts Combined views have been made available through the CASH MANAGEMENT role even though these views belong to NoetixViews for Oracle Receivables.

Cash Transfers

The CE Cash Transfers view for the Cash Transfers subject area provides information about the cash transfers among banks within or across legal entities. The cash transfers can be intra-company or inter-company. For an intra-company cash transfer, the source and destination bank accounts must be in the same legal entity. For an inter-company cash transfer, the source and destination bank accounts can be in different legal entities.

Cash Flow

The CE Cash Flow Details view for the Cash Flow subject area provides information about cash flows, source bank, destination bank, and clearing details. The cash flow may happen because of the manual entry of bank account transfers or the Sweep Transactions Generation, Generate Cash Leveling Transfers, or Bank Statement Cashflow Creation program. The view appears only for Oracle E-Business Suite Release 12 and later.

Support for Flexfields

The following tables list the flexfields in Oracle Cash Management and the corresponding Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle Cash Management

Descriptive flexfield

Noetix views

Statement Headers

CE Bank Stmt Line Dtls

Statement Lines

CE Bank Stmt Line Dtls

Cash Transfers

CE Cash Transfers

Bank Account

AP Bank Accounts

Bank Branch

AP Bank Accounts

Payment Information

AP Checks, AP Invoice Checks

Invoice

AP Invoice Checks

Invoice Payments

AP Invoice Checks

Payment Documents

AP Invoice Checks

Vendor

AP Invoice Checks

Receipt Information

AR Cash Receipts, AR Cash Receipts Combined

Customer information OLD

AR Cash Receipts, AR Cash Receipts Combined

Party Information

AR Cash Receipts, AR Cash Receipts Combined

Payment Schedule Information

AR Cash Receipts, AR Cash Receipts Combined

Accounting Calendar: Periods

AR Cash Receipts, AR Cash Receipts Combined

Customer Credit Profile Information OLD

AR Cash Receipts, AR Cash Receipts Combined

 

Key Flexfields Supported in NoetixViews for Oracle Cash Management

Key flexfield

Noetix views

Accounting Flexfield

AR Cash Receipts AR Cash Receipts Combined

Noetix Roles for Cash Management

NoetixViews for Oracle Cash Management has only a global role. The global role contains a set of views generated for all the business groups configured in the Oracle E-Business Suite instance. Noetix Views for Cash Management includes the CASH MANAGEMENT role.

Noetix Views and Cash Management Workflow

The following diagram explains the process flow of Cash Management and the corresponding subject areas supported by Noetix views.

For more information about the Noetix supported subject areas and the views corresponding to each subject area, see Support for Subject Areas.

Tips and Other Considerations

The following points would help you optimally use the views for Cash Management:

Noetix views for Cash Management do not cover the cash forecasting and cash positioning concepts.

The bank accounts-related information is maintained at the operating unit level for Oracle E-Business Suite versions prior to Release 12 and at the legal entity level for Oracle E-Business Suite Release 12 and later.

NoetixViews for Oracle Project Management

The Noetix business views and pre-built answers for Oracle Project Management provide a reporting solution to manage a project based on a single, integrated, accurate view of all project-related activities. NoetixViews for Oracle Project Management helps to track and manage the various project activities, such as creating, planning, and tracking of project workplans, budgets, and forecasts throughout the project life cycle. The views belong to the basic, value added, or cross functional types and additionally are categorized as set-up views.

Support for Subject Areas

NoetixViews for Oracle Project Management cater to the following subject areas:

Workplan

Resource

Budget

Manage Progress

Manage Issues

Schedules

Forecast

Project Sets

Workplan

The PA Proj User Define Attrs, PA User Defined Attrs, and PA Deliverable Actions views for the Workplan subject area help to review deliverables, work breakdown structures and dependencies, assigned resources, and project progress.

Resource

The PA WP Resource Usages view for the Resource subject area provides workplan resource usages, assigned resources, and staff resource requirements for projects.

Budget

The PA All Expenditure Items, PA Financial Plan Impacts, and PA Financial Plan Tasks views for the Budget subject area provide financial breakdown structures; published workplans; and generated, adjusted, submitted, and approved budgets for projects. Though a part of NoetixViews for Oracle Projects, the PA All Expenditure Items view is also available through the PROJECT MANAGEMENT role.

Manage Progress

The PA Tasks, PA Projects, PA Project Status Reports, and PA Workplan Details views for the Manage Progress subject area provide progress against tasks and deliverables. Though a part of NoetixViews for Oracle Projects, the PA Tasks and PA Projects views are also available through the PROJECT MANAGEMENT role.

Manage Issues

The following views for the Manage Issues subject area are used to track issues and display changes in the issues:

PA Control Item Actions

PA Control Item Comments

PA Control Item Impacts

PA Control Item Relations

PA Control Items

PA Supplier Deductions

PA Supplier Impact Dtls

Schedules

The PA WP Resource Usages and PA Project Exceptions views for the Schedules subject area provide information about workplans, schedules, and team schedule updates.

Forecast

The following views for the Forecast subject area provide information about the generated, reviewed, submitted, approved, and republished forecasts:

PA Project Status Reports

PA Workplan Details

PA Project Exceptions

PA Financial Plan Tasks

Project Sets

The PA Project Sets view for the Project Sets subject area provides information about the projects that are associated with a project set.

Support for Flexfields

The following table lists the flexfields in Project Management and the corresponding Noetix views that support these flexfields.

Descriptive Flexfields Supported in NoetixViews for Oracle Project Management

 

Descriptive flexfield

Noetix views

Human Resources

PA Tasks

PA Projects

Control Items Desc Flex

PA Control Items

Expenditure Items

PA All Expenditure Items

Project Status Report Sections

PA Project Status Reports

Project Sets

PA Project Sets

Projects

PA Tasks

PA All Expenditure Items

PA Projects

PA Workplan Details

Project and Task

PA Proj User Define Attrs

UDA EXT TL

PA Proj User Define Attrs

Tasks

PA Tasks

PA All Expenditure Items

PA Financial Plan Tasks

PA Workplan Details

Planning Transactions

PA WP Resource Usages

Noetix Views in Project Management Workflow

The following diagram explains the process flow of Project Management and the corresponding subject areas supported by Noetix views.

For more information about the Noetix supported subject areas and the views corresponding to each subject area, see Support for Subject Areas.

Noetix Roles for Project Management

NoetixViews for Oracle Project Management includes the standard, Cross Operations Extension (XOP), and global roles. A standard role contains a set of views generated for each operating unit. For an XOP role, a set of views is generated corresponding to one or more operating units depending on the chart of accounts settings in your Oracle E-Business Suite instance. A global role contains a set of views generated for the business groups in your Oracle E-Business Suite instance. A user can access all the views corresponding to an assigned role. Contact your Noetix System Administration User if you have any queries regarding the roles granted to you.

NoetixViews for Oracle Project Management uses the PROJECT MANAGEMENT role.

Replacement Views for Release 12

This section provides information about the views available for Oracle E-Business Suite 11i and their replacements in Oracle E-Business Suite Release 12. The 11i views that are available in Release 12 have been made obsolete and returns historical data. Also, some of the views available for 11i do not have replacement views in Release 12 because of the functional changes made in Release 12. The 11i replacement views for Oracle Subledger Accounting are discussed in Other Cross-Functional Views for Subledger Accounting in “NoetixViews for Oracle Subledger Accounting.”

Noetix Views for Projects

The table provided in this section lists the 11i views for Oracle Projects and their replacements for Release 12. The details also cover information about the availability of the 11i view in Release 12.

View for Oracle E-Business Suite 11i

Available for Release 12

Replacement view for Release 12

Change description

PB Revenue Distributions

Yes

PA Rev Dist SLA GL JE

The legacy view has been made obsolete because it will return only historical accounting data for Release 12.

PA Organizations

Yes

PA Organization History

The legacy view has been made obsolete because of granularity-related changes and will be removed in a future release.

PA Project Workplan

Yes

PA Workplan Details

The legacy view has been made obsolete because of functional changes and standardization of the view.

Noetix Views for Process Manufacturing Inventory Management

The table provided in this section lists the 11i views for Oracle Process Manufacturing Inventory Management and their replacements in Release 12. The details also cover information about the availability of the 11i view in Release 12.

The 11i views listed in this section are applicable for only Oracle E-Business Suite 11.5.10.2. For Release 12 and later, the views have been made obsolete because Oracle Process Manufacturing Inventory Management has been merged into Oracle Inventory; therefore, the views return only historical data.

View for Oracle E-Business Suite 11i

Available for Release 12

Replacement view for Release 12

GMI Inv Stock Locators

Yes

INV Stock Locators

GMI Inv Transactions

Yes

INV Transaction Details

GMI Inv Unallocated Rollup

Yes

INV Unallocated Rollup

GMI Item Catalogs

Yes

INV Item Catalogs

GMI Item Master

Yes

INV Items and INV Item Inventory Attributes

GMI Lots Sublots

Yes

INV Lot Details

GMI Month End Inventory

Yes

INV Period Close Details

GMI Onhand Inv By Location

Yes

INV Onhand Quantities

GMI Onhand Inv By Lot

Yes

INV Item Onhand By Lot

GMI Onhand Inv Rollup

Yes

INV Onhand Rollup

GMI Unallocated Inventory

Yes

INV Unallocated Inventory

GMI Production Rules

Yes

Not available

GMI Warehouse Rules

Yes

Not available

GMI Warehouse Transfer

Yes

Not available

Noetix Views for Process Manufacturing Planning

This section provides information about the 11i views for Oracle Process Manufacturing Planning and their replacements in Release 12.

The 11i views listed in this section are applicable for only Oracle E-Business Suite 11.5.10.2. For Release 12 and later, the Process Manufacturing Planning functionality is not supported, and, therefore, the views have been made obsolete and return only historical data. For Release 12 and later, use Noetix views for Oracle Advanced Supply Chain Planning instead of Noetix views for Process Manufacturing Planning.

The following views for Process Manufacturing Planning return historical data in Release 12:

GMP Action Messages

GMP Forecast Details

GMP MRP Action Msg Pegging

GMP MRP Demand Supply Dtl

GMP MRP Mtrl Unbucketed

Noetix Views for Process Manufacturing Financials

This section provides information about the 11i views for Oracle Process Manufacturing Financials and their replacements in Release 12.

The GMF Cost Warehouse Assoc view for Process Manufacturing Financials is applicable for only Oracle
E-Business Suite 11.5.10.2. For Release 12 and later, the view has been made obsolete and returns only historical data. For Release 12 and later, use the GMF Cost Organization Assc view.

Noetix Views for Inventory

This section provides information about the 11i views for Inventory and their replacements in Release 12.

The INV Demands view for Inventory is available for only Oracle E-Business Suite 11.5.10.2. For Release 12 and later, use the INV Reservations view.

Noetix Views for U.S. Federal Financials

This section provides information about the 11i views for Oracle U.S. Federal Financials and their replacements in Release 12.

The 11i views listed in this section have been made obsolete for Release 12. The following views for U.S. Federal Financials return historical data in Release 12:

AR FV Trans Code Mappings

FV Enhanced Trans Events

FV Transaction Codes

Noetix Views for Human Resources

This section provides information about the legacy views for Oracle Human Resources and their replacements for Release 12.

The HR AP 1099 Vendors view for Human Resources is available for only Oracle E-Business Suite 11.5.10.2. For Release 12 and later, use the HR AP 1099 Payments view.

Noetix Views for Enterprise Asset Management

This section provides information about the legacy views for Oracle Enterprise Asset Management and their replacements in Release 12.

The EAM WO Cost Details view for Enterprise Asset Management is applicable for only Oracle E-Business Suite 11.5.10.2. The view has been made obsolete in Release 12, and, therefore, it will return incorrect information for Release 12. For Release 12 and later, the functionality is provided through the EAM WO Actual Cost Details, EAM WO Estimated Cost Dtls, and EAM WO Oprn Cost Summary views.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk