Multi Org Security, Diagnostics Security and Application Appearence via Profiles

While using multi org application assigning profiles are critical at responsibility level;
MO: Operating Unit
MO: Default Operating Unit
HR:Business Group
HR: Security Profile
GL Ledger Name
GL: Data Access Set
MO: Security Profile (If MOAC is going to be used then a security profile should be created via HR and this profile should be set. If this is set then MO: Operating Unit is disregarded)

Normally Diagnostics on Forms require Apps password though in test or development environments this may cause problems. To make Diagnostics available for every user "Utilities:Diagnostics" profile can be set.

When an unexpected error occur in OAF screens, details of the error gives reason. To access to the details of error "FND: Diagnostics" profile should be set.

Changing the applications look and colour is possible. Especially differentiating test, dev and prod environments may prove very useful, to provide that "Java Color Scheme", "Java Look and Feel" profiles can be used.

Debugging Code

To debug a code there are advanced techniques but in basic cases dbms_output package can easily be used; it provides procedures to enable buffering, to create output and to retrieve the output; enable, put_line, get_line.

BEGIN
dbms_output.put_line('Debug test');
END;
/

This output is created in buffer though if wanted output can be written to a table.

iProcurement item prices

iProcurement can get item prices from different locations; inventory>items>master items>list price, purchase agreements, price lists or items' cost information.

Cost information is used for internal requisitions and it is derived from destination organization's item cost. Cost tables are; cst_item_costs, cst_item_cost_details and cst_item_cst_dtls_interface .

It is optional that whether users can or can not override the default requester. To determine that a profile is used; "ICX/POR: Override Requester" which can be limited to user only, users within the same personnel organization (HR Organization) or users within the same business group.