Best Of
Re: DBMS_AUDIT_MGMT.INIT_CLEANUP failed with "ORA-01403: no data found"
Got a solution for the issue.
Before I remove the customized audit tablespace, use DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION to set the tablespace back to the default SYSAUX. Then I can disable audit feature as normal.
After that, if the audit feature is enabled again, I can do init_cleanup successfully without issue.
Thanks,
Iris
Re: query to find specific asset group assigned to different orgs
In case the system items KFF has more than one segments, please use:
select msik.concatenated_segments "Asset Group", mp.organization_code
from mtl_parameters mp, mtl_system_items_kfv msik
where mp.organization_id = msik.organization_id
and msik.eam_item_type = 1
and msik.concatenated_segments like '&Asset_Group'
order by 1,2;
BR,
Florin
Re: How to cancel a particular line in a sales order through EDI.
Hi,
Thanks for the instant feedback, however when I look at Oracle support Doc ID 2246982.2 in the Limitation Tab, it is mentioned as below
Limitations
Not all transactions which can be done using P4210/P42101 will work in the batch process of R47011. Some limitations are detailed below.
| Transactions | Explanation |
|---|---|
| Update of exiting sales order (F4201/F4211) | R47011 shall not update exiting order, though you map the primary key of sales order and action type (C - Change) c.f., Document 1340444.1 - E1: 47: Inbound Purchase Order Change Edit/Update (860/ORDCHG) |
Also we are using R47011 for the Sales Oder creation through EDI. Not sure would the "Inbound Purchase Order Change Edit/Update (860/ORDCHG)" R47131 would work for change or cancel line of F4211.
2895622
Re: How to cancel a particular line in a sales order through EDI.
Doc ID 2246982.2 in the Limitation Tab is merely stating the R47011 Inbound 850 will only create sales orders and not update them with changes. The referenced document Document 1340444.1 - E1: 47: Inbound Purchase Order Change Edit/Update (860/ORDCHG) is the one you want to use to make updates/changes to the document.
The processing option tab on the R47131 net change tab states the following:
1. Enter a '1' to have the changes applied to the F4201 and F4211 files. If left blank, only a report is generated to show the proposed changes.
This program should be the one you want.
Re: How to remove components in template section during configuration.
Hi Team,
Thank you for reaching out to Oracle Communities. We will arrange for an expert to review your post and work with you at the earliest.
Regards,
Satheesh Kumar N
Re: Congratulations to our Most Valued Contributors (MVCs) for 2024!!
I am happy to receive the award !!
I hope to contribute to the community so that I can continue to receive the award this year.
asahide
Re: How can i start index monitoring on active data guard? Is it possible to monitor indexes in ADG?
I think v$object_usage is the right view - this is available as long as the instance with the ADG is running and after a db restart it is empty again - but it does only show entries for the connected user.
You can query that for all users as System also, but you need to build your own select:
SELECT U.NAME OWNER, IO.NAME INDEX_NAME, T.NAME TABLE_NAME, DECODE(BITAND(I.FLAGS, 65536), 0, 'NO', 'YES') MONITORING, decode(bitand(ou.flags, 1), 0, 'NO', 'YES') used, ou.start_monitoring, ou.end_monitoring from sys.user$ u, sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou where i.obj# = ou.obj# and io.obj# = ou.obj# AND T.OBJ# = I.BO# and u.user# = io.owner#;
Re: oracle 19c remote listener ssl problem
Hello tbela,
Can you clarify more on the note of "remote listener"? Do you mean a connection between a remote client with the DB listener? Which platform is the DB running on and what is the full version number of the DB?
Based on the "listenerssl" entries do you intend to have only the "tcps" address and not have the 'tcp' and/or 'ipc' addresses? Why 2 entries of "Wallet_Location"? Does the environment also has the GI? If so then the 'sqlnet.ora' entries are to be setup both under the GI home and DB home.
Hope this helps -- Cheers -- Suresh
Re: Instead of disposing and creating new one in another unit, can we transfer asset from one to another
Hi Vamshi HM.,
The concept of asset transfer from one Entity/OU/book to another doesn't exist in Oracle Asset.
The only available workaround is the one you already mentioned.
Regards,
Catalin