Tuesday, January 8, 2013

Oracle Business Intelligence Applications Version 7.9.6.4 Released

A new release of the Oracle Business Intelligence Applications has been announced.   Version 7.9.6.4 is generally available from Oracle Technology Network (OTN).


Oracle Business Intelligence Applications 7.9.6.4 Documentation

7.9.6.4 Release Notes

Some key points from the release notes:

  • The minimum version of Oracle Business Intelligence Enterprise Edition required to run the Oracle BI Applications Installer is 11.1.1.6.4.   The installer does not check the version during the install and will not generate a BI Apps RPD file if the platform version is lower than 11.1.1.6.4.
  • 1.3.13 Revenue Ago Metrics Using GL_Accounting_Period_WID Not Supported by
    PSFT in Oracle Project Analytics
        This issue applies to Releases 7.9.6.3 and 7.9.6.4.
    PeopleSoft does not support Revenue Ago Metrics Using GL_Accounting_Period_
    WID.  Workaround: To use the metrics available in table "Ago Measures" from the Subject Area "Project Revenue", you must remove the foreign key joins on Period from these facts in the
    repository (RPD). The server then uses the Date foreign keys, resolving the problem.
  • 1.3.15 Writeoff LOC Amounts and Exchange Rates Incorrect in Oracle Project Analytics
    This issue applies to Releases 7.9.6.3 and 7.9.6.4.  The data sourced from PeopleSoft for the W_PROJ_RETENTION_F table shows incorrect data for Project Retention write off amounts if the transaction currency code is different from the GL currency code. Workaround: There is no workaround for this issue.
  • 1.3.36 Recruitment Metric "Time to Fill (Days)" Has Incorrect Denominator
    This issue applies to Release 7.9.6.3 only.
    The recruitment metric 'Time To Fill (Days)' calculates the number of days lapsed
    between when a requisition is opened and when it is closed. The formula is calculated
    as follows:
    sum(W_RCRTMNT_EVENT_F.RQSTN_OPEN_TO_RQSTN_CLOSE_DAYS) / nullif(count(distinct W_
    RCRTMNT_EVENT_F.JOB_RQSTN_WID), 0)
    The denominator should be Closed Requisitions not All Requisitions.
    Workaround
    The workaround for this issue is to apply the following change to the Oracle BI
    Enterprise Edition repository file (OracleBIAnalyticsApps.rpd):
    1. Backup the existing repository file.
    2. In the repository file, identify the logical fact table 'Fact - HR - Recruitment Event
    Information'.
    3. Locate the logical column 'Time To Fill (Days)'.
    4. Double-click the logical column and change the expression, as follows:
    From:
    Core."Fact - HR - Recruitment Event Information"."Time To Fill (Days) -
    Internal" / Core."Fact - HR - Recruitment Event Information"."Job Requisitions
    Count"
    To:
    Core."Fact - HR - Recruitment Event Information"."Time To Fill (Days) -
    Internal" / Core."Fact - HR - Recruitment Event Information"."Job Requisitions
    Closed"
  • 1.3.58 CURRENT_DAY Variable Defaults To A Static Value Instead of a Dynamic Value
    This issue only applies to Release 7.9.6.3.
    Dashboards that use the metadata repository variable CURRENT_DAY are showing
    invalid data because this variable is defaulted incorrectly to the static value 4-14-2011.
    Workaround
    1. Use BI Administration Tool to edit the BI metadata repository.
    2. Configure the value of the CURRENT_DAY variable to have the Default Initializer
    set to VALUEOF("LAST_REFRESH_DT").
    This can done by double clicking the CURRENT_DAY repository variable under
    the option Manage, then Variables, then Static.



3 comments:

  1. Wonderful post! I think the actual effective office manager is excellent in determining their employees' advantages as well as applauding all of them each and every occasionally.
    employee engagement

    ReplyDelete
  2. Awesome information. I am really surprised with this topic. Keep up the good work and post more here to read. 
    HR analytics

    ReplyDelete
  3. The post is written in very a good manner and it entails many useful information for me. I appreciated what you have done here. I am always searching for informative information like this. Thanks for sharing with us
    HR analytics and intelligence

    ReplyDelete