Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Comments

  • Alexey Shtrakhov

    Sorry!!! My fault! Now I saw that Annex doc!

    Thanks!!!

  • Alexey Shtrakhov

    Still missing this Drill-Down information in this document.

    Alexey

  • Wendy Ware

    Perhaps I'm missing something, but I was unable to find the employee default expense account in subject areas.  I use the following SQL to report on that.  Wendy

     

    select

    pu.USERNAME,

    GL.SEGMENT1||'.'||GL.SEGMENT2||'.'||GL.SEGMENT3||'.'||GL.SEGMENT4||'.'||GL.SEGMENT5||'.'||GL.SEGMENT6||'.'||GL.SEGMENT7||'.'||GL.SEGMENT8||'.'||GL.SEGMENT9||'.'||GL.SEGMENT10 "DEFAULT EXPENSE"

    ,paex.EXPENSE_CHECK_ADDRESS "CHECK ADDRESS"

    from

    per_users pu

    join per_employees_x paex on pu.person_id = paex.person_id

    LEFT join GL_CODE_COMBINATIONS GL on GL.CODE_COMBINATION_ID = paex.DEFAULT_CODE_COMB_ID

     

     

  • Samantha Rawson

    We have had an OTBI report developed to take account of those invoices that are not accounted as nothing standard deals with this scenario.  We look at the hold status of the invoices to exclude from the GRNI calculation

    To tie to liability we also have the GRNI stated in ledger currency

  • Chris Pinto

    I completely agree with Marybeth here. A direct link should be available within customer connect itself. I had found the report sharing center via google using the following keywords "ERP report sharing center customer connect".

  • MShrini

    Hi Nidhi,

     

    You can you use the below subject are to fetch the employee default account with cost center and other details.

     

    Expenses Subject Areas, Folders, and Attributes: Explained

     

    Best Regards

    MSrini.

  • Marybeth Snodgrass

    You should add this to the idea lab. Seems that oracle is more responsive to enhancement requests on those forums.

  • Marybeth Snodgrass

    I think the report sharing center for ERP is barely being utilized because there is no direct link where one should be. The HCM one is easy to find, but even after searching  customer connect site, followed up by multiple google searches, the only place I was able to find a link to navigate to ERP report sharing center is in this post.. Because no direct link, there has not been any posts in 2+ years. Furthermore, there are only 5 posts in ERP vs. the 243 in HCM.

     

     

  • Senthilrajan Vaithianathan

    Oracle has created a ER for this request,

    Bug 29939043 : COMPREHENSIVE REPORTING ROLE IN SAAS

  • Rinku Gautam

    Hi Shakher,

     

    My requirement is suppose We have a user A and it is tied to US Business Unit.

    We have given "BI Publisher Data Model Developer" Role so that the user can create and edit data model.

    Now, this user should be restricted to data, related to US Business unit only when he attempts to create data model.

    The user should not be able to access non-US Business entities data even from oracle base tables in Data Model.

    Since standard roles are not available to achieve above, To implement solution for above, I am thinking to create database per business unit data.

    Once we create new data source, that gets reflect in the "Data Source" field of data Model for SQL Script.

     

    Pls let me know if there are any other workaround to achieve above.

     

    Thanks,

    Rinku

     

  • Senthilrajan Vaithianathan

    Hi,

    While SR is the proper solution for restoration, you can create a new 'Custom' Folder under 'Shared' Folder location and try one of the option below if that works for you...

    • If you haven't started any development inside custom folder, you can just start creating subfolders and reports inside the same.
    • If you have a backup of the Custom Folder, you can just restore it inside the newly created 'Custom' folder
    • If you don't have a backup then you may need to work with Oracle through a SR for restoration.

     

     

  • Sudhakara Rao Kovuru

    Hi Madhu,

    Please try below tables

    -- Bank Details
    IBY_EXTERNAL_PAYEES_ALL_ 
    IBY_EXT_BANK_ACCOUNTS_
    IBY_EXT_PARTY_PMT_MTHDS_

    --Supplier Details
    POZ_SUPPLIERS_ 
    POZ_SUPPLIER_SITES_ALL_M_

    Thanks,

    -Sudha.

  • Madhu G

    Hi,

    After research and your suggestions I have done below Mapping, But still unable to find for few. Could you please help on the mapping.

    POZ_SUPPLIERS_PII_ --
    Supplier Name                 : Not Found
    Supplier Alternate Name  : Not Found
    Tax Registration Number  : Not Found
    Taxpayer ID (for 1099)       : POZ_SUPPLIERS_PII_ -----> Income_tax_id

    POZ_SUPPLIER_SITES_ALL_M_ 
    Address Details   : Not Found
    Pay Group =    POZ_SUPPLIER_SITES_ALL_M_  -------->Pay_Group_lookup_code
    Payment Terms = POZ_SUPPLIER_SITES_ALL_M_-------->terms_id

    Bank Name  : Not Found

    Bank Branch Number: Not Found

    Bank Account Number: Not Found

    IBAN Number: Not Found

    Please help if possible, we are specifically looking for the audit table where we can see the Column which changed and updated_by as well for the above fields in Suppliers.

     

    Thanks,

    Madhu

  • Senthilrajan Vaithianathan

    We have created a SR with Oracle and the support engineer is checking with the Product team, I think this might end up with an Enhancement Request.

    -Senthil

  • Sudhakara Rao Kovuru

    Hi Madhu G,

    Yes we can do for single job by making false of Allow multiple pending submissions option but not for job sets.

    Please go through the below note and let me know if you have any questions?

    ESS Jobs: Setting Self Incompatibility for Custom Jobs and JobSets for Cloud Users (Doc ID 2304614.1)

    Thanks,

    -Sudha