Posts

Posts

  • Ramesh Radhakrishnan
    "Update Supplier Keyword Search Index and Source to...2
    Topic posted June 9, 2019 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged Public Sector, Sourcing Programs in Procurement > Supplier Management public
    Title:
    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes and Errors
    Content:

    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes  and Errors and it is not generating any error log. Any pointers about this program how to troubleshoot this program. Also I see below note relevant to this program

    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes (Doc ID 2474423.1)

     

    Version:
    R13-19B
  • Alex Montroy
    19A - OM Process Sales Orders for Projects1
    Topic posted March 19, 2019 by Alex Montroy, tagged Order Management, Order Management Analytics, Public Sector, SCM in Order Management > Order Management public
    Title:
    19A - OM Process Sales Orders for Projects
    Summary:
    Processing Sales orders for Projects question.
    Content:

    Hello,

     

    In the recent 19A update, Oracle have introduced the ability to process sales orders for Projects. The functionality allows you to enter project charging details on/each individual line basis.

    Whilst I have discussed this with support and product design, it doesn't appear that automating the functionality is yet available - or at least speeding it up.

    So for my organisation, we a projects facing delivery organisation where there are 1000's of projects. Majority (so hundreds) of which will need items from Inventory, over the life cycles each months for different volumes. Some Projects may need one item in a month - others need 300 items in a month.

     

    This enhancement would be ideal to adopt but what concerns me is the volume of manual work that is needed. Effectively, adding the project charging details on a line by line basis would not work for us.

     

    Oracle support have suggested an Order Management Extension which could achieve the same outcome?

    Extract from Support:

    Currently there is no defaulting supported for defaulting of the project related attributes while entering it from

    the UI. Are all of the 50 lines on the order expected to be against the same project and carry the same values for all the project information? If so, they can consider entering the project on one of the line and then writing an order management extension to copy the project information from one of the line to rest of the lines assuming it has the same project information for all of the lines.

     

    Has any other users of OM who rely heavily on Project charging having the same issue? How are other organisations charging transactions back to projects on a large volume scale?

     

    Thanks,

    Alex

     

  • Elizabeth Hurley
    19D Cannot Dismiss Notifications145.0
    Topic posted November 21, 2019 by Elizabeth HurleyRed Ribbon: 250+ Points, tagged Approvals/Notification, Public Sector in Procurement > Self Service Procurement public
    Title:
    19D Cannot Dismiss Notifications
    Summary:
    Delete option [X] not displayed on hover over notifications
    Content:

    Users can no longer dismiss notifications.  When hovering over the notification in the Pending Notifications list (accessed from the Bell icon), the [X] (delete option) does not appear.  The users have noted the long list of notifications but do not have the same way to clear them.  Any FYI notifications from before the 19D patch was applied do have the [X] option and any notifications from Monday and later (post-19D) do not.

    Has this feature been modified?

     

    Thank you.

    Version:
    19D
  • Kamran Butt
    Access for General Ledger DashboardsAnswered4
    Topic posted September 23, 2019 by Kamran ButtRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports in Reporting and Analytics for ERP public
    Title:
    Access for General Ledger Dashboards
    Summary:
    Cannot view data for seeded GL Analytics Dashboards
    Content:

    Hello,

    What security role do I need to access the General Ledger Dashboards: Account Analysis, General Journals, Trial Balance, etc?

    At the moment, I am a super-user, I can see and edit all the objects, but I see no data in any of the reports.

    These are the reports I am trying to access: https://docs.oracle.com/cd/E51367_01/financialsop_gs/OCUAR/F1550150AN11FF9.htm#F716749AN122F4. The BI Publisher reports work without any issues, but the Analytics reports do not show any data.

    Any thoughts would be appreciated.

    Thanks!

    Version:
    Oracle Cloud 19C (11.13.19.07.0)
    Image:
  • Tausif Mulla
    Account value description in multi language25.0
    Topic posted January 28, 2019 by Tausif MullaBronze Medal: 1,250+ Points, tagged Accounting Hub Cloud Service, Assets, Budgetary control, Cash Management, Collections, Compliance, Configuration, Discussion Forums, Expenses, Financials, Fusion, General Ledger, Help Center, Intercompany, Invoice Imaging, OTBI, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Security, Setup, Setup / Administration, Subledger Accounting in Core Financials > Financials – General public
    Title:
    Account value description in multi language
    Summary:
    Account value description in multi language
    Content:

    Hi,

    We have a requirement for a global project that the value set values (Descriptions) we have in "English" should be in multi language depending upon the user location. 

    For example, during configuration we will update all the description in "English" for value set values, however when a china user logins, he / she should be able to see the value description in Mandarian language. Similarly for other users across the globe.

    Please suggest if this is achievable in oracle cloud ERP.

    Thanks !

  • Lak
    Add Account Parmeter to Custom BI Puslisher Report1
    Topic posted December 10, 2018 by LakRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Add Account Parmeter to Custom BI Puslisher Report
    Content:

    Hi Friends,

    I want to add account form and account to parameters to custom bi publisher report. I tried using add flex field process but unable to create parameter. Could you please let me know the process for adding account(GL_CODE_COMBINATIONS - SEGMENT1to7) parameter to custom BI Publisher report.

    Appreciated your quick help..!

    Thanks

    Lak

    Version:
    ORACLE CLOUD ERP R13
  • MShrini
    After R12 upgrade BIP and OTBI reports are not defaulted to...Answered25.0
    Topic posted November 3, 2017 by MShriniBronze Crown: 15,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
    Summary:
    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
    Content:

    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role but user were accessed in R11.  Please help  us with solution if you are faced the same in R12 upgrade.

  • MShrini
    After R12 upgrade BIP and OTBI reports are not defaulted to...2
    Topic posted November 3, 2017 by MShriniBronze Crown: 15,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary control, Cash Management, Collections, Compliance, Configuration, Core HR, Expenses, Financials, General Ledger, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Sample Reports, Security, Setup / Administration, Subledger Accounting, Update, User Interface in Integrations and Extensions public
    Title:
    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
    Summary:
    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
    Content:

    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role but user were accessed in R11.  Please help  us with solution if you are faced the same in R12 upgrade.

  • Andy Cleary
    AIP Invoice Image - matching multiple invoice lines to...Answered7
    Topic posted July 12, 2019 by Andy ClearyBlue Ribbon: 750+ Points, tagged Payables, Public Sector, Tip in Core Financials > Payables & Cash Management public
    Title:
    AIP Invoice Image - matching multiple invoice lines to single line PO
    Summary:
    Issue where multiple invoice lines are partially read from invoice but not matched to single line PO
    Content:

    Hi

    We're using the AIP invoice imaging cloud solution.  We create a lot of blanket/open/draw-down POs which have a single value line intended to cover multiple invoices and receipts for a period of time. These are particularly used by our department running catering/food vendoring outlets.

    We have an issue where the PO number is read succesfully on the invoice and multiple line invoices are read and multiple invoice lines then created but fail to be matched to the single PO line available leaving the lines partially entered and the invoice as 'Incomplete' status.  So the AP team have to manually match all the invoice lines against the single PO line.  If there is only one PO line why don't all OCR read invoice lines get matched against it by default? Some multiple invoices do match to a single PO line succesfully but the majority do not. 

    Is anyone else experiencing this issue and have you found any configuration setting for invoice imaging or workarounds that assisted first time invoice matching?

    Many thanks
    Andy Cleary

     

     

     

     

     

     

    Version:
    19B
  • Janusz Jasinski
    Amending SQL slightly brings me: ORA-01427: single-row...35.0
    Topic posted October 30, 2019 by Janusz JasinskiSilver Crown: 22,500+ Points, tagged BI Publisher, Public Sector, Reports in Reporting and Analytics for ERP public
    Title:
    Amending SQL slightly brings me: ORA-01427: single-row subquery returns more than one row
    Summary:
    ORA-01427
    Content:

    I am using Oracle Fusion, the finance/payables reporting side of things

    I have the following code:

        SELECT DISTINCT PHA.SEGMENT1 
        FROM 
            AP_INVOICES_ALL AIA, -- https://docs.oracle.com/en/cloud/saas/financials/19a/oedmf/AP_INVOICES_ALL-tbl.html
            PO_HEADERS_ALL PHA -- https://docs.oracle.com/applications/farel12/procurementop_gs/OEDMP/PO_HEADERS_ALL_tbl.htm
        WHERE
            AIA.PO_HEADER_ID = PHA.PO_HEADER_ID 
            AND AIA.PO_HEADER_ID IS NOT NULL 
            AND AIA.INVOICE_NUM = XTE.TRANSACTION_NUMBER 
            AND AIA.INVOICE_ID = XTE.SOURCE_ID_INT_1

    This "works" in that it returns no errors. However it's looking at the wrong table so wrong data is being brought back. No biggie, we have identified which table it is.

    It's used in a wider context as below to define a column value

        ( 
                CASE
                  WHEN
                    GJH.JE_SOURCE IN 
                    (
                      'Purchasing', 'Payables'
                    )
                  THEN
        ( 
                    SELECT DISTINCT
                      PHA.SEGMENT1 
                    FROM
                      AP_INVOICES_ALL AIA, PO_HEADERS_ALL PHA 
                    WHERE
                      AIA.PO_HEADER_ID = PHA.PO_HEADER_ID 
                      AND AIA.PO_HEADER_ID IS NOT NULL 
                      AND AIA.INVOICE_NUM = XTE.TRANSACTION_NUMBER 
                      AND AIA.INVOICE_ID = XTE.SOURCE_ID_INT_1
        
                      ) 
                    WHEN
                      GJH.JE_SOURCE IN 
                      (
                        'Receipt Accounting'
                      )
                    THEN
        ( 
                      SELECT
                        CPOD.PO_NUMBER 
                      FROM
                        --cmr_transactions ct
                        CMR_PURCHASE_ORDER_DTLS CPOD , CMR_RCV_EVENTS CRE , POZ_SUPPLIERS_V PS 
                      WHERE
                        CRE.CMR_PO_DISTRIBUTION_ID = CPOD.CMR_PO_DISTRIBUTION_ID 
                        AND CPOD.VENDOR_ID = PS.VENDOR_ID 
                        AND CPOD.ACTIVE_FLAG = 'Y' 
                        AND CRE.ACCOUNTING_EVENT_ID = XTE.SOURCE_ID_INT_1 ) 
                      ELSE
                        NULL 
                END
        ) AS PURCHORDERNUM,

    However I need to amend the SQL to be the following:

        SELECT DISTINCT PHA.SEGMENT1 
        FROM
            AP_INVOICE_LINES_ALL AIA, -- https://docs.oracle.com/en/cloud/saas/financials/19a/oedmf/AP_INVOICE_LINES_ALL-tbl.html
            PO_HEADERS_ALL PHA 
        WHERE
            AIA.PO_HEADER_ID = PHA.PO_HEADER_ID 
            AND AIA.PO_HEADER_ID IS NOT NULL 
            --AND AIA.INVOICE_NUM = XTE.TRANSACTION_NUMBER 
            AND AIA.INVOICE_ID = XTE.SOURCE_ID_INT_1

    This now brings me back `ORA-01427: single-row subquery returns more than one row` but I can not see why. I am merely changing the table it is looking at *and* using DISTINCT