Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Murali Gangidi
    Subject Area in Account Paybles to get information for OTBI...
    Topic posted January 8, 2019 by Murali GangidiBronze Medal: 1,250+ Points, tagged BI Publisher, OTBI, Sample Reports, Tip 
    85 Views, 4 Comments
    Title:
    Subject Area in Account Paybles to get information for OTBI from AP_PAYMENT_TEMPLATES table
    Summary:
    Subject Area in Account Paybles to get information for OTBI from AP_PAYMENT_TEMPLATES table
    Content:

    Hi All,

    I need to pull the Template Name and Template Description from  AP_PAYMENT_TEMPLATES table in OTBI Reports. Does anyone know which subject area/dimension/column stores this info.

     Any Ideas or Oracle notes will be helpful to identify this.

    Comment

     

    • Murali Gangidi

      AP_PAYMENT_TEMPLATES

      The AP_PAYMENT_TEMPLATES table contains the user defined Payment Process Request Templates. The Templates can be used to default the Invoice Selection Critera in AP_INV_SELECTION_CRITERIA_ALL. This table corresponds to the Create Payment Request Template page.

      Details

      • Schema: FUSION

      • Object owner: AP

      • Object type: TABLE

      • Tablespace: APPS_TS_TX_DATA

      Primary Key

      Name Columns
      AP_PAYMENT_TEMPLATES_PK TEMPLATE_ID

      Columns

      Name Database Length Precision Not Null Comments Flexfield Mapping
      TEMPLATE_ID NUMBER   18 Yes System generated primary key for payment template.  
      TEMPLATE_NAME VARCHAR2 175   Yes Payment Process Request Template Name  
      TEMPLATE_TYPE VARCHAR2 30     Payment Process Request Template Type. Values, from the lookup PAYMENT_TEMPLATE_TYPE  
      DESCRIPTION VARCHAR2 240     Payment Process Request Template Description
    • Veronica Dumitriu

      Hi Murali,

      What is the use case and the business functionality that you are trying to achieve in OTBI?

      If you check the Financials lineage documentation, you could search for a table name and get all the subject areas that are sourced from the respective table.Currently we do not expose this table in the presentation layer on OTBI. If there is a business need for this, please log an SR and ER for it.

      thanks,

      Veronica