How to check table level data from descriptive flexfield

Posted on 2008-11-19
Last Modified: 2013-12-19
I need to find out what data is being entered into a descriptive flexfield by users.  The form is in Oracle Receivables and can be navigated to by:  Receivables User > Transactions > Transactions >Credit (tab)

The field that I want to query is "Cust Reference" but I'm struggling to find the descriptive flexfield that it relates to and therefore the table and column...

Any help would be massively appreciated!!
Question by:gflmartins
    LVL 2

    Expert Comment

    Do you know the name of Descriptive Flex Field?
    LVL 2

    Accepted Solution

    Navigate to your form
    then Help > Diagnostics > Examine...
    in "Block" enter $DESCRIPTIVE_FLEXFIELD$
    in "Field" you can see list of all Descriptive Flexfields in form
    Then you choose particular flexfield, in "Value" you can see the name of Descriptive Flexfield.
    Using this name find Descriptive Flexfield in form "Descriptive Flexfield Segments" (Application Developer Responsibility)
    Then you can find which segment is using which column in database.
    Then you Compile Descriptive Flexfield (button "Compile") it shows the name of View, which you can use to query data for this Descriptive Flexfield.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now