To enable DFF switch responsibility to Application Developer
Flexfield à Descriptive à Segments
Supply the title and query the form. Uncheck the checkbox called FREEZE FLEXFIELD DEFINISION and click on Segments button.
Describe the fields you want to display in DFF in the below form.
Check the PO_VENDOR_ALL table to know whether the Supplier name and item fields in the DFF are stored in the Attribute Column of the table or not.
The main components of the multi organization are
1) Business Group (BG)
2) Legacy Entity
3) Set Of Books (SOB)
4) Operating Units or Divisions
5) Organizations
Business Group (BG): The business group represents the highest level in the organization structure, such as the consolidated enterprise, a major division, or an Operation Company. A BG is used to secure human resources information like generation of employee numbers, generation of applicants, position flex fields, Job flex fields, Grade Flex field, Fiscal year, etc.
Legacy Entity: It is a legal business, which is going to have its own legislation code or tax registration number. At this level we are going to prepare all our financial statements.
Set Of Books (SOB): A SOB is a collection of Currency, Calendar and Chart of Accounts (COA). Oracle General Ledger is used to secure Journal transactions (such as journal entries and balances) of a company by set of books. For each organization of the Business Group we need to define a set of Book.
Operation Unit: An operating unit is a division or a Business unit of the legal entity. At this level we are going to maintain the information of sub-ledgers. We are going to maintain the ledgers at Legal Entity level. Receivable, Payables, Assets, etc. are comes under Operation Unit level.
Organization: The different types of organizations are Inventory Organization, Asset Organization, Human Resource Organization, etc. These organizations are going to be maintained at operating unit level.
Note: In case if we are working with single organization we can define an entity as a Business Group, Legal Entity, Operating Unit and Organizations.
The individual Accounts (i.e. Application Receivables) of an organization (i.e. Tata Motors) of multi organization (Tata Group) are identified by
First by Module then Responsibility then Profile Option then Set of Books.
In the above example
Data will be secured for every organization by using Set Of Books ID.
The following are the tables are going to be effected for all the Organizations of multi organization.
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
To record the sales transactions of all the organizations will be stored in the AR_TRANSACTION_ALL table. Extra columns required to identify the individual sales transactions are Set_Of_Books_ID, Org_ID (Operating Unit) and Organization_ID (Business Group)
PROGRAM LEVEL: If the Profile is having access at Program Level then we can use them in our Programs.
1)Create the Function for the User form name called "Run Reports"
2)Attach the Function to the menu.
3)Attach the menu to the responsibility so that user can call the form from the menu.
1)Create the Request group in System administrator by specifying the request group code Copy the Request group name application short name request group code
2)Goto the Appllication developer create the fucntion for the user form name called " Run Reports"
3)Pass the follwoing Parameters while creation of the function.REQUEST_GROUP_CODE="CUSTOMERCODE1" REQUEST_GROUP_APPL_SHORT_NAME="AR" TITLE="23CUSTOMERS"
4)Attch the function to the Menu , Menu to Responsibility , Responsibility to user
5)when we open the form we can get the programs which are there in the request group.
note: We will follow this prcocedure to attach the multiple request groups to the single Responsibility.
1)Define the Record Group Either Static Values or By using the Query
2)Create LOV and attach the Record Group
3)Attach the LOV to field in the property called list of Values.
1)Select the Field properties and select the property called List of Values : ENABLE_LIST_LAMP
2)Goto the Item level Trigger called KEY-LIST-VAL trigger call the following API CAlendar.Show();
)Develop the from by using TEMPLETE.fmb
2)Develop the Master Block and create the fields.
3)Attach the Property classes and other customization steps.
4)Create Detail Datablock by selecting the Detail columns after selecting the columns select the next button
5)Uncheck the check box called Auto join Datablocks select the button called Create Relationship button and select the Master Level primary key column and Detail level reference column system will automatically join condition.
6)Select the Tabular style when we are going to attach to the Layout so that we can display either single record or multiple records.
7)select next button enter no of records to be displayed and check the check box called Display Scroll bar .
1)Open the TEMPLETE.fmb
2)Delete Canvas,Window,Datablock
3)Create New Canvas,Window attach Property classes
4)Create New Datablock select Manuval Development
5)Goto Properties of Datablcok
1)SubClass Information = Block
2)Query Data SourceName = TableName
3)Query Data SourceColumns = Select Colunmns and Datatypes
6)Goto Canvas Define the Frame attach Properties
1)SubClass Information = FRAME_RECT
2)Layout Datablock = Select the Datablock Whatever we have created
7)Define Boiler Plate Text and Texst Items for Text Items attach folowing Property Classes
1)SubClass Information = TEXT_ITEM
2)Coluimn Name = Database Column Name8)Save the form
9)Change the Property called first Navigation Datablock
10)Customize Pre-Form WHEN-NW-FORM-INSTANCE Triggers APP_CUSTOM package
11)Save the .fmb AND generate the .fmx
12)Register the Form in Application Developer
TEMPLETE.fmb : It is pre-defined .fmb contains the existing functionality which willsuport for all the Menu,Toolbar, and Other Oracle Applciations features.that is the Reason we have to start form development with TEMPLETE.fmb
