Best Of
Re: Oracle 12 Spatial – How to Set Up NTv2 Grid for GDA94 to GDA2020 Transformation
To enable NTv2 grid-based transformations (such as from GDA94 to GDA2020) in Oracle Spatial (Oracle Database 12c),
you need to ensure that Oracle Spatial can locate and access your NTv2 grid files (*.gsb). Here’s how you can do this:
Oracle Spatial looks for datum shift (grid) files in the directory specified by the SDO_COORD_ATR_PATH initialization parameter.
If this parameter is not set, Oracle will use its default directory ($ORACLE_HOME/md/demo/coordinate/), but setting the parameter is best practice.
Place your .gsb files in a directory accessible to the Oracle server, e.g.:
/u01/app/oracle/product/12.2.0/dbhome_1/md/demo/coordinate/
or a custom directory (preferred for custom files), e.g.:
/u01/app/oracle/ntv2_grids/
Set the SDO_COORD_ATR_PATH database initialization parameter to point to this directory.
You can set this system parameter (as SYSDBA):
ALTER SYSTEM SET SDO_COORD_ATR_PATH = '/u01/app/oracle/ntv2_grids/' SCOPE=SPFILE;
Restart the database if you set the parameter using SPFILE or pfile.The Oracle RDBMS user must have read access to the grid files and the directory.
Oracle Spatial transformations must refer to the NTv2 transformation by name, referencing your grid file in the transformation definition.
Check the table SDO_DATUM_TRANSFORMS to see if your transformation is already defined, or create a custom transform referencing the grid file.
Thanks
Swati A
Re: Cascading of existing Style Supplier onto a new SKU is a base functionality?
Hi User_B13BC,
Yes, this is standard out-of-the-box MFCS behavior.
The parameter CORESVC_ITEM_CONFIG.CASCADE_IUD_ITEM_SUPPLIER determines whether inserts, updates, or deletes on item/supplier details should cascade to child items. When this parameter is set to 'N', propagation is disabled, meaning each SKU will only have the suppliers explicitly assigned to it.
Thanks,
Atanu
Re: Concurrent request completes without error but cannot view output or log file in the browser.
We are having the exact same problem, and it also started today Jan 31 2023. No configuration changes, nothing we did that might have triggered the problem. A bounce of services didn't help. We are running AutoConfig now, as you found, to see if that helps us.
PhatDBA
Re: Ability to Push New Cost Code Rows from Template to Existing Project Shells
Thanks Jeff! This is useful. I used Create Code but wasn't aware of the Sort Cost Sheet APIs.
Nasim N
Re: Ability to Push New Cost Code Rows from Template to Existing Project Shells
Hi Nasim,
I agree that this would be a great enhancement to Unifier.
If you're looking for an immediate solution, I've suggested to other customers in the past to look at our REST APIs for this exact purpose. You can use tools like OIC or Postman to iterate through all your project numbers.
Check out:
- Create CBS Codes (https://docs.oracle.com/cd/G18097_01/English/Integration_Documentation/integration/10293166.htm) as
- Sort Cost Sheet (https://docs.oracle.com/cd/G18097_01/English/Integration_Documentation/integration/10301291.htm).
Jeff
Re: Calendar Groups
Hello Kimberly,
Yes, you can use the Calendar Group - Auto Creation page (GP_AUTO_CAL_GRP) to create calendar groups using existing periods and calendars newly.
Navigation:
Global Payroll & Absence Mgmt > Absence and Payroll Processing > Define Calendars > Calendar Group - Auto Creation
https://docs.oracle.com/cd/G40410_01/hcm92pbr53/eng/hcm/hgpy/DefiningAutomatedCalendarGroups.html
Re: CRM Activity Email issue
Thanks for your help and we were able to get it to work
Re: How are you integrating multiple P6 schedules in OPC and importing updates without losing logic?
Our contracting with our GCs is different. Design-assist and they work off their own P6 platforms and submit weekly updates. We import into our OPC.
This worked well until we onboarded a cGMP P6 scheduler for our new more complex project who is use to integrating P6 schedules in P6 EPPM (and using IPD contracting structure where multiple stakeholders work in the same P6 environment). He finds OPC a bit awkward using Program to integrate multiple schedules. However, the solution proposed appears to work. We will tie the Mechanical Completion by System ties in the GC schedule once and send it back to them to keep updating. Then we can use that to import updates back into OPC and our integrated schedule. It will experiment with this and can report any bugs I see.