Oracle Branding Logo Change

Oracle Branding Logo Change

Step 1 : Place the XXX.Png file under $OA_MEDIA directory in App Tier.

Step 2 : Query the Profile & Change the value . 

              System Administrator > Profile - System.

              Query profile "Corporate Branding Image for Oracle Applications"

              Change the SITE level value to the name of the custom image file { XX_CUSTOM_LOGO.jpg }

Step 3 :  Clear the Cache From Functional Administrator.

Request Group Name based on previous Concurrent Program run

i) To find the Request Group Name based on previous Concurrent Program run

SELECT cpt.user_concurrent_program_name     "Concurrent Program Name",
       DECODE(rgu.request_unit_type,
              'P', 'Program',
              'S', 'Set',
              rgu.request_unit_type)        "Unit Type",
       cp.concurrent_program_name           "Concurrent Program Short Name",
       rg.application_id                    "Application ID",
       rg.request_group_name                "Request Group Name",
       fat.application_name                 "Application Name",
       fa.application_short_name            "Application Short Name",
       fa.basepath                          "Basepath"
FROM fnd_request_groups          rg,
            fnd_request_group_units     rgu,
            fnd_concurrent_programs     cp,
            fnd_concurrent_programs_tl  cpt,
            fnd_application             fa,
            fnd_application_tl          fat
WHERE rg.request_group_id       =  rgu.request_group_id
   AND rgu.request_unit_id       =  cp.concurrent_program_id
   AND cp.concurrent_program_id  =  cpt.concurrent_program_id
   AND rg.application_id         =  fat.application_id
   AND fa.application_id         =  fat.application_id
   AND cpt.language              =  USERENV('LANG')
   AND fat.language              =  USERENV('LANG')
   AND cpt.user_concurrent_program_name = '<Custom Program/Report Name>';

My Group Requisition Functionality in iProcurement

To view the 'My Group Requisition' functionality, use the below setup under the Purchasing Super User Responsibility to achieve it.

Before changing the Security Level setup

Responsibility: ICX USD1 iProcurement User 

Navigation: iProcurement Home Page à Requisition

View LOV is not listing “My Group Requisition”

Cause: Security Option is setup at “Purchasing” level in the Document Type Setup.

Responsibility: Purchasing Super User

Navigation: Setup à Purchasing à  Document Types

To fix this, setup the Security Option at “Public” level in the Document Type Setup

Access Level Privilege:

Private: Only the document owner may access these documents.

Public: Any user may access these documents.

Purchasing:  Only the document owner and users listed as buyers in the Define Buyers window may access these documents.

After changing the Security Level setup

My Group Requisition LOV is listed in the iProcurement!

Not Able To Do Third Party Registration Setup Of Supplier At Null Site - TDS Setup

When attempting to third party registration for TDS Regime 
the following error occurs.

ERROR
-----------------------
APP-JA-460353:You must create a records for null site first

Solution : 

To implement the solution, please execute the following steps:

1. Go into the responsibility: Oracle Financial for India 

2. Navigate to Party Registration > Define Third Party Registration 

3. To Create a null site level setup of Supplier , Do not pass any value for Operating unit 

4. In Find Third Party Registration Form ,Pass only Party type as "supplier " and Click on New 

5. Not Pass the all details to do the supplier setup at null site level 

6. Migrate the solution as appropriate to other environments.

********************************************************************************************

ORA-20002: [WF_NO_ROLE] NAME=FND_RESP|ICX|XXICX_SSP_IPROC|82 ORIG_SYSTEM=FND_RESP ORIG_SYSTEM_ID=51285 has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

Issue: Trying to assign a responsibility to a user using "fnd_user_pkg.addresp" or from "Users" Screen in "System Administrator" responsibility and you receive the error below:

"ORA-20002: [WF_NO_ROLE] NAME=FND_RESP|ICX|XXICX_SSP_IPROC|82 ORIG_SYSTEM=FND_RESP ORIG_SYSTEM_ID=51285 has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT"


As its shown; this is the custom exception raised by Oracle API.

Let see how to get it resolve:

1) Submit Program "Workflow Directory Services User/Role Validation" with parameters like

"100000, USERNAME, , Y, Y, N, "

• Parameters
  • Batch Size: Number of records that will be processed per commit cycle
  • Fix dangling user/roles: Removes any user/roles where the user and/or the role does not exist in WF_LOCAL_ROLES
  • Add missing user/role assignments: Adds any user/roles that are present in WF_LOCAL_USER_ROLES but missing in WF_USER_ROLE_ASSIGNMENTS
  • Update WHO columns in WF tables: Controls the updating of who columns when corrupt records are corrected

2) Set the Enable Security Groups profile option to Yes at application level for the application relevant to the responsibility

3) Submit Program "CREATE FND_RESP WF ROLES"

Hope it helps !!