Best Of
Re: Oracle® Enterprise Manager 24ai Release 1 Update 5 (24.1.0.5) for Oracle Management Service
Thanks for letting us know.
Re: ODACLI configure-dataguard fails around step 7 Restore missing archivelog (Primary Site)
I found in my case the DG DB was created by the ODACLI command but Data Guard was being stupid. Here's my fix (DGsid is Data Guard DB sid is primary)
Once the ODACLI command fails (around strep 7) continue with DGMGRL commands:
Set all relevant environment variables ORACLE_HOME, ORACLE_BASE, ORACLE_SID…
On STANDBY -
srvctl stop database -db DGsid
srvctl start database -db DGsid -startoption MOUNT
sqlplus / as sysdba
alter database flashback on;
exit;
srvctl stop database -db DGsid
srvctl start database -db DGsid -startoption OPEN
On PRIMARY ORACLE-
dgmgrl /
CREATE CONFIGURATION "sid_DGsid" AS PRIMARY DATABASE IS sid CONNECT IDENTIFIER IS sid;
ADD DATABASE DGsid AS CONNECT IDENTIFIER IS DGsid;
ENABLE CONFIGURATION;
On PRIMARY ROOT
odacli register-dataguard
On STANDBY ORACLE-
Verify " alter database recover managed standby database disconnect; " is running.
If you can't do it because xxx needs more recovery
On STANDBY ORACLE-
rman target /
recover standby database from service sid;
restore database from service sid;
sqlplus / as sysdba
alter database recover managed standby database cancel;
alter database recover managed standby database until consistent;
alter database recover managed standby database until SCN 14841932117759;
alter database recover managed standby database until SCN 14842485120952;
alter system set db_recovery_file_dest_size=2T;
alter database flashback on;
alter database open read only;
alter database recover managed standby database disconnect;
over and over again and again until it works.
JWR
Re: Move Order Pick Slip status is showing as Unallocated
Hi
Did you specify a Source Subinventory when creating the Move Order? You need to allocate the material for move order. You can do it manually by querying the move order created and clicking the Allocate button in Transact Move Order form or you can check Auto Allocate Approved Lines parameter to Yes when you ran the Move Order Pick Slip report.
Hope this helps.
Thanks,
Rahul
Re: Is there a way to calculate a percent discount on a purchase order?
Hi Nick,
Thanks for the info and documentation. I tested and was able to apply a 5% discount to each PO line. But there's nothing on the online PO itself that indicates a price adjustment was made, except by drilling down into the Schedule for each line and clicking on the Price Adjustment icon.
There's also nothing on the printed copy of the PO. It just shows the adjusted prices, without any mention of an adjustment being applied or what the original base prices were.
It also will apply the adjustment to every PO that is created from the contract when we only want it to apply to POs over a specific dollar amount.
What I'm looking for is how to apply a 5% discount to POs over $300. Is there a way to do that? I don't think there is an automatic way for that to happen but wanted to confirm. It seems my only option is to manually add a line onto the PO for a negative dollar amount.
Re: Adding multiple email recipients CreateRequest of Outbound Communications Manager BS
Hi @Ameen Dehaliah,
Okay, I have read again your request.
we have a workflow (Step: BS.Outbound Communications Manager | Method.CreateRequest) where we dynamically select the email recipient depending of the project status and overwrite the recipient from email template (Recipient Group), either the approver or the owner.
For implementing you have to use the CreateRequest method parameter "TestAddress: Recipient address (for the To line) to use for testing. This address overrides all other addresses". See .
I hope, it helps. You can contact me if you have any question. And yes, it works, i.e., the recipient group is overwritten.
Regards,
Jose Luis
Re: ODACLI configure-dataguard fails around step 7 Restore missing archivelog (Primary Site)
I don't think there's any workaround on the old version, at least using the oda commands.
You can configure it using dgmgrl on that version though.
Koop
Re: Script see who added a responsibility or removed end date of responsibility to user
Oops, in the query
ug.last_updated_by
should be
ug.last_update_date
Apologies for that, was typing along and wrote the wrong thing.
Thanks,
J
Re: Script see who added a responsibility or removed end date of responsibility to user
Hi Linda,
This query should work. It will prompt for the user name and the responsibility name Be aware that it can only show who last updated it. So if the responsibility has been taken away again, you will see the person who took it away.
select u.user_name, t.responsibility_name, ug.start_date access_began, ug.end_date access_ends
, ug.last_updated_by access_change_date, uc.user_name access_updated_by
from apps.fnd_user_resp_groups_all ug, apps.fnd_responsibility_tl t
, apps.fnd_user u, apps.fnd_responsibility r, apps.fnd_user uc
where nvl(ug.end_date,sysdate+1) > sysdate -- user has the responsibility as of today
and nvl(r.end_date,sysdate+1) > sysdate -- responsibility itself is not end-dated as of today
and nvl(u.end_date,sysdate+1) > sysdate -- user is not end-dated as of today
and ug.responsibility_id = t.responsibility_id
and ug.responsibility_application_id = t.application_id
and t.responsibility_id = r.responsibility_id
and t.application_id = r.application_id
and ug.user_id = u.user_id
and uc.user_id = ug.last_updated_by
and u.user_name = '&USER_NAME'
and t.responsibility_name = '&RESPONSIBILITY'
If this works, please check Yes where it asks if this answers the question.
Thanks,
J