Total Amount APTB not same with Trial Balance

Post date: Jun 18, 2015 8:27:53 AM

Hi Iwan,

Glad to know issue resolved :)

Yes, that is right. You can open the Definition and click on Apply.

It will update balances in the table.

Let me know if you need any more assistance.

Regards

Purvi

Hi Purvi,

The problem solved.

So my conclusion, for update the balances in xla_trial_balances you just need to do 'apply' in open account balances listing' and the Open Account Balances Data Manager concurrent program is run. Is that right ?

Regards,

Iwan Herdian

Hi,

Thanks for the information. Acknowledging your update to the SR. Will wait for further response from you.

Regards

Purvi

Dear Purvi,

Thanks for your feedback, I'll try it your suggestion

Regards,

Iwan

Hi Anton,

Verified the data.

Invoice is cancelled, the cancellation event is not inserted in trial balance tables.

Please do this:

1. Navigate: Payables Responsibility > Setup > Accounting Setups > Subledger Accounting Setups > Open Account Balances Listing Definitions

2. Query the Report Definition Code (BTN AP TB Kalimantan dan Jakarta)

3. Open report definition and merely click on apply button. This will repopulate xla_trial_balance table.

Then re run trial balance and advise.

IF issue does not resolve provide TB analyzer output for invoice using these steps:

a) Download the file ap_aptb_detect_pkg.zip from note 1553507.1

b) Run the script ap_aptb_detect_pkg.sql as user APPS to create the package definition

c) Run the wrapper SQL – run_aptb_diag.sql by giving the appropriate parameters

For more information, please refer the below notes.

Note 1553507.1 - R12: Payables Trial Balance Helper - Diagnostic to Validate Data for APTB issues

Regards

Purvi

Verified the issue in the log file as noted below:

LOG FILE

-----------------------

Filename = Accounts_Payable_Trial_Balance_170615.xls

See the following error: Remaining amount is shown for cancelled invoice.

APTB:

Ledger BTN_LEDGER

AKON

BT2.000.0000000.0000.0000000.000.210110001.000.000.000

Transaction Type Transaction Number Date Currency Payment Status Cancelled Date Original Amount Remaining Amount

AP Invoices AP/BTN-SINTANG-S/15/IV/0862 12-Apr-15 IDR Not Paid 2015-04-12T12:00:00 0 16,590.00

On : 12.1.3 version, Accounting Issues in AP

ACTUAL BEHAVIOR

---------------

One cancelled invoice is shown as outstanding in the AP Trial balance

EXPECTED BEHAVIOR

-----------------------

Remaining amount should be 0 for cancelled invoice

STEPS

-----------------------

The issue can be reproduced at will with the following steps:

1. Create invoice, cancel it

2. Run APTB it shows the invoice as outstanding

BUSINESS IMPACT

-----------------------

The issue has the following business impact:

Due to this issue, users cannot reconcile AP with GL

Name

--------

ODM Data Collection

APTB:

Ledger BTN_LEDGER

AKON

BT2.000.0000000.0000.0000000.000.210110001.000.000.000

Transaction Type Transaction Number Date Currency Payment Status Cancelled Date Original Amount Remaining Amount

AP Invoices AP/BTN-SINTANG-S/15/IV/0862 12-Apr-15 IDR Not Paid 2015-04-12T12:00:00 0 16,590.00

APlist

invoice_id 19613

invoice_num AP/BTN-SINTANG-S/15/IV/08

amount = 0

cancelled invoice

XLA_TRIAL_BALANCES

the applied event for invoice cancellation is not available

GDF:

Invoice ID 19613

No issues

FileName

----------------

Attachment: <IRG___AP_Data_Validation_Repor_170615.html>

FileComment

----------------------

FileName

----------------

Attachment: <Accounts_Payable_Trial_Balance_170615.xls>

FileComment

----------------------

FileName

----------------

Attachment: <ODI-Invoice_Data-17-Jun-2015_14-40-59.zip>

FileComment

----------------------

FileName

----------------

Attachment: <ODI-Invoice_Data-17-Jun-2015_14-35-45.zip>

FileComment

----------------------

Hi Purvi,

Is there any update ?

Regards,

Iwan Herdian

Hi Purvi,

I've already uploaded those files needed for analysis

Hope it will be helpful

Regards,

Iwan Herdian

Upload to TDS successful for the file IRG___AP_Data_Validation_Repor_170615.html.

Upload to TDS successful for the file Accounts_Payable_Trial_Balance_170615.xls.

Upload to TDS successful for the file ODI-Invoice_Data-17-Jun-2015_14-40-59.zip.

Upload to TDS successful for the file ODI-Invoice_Data-17-Jun-2015_14-35-45.zip.

Hi Iwan,

We need to identify the invoice of AKON supplier which is causing issue.

For that run APTB in detail mode for AKON vendor.

You will get invoice number causing issue.

With that invoice number provide below details:

A. Please upload aplist of invoice having issue

To run the APLIST for R12 you will need to do the following:

a) Goto Metalink Note 167000.1 and follow the instructions to install the latest diagnostic patch and setup diagnostics to run in R12.

b) Login to the application and open the Oracle Diagnostic Tool responsibility setup and assigned per the instructions in Note 167000.1.

c) Pick Application Short Name: SQLAP

d) Choose Tests -> Applications -> Payables -> Invoice ->

Invoice Data Collection

e) Check the select box and click Execute

f) Enter the parameters corresponding to your Invoice/Payment and submit the diagnostic.

Include GL Tables: Yes

Include Related Data: Yes

g) Click Submit

h) Save the diagnostic output as HTML and upload to the SR.

B. Please upload the GDF diagnostics for transaction in issue as per below steps (note 1360390.1)

a. Download the file ap_gdf_detect_pkg.zip from note 1360390.1 . This file contains the package definition file ap_gdf_detect_pkg.sql as well as two wrapper scripts which can be used to submit the detection procedures:

b. Run the script ap_gdf_detect_pkg.sql as user APPS to create the package definition.

c. Run single_trx.sql for the invoice/check in question

d. This will generate an output file of the format AP-GDF-<timestamp>.html and will indicate the location of this file and the log file. Please upload them to the SR.

Regards

Purvi

Hi Purvi,

For point number3, please check supplier 'AKON' in attachment before

Regards,

Iwan Herdian

Hi Purvi,

My expectations is the APTb report show the correct detail and right sum and match to Trial balance for liability account

Regards,

Iwan Herdian

Upload to TDS successful for the file IRG___SLA_Rincian_Account_Anal_120615.xls.

Hi Purvi,

1. I confirm:

- My phone number: +6281316610206

- My e-mail: iwan.herdian@optima-data.com or iwan.herdian@incasi.co.id

2. Attached

3. I will check it and then inform to you

Regards,

Iwan Herdian

Hi,

1. Please confirm contact details:

Phone: +6281316610206

email: anton.halim@optima-data.com

2. Please upload output file of report and clarify your expectation.

3. Have you identified any transaction which is incorrect.

Regards

Purvi

Hi,

I am an analyst in the AP product group and have been assigned your Service Request (SR). To better understand Oracle Support processes and procedures, feel free to review My Oracle Support (MOS) note 166650.1-Working effectively with support.

If you have comments, concerns or suggestions do not hesitate to contact my manager Rajiv Arora at Rajiv.Arora@oracle.com.

Please confirm the contact details as seen on SR header is correct. In case of any changes, let me know so that I can change it.

If the resolution process requires immediate attention, please call into Oracle Support.

Regards

Purvi Purswani

Global Customer Support

Customer Problem Description

---------------------------------------------------

Problem Summary

---------------------------------------------------

Total Amount of AP Trial Balance is not match with Ending Balance in Trial Balance for liability acc

Problem Description

---------------------------------------------------

Total amount of APTB is not match in April 2015 period

Error Codes

---------------------------------------------------

Problem Category/Subcategory

---------------------------------------------------

Technical Issues/Other AP Technical Issue

Uploaded Files

---------------------------------------------------

Template Question Responses

---------------------------------------------------

1) ### Describe how this problem is impacting your business. Include relevant information such as critical events (i.e., upgrade or project milestones), dates (i.e., go live dates), number of users affected, financial impact, etc.

Can not know the exactly amount of our total liability because the total amount in ending balance Trial Balance is not same with APTB report