Archive for the ‘Oracle’ Category

Scheduling Failed : Unable To Find A Calendar Date

July 12th, 2020, posted in Oracle
Share

Scheduling Failed Unable To Find A Calendar Date,Find A Calendar Date,Calendar Date,Scheduling Failed,Oracle Scheduling Failed,Oracle apps ,Oracle dba,

 

As I got this Error while placing a Sales order I just searched and got this Document from Oracle (Doc ID 1265873.1) As Mentioned I have Setup the Workday Calendar and then when I checked the Issue was resolved.

Below is the solution provided by Oracle :

Set up the Workday Calendar.

The Workday Calendar must be setup correctly and rebuilt any time modifications are made to the Calendar.

Navigation paths: Bill of Materials/Setup/Calendars
OR
Inventory/Setup/Organization/Calendars

Once you have made your modifications, you need to rebuild the calendar by selecting the special option on the top tool bar. On the drop down list, click ‘Build’.

Then run data collections to collect this information, then try to schedule the order.

If this still fails then review Note 563072.1 – ‘Unable To Find A Calendar Date’ While Scheduling a Sales Order
— this details other errors in setup that can cause this issue to occur.

Share

Decoded INST_TOP Oracle R12 INSTANCE_HOME

June 13th, 2020, posted in Oracle
Share

 

Features on this R12 INST_TOP

-All the logs files have been moved from APPL_TOP,ORACLE_HOME to this to top

  • All configuration files have been moved to INST_TOP
    like
    DBc file
    All the http related config files
    appsweb.cfg
    All the start or stop scripts
    all the OC4J related config files

-we can now share the Apps and technology stack among multiple nodes and even instances (Dev,Test, Production) as all the log and config are located in this top.We will have INST_TOP for each context.

-Configuration and log files are co-located

-Easier collection of instance state
-Minimize disk usage and maximize performance

Filesystem look

/inst/apps/ ($INST_TOP)
/admin
/scripts ($ADMIN_SCRIPTS_HOME) All the start and stop are here
/appl ($APPL_CONFIG_HOME) All the apps env are here
/fnd/12.0.0/secure ($FND_SECURE) dbc file lis located here
/certs
/logs ($LOG_HOME) all the logs are located
/ora ($ORA_CONFIG_HOME)
/10.1.2
/10.1.3 ($ORACLE_CONFIG_HOME) all the techstack(oacore,forms) related config files
/pids
/portal
/rgf

Some more changes to variable

OA_HTML =$COMMON_TOP/webapps/oacore/html
JAVA_TOP=$COMMON_TOP/java/classes
AF_JLIB=$COMMON_TOP/java/lib
JAVA_BASE=$COMMON_TOP/java/

Advantage  of INST_TOP

-Clear distinction between the shared file system and the file system unique to an instance
-Ability to share code (Apps, technology stack) among multiple  nodes and even instances (Development ,Test, Production)
-Enables split ownership of applications and technology stack file systems
-Improves code safety by making shared file system read-only while not patching
-Configuration and log files are co-located
-Easier collection of instance state
-Ability to use network or local storage for various file system portions
-Minimize disk usage and maximize performance

R12.2 Changes

-R12.2 contains the Fusion Middleware 11g tech-stack. The logfile and configuration files is located in that Oracle Home

Concurrent Manager log/out files have been moved in Non editioned File system

Where to Put INST_TOP in shared file system

It is recommended to put INST_TOP on local filesystem  in shared APPL_TOP filesystem  architecture. This is because of the Apache mutex problem.Apache performance is highly sensitive to mutex file access latency, and at higher loads is also sensitive to I/Os per second. In case you have INST_TOP on shared filesystem, it is suggested to point these context variable to local file-system

s_lock_pid_dir
s_pids_dir
s_web_pid_file

 

 

Conclusion

Hope you like the post on R12 INST_TOP, all the advantages and R12.2 changes.  Please do provide the feedback.

 

 

Share

Create Oracle EBS Application Custom Top

June 6th, 2020, posted in Oracle
Share

Share

Enable Export Feature in Custom Forms

April 26th, 2020, posted in Oracle Queries
Share

Occurred In Oracle Reports,Oracle Reports,Oracle,Reports,Enable Export Feature in Custom Forms,Enable Export Feature, in Custom Forms,Oracle Custom Forms,Oracle Forms,In Order to Enable Export option, available in Oracle Application forms to export the data into Excel file.
In the custom form at form level trigger write the below code in When-New-Form-Instance trigger.

APP_SPECIAL.ENABLE('FILE.EXPORT', PROPERTY_ON);
Share

Oracle Queries for checking Profile Option Values

April 19th, 2020, posted in Oracle Queries
Share
SELECTatabase, dba imam, dba immam, Imam Dba, ORA-28014: Cannot Drop Administrative Users, Oracle, Oracle DBA, oracle quries
substr(pro1.user_profile_option_name,1,35) Profile,
decode(pov.level_id,
10001,'Site',
10002,'Application',
10003,'Resp',
10004,'User') Option_Level,

decode(pov.level_id,

10001,'Site',
10002,appl.application_short_name,
10003,resp.responsibility_name,
10004,u.user_name) Level_Value,

nvl(pov.profile_option_value,'Is Null') Profile_option_Value

FROM

fnd_profile_option_values pov,
fnd_responsibility_tl resp,
fnd_application appl,
fnd_user u,
fnd_profile_options pro,
fnd_profile_options_tl pro1

WHERE

pro1.user_profile_option_name like ('%Ledger%')
and pro.profile_option_name = pro1.profile_option_name
and pro.profile_option_id = pov.profile_option_id
and resp.responsibility_name like '%General%Ledger%' /* comment this line if you need to check profiles for all responsibilities */
and pov.level_value = resp.responsibility_id (+)
and pov.level_value = appl.application_id (+)
and pov.level_value = u.user_id (+)

order by 1,2;
Share