Credit Memo against Invoice

http://receivablesar.blogspot.com/2016/06/credit-memo-against-invoice.html

Please Copy and Paste the Below URL in your Browser

http://oracler12applicationfunctional.blogspot.com/2014/03/credit-memo-against-invoice-in-r12.html

Receipt Workbench Issue: Custom Menu has Tools -> View Accounting Disabled. How can I enable it? (Doc ID 417417.1)

http://receivablesar.blogspot.com/2016/06/applies-to-oracle-receivables-version-11.html

Receipt Workbench Issue: Custom Menu has Tools -> View Accounting Disabled. How can I enable it? (Doc ID 417417.1)

GOAL

When you navigate to Receipts window using a Custom Responsibility that has Custom menu attached, the Tools > View Accounting menu is grayed out/disabled. How do I enable this option?

Responsibility: Receivables manager

Navigation: Receipt > Receipts
Invoke Menu Tools > View Accounting

It is grayed out on Receipts form

SOLUTION

Function SLA: View Accounting - Lines Inquiries needs to be attached to the menu.

Perform the following steps:

Responsibility: System Administrator

Navigation: Application > Menu
Query the menu being used
Add a new line and enter the following values:
Seq# - enter a unique value
Prompt - leave blank
SubMenu - leave blank
Function - SLA: View Accounting - Lines Inquiries
Description - enter a description
Grant - Yes

Save your changes. Now, View Accounting should be enabled on Tools Menu on Receipts form.

Receipt Workbench Error: Listing of APP-AR Errors (Doc ID 460857.1)

http://receivablesar.blogspot.com/2016/05/receipt-workbench-error-listing-of-app.html

Receipt Workbench Error: Listing of APP-AR Errors (Doc ID 460857.1)

How to enable Manage Exceptions on Oracle Receivables R12.2.4

http://receivablesar.blogspot.com/2016/03/how-to-enable-manage-exceptions-on.html

How to Setup the New Manage Accounting Exception Program in Receivables? (Doc ID 1937611.1)

APPLIES TO:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

GOAL

How can I setup the new Consolidated Review and Manage Accounting Exception Program in Receivables?

SOLUTION

Please perform the following:

1. For Release 12.1, the Manage Exception Functionality is available through Patch 22482346, and in the FEB-2016 RPC Patch 22471504. For Release 12.2, it is available through Patch 16634326.
NOTE: The program will ONLY sweep those transactions that are in error (xla_events.event_status_code = U and xla_events.process_status_code = I)

2. Once the patch is applied, please make sure the function Accounting Exception: Manage (AR_ARXSUMPS_MANAGE_EXP) is available in the AR Control Accounting Menu:

a. Under your System Administrator Responsibility, please go to Application --> Menu

b. Query for Menu = AR_CONTROL_ACC_GUI



3. When you try to close the period the system will check for Unposted items. If there are any, the Manage Exception button will be enabled in the Open/Close Period form.



4. Click on Manage Exceptions and you will get the following warning:



5. If you choose to sweep the transactions, you will get another warning stating that the changes cannot be undone.

GL_Interface containing duplicate records which has already been posted in GL transferred from Receivables (Query)

http://receivablesar.blogspot.com/2016/02/select-h.html

SELECT
H.NAME,
H.DEFAULT_EFFECTIVE_DATE,
H.DESCRIPTION,
H.JE_HEADER_ID,
A.JE_HEADER_ID,
H.JE_SOURCE,
H.JE_CATEGORY,
H.LEDGER_ID,
H.ACTUAL_FLAG,
H.PERIOD_NAME,
A.GL_SL_LINK_ID,
H.CODE_COMBINATION_ID,
H.ENTERED_DR,
H.ENTERED_CR
FROM
(
SELECT * FROM GL_INTERFACE
WHERE USER_JE_SOURCE_NAME='Receivables' AND USER_JE_CATEGORY_NAME='Sales Invoices' AND LEDGER_ID=2021 AND ACTUAL_FLAG='A' -- 783
) A,
(
SELECT
H.JE_SOURCE,
H.JE_CATEGORY,
H.LEDGER_ID,
H.ACTUAL_FLAG,
H.PERIOD_NAME,
gll.CODE_COMBINATION_ID,
gll.ENTERED_DR, gll.ENTERED_CR,
ael.gl_sl_link_id,
H.NAME,
H.DEFAULT_EFFECTIVE_DATE,
H.JE_HEADER_ID,
H.DESCRIPTION
FROM
GL_JE_HEADERS H,
GL_JE_LINES gll,
XLA_AE_HEADERS aeh,
XLA_AE_LINES ael,
XLA_EVENTS aea,
GL_IMPORT_REFERENCES gir

WHERE 1=1
AND H.JE_HEADER_ID=gll.JE_HEADER_ID
   AND ael.gl_sl_link_id = gir.gl_sl_link_id
   AND gir.gl_sl_link_table in ('APECL', 'XLAJEL','XLAJEL')
   AND aea.application_id = 222
   AND aea.event_id = aeh.event_id
   AND aeh.ae_header_id = ael.ae_header_id
   AND gll.je_header_id = gir.je_header_id
   AND gll.je_line_num = gir.je_line_num

AND H.JE_SOURCE='Receivables'
AND H.JE_CATEGORY='Sales Invoices'
AND H.LEDGER_ID=2021
AND H.ACTUAL_FLAG='A'
--AND H.DEFAULT_EFFECTIVE_DATE='20-JUL-2009'
--AND H.PERIOD_NAME='JUL-09'
--AND H.DESCRIPTION LIKE '%200900160%'
) H
WHERE 1=1
AND H.JE_SOURCE=A.USER_JE_SOURCE_NAME
AND H.JE_CATEGORY=A.USER_JE_CATEGORY_NAME
AND H.LEDGER_ID=A.LEDGER_ID
AND H.ACTUAL_FLAG=A.ACTUAL_FLAG
AND H.PERIOD_NAME=A.PERIOD_NAME
--AND H.CODE_COMBINATION_ID=A.CODE_COMBINATION_ID
--AND (H.ENTERED_DR=A.ENTERED_DR or H.ENTERED_CR=A.ENTERED_CR)
AND H.GL_SL_LINK_ID=A.GL_SL_LINK_ID

Complete/Incomplete In Oracle Receivable

http://receivablesar.blogspot.com/2016/02/we-are-having-issue-that-during.html

we are having issue that during the complete/incomplete of transactions in Oracle Receivables the system got stuck or takes too much time. Kindly review and share the reason to overcome through this problem because whenever user perform this action it irritates too much. 


Please follow the below Document attached and upload it to Support

All About the SQLT Diagnostic Tool (Doc ID 215187.1)
SQLT Usage Instructions (Doc ID 1614107.1

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

The analyze percents of schema of AR, ZX are 10%.
Your database is 11.2.0.1.0. You can use the Auto_Sample_Size when you run the the Gather Schema Statistics.

I suggest you should run the Gather Schema Statistics with Estimate percent
as null (Auto_Sample_Size) and schema name as both AR and ZX after
applying patch 16410424:R12.FND.B according to the document below.

Best Practices for Gathering Statistics with Oracle E-Business Suite ( Doc ID 1586374.1 )

Patch 16410424:R12.FND.B
Fix version:
AFSTATSB.pls 120.12.12010000.19 or higher.

Please test the this issue after running the Gather Schema Statistics.

Wrong Distribution Account in Receivable Transaction

http://nethpsl.blogspot.com/2016/01/wrong-distribution-account-in.html

Please check with your business that they want to use the same Revenue Account for both transaction and credit memo.
If yes, AR: Use Invoice Accounting for Credit Memos is set to Yes other set it to NO.

Here is detail related to above profile.

"Note: Receivables does not require you to enter a Revenue Account
for Credit Memo transaction types if the profile option
AR: Use Invoice Accounting for Credit Memos is set to Yes.
Otherwise, you must enter a Revenue Account."

"AR: Use Invoice Accounting for Credit Memos:
This profile option determines whether to assign your credit memo
to the same accounts that are assigned to the invoice you are
crediting.

The value for this option can be set by the system administrator
at the site, application, responsibility, and user levels, but
cannot be updated by the user."