Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 11 Vote(s) - 2.73 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Credit Check Loop Hole - Logistics team can ship infinite amount of goods
02-03-2014, 09:37 PM, (This post was last modified: 02-03-2014, 09:41 PM by PhilipS.)
#1
Credit Check Loop Hole - Logistics team can ship infinite amount of goods
Hi,

I need to seek the attention of credit experts out there and give your opinion on this; potentially is a big issue for Oracle, but would like input from Credit Management people.
  • In the credit check rules there is shipping horizon days, this allows for future orders to be excluded from credit exposure value.
  • Our company is set to 22 days
  • We have credit check set to check all orders at pick release - after pick release there is no further financial system control, goods normally delivered within 2 days, sometimes same day.
  • We supply to up to 500 national locations for a single customer and each shipment has separate invoice and normal value is $500 to $2000 USD each shipment
  • So we a receive a national order which splits in our system to 500 separate sales orders, the order has a scheduled shipping date of 30 days from now.
  • The customer has not paid for two months and the available credit limit is approx $50k, the orders we received is valued at approximately $700k but does not go on credit hold, as the credit exposure calculation excludes it as the order scheduled shipping date is over 22 days.
  • The customer contacts us a few days later and requests urgent shipment for the $700k order (which is scheduled for 26 days time)
  • The Order management/logistics team pick release the orders and then dispatch all orders to the customer
  • Oracle finalises its processes overnight and the next day the account balance exceeds the credit limit by $650k because the $700k was invoiced.
So we have account balance that is in excess of the credit limit by a sizeable amount - no orders went on hold - thoughts? Is oracle malfunctioning?
Reply
02-07-2014, 07:01 PM,
#2
RE: Credit Check Loop Hole - Logistics team can ship infinite amount of goods
Hi PhlipS
You can control the credit Days Control through the Credit Check Rules Setup.
Navigation Path: Order Management > Setup > Rules > Credit
Fields to Control: Days to Honor Manual Release
Setup Screen Shot: Attached
More Explanation : You can give number of days in the 'Days to Honor Manual Release' which you want to be work after the Order has been released for credit hold. For example if you will give 2 days then the shipping department can perform the n number of shipment against this order without any further hold.
If you want to control the credit check on each and every delivery then simply uncheck the 'Override Manual Release' field.

Thanks & Regards,
Irfan Arshad
Reply
02-07-2014, 10:31 PM, (This post was last modified: 02-07-2014, 11:03 PM by shirfan.)
#3
RE: Credit Check Loop Hole - Logistics team can ship infinite amount of goods
   


(02-07-2014, 07:01 PM)shirfan Wrote: Hi PhlipS
You can control the credit Days Control through the Credit Check Rules Setup.
Navigation Path: Order Management > Setup > Rules > Credit
Fields to Control: Days to Honor Manual Release
Setup Screen Shot: Attached
More Explanation : You can give number of days in the 'Days to Honor Manual Release' which you want to be work after the Order has been released for credit hold. For example if you will give 2 days then the shipping department can perform the n number of shipment against this order without any further hold.
If you want to control the credit check on each and every delivery then simply uncheck the 'Override Manual Release' field.

Thanks & Regards,
Irfan Arshad

Hi
Further to this, if your shipping horizon days are 22 then it's mean that your total exposure includes only uninvoiced orders scheduled to ship within 22 days of the current date. Orders scheduled to ship after 22 days are not included.
Regards,
Irfan Arshad
Reply
10-16-2019, 06:18 AM,
#4
RE: Credit Check Loop Hole - Logistics team can ship infinite amount of goods
audiobookkeepercottageneteyesvisioneyesvisionsfactoringfeefilmzonesgadwallgaffertapegageboardgagrulegallductgalvanometricgangforemangangwayplatformgarbagechutegardeningleavegascauterygashbucketgasreturngatedsweepgaugemodelgaussianfiltergearpitchdiameter
geartreatinggeneralizedanalysisgeneralprovisionsgeophysicalprobegeriatricnursegetintoaflapgetthebouncehabeascorpushabituatehackedbolthackworkerhadronicannihilationhaemagglutininhailsquallhairyspherehalforderfringehalfsiblingshallofresidencehaltstatehandcodinghandportedheadhandradarhandsfreetelephone
hangonparthaphazardwindinghardalloyteethhardasironhardenedconcreteharmonicinteractionhartlaubgoosehatchholddownhaveafinetimehazardousatmosphereheadregulatorheartofgoldheatageingresistanceheatinggasheavydutymetalcuttingjacketedwalljapanesecedarjibtypecranejobabandonmentjobstressjogformationjointcapsulejointsealingmaterial
journallubricatorjuicecatcherjunctionofchannelsjusticiablehomicidejuxtapositiontwinkaposidiseasekeepagoodoffingkeepsmthinhandkentishglorykerbweightkerrrotationkeymanassurancekeyserumkickplatekillthefattedcalfkilowattsecondkingweakfishkinozoneskleinbottlekneejointknifesethouseknockonatomknowledgestate
kondoferromagnetlabeledgraphlaborracketlabourearningslabourleasinglaburnumtreelacingcourselacrimalpointlactogenicfactorlacunarycoefficientladletreatedironlaggingloadlaissezallerlambdatransitionlaminatedmateriallammasshootlamphouselancecorporallancingdielandingdoorlandmarksensorlandreformlanduseratio
languagelaboratorylargeheartlasercalibrationlaserlenslaserpulselatereventlatrinesergeantlayaboutleadcoatingleadingfirmlearningcurveleavewordmachinesensiblemagneticequatormagnetotelluricfieldmailinghousemajorconcernmammasdarlingmanagerialstaffmanipulatinghandmanualchokemedinfobooksmp3lists
nameresolutionnaphtheneseriesnarrowmouthednationalcensusnaturalfunctornavelseedneatplasternecroticcariesnegativefibrationneighbouringrightsobjectmoduleobservationballoonobstructivepatentoceanminingoctupolephononofflinesystemoffsetholderolibanumresinoidonesticketpackedspherespagingterminalpalatinebonespalmberry
papercoatingparaconvexgroupparasolmonoplaneparkingbrakepartfamilypartialmajorantquadruplewormqualityboosterquasimoneyquenchedsparkquodrecuperetrabbetledgeradialchaserradiationestimatorrailwaybridgerandomcolorationrapidgrowthrattlesnakemasterreachthroughregionreadingmagnifierrearchainrecessionconerecordedassignment
rectifiersubstationredemptionvaluereducingflangereferenceantigenregeneratedproteinreinvestmentplansafedrillingsagprofilesalestypeleasesamplingintervalsatellitehydrologyscarcecommodityscrapermatscrewingunitseawaterpumpsecondaryblocksecularclergyseismicefficiencyselectivediffusersemiasphalticfluxsemifinishmachiningspicetradespysale
stunguntacticaldiametertailstockcentertamecurvetapecorrectiontappingchucktaskreasoningtechnicalgradetelangiectaticlipomatelescopicdampertemperateclimatetemperedmeasuretenementbuildingultramaficrockultraviolettesting
Reply
12-24-2019, 02:45 AM,
#5
RE: Credit Check Loop Hole - Logistics team can ship infinite amount of goods
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
сайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайтсайт
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Want to check supplier changes back end. Ryan Adam 3 4,221 12-24-2019, 10:15 AM
Last Post: viggora
  Want to link Operating Unit and AR credit memo Tax Ryan Adam 3 3,923 12-24-2019, 08:57 AM
Last Post: viggora
  Want todelete AR Credit Memo which is in Incomplete mode Erica Kristen 3 4,190 12-24-2019, 08:09 AM
Last Post: viggora
  Credit Memo from a transaction dispute Nadia Ahmad 3 4,432 12-24-2019, 08:07 AM
Last Post: viggora
  How can check delay invoice listing Joseph George 3 3,768 12-24-2019, 07:39 AM
Last Post: viggora
  Delete AR Credit Memo which is in Incomplete Mode Ahmad Mujeeb 3 7,694 12-24-2019, 07:34 AM
Last Post: viggora
  Can adjust wrong default “Ship to” in the invoice workbench Archita Jartin 2 4,084 12-24-2019, 04:18 AM
Last Post: viggora
  Rounding of total invoice amount instead of each line item amount shahzadmsaleem 2 3,538 12-24-2019, 03:53 AM
Last Post: viggora
  Change of Lookup Codes shall amount to Customization Sara Khan 3 6,605 12-23-2019, 11:55 PM
Last Post: viggora



Users browsing this thread: 3 Guest(s)