16 In which tables FF are stored?
- FND - ID - FLEXS
- FND-ID-FLEX-STRUCTURES 5
- Internet computing Architecture is a frame work for 3-tired, distributed computing that supports Oracle Applications products.
- The Three tiers are : Data Base Tier, Application Tier and Desk Top Tier
- Database tier manages Oracle 8i database.
- Application tier manages Oracle Applications and other tools.
- Desktop tier provides the user interface displace.
- With internet computing architecture, only the presentation layer of Oracle Applications is on the Desk Top tier in the form of a plug-in to a standard internet browser.
- FND_PROGRAM.EXECUTABLE
- FND_PROGRAM.REGISTER
- FND_PROGRAM.PARAMETER
- FND_PROGRAM.ADD_TO_GROUP
- FND_REQUEST.SUBMIT_REQUEST
- FND_PROFILE.VALUE
- FND_PROFILE.GET
$fle x $ value setname.
20)How to call WHO columns into the form
- FND_STANDARD.FORM_INFO
- FND_standard.set_who
- FND_STANDARD.SYSTEM_DATE
- FNID_STANDARD.USER
- APP_COMBO
- APP_DATE
- APP_EXCEPTION
- APP_FIELD
- APP_FIND
- APP_ITEM
- APP_ITEM_PROPERTY
- APP_NAVIGATE
- APP_RECORD
- APP_REGION 7
- APP_STANDARD
- APP_WINDOW
- FND_CURRENCY
- FND_DATE
- FND_GLOBAL
- FND_ORG
- FND_STANDARD
- FND_UTILITIES.OPEN_URL
- FND_UTILITIES. PARAM_EXISTS
By using FND_FLEX.EVENT (EVENT varchar 2)
24)How to register an executable through backend?
FND_PROGRAM.EXECUTABLE
25) How to register a table and columns through back end?
by using AD_DD package
26) How to write to a file through concurrent program.
- FND_FILE.PUT_LINE
- FND_FILE.NEW_LINE
- FND_FILE.PUT_NAMES
- FND_REQUEST.SET_OPTIONS
- FND_REQUEST.SET_REPEAT_OPTIONS
- FND_REQUEST.SET_PRINT_OPTIONS
- FND_REQUEST.SET_MODE
- FND_CONCURENT.GET_REQUEST_STATUS
- FND_CONCURRENT.WAIT_FOR_REQUEST
To get the data correctly, the xxx-ALL must be referenced and the ORG_ID value should be specified to extract portioned data. Multiorg views are partitioned by using ORG_ID.
So access through multiorg views will not return any roes, as the CLIENT_INFO Value is not set
- Use HR_OPERATING UNITS to identify the organization _id of the OU on which query is based.
- Use FND_CLIENT_INFO package to set the value in CLIENT INPO using set_org_contest.
Now qurying of multiorg views can be done.
30. How do you find that muliorg is installed?
- Multi organization architecture is meant to allow multiple companies or subsidiaries to store their records with in a single data base.
- Multiple organization Architecture allows this by partitioning data through views in APPS schema.
- Implementation of Multi org generally includes more than one business group.
select multi_org_flag from fnd_product_groups)
if the result is „Y? means the database is group for multiorg
