วีดีโอ

SQL*Loader: Release 19.0.0.0.0 - Production on Wed Nov 20 18:09:27 2024 Version 19.24.0.0.0 Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved. Control File: /u01/APPLTOP/instance/ess/rfd/7356284/DooOrderSalesCreditsInt.ctl Using character length semantics. Data File: /u01/APPLTOP/instance/ess/rfd/7356284/out/DooOrderSalesCreditsInt.csv Bad File: /u01/APPLTOP/instance/ess/rfd/7356284/out/7356284_bad.txt Discard File: /u01/APPLTOP/instance/ess/rfd/7356284/out/7356284_discard.txt (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 50 Bind array: 250 rows, maximum of 1048576 bytes Continuation: none specified Path used: Conventional Table DOO_ORDER_SALES_CREDITS_INT, loaded from every logical record. Insert option in effect for this table: APPEND TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- --------------------- SOURCE_TRANSACTION_ID FIRST 200 , O(") CHARACTER SOURCE_TRANSACTION_SYSTEM NEXT 120 , O(") CHARACTER SOURCE_TRANSACTION_LINE_ID NEXT * , O(") CHARACTER SQL string for column : "NVL(:SOURCE_TRANSACTION_LINE_ID, '_fomNullValueId')" SOURCE_TRANSACTION_SCHEDULE_ID NEXT * , O(") CHARACTER SQL string for column : "NVL(:SOURCE_TRANSACTION_SCHEDULE_ID, '_fomNullValueId')" SOURCE_TXN_SALES_CREDIT_ID NEXT 200 , O(") CHARACTER SALES_PERSON_ID NEXT 72 , O(") CHARACTER SALES_PERSON NEXT 1440 , O(") CHARACTER SALES_CREDIT_TYPE_CODE NEXT 4000 , O(") CHARACTER SALES_CREDIT_TYPE_REFERENCE NEXT 4000 , O(") CHARACTER PERCENT NEXT * , O(") CHARACTER SQL string for column : "fun_load_interface_utils_pkg.replace_decimal_char(:PERCENT)" CREATION_DATE EXPRESSION SQL string for column : "systimestamp" LAST_UPDATE_DATE EXPRESSION SQL string for column : "systimestamp" OBJECT_VERSION_NUMBER CONSTANT Value is '1' CREATED_BY CONSTANT Value is 'SCM11.STUDENT' LAST_UPDATED_BY CONSTANT Value is 'SCM11.STUDENT' LAST_UPDATE_LOGIN CONSTANT Value is '275C8BAF4257F638E063E462F00AF643' LOAD_REQUEST_ID CONSTANT Value is '7356274' value used for ROWS parameter changed from 250 to 96 Record 1: Rejected - Error on table DOO_ORDER_SALES_CREDITS_INT, column SALES_PERSON_ID. ORA-01722: invalid number Record 2: Rejected - Error on table DOO_ORDER_SALES_CREDITS_INT, column SALES_PERSON_ID. ORA-01722: invalid number Table DOO_ORDER_SALES_CREDITS_INT: 0 Rows successfully loaded. 2 Rows not loaded due to data errors. 0 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Space allocated for bind array: 1045536 bytes(96 rows) Read buffer bytes: 1048576 Total logical records skipped: 0 Total logical records read: 2 Total logical records rejected: 2 Total logical records discarded: 0 Run began on Wed Nov 20 18:09:27 2024 Run ended on Wed Nov 20 18:09:28 2024 Elapsed time was: 00:00:00.48 CPU time was: 00:00:00.10

sir i have done same process but i am getting this error

Thank you so much for your videos Sir Can you post the Second video of "Costing Transaction Verification for Miscellaneous Receipt" because you uploaded the third video twice

How to configure flat rate shipping charge for the entire order?

can you paste the link for next session on drop ship

How can we get access to demo access?

Hi Mars, I followed your instructions to setup service provider BU in Oracle Fusion 24B. My use case is allow BU1 to buy for other BUs. When I try to create an Order, in Create Order Page I can't view anyone supplier when I use one of configured requisitioning BU, but I can find it when try to create order with same Purchasing and requisitioning BU (Provider). Could you help me to solve this issue? any suggestions?

How to give multiple roles to 1 user at once in Oracle Fusion??? Also, how to give data access to user roles at once in oracle fusion?? Please revert asap.

can i get next continuous video.

Thanks for this video. it is very helpful for me.

this pricing video seems incomplete, can you please upload full pricing video.

Part1 link please

Thank your for explaining clearly :)

Thanks

Good Information

He is very good trainer, his way of explanation awesome and he explained each and every topic with realtime scenarios

All your videos are awesome! Really great helpful all scm peoples

Promo SM

While you are scheduling the job for import requisitions after Loading interface files, you said requisition BU will get automatically populated but in my case it's not getting populated and can't see it in the drop down as well. Any suggestion on how to get this

Can the invoicing be done from supplier portal for consignment inventory.

Could you please add Cycle count video as well

how to get the inventory item with images in purchase requisition page? it is not coming even though we have given image at item level

Nice

Hi All, When I try to update the EFF for sales orders when Line status is closed and Header status is processing it is working fine, But for some Return orders giving an error like the fulfill line is closed you can't update the line, this error I am getting only for return order and for specific return orders only like 5-6 in 10 Orders, and for normal orders I am able to update. Same thing happened through REST API also. Any idea on this why we are getting likt that for specific orders? I don't see any difference between success and failure orders in the tables. Please share your thoughts.

Please allow legends

Thank you for detailed explanation !!

Let suppose while defining the work flow , we will choose the same sequence number for both approver , then is this follow the parallel approval?

Good concept..

Great Job sir... Very nicely u have explained

Does Subinventory Transfer Transaction create Accounting Entries?

hello sir , i want to be trained on oracle scm....is there any platform so that i can connect wit you?

bill to account number does not appear

Quando vcs terão novos treinamentos?

Thank you.

Sir how to upload attachment via Requistion FBDI

Hi. Why shouldn't we use common reference data set for the cost accountant role?

Not able to select item in mass item replacement page

It was said that tomorrow only the report will work right. Why is that so? Is it bcoz you had given any date of today

Why are we doing that process create consumption advice

seteshparambil dhivaakaran , thank you sir.

i will

siva send me your status video in whatsapp.

mutheee!!!!!!!!! ineee neethambleeeeeeee💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥💥

We are creating custom orchestration process for no reservation but still items are getting reserved after creating the pick wave I want remove the reservation for after create pick wave is it possible?

My screen or your screen OMG"" HAAHAHAH

Nice

Nice teaching sir pls upload oracle cloud technical vedios

Thanks !!!

Thank you very much but I didn't find this video in the Channel "How to record entry costing module Miscellaneous Receipt Transaction" Can you upload the second video, because there are duplicates in video number 2 and 3