Oracle EBS AR Open Invoice query

SELECT apsa.amount_due_original receipt_amount,        apsa.amount_due_remaining unapplied_amount,        apsa.due_date,        DECODE (...

Oracle Apps:AR receipt errors

Issue: When attempting to apply invoice to the receipt and on giving the discount The following error occurs: APP-AR-11248: Discount taken...

Oracle apps Receivables :Default Shipping Date

How can I do that in autoinvoice program take the default date and not the date of the order sale or the date of the shipping date? In AR ...

Oracle EBS: Internal VS External Banks

Data model changes between R11i and R12 have changed how banks are created and stored. In R11i, in the bank accounts form you could se...

Oracle EBS: AR Receipts(Standard,Mis Receipts,Trade Receipts)

Difference between Standard, miscellaneous and  trade receipts   Standard receipts: Payment (such as cash or a check) that you receive f...

Oracle APPS :Customer Interface errors part-1

Release Cause Fix 11.5.x to 12.1.x Attempting to insert contacts through the Customer Interface program and...

Oracle EBS : Purchasing: Receipt Correction

How to Prevent Users from Creating a Correction on Receipt that has Been Matched to Invoice? Solution It is Oracle standard functiona...

Oracle ERP : AR:Autoinvoice Errors and Resolutions

AutoInvoice Errors and Resolutions Error Message Cause Action Please define all periods in which revenue is to be recognized or...

Oracle EBS : GL Date Validation in Auto Invoice

GL Date Validation In AutoInvoice 1.       The entered or derived GL date must be in an Open or Future enterable accounting period. ...

Oracle EBS:AR Date Derivation In AutoInvoince

Date Derivation In AutoInvoince:   During the process of AutoInvoice you can enter the General Ledger (GL) date and the Transaction date...

Oracle Order Management :Shipped Quantity Not Matching With AR Invoiced Quantity

Issue: Shipped Quantity Not Matching With AR Invoiced Quantity Reasons: The reason why fulfilled_quantity and invoiced_quantity is ...

Oracle APPS : eBTAX :issues

The 15% tax until dec'16 from Jan onwards it is 17.5%  Old Tax code and rates has made ineffective 31/Dec/2016 New Tax code and r...

Oracle Receivables:Auto invoice error

In AR  invoice  interface table interface_status='P' but invoices were not   created  In below output file in Auto  invoice...

ebiztechnics :2nd week Oct'2017 weekly Update

Greetings from eBiztechnics !!!! Hope you are enjoying the weekend... Last week we published articles on Payables,Order Management and ...

Oracle APPS :iReceivables VS Receivables

Customer can log into iReceivables to view his  Invoice  Details, Pay Invoices,raise Dispute etc through Web.  It is a Self Se...

Oracle Applications: Receivables :Credit memo Issues

Issue: AR Credit Memo is more than the Customer Invoice. AR invoice against a customer but the customer issue larger credit ...

Oracle Receivables : Auto Invoice:Import

Oracle Receivables : Auto Invoice:Import Auto invoice Error:- You must supply an invoice number when your batch source indi...

Oracle Order Management: Data flow from Order Management to Receivables

Receivables Interface & Data flow from Order Management to Receivables  Tables RA_INTERFACE_LINES_ALL and RA_INTERFACE_SALESCR...

Oracle Applications: Receviabes: Setup Freight For AutoInvoice

Oracle Applications: Receivables: Setup Freight  For AutoInvoice When processing freight in Receivables, you have two options: ...

Oracle eBusiness Suite : Mapping between GL and AR

The General Ledger Transfer process puts rows into GL_IMPORT_REFERENCES.REFERENCE21 to REFERENCE30. If the journal is imported in de...