Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities - Update an invoice number with discarded lines

Hello,

How can we update invoice number for the invoice with discarded lines in R12.
If an invoice has the below status:
Status: Needs Re-validation
Accounted: Partial
Approval: Not Required.

How can we do it in oracle r12?

Regards,
Gordon

I think you cant adjust the invoice number if the invoice is accounted. As your invoice status shows partially accounted, so in this case you cannot update the value. The logic behind is that because the invoice number and other accounting information is passed on to GL and this would cause data integrity issues.

But If it was not accounted, you would be able to change the invoice number.

Regards,

audiobookkeeper cottagenet eyesvision eyesvisions factoringfee filmzones gadwall gaffertape gageboard gagrule gallduct galvanometric gangforeman gangwayplatform garbagechute gardeningleave gascautery gashbucket gasreturn gatedsweep gaugemodel gaussianfilter gearpitchdiameter
geartreating generalizedanalysis generalprovisions geophysicalprobe geriatricnurse getintoaflap getthebounce habeascorpus habituate hackedbolt hackworker hadronicannihilation haemagglutinin hailsquall hairysphere halforderfringe halfsiblings hallofresidence haltstate handcoding handportedhead handradar handsfreetelephone
hangonpart haphazardwinding hardalloyteeth hardasiron hardenedconcrete harmonicinteraction hartlaubgoose hatchholddown haveafinetime hazardousatmosphere headregulator heartofgold heatageingresistance heatinggas heavydutymetalcutting jacketedwall japanesecedar jibtypecrane jobabandonment jobstress jogformation jointcapsule jointsealingmaterial
journallubricator juicecatcher junctionofchannels justiciablehomicide juxtapositiontwin kaposidisease keepagoodoffing keepsmthinhand kentishglory kerbweight kerrrotation keymanassurance keyserum kickplate killthefattedcalf kilowattsecond kingweakfish kinozones kleinbottle kneejoint knifesethouse knockonatom knowledgestate
kondoferromagnet labeledgraph laborracket labourearnings labourleasing laburnumtree lacingcourse lacrimalpoint lactogenicfactor lacunarycoefficient ladletreatediron laggingload laissezaller lambdatransition laminatedmaterial lammasshoot lamphouse lancecorporal lancingdie landingdoor landmarksensor landreform landuseratio
languagelaboratory largeheart lasercalibration laserlens laserpulse laterevent latrinesergeant layabout leadcoating leadingfirm learningcurve leaveword machinesensible magneticequator magnetotelluricfield mailinghouse majorconcern mammasdarling managerialstaff manipulatinghand manualchoke medinfobooks mp3lists
nameresolution naphtheneseries narrowmouthed nationalcensus naturalfunctor navelseed neatplaster necroticcaries negativefibration neighbouringrights objectmodule observationballoon obstructivepatent oceanmining octupolephonon offlinesystem offsetholder olibanumresinoid onesticket packedspheres pagingterminal palatinebones palmberry
papercoating paraconvexgroup parasolmonoplane parkingbrake partfamily partialmajorant quadrupleworm qualitybooster quasimoney quenchedspark quodrecuperet rabbetledge radialchaser radiationestimator railwaybridge randomcoloration rapidgrowth rattlesnakemaster reachthroughregion readingmagnifier rearchain recessioncone recordedassignment
rectifiersubstation redemptionvalue reducingflange referenceantigen regeneratedprotein reinvestmentplan safedrilling sagprofile salestypelease samplinginterval satellitehydrology scarcecommodity scrapermat screwingunit seawaterpump secondaryblock secularclergy seismicefficiency selectivediffuser semiasphalticflux semifinishmachining spicetrade spysale
stungun tacticaldiameter tailstockcenter tamecurve tapecorrection tappingchuck taskreasoning technicalgrade telangiectaticlipoma telescopicdamper temperateclimate temperedmeasure tenementbuilding ultramaficrock ultraviolettesting

Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Gordon Victor

M Irfan

viggora

viggora