Infolinks

Friday, 22 June 2012

SYSTEM ADMINISTRATOR

[SYS] No Organizations Are Currently Defined

After setting a new Operating Unit (OU), I encountered this problem when i tried to open any forms that are related to Inventory Organization.
Steps I used in organization setup (has to be in sequential mode):
(1) Setup new Set of Book
(2) Setup new Location
(3) Setup new Legal Entity
(4) Setup new Operating Unit
(5) Setup new Inventory Organization
(6) Setup new responsibility
(7) Setup Profile Option for new responsibility


Everything is smooth till I click on the "Change Organization" in my new responsibility. It prompted me "No Organizations are currently defined.". These happened to other forms that use inventory organization as well, such as Material Transactions, Receipts, etc.
This has something to do with Organization Access. After checked Organization Access, ORG_ACCESS table is empty. Setup has been verified many times, nothing was missed out.
We finally discovered it was a customization on standard view, ORG_ACCESS_VIEW. This is root cause of the issue.

[SYS] Utilities:Diagnostics

To disable the password promting when i click "Examine", set the Profile Option to value "Yes" for Utilities:Diagnostics.

[SYS] Form Personalizations - Set Property Value for Descriptive Flexfield


Assuming you have have 3 flexfields for each line of record, but for setting the value for Target Object, there is only 1 Target Object available for 3 flexfields, e.g. {something}.DESCFLEX, how to set value for 3 of them?

Ans: At the Value field, enter something like this => Value1.Value2.Value3

Separate each value by a dot.

[SYS] Form Personalizations - Setting Property Value by Calling a SQL Query


Can be done.

Enter the value as below:
=(SELECT AGENT_ID FROM PO_HEADERS_ALL WHERE SEGMENT1=:RCV_TRANSACTION.PO_NUMBER)

:RCV_TRANSACTION.PO_NUMBER is a Target Object ("Item" Type) name, which you can refer after you clicked on "Insert Item Value..." button. It can also be found under Target ObjectLOV with Object Type "Item".

[SYS] Java Cache Caused Internet Explorer Crashed


I was trying to launch the Oracle form (in Java applet), IE crashed. I tried on Firefox, it did not get launched at all. Restarted my system, problem still there.

Before I decided to call Helpdesk to examine my system, I found a trick that can save me a lot of time dealing with Helpdesk.

Checked "Control Panel", "JInitiator 1.3.1.29" (your version might be different), "Cache" tab. My total file size in JAR Cache folder has exceeded the limit. I have then removed all cache files in that folder, increased my size limit, and it works!!!

[SYS] Trick - Maximise Form


Due to "bad" design of Oracle Form UI, the grid information in Oracle form will not maximise eventhough I maximised the form. 1 typical example is Material Transaction form.
There a trick to "force" the grid to grow bigger, and then fit to the maximised form.
First, maximise the form.
Then, move the mouse in between 2 fields until a double-headed arrow appears.
Double Click.
You will see this magic works.

[SYS] Concurrent Program Always in Pending Status

Some times we found out a submitted request is always in Pending status, we need to know if the manager is running fine. To determine which concurrent manager is handling a specific concurrent program, run this,

SELECT user_concurrent_program_name, user_concurrent_queue_name
FROM apps.fnd_concurrent_programs_tl cp,
apps.fnd_concurrent_queue_content cqc,
apps.fnd_concurrent_queues_tl cq
WHERE cqc.type_application_id(+) = cp.application_id
AND cqc.type_id(+) = cp.concurrent_program_id
AND cqc.type_code(+) = 'P'
AND cqc.include_flag(+) = 'I'
AND cp.LANGUAGE = 'US'
AND cp.user_concurrent_program_name = '&USER_CONCURRENT_PROGRAM_NAME'
AND NVL (cqc.concurrent_queue_id, 0) = cq.concurrent_queue_id
AND NVL (cqc.queue_application_id, 0) = cq.application_id
AND cq.LANGUAGE = 'US'

[SYS] Default Type: Profile


We have different value in Default Type in concurrent program parameter, Constant, Current Date, etc. I want to share about "Profile" in this post.

For Default Type Profile, the Default Value indicates Profile Name (In Application Developer responsiblity, Name field in Profile). Note that the User Profile Name is what we see in the System Administrator responsibility.

The value which returns to the concurrent program is the value for the Profile Name, either user, responsibility, or other levels.
SQL:
SELECT profile_option_name, user_profile_option_name
FROM apps.fnd_profile_options_vl
WHERE profile_option_name = 'MY_CUSTOM_PROFILE_NAME'

profile_option_name is referring to Profile Name, user_profile_option_name is referring to User Profile Name.

[SYS] FND: Default Request Days

"FND: Default Request Days" profile decides the default value shown in "Select the Number of Days to View" field after you choose View->Requests

[SYS] PHASE_CODE and STATUS_CODE in FND_CONCURRENT_REQUESTS Table


It has been a bit confusing, hence i summarized the fields' values and meaning as follows:

PHASE_CODE

P - Pending
C - Completed
R - Running

STATUS_CODE
Q - Standby //Scheduled
R - Running
C - Normal
D - Cancelled
E - Error
G - Warning
I - Normal //Inactive
 
 

No comments:

Post a Comment