Posts

Posts

  • Pramod Dhiman
    Maintenance Calendar for 24 X 7 is throwing error ZMM-495085
    Topic posted 6:14 AM by Pramod DhimanGreen Ribbon: 100+ Points, tagged Public Sector in Manufacturing & Maintenance > Maintenance public
    Title:
    Maintenance Calendar for 24 X 7 is throwing error ZMM-495085
    Summary:
    Maintenance Calendar for 24 X 7 is throwing error ZMM-495085
    Content:

    i need to create a maintenance calendar for 24 X 7.

    i started with "create time shift" option.

    Shift start time is 8:00 AM and duration 8 hrs.

    i am giving Flexible shift start time 8 am duration 8 hrs, flexible shift end time 12 am duration  8 hrs.

    But still i am getting error message  

     
    The start time of the first shift detail must be equal to the start time of the shift. (ZMM-495085)

    I find no description on oracle support portal for ZMM-495085

     

  • Dev Thota
    PO Accrual Report - Requester Name Issue.25.0
    Topic posted Yesterday by Dev ThotaGold Trophy: 10,000+ Points, tagged OTBI, Public Sector, Tip, White Paper in Inventory and Logistics > Costing public
    Title:
    PO Accrual Report - Requester Name Issue.
    Summary:
    PO Accrual Report - Requester Name Issue.
    Content:

    Hi All,

    When I inactivate terminated users in Oracle, this report is removing their name on requisitions even though the PO requester is still that user

    Thanks,

    Dev Thota.

    Version:
    19D
  • Dennis Oliver
    Mass Update Project Manager3
    Topic posted Yesterday by Dennis Oliver, tagged Project Costing, Public Sector in Project Management public
    Title:
    Mass Update Project Manager
    Summary:
    I need to update project manager on hundreds of projects, can the project import spreadsheet be used for this?
    Content:

    I need to update project manager on hundreds of projects as the project manager assigned to the project has left the business, can the project import spreadsheet be used for this or is it just used to create new projects?

    Version:
    19D
  • Sarah Munro
    How can I find all reports using the same BI Publisher Data...2
    Topic posted November 14, 2019 by Sarah MunroRed Ribbon: 250+ Points, tagged BI Publisher, BI Publisher Data Models, Public Sector in General OBIEE public
    Title:
    How can I find all reports using the same BI Publisher Data Model
    Summary:
    I need to be able to identify all the reports that are using a Data Model before I make changes to the DM.
    Content:

    Bi Publisher Data Model has been created, I now need to know all the reports that are using this DM. Is this possible?

    Version:
    Oracle BI EE 11.1.1.9.0
  • Irina Feldesh, CPA, CGA
    Budget Transfers and Forecast Adjustment Entries65.0
    Topic last edited November 13, 2019 by Irina Feldesh, CPA, CGASilver Trophy: 7,500+ Points, tagged Financial Planning, Integration, Public Sector, Reports in Enterprise Performance Mgmt > Planning public
    Title:
    Budget Transfers and Forecast Adjustment Entries
    Summary:
    Best practices for budget transfers and forecast adjustments for clients with EPBCS/PBCS (Cloud) and PeopleSoft On-Premise Application
    Content:

    We are currently using custom built forms and business rules (CONSOL, PROJECT, and POSITION BSO cubes) to process revised budget transfers and quarterly forecast adjustments within the EPBCS application and then write back that data to our PeopleSoft On-Premise Application via a staging table that generates general journals during the nightly batch into the BUDGETS ledger.

    Our biggest challenge with this setup is dealing with multiple transactions to the same scenario in a particular year/period/version since only dimensions (our chartfields, i.e. department, account, fund, program, project, position, employee) are relevant as part of the unique combination in EPBCS (i.e. the cloud application does not appear to have been designed to handle journal line transaction detail).

    Our workaround for this was to setup scenarios suffixed by a number (i.e. RBGT_PTC_DBT_01, RBGT_PTC_DBT_02, etc.), but since the scenario dimension has a maximum of 75 members, this is not a sustainable practice as in some cases we start to get pretty close to running out of scenarios.

    We would like to get some ideas from other users as to how you are handling budget transfers (i.e. do you post these transactions in EPBCS / PBCS, how do you have the system configured to handle multiple journals to the same chartfield combination in a particular year/period, etc.).

    Any information you can provide to help us improve our existing process would be greatly appreciated.

    Thanks,
    Irina Feldesh

    Version:
    EPBCS 19.06.82 & PeopleSoft 9.2 FSCM PUM 19, HCM PUM 25, PeopleTools 8.56.06
  • Irina Feldesh, CPA, CGA
    Smart View “No Data / Missing” Option Suppressing ZeroesAnswered95.0
    Topic last edited November 13, 2019 by Irina Feldesh, CPA, CGASilver Trophy: 7,500+ Points, tagged Planning, Public Sector, Reports, SmartView in Enterprise Performance Mgmt > Planning public
    Title:
    Smart View “No Data / Missing” Option Suppressing Zeroes
    Summary:
    The latest Windows version of Smart View incorrectly suppresses zeroes when “No Data / Missing” suppression is selected in the Smart View Data Options
    Content:

    It appears that as of the May 2019 update (Version 11.1.2.5.900 Build 093), users can no longer leverage the “No Data / Missing” suppression options, instead they must use the “Suppress Missing Blocks” option when running Ad Hoc Analysis reports via the Smart View for Office Add-In (Microsoft Excel for Office 365 MSO, 64-bit) in order to suppress rows or columns that do not have data while retaining any rows or columns that have a zero value.

    Has anyone else noticed this odd behaviour? If so, have you filed an SR with Oracle reporting the bug?

    Regards,
    Irina

    Version:
    EPBCS 19.09.72, Oracle Smart View for Office 11.1.2.5.900 (Build 093), Microsoft Excel for Office 365 MSO (16.0.10730.20344) 64-bit or Excel 2016 64-bit, Windows 10 Education 64-bit
    Image:
  • Dev Thota
    How to create a OSP PO with 3 lines in a single purchase...1
    Topic posted November 5, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Electronic Records and Signatures, Manufacturing MDM, Manufacturing Analytics, OTBI, Production Execution, Production Scheduling, Public Sector, Tip, White Paper, Work Execution, Work Request Management in Manufacturing & Maintenance > Manufacturing public
    Title:
    How to create a OSP PO with 3 lines in a single purchase order
    Summary:
    How to create a OSP PO with 3 lines in a single purchase order
    Content:

    While doing the manufacturing implementation our business needs to have a multiple lines in a single OSP purchase order. Can you please suggest us how to achieve it?. It is fine even if it is possible with single/multiple supplier operations.

    Version:
    19C
  • Srikanth
    UOM mismatch and quantity discrepancy between initial search...Answered104.5
    Topic last edited July 25, 2019 by AshokBlack Diamond: 60,000+ Points, tagged Create Requisition, Internal Material Transfer, Public Sector in Procurement > Self Service Procurement public
    Title:
    UOM mismatch and quantity discrepancy between initial search and review cart screens - in scenario Fulfill Expense Requisitions for Agreement Based Catalog Items From Internal Sources
    Summary:
    UOM mismatch and quantity discrepancy between initial search and review cart screens - in scenario Fulfill Expense Requisitions for Agreement Based Catalog Items From Internal
    Content:

     

    1. Consider below scenario for Fulfill Expense Requisitions for Agreement Based Catalog Items From Internal Sources:

    Quantity = 1

    Item purchasing UOM: Bag of 1000 (with 1000 Each as UOM conversion)

    Item issue UOM: Each

    2. Search for item in self service procurement

    3. Purchasing UOM appears for item with quantity = 1 (i.e. Bag of 1000)

    4. Add item to cart

    5.  Review cart. UOM changes to issuing UOM (but quantity remains one). Summary: Quantity value remains same but UOM changes at this step

    6. Initial quantity = 1000 Each (considering UOM conversion)

    7. Quantity during cart review = 1 Each 

    8. Summary: UOM mismatch and quantity discrepancy between initial search and review cart screens

     

    9. Why bug? When user search, the quantity that appears is different from the quantity that appears when the user reviews the cart. This leads to operational impact (sufficient quantity not available) or excess inventory holding cost (excess inventory) if the users consider initial quantity as source of truth

    10. Suggested solution: For this scenario of internal intra-organization transfer for destination type expense, upon search with the given item, the initial search screen should return the issuing uom directly (instead of the purchasing uom). 

    If item is not internal transfer enabled in the given deliver-to location, then the purchasing UOM needs to come in the initial search screen.

    11. Conclusion: Kindly request to resolve this bug in 19D

    With 15000 users having self service procurement, such kind of discrepancies lead a lot of operational and financial issues.  The impact is also documented above

  • Dev Thota
    How to use manufacturing to create a PO with variable cost...1
    Topic posted November 5, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Electronic Records and Signatures, Manufacturing MDM, Manufacturing Analytics, OTBI, Production Execution, Production Scheduling, Public Sector, Tip, White Paper, Work Execution, Work Request Management in Manufacturing & Maintenance > Manufacturing public
    Title:
    How to use manufacturing to create a PO with variable cost for same work order quantity
    Summary:
    How to use manufacturing to create a PO with variable cost for same work order quantity
    Content:

    We are implementing fusion manufacturing and our business needs to have a variable amount PO with same work order quantity as shown in the attached screen shot. The RM cost will vary from one work order to another work order, is there any feature available to achieve this.

    Version:
    19C/19D
    Image:
  • Dev Thota
    How to establish relation between OSP PO quantity and WO...1
    Topic posted November 6, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Electronic Records and Signatures, Manufacturing MDM, Manufacturing Analytics, OTBI, Production Execution, Production Scheduling, Public Sector, Tip, White Paper, Work Execution, Work Request Management in Manufacturing & Maintenance > Manufacturing public
    Title:
    How to establish relation between OSP PO quantity and WO quantity
    Summary:
    How to establish relation between OSP PO quantity and WO quantity
    Content:

    Hi,

    Currently when we are creating the work order for quantity 1 it is creating a PO for quantity 1 but our business needs some linear relation like if WO qty is 1 PO is 5, if WO qty is 2 PO is 10 like multiple of numbers. Can any one suggest on this?

    Version:
    19C/19D