My Oracle Support Banner

Create Accounting Does Not Pull Transaction Item Sales Account (Doc ID 1486893.1)

Last updated on FEBRUARY 12, 2018

Applies to:

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

Goal

Custom rule was defined to pull segment4 from the accounting flexfield from the item entered onto a manual invoice line. However the create accounting output is not pulling from the default sales account set up on the item.

Researched the topic and found note 1152376.1

Tried to run SQL fix but received this error in Dev instance:
SQL> @$ONT_TOP/patch/115/sql/ontspgrn.sql
Enter value for 1: ONT
DECLARE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at line 28
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.