How To Get Segment Description In Oracle Apps
How To Get Segment Description In Oracle Apps. Select segment1 company, apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id. The intercompany qualified segment cannot be set with any of the three balancing segment qualifiers.
Segment labels can only be assigned once within a chart of accounts. If this parameter is omitted, the ledger currently selected in the ledger dropdown list will be used. Hi all, would like to ask assistance from the expert guru in oracle on how can we implement this in the business.
For An Example On Assignment Attributes Descriptive Flexfield (Dff Per_Asg_Df), Based On Officer = Yes, Officer Title Field Has To.
For dependent segments, enter the independent value that the segment value relates to. ) company_desc, segment2 location, apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id. If this parameter is omitted, the ledger currently selected in the ledger dropdown list will be used.
Dbms_Advisor.create_Task ( Advisor_Name => 'Segment Advisor', Task_Id => :Id, Task_Name => Name, Task_Desc => Descr);.
The intercompany qualified segment cannot be set with any of the three balancing segment qualifiers. The following table shows the segment labels that are assigned to each segment in the. Home » oracle r12 gl code combination with segment description.
Use Below To Check Segment Space In Oracle Database:
Select segment1 company, apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id. Qn1:i am trying to identify the tables that has been populated by the rapid implementation sheet upload that has uploaded the hierarchy information. This document will guide you how to implement context sensitive segments in descriptive flexfield (dff).
Can You Please Tell Me The Tables I Could Use To Pull The Information For.
I tried querying gl_seg_val_hierarchies and could only find the hierarchy uploaded for company (balancing segment) only. Segment labels can only be assigned once within a chart of accounts. Similarly pull in the columns mentioned below for the remaining levels.
Hello , I'm Trying To Get The Account Description For Segment6 Using This Query Select Gl_Flexfields_Pkg.get_Description_Sql.
Optionally enter a ledger id to bind the formula to a specific ledger. For dependent segments, enter the independent value that the segment value relates to. The values in this segment's value set must be the same as the primary balancing segment.
Post a Comment for "How To Get Segment Description In Oracle Apps"