Posts

SCM

SCM Cloud Procurement Order management SupplyChain  Planning Manufacturing(transactions are done at manufacturing org level) Work Definition(Bill of Material) Close Work Order Transfer transactions to Costing Transfer transactions to Inventory  Work Execution Manufacturing Organization Manage Work Order UnReleased workorders are from Planning cloud Review Dispatch list of workorder show workorder, Materials & resources/items used to complete workorder Inventory & Costing Intercompany Transaction People move from high tax area like California to Texas for savings. Similarly companies use tax advantages by moving to Asia, Hongkong, Malasia. Supply Chain Financial Orchestration OR Intercompany Transaction Customer places order in US where sales Organization is present Product will be sourced from South Korea and shipped to US. Financial Transaction(on paper) will be routed as if it has taken from Hongkong to US to save Tax.  Setups Trade relationships Transfer pricing(Hongkong wil

OTM

OTM- Transportation planning System. It integrates and streamlines Transportation planning Transportation execution Freight payment Business Process automation What is in trucks Where are trucks When to deliver which shipments are running late which routes are profitable Concepts & Functionality OTM is integrated with Order Management(or external order processing system) which feeds sales orders to OTM.  Phases Plan  Optimize, route & Consolidate Order consolidation, multi-stop truck load, pooling, cross-docking, continuous moves, Multi-mode(internation) Multi-leg transporation has more than one itinary/trips/stops Execute Monitor in-transit shipments Settle Automate freight payment & customer billing Shipper Review shipment request from OM or ERP Create Tender Publish tender to service provider Service provider approves tender (isp) picks up the shipment tracking of shipment send notifications until the shipment is delivered Process Flow ERP Sales order created in Order Ma

API for Reports & UCM

 SOAP UI https://fusovmsmc84-fa-ext.us.oracle.com/xmlpserver/services/v2/ReportService?wsdl runReport Remove all other attributes apart from paramname & values, format, <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://xmlns.oracle.com/oxp/service/v2">    <soapenv:Header/>    <soapenv:Body>       <v2:runReport>          <v2:reportRequest>                <v2:attributeFormat>pdf</v2:attributeFormat>             <v2:parameterNameValues>                <v2:listOfParamNameValues>                   <!--Zero or more repetitions:-->                   <v2:item>                      <v2:name>?</v2:name>                      <v2:values>                         <!--Zero or more repetitions:-->                         <v2:item>?</v2:item>                      </v2:values>                   </v2:item>                </

Security

 Securing ESS Jobs When a custom ESS job is created a Function Privilege with same name will be created implicitly Create a Custom JOB role and add the new custom ess privilege that is created Add the custom job role to USER Submit Retrieve Latest LDAP Changes job  BIP Security Analytics -> Browse Catalog BIP Template -> More -> Permissions -> add -> Add user Following user will have following permissions. To modify More -> Permissions and change BI Administrator BI Author BI Consumer System Administrator(User)   ---- select /*3-25921486741*/ Distinct bu_id, bu.BU_NAME, u.username, role.ROLE_NAME, role.START_DATE_ACTIVE, role.END_DATE_ACTIVE, role.ACTIVE_FLAG from fusion.hz_parties h, fusion.per_users u, fusion.per_all_people_f f, fusion.FUN_ALL_BUSINESS_UNITS_V bu, fusion.FUN_USER_ROLE_DATA_ASGNMNTS role where 1=1 and h.user_guid = u.user_guid and u.person_id = f.person_id and sysdate between f.effective_start_date and f.effective_end

SOAP Services

Payables Soap Services External InvoiceInterfaceService https://fusovmsmc84-fa-ext.us.oracle.com/fscmService/InvoiceInterfaceService?wsdl  submitInvoiceImport submitInvoiceImportWithSource   createB2BInvoice createInvoiceInterface   createInvoiceInterfaceWithAttachments   updateInvoiceInterface getSupplierRejections getInvoiceInterface findInvoiceInterface InvoiceService https://servername/fscmService/InvoiceService?WSDL cancelInvoice createURLAttachment insertSingleHold releaseSingleHold getInvoiceInstallments updateInvoiceInstallments getInvoiceStatus findInvoiceStatus SetupService  https://servername/fscmService/{servicename}?WSDL Internal  InvoiceInterfacePrivateService InvoiceApprovalBCService Services Name xml type starting api crux erpintegrations  

IDR/Imaging

IDR recognizes currency from image file in following order   Defaulting of currency from PO has the highest precedence Recognize the currency symbol (e..g €) available on the Image If currency symbol is not available then look for currency code (e.g. EUR) If no currency symbol/code found on the image then use the currency from supplier address (country) If IDR did not predict any currency, then currency setup at supplier site   would be used. If IDR did not predict any currency, and currency not setup at supplier site level, then it would use the currency setup at business unit level. Duplicate invoices:  Routing attribute 5 corresponds to Doc ID.  Doc id is unique ID for invoice in a attachment. APXIDRINT  Maintain Intelligent Document Recognition Service for Payables  SuppliersExtractJob.java Hybridization Cimification Import process Schedule with IMAGE source will submit Supplier push job after migration date Case 1: Source = IMAGE && No IDR setup data && Migration