What validations u did in the customer interface?
customer number: must be null if your r using automatic customer numbering, must exit if you are not using automatic customer numbering. This value much be unique with in HZ_PARTIES
customer status: must be ‘A’ for active or ‘I’ for inactive HZ_PARTIES_STATUS
bank account num or bank account currency code :
if the bank a/c already exist do not enter a value
if the bank a/c does not exist you must enter a value
bank a/c name: it must exist in AP_BANK_ACCOUNTS or if it does not exist values must exist for BANK_A/C_CURRENCY_CODE
BANK_A/C_NUM
BANK_NAME
BANK_BRANCH_NAME
Sob id constant or not
Periods are opened or not
Populate all who columns
New org-id, and organization is.
Populate all not null columns
U can populate null columns also if required.
Note: every interface table has two error msg
Error code.
Error msg.
Tell me some API?
FND_FILE.PUTLINE (FND_FILE.LOG, ‘MESSAGE’)
FND_FILE.PUTLINE (FND_FILE.OUTPUT, ‘MESSAGE’)
FND_FILE.PUT (which number, buff in varchar);
FND_FILE.NEW_LINE (which number, buff in varchar);
FND_REQUEST.SET_MODE -- Call this function before calling fnd_request.submit_request from the database.
FND_PROFILES
FND_APPLICATIONS
FND_GLOBAL
FND-FILE
FND_CONCSUB (can submit conc program in host invironment)
Is the Program exits, delete conc program and its executables.
IF FND_PROGRAM.PROGRAM_EXITS (‘EMP’,APPLICATION_NAME_IN) THEN
FND_PROGRAM.DELETE_PROGRAM (‘EMP’,APPLICATION_NAME_IN)
FND_PROGRAM.DELETE_EXECUTABLE (‘EMP’,APPLICATION_NAME_IN)
END;
How can u call a standard interface program from sql or pl/sql code?
FND_REQUEST.SUBMIT_REQUST (‘PO’,’EXECUTABLE NAME’,PARAMETERS)
To know the status of the request?
FND_CONCURRENT.GET_REQUEST_STATUS
Roll back statements?
FND_CONCURRENT.AF_ROLLBACK;
FND_CONCURRENT.AF_COMMIT
API’s for Customer interface?
HZ_CUST_A/C_VZPUB.UPDATE_CUST_A/C
HZ_CUST_A/C_VZPUB.CREATE_CUST_A/C
What are profile options?
Is the Functional and Technical behavior of Oracle Applications Package.
EX: - I want to assign the user3 responsibility to p4 printer then
System Administrator -- Profile -- System
Types of profile options:
1) Site: which affects all users at an installation site.
2) Application: which affects all users working under responsibility owned
by a particular application.
3) Responsibility: which affects all user working a specific responsibility.
4) User: which affects a unique application user.
Profile options will be stored in these tables
1) FND_PROFILE_OPTIONS
2) FND_PROFILE_OPTIONS_VALUES
MO: OPERATING UNIT: Is one of the profiles which we will set organizations to a particular operating unit
API’S:- FND_PROFILE.PUT (‘USER_ID’, VALUE);
FND_PROFILE.GET (‘USER_ID’);
FND_PROFILE.VALUES (‘USER_ID’) RETURN number;
Oracle E-Business suite?
Oracle apps + analytical components software.
(Oracle discover)
(Oracle sales analyzer)
(Oracle financial analyzer)
(Oracle marketing analyzer)
What is multi org?
“Legal entity has more than one operating unit is called as multi orc”
a) Business group --- Human resources information is secured by Business group
b) Legal entity. --- inter company and fiscal/tax reporting.
c) Operating unit --- secures AR, OE, AP, PA and PO Information.
d) Organizations --- is a specialize unit of work at particular locations
Multi-org tables?
1) HRG_ORGANIZATION_DEFINATIONS.
2) ARF_BUSINESS_GROUPS.
3) GL_SET_OF_BOOKS
4) HR_LEGAL_ENTITIES_
5) HR_OPERATING_UNITS
6) MTL_SYSTEM_PARAMETERS
How do u restrict the data for a responsibility as per the org-id?
Through multi-org (MO) you can restrict the data for a responsibility as per ORG-ID only.
Difference between ORG-ID and Organization id?
A global variable exists in the oracle data base called client info which is 64 bytes long, the first 10 bytes are used to store the operating unit id(or org-id) for the multiple organization support features.
Multi-org views are partitioned by ORG-ID the org-id value is stored in CLIENT-INFO variable (it comes ap, po, ar and om level)
ORGANIZATION-ID: It’s for inventory, mfg and bom.
What is template?
a) The TEMPLATE form is the required starting point for all development of new Forms.
b) The TEMPLATE form includes platform–independent attachments of several Libraries.
APPSCORE:- It contains package and procedures that are required of all forms to support the MENUS ,TOOLBARS.
APPSDAYPK:- It contains packages that control the oracle applications CALENDER FEATURES.
FNDSQF:- It contains packages and procedures for MESSAGE DICTONARY, FLEX FIELDS, PROFILES AND CONCURRENT PROCESSING.
CUSTOM:- it allows extension of oracle applications forms with out modification of oracle application code, you can use the custom library for customization such as zoom ( such as moving to another form and querying up specific records)
It contain 2 functions
–Zoom function available
- Style function available
1 procedure – Event procedure
Who information’s?
1) Created by
2) Creation date
3) Last _updated by
4) last_update_date
5) last_update_value
Form development process?
a) Open template form
b) Save as <your form>.fmb
c) Change the form module name as form name.
d) Delete the default blocks, window, and canvas
e) Create a window.
f) Assign the window property class to window
g) Create a canvas (subclass info)
h) Assign canvas property class to the canvas
i) assign the window to the canvas and canvas to the window
j) Create a data block (Must be register in the AOL)
k) Modify the form level properties. (sub class item à Text item)
l) Modify the app_cusom package. In the program unit.
1) If (wnd = <’object name’> then
2) If (wnd =<’object name’> then Go_block<’object name’>;
Return;
m) Modify the pre-form trigger (form level) app.window.set.window_position (<’object name’> ,null, <’object name’> )
n) Modify the module level properties ((console window, First navigation
p) Save and compile the form. Place the .fmx in the server directory.
q) Register in the AOL
APPLICATION -- FORM
APPLICATION -- FUNCTION
APPLICATION -- MENU (ar_navigate_gui)
What are the triggers that can’t be modified during forms customization?
Standard_attachment
Zoom
Folder_action
Key_help
Key_exit
Key_commit
When_window_closed
Close_window
How do u identity its name of report?
System administrator -- concurrent -- program -- define
System administrator -- concurrent -- program --executable
sql*plus files registration?
create .sql or plr script file
Place in .sql or .pls files in the specified module like <prompt>11.50\sql dir.
(While putting in the server dir u specify the module name like “ar.gv_table”)
Register the executable with AOL(method name -- sql*plus)
Define a conc prog based on the registered executable
Add/assign concurrent program to request group.
Passing the parameters:
before that u have to create the value set
Go to application -- validation -- set
(Before creating value sets, you have to register the parameters in the AOL)
sys admin-- concurrent -- program -- define
Click on parameters, and here enter the parameter name and validation type and all and save it.
Then go to sys admin -- security -- responsibility -- request(listing)
Then go receivables responsibility -- reports-- listing
sql*loader file registration?
Create a .CTL file
Place the .ctl file in <prompt>\11.5.0\bin\
Place .dat file in any directory of concurrent process server
Register the sql*loader executable (execution method -- sql*loader)
Define a concurrent program
Add/assign the concurrent prog to a request group
What are the User PARAMETERS in the Reports?
P_CONC_REQUEST_ID
FND USER EXITS:-
FND SRWINIT: sets your profile option values, multiple organizations and allows Oracle Application Object Library user exits to detect that they have been called by an Oracle Reports program.
FND SRWEXIT: ensures that all the memory allocated for AOL user exits have been freed up properly.
FND FLEXIDVAL: are used to display flex field information like prompt, value etc
FND FLEXSQL: these user exits allow you to use flex fields in your reports
FND FORMAT_CURRENCY: is used to print currency in various formats by using formula column
No comments:
Post a Comment