How To Get Segment Description In Oracle Apps
A contextsensitive segment is a segment that may or may not appear depending upon what other information is present in your form. Number of the Segment 3.
Chart of Account id 2.
How to get segment description in oracle apps. You can use the following query to get the description of COA of Oracle EBS by using appsgl_flexfields_pkgget_description_sql and avoid hideous number of joins back to FND_FLEX_VALUES_TL and generally hard-code in value set ids. Chart of Accounts Segment Descriptions in Oracle eBS. Do not use special characters such as - or in your prompts.
Oracle apps technical and functional. From the new logical table Dim - GL SegmentXX drag the Segment Code Segment Name Segment Description Segment Code Id and Segment Value Set Code attributes to the Detail GL Segment level of the hierarchy. -Query to Get Segment Value and Description of Each segment.
This query can be used to find out all the DFF Segments defined for a specific table. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access Live Meeting Support to Clear your Queries. But Oracle has provided a package which will help to get the description easily.
----- 1 Below given query can be used TO get concatenated Gl code combinations segment AND its description USING API GL_FLEXFIELDS_PKGget_concat_description -----SELECT gccCODE_COMBINATION_ID gccCONCATENATED_SEGMENTS APPSGL_FLEXFIELDS_PKGget_concat_descriptiongccchart_of_accounts_id gcccode_combination_id acc_description FROM gl_code_combinations_kfv gcc. APPSGL_FLEXFIELDS_PKGGET_DESCRIPTION_SQL GCCCHART_OF_ACCOUNTS_ID. Oracle Advanced Controls 11g Applications Certified Implementation Specialist.
For this you will need to first find the value set name for the Natural Account segment and then use it in this query. Segment Prompts and List of Values Enter prompts for the segment as it should appear in the flexfield window and its list of values if this segment uses a validated value set and in reports your application generates. Query to get the details of a Descriptive Flexfield The below gives the details of Descriptive Flex Field defined in Oracle eBusiness Suite.
Select fvsflex_value_set_name fvflex_value fvtdescription from appsfnd_flex_value_sets fvs appsfnd_flex_values fv appsfnd_flex_values_tl fvt where fvsflex_value_set_name like. HCM Cloud 3 OTBI 2 OTHERS. Operating Unit- AP AR PO OE -Bal Segment 1 Bal Segment 2Bal Segment 3 Inventory Org MFG INV Ship There is one confusion between Oracle Financial and HRMS consultant as they simply assume SOB is more meant for non HRMS module and BG is more for HRMS in certain extend this is trueLets investigate this on GRELE and OU as follows.
Find Data Base Object Source. Query For GL Segments Description Select GCCCONCATENATED_SEGMENTS ACCOUNT GL_FLEXFIELDS_PKGGET_CONCAT_DESCRIPTIONGCCCHART_OF_ACCOUNTS_ID GCCCODE_COMBINATION_ID DESCRIPTION from GL_CODE_COMBINATIONS_KFV GCC. The difference being that GL Wand functions retrieve information from your Oracle Applications system.
Avail 25 to 80 discount. Chart of Accounts Segment Descriptions in Oracle EBS R12. Query to get GL Account and Account Segment Description 1Query to get Account Code Combination Description.
Similarly pull in the columns mentioned below for the remaining levels. ----- 2Below given Query. ORACLE EBS COMMONLY USED QUERIES AND SAMPLE CODE 38 ORACLE.
Find Out eBS Table Name. Important Join conditions between Oracle apps modules. Below is an example of the same.
R12 How to Get Chart of Accounts Segment Descriptions In R12 We Cant just directly get the Code Combination ie Accounting Flex Field Description from a single table. - Get Balance - Segment Description - Next Segment Value - Previous Segment Value - Parent Flag - Enabled Flag - Account Type - Period Name - Set of Books Name - Segment Descriptive Flexfield. Drilldown from GL XLA to AP Payments Transaction.
UNIX 3 ER DIAGRAMS 2 ORACLE CRM MODULE 2 ORACLE 12c 1 Fusion Applications. Segment value for which you need the. GL_FLEXFIELDS _PKG to get the description of GL Account.
Get Segment Description Oracle R12 Bahaa Oracle Issues SELECT SUBSTRgl_flexfields_pkgget_description_sql chart_of_account_idsegment_numbersegment_value1500 segment_desc from dual. Chart of Accounts Segment Descriptions in Oracle EBS R12 Script You can use the following query to get the description of COA of Oracle EBS by using appsgl_flexfields_pkgget_description_sql and avoid hideous number of joins back to FND_FLEX_VALUES_TL and generally hard-code in value set ids. Query to get Account Segment Description September 1 May 1 2017 16 November 3 October 4 September 4.
If you wish to display the account description Oracle provides an API for that instead of hitting the Value Set tables for each of the segment. Important FND Tables in EBS. GL Wand currently has the following functions.
A descriptive flexfield can get context information from either a field somewhere on the form or from a special field a context field inside the descriptive flexfield popup window.
