Cloud
Discussion List
-
Choice of equipment based on size and packages instead of volume.Hi, currently, the choice of equipment in OTM takes into account the volume of the goods with the volume of the equipment, choosing the smallest. This implies that if th…davide.mincione 61 views 11 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
Convert the column in the report to a numeric datatype from VARCHAR.Summary: I have a requirement: the output of the report, including columns like net_amount_due, should have a data type in number format after extraction in excel. Conte…DataWhiz 51 views 8 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Fusion Based SCM Approval workflow is required in OTMSummary: Fusion Based SCM Approval workflow is required in OTM Content (please ensure you mask any confidential information): Dear Team, We are unable to create the Fusi…Sravan Prasad B V 31 views 4 comments 5 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
Can I link events with stops events automatically ?To explain the scenario we can say for example that we are having 2 quick code events which are: -Arrival at stop -Start Loading Now we need to link the event "Start loa…Ahmed Matar 21 views 6 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management -
Import Export is corrupting the dataWe have below requirement and since the count of data was high so we tried to import the data from CSV and we are able to do so. But that corrupted or data and system is…Pinku_Burnwal 21 views 3 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
What are the standard limits with using .zip file based CSV Import in OTM/GTM 24BSummary: We are doing a GTM Migration from On Premises 643 to SaaS 24B and we have observed that the .zip import utility (Clubbing more than one CSV in zip file and usin… -
Best way to migrate Data/setup from OTM on-prem to OTM/GTM CLoudSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Tanmay Singh 93 views 1 comment 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
ICS-10064 error when calling a stored procedure with the ADW adapterContent I'm having trouble invoking a stored procedure using the ADW adapter in a scheduled orchestration. My procedure is very simple: create or replace PROCEDURE proce…
-
Dynamically passing the decryption key in the stage activity decrypt File operationSummary: How to dynamically pass the decryption key in the stage activity decrypt File operation. Content (please ensure you mask any confidential information): How to d…
-
Upgrade strategy/experience OIC Gen-2 to Gen-3Summary: I am curious what your upgrade strategy/experience is from OIC Gen-2 to Gen-3. Content (required): We are use OIC Gen-2 to build our integrations in, we have ma… -
ALLOW DATA DICTIONARY FOR DBA ADMIN ROLE ONLYSummary: ALLOW DATA DICTIONARY FOR DBA ADMIN ROLE ONLY This Optional Feature, when enabled, allows you to limit access to the data dictionary to users with a DBA ADMIN r…Sindhu Raja-Oracle 71 views 3 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
OTM Cost Allocation not working as expectedSummary: I have requirement to allocate the shipment cost on to orders. I have multistop shipment where i allocate the cost on the basis of volume carried distance. When…Mrugen Sunil Munshi 21 views 3 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Can I manually creates Order Release and linked it with order base after creation ?Summary: Can I manually creates Order Release and linked it with order base after creation ?Ahmed Matar 21 views 8 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Error while activating Integration After OIC Gen 3 UpgradeSummary: We are getting activation failure for few integrations post OIC Gen 3 Upgrade Content (please ensure you mask any confidential information): Hi All, Hope you al… -
Functional currency on invoice not visible on invoiceSummary: When invoice cost is modified by user post invoice creation, it doesnt reflect functional currency for lines as well as at invoice header cost. User adds/modify…Naresh Pulluru 31 views 9 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
USE REPORT DATABASE FOR BULK REPORT GENERATIONSummary: Please explain in detail about the optional feature introduced in 24C, how its used, how it differs with existing setup Content (please ensure you mask any conf…Sindhu Raja-Oracle 11 views 2 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
How to fetch invoice line item seq when any new line added/modified on invoice?Summary: When any new line added or existing line modified on invoice, want to fetch LINEITEM_SEQ_NO for invoice line which is added/modified. Based on that add/update i…Naresh Pulluru 41 views 8 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
How can we query the ARCHIVE data base in cloud to check the purged data?Summary: After purging the data, OTM moves the data from GLOGOWNER schema to ARCHIVE schema. How can we query the ARCHIVE data base in cloud to check the purged data? Co…Lakshmana Kodukula 21 views 3 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
Xslt 2.0 to remove duplicates in oicSummary: What is the fastest possible way to use in xslt 2.0 in oic gen 3 to remove the duplicates from the file size of 17 MB? I have used for-each-group function to re…
-
Can I modify in Accessorial Code Screen ?I need to modify in Accessorial Code screen to change fields name for example but I tried searching in Manage Layout for the Accessorial Code screen but I didn't found a…Ahmed Matar 11 views 3 comments 0 points Most recent by Nilesh Kumar Mal-Oracle Transportation Management
-
How to include multiple cross-docking into itinerarySummary: When shipments are generated, OTM is generating options to go via only one cross-dock per itinerary. We have multiple cross-docks in Europe and we want to allow… -
Is there an undocumented BLOB size limit on db.xml imports?Summary: I am trying to upload BLOB data to otm cloud via the DBXMLServlet. This works quite well until the size of the BLOB exceeds about 880K, at which point the servl…blasleyknotm 151 views 27 comments 0 points Most recent by Islam Bahgat-Oracle Transportation Management
-
How to identify special characters other than 0-9 and A-Z in autocomplete ruleSummary: How to identify special characters other than 0-9 and A-Z in autocomplete rule Content (please ensure you mask any confidential information): How to identify sp…
-
How to use Bulk Import option in Snowflake adapter in OICSummary: I am trying to load bulk data into Snowflake tables from Fusion using OIC, I see in the documentation we have an option to bulk import data using internal or ex…
-
Why delete UE was not able to capture records that have been deleted via HDL?Summary: I have deleted supervisor records via HDL but the HCM extract that uses delete UE is not able capture the deleted records.
-
How to add EVENT_END_DATE to IE_SHIPMENTSTATUS tableSummary: How can I add EVENT_END_DATE to the IE_SHIPMENTSTATUS table? Please help me by providing the XML and XSD files. Content (please ensure you mask any confidential…
-
User preferences no longer applying to majority of usersSummary: As of 15:42 CST today, manage user access- user preferences at user role seem to no longer be applying to the majority of our dispatch users. We have specific p… -
how to replace schema name in db procedure invocation in OIC GEN3Summary: We have a requirement where the schema name need be changed when we move the code from Non-prod to prod instance. Please let us know how the schema name change …
-
ESS_REQUEST_HISTORY table has no report history which is scheduled 3 months back from system dateSummary: Hi, Table ESS_REQUEST_HISTORY do not have overall report history. The table has data which is scheduled in 3 months. Is there any other tables , to store full r…Ranjith1166 41 views 2 comments 0 points Most recent by Ashok Kalidindi-Oracle Transportation Management
-
Hi Team, i am unable to upload public sinigng key in to OICS console, giving error invalid keySummary: Hi Team, i am unable to upload public sinigng key in to OICS console, giving error invalid key Content (please ensure you mask any confidential information): Ve…