Best Of
Re: new MOS - how to find BUGs?
Hi @Jim Dickson ,
There are a couple of differences.
You've actually linked categories from two separate Oracle communities. The first is from My Oracle Support Community, which is a set of forums in which Oracle support customers of on-premise applications and technologies can get help from Oracle's support staff, as well as network with other peer users throughout the world who may have guidance to offer. The community is heavily moderated and is considered an extension of the Oracle support portal. Members here must have a licensed support association with Oracle.
The second link you provided is to the open-access Developers community. Topics in that community tend to be of a more technical nature and generally occur between external implementers of Oracle products, with some involvement from Oracle product development, IT managers, etc. There is no restriction on membership, and the forums are lightly moderated.
Hope this helps.
Jennifer B
Re: Customer Balance Generation - By Ship To
Thank you for your update Muhammed, and nice to 'meet' you via the SR details ! We will make the changes you have listed, and we understand you will research the creation of a custom report to handle the requirement.
We look forward to working with you in both the Support Community and via Service Requests.
With regards,
-Matt
Re: Keeping and entering DFF values in Projects Funding screen after migrating to G-invoice projects SU
Hi,
You can set profile option: PA: Manage Revenue Budget Manually = Yes. This will allow user to manually enter and confirm funds. You can then enter DFF.
Thank you,
Christine
Re: Query assistance needed on view with large partitioned/sub-partitioned table
Also note on the "data type" as chosen: you can't change it anymore, but I would have done this:
- first the year, since if you order, you can order on year - but you can't order on month as the year is further in the value only (in your usage)
- use month numbers (01, 02. 03, …) instead of names, as also here you can order on numbers, not on names (as it happens to be that month sequence inside a year is not alphebetical). But also : a named month is also language dependent, and numbers are not.
- Optionally, whet you can do is this (and exmple for the current month) 2025-07-[july2025] You can order this AND you can see the name in a human readable manner, because the ordering happens to the left of the value (as is typical for words, even if we filled them with numbers), and when the sorting is actually completed (at the month number), you can enter any letter/number/character after that
Maybe even better would have been two columns, one with year only, one with month only, and make that a combined Primary Key and also the base of partitions. Maybe you could partition per year, and inside sub-partition per year and month. And then you can still sub-partition more.
Mr. C
Re: Query assistance needed on view with large partitioned/sub-partitioned table
Without knowing all the columns in detail it's best to use the actual same filter in the queries as those used in the partitions … and no functions ! Exact string matches … For that I'm not sure if using LIKE is even a good option. Given there are only 12 months in a year, and you know the values of these 12 months I would test if all goes faster if you name the months literally. OK, coding becomes much more complex, but … partitioning is about performance. If you're in that corner, speed is your objective.
Mr. C
Re: Is there is anyway to update "Allow Charges" in Project Task throug backend
Hi Abdul Hameed,
You can use PA_PROJECT_PUB.UPDATE_TASK , parameter: P_CHARGEABLE_FLAG .
Thank you,
Christine
Re: Work order demand not respected as demand
Hi Aji,
In Workbench, Please query for the Order Number = F/MRP/22 and Org = UJA:MPR and check the Action column.
If Action = Cancel then Work Order Demand will not be considered.
Please don't add any other filter.
Thanks
Re: About statistics on PDB$SEED before upgrade
The OP clearly states there is a need, not sure why you're challenging that, but if you find some actual arguments, let us know.
Mr. C
Re: Question about "19.28 release Update Known Issues (Doc ID 19202507.9) # 1.13 Incorrect results ..."
Well, yes, until a patch is created which fixes that issue. That patch being another RU, or a one-off, or whatever.
You could say that you'd only need it on the databases that use the mentioned failing feature … but that may be a tough call and thus it may be smarter to just set the parameter on all databases. Until, as said, there's a patch to fix it. Don't assume it's the next RU.
Mr. C
Re: Accumulated Depreciation calculated for assets having depreciation check off
Hi,
I advise you to raise a Service Request. It's difficult to say if you can revert back to the previous financial information without reviewing the asset trace output file.
Basically, if you did not perform any AMORTIZED adjustment on this asset, it's possible.
Regards,
Catalin