| Author |
Message |
    
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17081
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 30, 2011 - 10:49 pm: |
|
Dobbey:fnd_currencies lo japan yen ki precision 0 undi .. daanni 2 ki maarchii... ap interface table lo exchange rate ichaanu....motham import ayyi kursunnay bederr
thats cool  |
Dobbey
Mudiripoyina Bewarse
Username: Dobbey
Post Number: 3043
Registered: 03-2011
Posted From: 99.119.215.125
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 30, 2011 - 10:49 pm: |
|
Ravanabrahma:
fnd_currencies lo japan yen ki precision 0 undi .. daanni 2 ki maarchii... ap interface table lo exchange rate ichaanu....motham import ayyi kursunnay bederr
Health is Happiness
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17074
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 30, 2011 - 11:06 am: |
|
Dobbey:prod issue nee.. prod nunchi oka instance daily early morning clone ayiddi.. daanlo ne chustunnaa
hmm....oracle tho SR koda open chesi unchu side na...vadu koda chosthadu |
Dobbey
Mudiripoyina Bewarse
Username: Dobbey
Post Number: 3029
Registered: 03-2011
Posted From: 65.204.218.243
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 30, 2011 - 11:03 am: |
|
prod issue nee.. prod nunchi oka instance daily early morning clone ayiddi.. daanlo ne chustunnaa
Health is Happiness
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17073
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 30, 2011 - 11:03 am: |
|
vertex oo edo untadi..alantivi dev systems lo pettaru...next level instance ki vellu..leka ee error prod lo vasthunda? |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17072
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 30, 2011 - 11:02 am: |
|
baa...general ga dev systems lo aa tax engines gatra add cheyyaru anukunta..ala emanna undemo chodu |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17071
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 30, 2011 - 11:01 am: |
|
Dobbey:adi chussaa already .. artham kaakane... emanna simple solution chepthavemo ani vesaaa
inka vere ante theledu baa  |
Dobbey
Mudiripoyina Bewarse
Username: Dobbey
Post Number: 3028
Registered: 03-2011
Posted From: 65.204.218.243
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 30, 2011 - 11:00 am: |
|
Ravanabrahma:The pl/sql tables passed as parameters to the tax engine were not getting flushed in one of the cases. As a result of this the input tax pl/sql table was passing wrong number of records to the tax engine and the tax that is being returned by the tax engine was incorrect. This incorrect tax was getting added to the invoice amount and so total invoice amount was calculated wrongly.
adi chussaa already .. artham kaakane... emanna simple solution chepthavemo ani vesaaa 
Health is Happiness
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17069
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 30, 2011 - 10:52 am: |
|
Dobbey:Reject Code - Invalid Precision in Invoice Amount
Dobbey:bemmam bederr.. payables open interface eee errors tho reject avuthundi any idea?
Reject Code - Invalid Precision in Invoice Amount
metalink lo aa error ki ila ichadu baa..chodu idi emanna help avuthundemo..
Symptoms
In oracle Purchasing, Pay on Receipt AutoInvoice computes the invoice amount incorrectly and Payables Invoice interface record is created with the wrong precision resulting in the following reject message (per Payables Open Interface Rejections Report):
Reject Code - Invalid Precision in Invoice Amount
Reject Reason - The invoice amount is not within the precision for currency
Cause
The pl/sql tables passed as parameters to the tax engine were not getting flushed in one of the cases. As a result of this the input tax pl/sql table was passing wrong number of records to the tax engine and the tax that is being returned by the tax engine was incorrect. This incorrect tax was getting added to the invoice amount and so total invoice amount was calculated wrongly.
This is explained in the following bugs:
Bug:4321935 INVOICE AMT IS INCORRECTLY CALCULATED WHEN PAY ON RECEIPT IS RAN
Bug:4112614 RG:INVOICE AMT IS INCORRECTLY CALCULATED WHEN PAY ON RECEIPT IS RAN
Solution
For 11.5.9 (Procurement Family Pack I, 11i.PRC_PF.I):
Apply Patch 4112614
Fixed in file:
po patch/115/sql POXIVRPB.pls-115.42.1159.6
For 11.5.10 (Procurement Family Pack J, 11i.PRC_PF.J):
Apply Patch 4321935
Fixed files are:
po patch/115/sql POXIVRPB.pls 115.52.11510.4
po patch/115/sql POXIVRPS.pls 115.16.11510.2 |
Dobbey
Mudiripoyina Bewarse
Username: Dobbey
Post Number: 3027
Registered: 03-2011
Posted From: 65.204.218.243
Rating: N/A
Votes: 0 (Vote!) | | Posted on Friday, September 30, 2011 - 10:48 am: |
|
bemmam bederr.. payables open interface eee errors tho reject avuthundi any idea?
Reject Code - Invalid Precision in Invoice Amount
Health is Happiness
|
Andhramass
Bewarse Legend
Username: Andhramass
Post Number: 48621
Registered: 07-2006
Posted From: 203.26.122.12
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 3:55 am: |
|
Prasanth:
anni dananallo Annadanam Minna lal salam
|
Prasanth
Bewarse Legend
Username: Prasanth
Post Number: 61391
Registered: 03-2004
Posted From: 110.76.160.100
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 3:54 am: |
|
 |
Andhramass
Bewarse Legend
Username: Andhramass
Post Number: 48620
Registered: 07-2006
Posted From: 203.26.122.12
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 3:49 am: |
|
Prasanth:epudeltunnaaru? place unte petrol kharchulu ista
payyina kalli yee antha
anni dananallo Annadanam Minna lal salam
|
Prasanth
Bewarse Legend
Username: Prasanth
Post Number: 61389
Registered: 03-2004
Posted From: 110.76.160.100
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 3:28 am: |
|
\anduke memu car lo povali ani fix ayyam\
epudeltunnaaru? place unte petrol kharchulu ista |
Suyodhana
Mudiripoyina Bewarse
Username: Suyodhana
Post Number: 2600
Registered: 06-2007
Posted From: 115.113.76.194
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 3:13 am: |
|
420:
andariki help chestav
naaku punch line immante accenture dappu kodatav
Dedicated to Esperanza
|
420
Bewarse Legend
Username: 420
Post Number: 12287
Registered: 12-2006
Posted From: 77.168.111.63
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 2:52 am: |
|
Ravanabrahma:its working annai..you rock..denemma oka 2 hours kottukunna :-( intha simple ga cheppesav...racha..inka pandaga chestha..kiki
Good thumbee , glad it worked out for you ..
Knit India,do not split India !
|
420
Bewarse Legend
Username: 420
Post Number: 12286
Registered: 12-2006
Posted From: 77.168.111.63
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 2:49 am: |
|
Andhramass:yes, we're Blessed.
And we are all displaced all around the world ..
Knit India,do not split India !
|
Codes
Bewarse Legend
Username: Codes
Post Number: 62895
Registered: 05-2006
Posted From: 212.60.115.186
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 2:04 am: |
|
Don_corleone:
etta vundi ipudu ?
I have no budget for other people's faith in humanity.
|
Andhramass
Bewarse Legend
Username: Andhramass
Post Number: 48608
Registered: 07-2006
Posted From: 203.26.122.12
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:39 am: |
|
Sachinfan:we are blessed annai...
yes, we're Blessed.
anni dananallo Annadanam Minna lal salam
|
Don_corleone
Yavvanam Kaatesina Bewarse
Username: Don_corleone
Post Number: 1083
Registered: 09-2011
Posted From: 183.82.185.51
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:38 am: |
|
emi jugalbandi |
Sachinfan
Bewarse Legend
Username: Sachinfan
Post Number: 22649
Registered: 10-2010
Posted From: 71.171.101.88
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:36 am: |
|
Andhramass:sir nanee
trillionare
we are blessed annai...
gaali puraanam...sollu ki ankitham 
|
Andhramass
Bewarse Legend
Username: Andhramass
Post Number: 48607
Registered: 07-2006
Posted From: 203.26.122.12
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:34 am: |
|
Sachinfan:meerante jamindarlu vayya..
sir nanee
trillionare
anni dananallo Annadanam Minna lal salam
|
Don_corleone
Yavvanam Kaatesina Bewarse
Username: Don_corleone
Post Number: 1082
Registered: 09-2011
Posted From: 183.82.185.51
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:33 am: |
|
Sachinfan:meerante jamindarlu vayya..
intlo unna iddariki rendu car lu konesina G balisina poojari evado andariki telusu raa |
Sachinfan
Bewarse Legend
Username: Sachinfan
Post Number: 22648
Registered: 10-2010
Posted From: 71.171.101.88
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:32 am: |
|
meerante jamindarlu vayya..
gaali puraanam...sollu ki ankitham
|
Don_corleone
Yavvanam Kaatesina Bewarse
Username: Don_corleone
Post Number: 1081
Registered: 09-2011
Posted From: 183.82.185.51
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:32 am: |
|
Prasanth:
anduke memu car lo povali ani fix ayyam |
Andhramass
Bewarse Legend
Username: Andhramass
Post Number: 48606
Registered: 07-2006
Posted From: 203.26.122.12
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:23 am: |
|
Prasanth:
naducuhukunta vellu annii
anni dananallo Annadanam Minna lal salam
|
Prasanth
Bewarse Legend
Username: Prasanth
Post Number: 61388
Registered: 03-2004
Posted From: 110.76.160.100
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:19 am: |
|
\private bus ekkatam varake nee vanthu...ekkaka addam pagiliddo neeke edanna pagiliddo adantha KCR vanthu\
deenemma badava...nenu okkade ayte parle..with wife n kid povaale |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17028
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:15 am: |
|
racha lepav..kevvv |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17027
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:15 am: |
|
Lilliput:aithe maaku ivvandi
 |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17026
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:14 am: |
|
decode (rank() over (partition by a.PO_Number order by cii.serial_number), 2, 0, SUM (pcdla.burdened_cost) ) Burdened_Cost, |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17025
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:14 am: |
|
Penkonda_tiger:very simple ..
Inner query with Rank over and on outer query use Decode for Rank greater than 1 value 0
its working annai..you rock..denemma oka 2 hours kottukunna  intha simple ga cheppesav...racha..inka pandaga chestha..kiki |
Don_corleone
Yavvanam Kaatesina Bewarse
Username: Don_corleone
Post Number: 1079
Registered: 09-2011
Posted From: 183.82.185.51
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:13 am: |
|
private bus ekkatam varake nee vanthu...ekkaka addam pagiliddo neeke edanna pagiliddo adantha KCR vanthu |
Prasanth
Bewarse Legend
Username: Prasanth
Post Number: 61387
Registered: 03-2004
Posted From: 110.76.160.100
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:11 am: |
|
\tiragavu bus lu...waste book cheskoku\
mari private bus lu kuudaana? avi booking baane chuuyistunnaruga?
nee reply batti....
ellundi morning train or repu night bus oo telchaali |
Suyodhana
Mudiripoyina Bewarse
Username: Suyodhana
Post Number: 2579
Registered: 06-2007
Posted From: 115.113.76.194
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:10 am: |
|
Penkonda_tiger:
Dedicated to Esperanza
|
Lilliput
Bewarse Legend
Username: Lilliput
Post Number: 12204
Registered: 08-2010
Posted From: 76.97.208.33
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:09 am: |
|
Ravanabrahma:annai ichentha goppavadina nanesh nenu
aithe maaku ivvandi
Saddaaaa Haqqqqq Iitthhheeee Raakhhhhh 
|
Don_corleone
Yavvanam Kaatesina Bewarse
Username: Don_corleone
Post Number: 1078
Registered: 09-2011
Posted From: 183.82.185.51
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:08 am: |
|
tiragavu bus lu...waste book cheskoku |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17024
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:08 am: |
|
Don_corleone:jeetham lo sagam vaata penkulu ki istannava leda
annai ichentha goppavadina nanesh nenu  |
Prasanth
Bewarse Legend
Username: Prasanth
Post Number: 61386
Registered: 03-2004
Posted From: 110.76.160.100
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:08 am: |
|
nanee ga
repu vja poye bus lu nadustaaya? rtc online lo miyapur nundi oka bus, kphb nundi morning oka bus maatrame ettaadu eti... |
Prasanth
Bewarse Legend
Username: Prasanth
Post Number: 61385
Registered: 03-2004
Posted From: 110.76.160.100
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:05 am: |
|
suustaave mari delete cheyy... |
Don_corleone
Yavvanam Kaatesina Bewarse
Username: Don_corleone
Post Number: 1077
Registered: 09-2011
Posted From: 183.82.185.51
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:05 am: |
|
Prasanth:
ee DB lo enduku esav aa DB post lu |
Prasanth
Bewarse Legend
Username: Prasanth
Post Number: 61384
Registered: 03-2004
Posted From: 110.76.160.100
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 1:01 am: |
|
lillips aa chintu bhai post lo ee matter suusi avaakkayya:
"eee issue ki full stop pettalantey T icheyaalsindhey. vipareethanga rechagotti chasthunnaaru,antlavedhavalu. 50+ years vachaaka kooda houston lo maa pinni(karimnagar) & maa babai(WG) daily kottukuntunnaaranta T issue meedha. Maa friend rajareddy (chittur) & his wife (nizamabad) daily arugements.
" |
Don_corleone
Yavvanam Kaatesina Bewarse
Username: Don_corleone
Post Number: 1076
Registered: 09-2011
Posted From: 183.82.185.51
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:58 am: |
|
Lilliput:motham ready repu US time lo release sedhaamu
 |
Lilliput
Bewarse Legend
Username: Lilliput
Post Number: 12203
Registered: 08-2010
Posted From: 76.97.208.33
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:57 am: |
|
Don_corleone:
motham ready repu US time lo release sedhaamu
Saddaaaa Haqqqqq Iitthhheeee Raakhhhhh
|
Don_corleone
Yavvanam Kaatesina Bewarse
Username: Don_corleone
Post Number: 1075
Registered: 09-2011
Posted From: 183.82.185.51
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:54 am: |
|
Ravanabrahma:
jeetham lo sagam vaata penkulu ki istannava leda |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17023
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:53 am: |
|
thats okay annai..idea vachinatte undi..aagu sootha.. |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17022
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:53 am: |
|
oh ardamaindi..maarustha aagu annai.. |
Penkonda_tiger
Celebrity Bewarse
Username: Penkonda_tiger
Post Number: 6091
Registered: 06-2005
Posted From: 82.157.134.169
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:49 am: |
|
Ravanabrahma:naa query idi bhayya..ela rastham rank..
Hemu, I am in the car now in a Jam .. will be in the office after 2 hours .. .. I will help yuu then okay ..
kanapade nijam: Good manners , kanapadanidhi: abusive language
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17021
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:48 am: |
|
http://www.techonthenet.com/oracle/functions/rank.php
ee link chosthunna kani naa query ni ala ela marchalo ardam kaalaa |
420
Bewarse Legend
Username: 420
Post Number: 12285
Registered: 12-2006
Posted From: 82.157.134.169
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:43 am: |
|
Flight unkaaaal whats up .. heard you watched Dookudu 3 times in a row ..
and you do not maintain same concentration for Jnr Movies ..
Knit India,do not split India !
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17019
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:21 am: |
|
Penkonda_tiger:
thanks annai...chostha aagu.. |
Kubang
Pilla Bewarse
Username: Kubang
Post Number: 163
Registered: 09-2011
Posted From: 68.147.147.218
Rating: N/A
Votes: 0 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:17 am: |
|
Penkonda_tiger:
 |
Penkonda_tiger
Celebrity Bewarse
Username: Penkonda_tiger
Post Number: 6090
Registered: 06-2005
Posted From: 82.157.134.169
Rating: 
Votes: 1 (Vote!) | | Posted on Thursday, September 29, 2011 - 12:06 am: |
|
very simple ..
Inner query with Rank over and on outer query use Decode for Rank greater than 1 value 0
kanapade nijam: Good manners , kanapadanidhi: abusive language
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 17018
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, September 28, 2011 - 11:27 pm: |
|
naaku oka query undi..andulo oka column value anni rows ki vasthundi..
for ex:
asset_number, task_number expenditure_amount, po_number
01 01 20.00 011
01 01 20.00 022
indulo prathi po_number ki oka row vasthundi..eventhough the task, asset number are same..
my requirement is show both the lines,but under amount column show 20 for only one line and 0 to the rest of the rows..
ela cheyyali? |
Archives - 2011