Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle 10.7 - Receivables Adjustment issue (Oracle 10.7)
Oracle 10.7 - Receivables Adjustment issue [message #443438] Mon, 15 February 2010 15:14
Messages: 1
Registered: February 2010
Junior Member
Hello champs...i am in real trouble.

Require help from you guys in Oracle Receivables - Adjustments issue. I am very new to this application, so may not know all the things (or all the things).

I have oracle 10.7 financial application, where user wanted to make an adjustment in receiveables. But somehow the user entered wrong and too many adjustments. Right now there is one pending adjustment is there for amount: 7,410,012.

Here is the output of (Attached: Tbl_structure):
select * from AR_ADJUSTMENTS_ALL
where adjustment_id in
order by 1 ;

I made some changes in 1 record and that was :
update ar_adjustments_all
set GL_DATE = SYSDATE --o ld Value 11-Dec-2009 (11-dec-2009 00:00:00)
, STATUS = 'W' -- old Value A
, POSTABLE = 'Y' -- old Value N
where adjustment_id = '39600';

Right now, status is (attached jpg file).

Need your help to adjust the pending adjustments.

Thanks for the help.

Let me know incase you need more information from my side.

SP Singh
Previous Topic: From where Indexes are analyzed
Next Topic: PO & iProc mapping for Catalog Supplier
Goto Forum:

Current Time: Thu Oct 27 00:02:55 CDT 2016

Total time taken to generate the page: 0.09117 seconds