My Oracle Support Banner

OM_BILL Abended at Step OM_BILL.MCA.Step01 For India GST Business Unit When Adding Order Header And Line Notes (Doc ID 2826958.1)

Last updated on APRIL 01, 2024

Applies to:

PeopleSoft Enterprise SCM Order Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

OM_BILL error for India GST Business Unit when adding order header and line 'INVOICE' notes.

ERROR:


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

         Setup: Menu > Setup Financials/supply Chain > Common Definitions > India GST > BU Tax Applicability. Make sure GST (Sales) and GST (Purchase) are checked.

1. Create Sales Order for Business Unit 'IND01' and Customer 'IND03' add 2 lines. Navigation: Menu > Order Management > Quotes and Orders > Create or Update Sales Order
2. From Header Menu Drop Down. Add Invoice Note 'Invoice'
3. From Line Menu Drop Down. Add Line Note ‘Invoice’
4. Save Order Management
5. From Header Menu Drop Down Select Reserve
6. Run Order Release. Auto Pick. Advance to Depleted. Menu > Inventory > Fulfill Stock Orders > Princing > Order Release Request.
7. Run process excise and sales tax. 
8. Run OM_BILL. 1.  Navigation: Menu > Order Management > Quotes and Orders > Create OM Billing Entries > Process OM Billing . No success. Process abended:
"File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1811 Error Position: 0 Return: 805 - ORA-00001: unique constraint (EMDBO.PS_INTFC_BI) violated Failed SQL stmt: INSERT INTO PS_INTFC_BI (INTFC_ID, INTFC_LINE_NUM, TRANS_TYPE_BI"
"Process XXXXXX ABENDED at Step OM_BILL.MCA.Step01 (SQL) -- RC = 805"

Changes

 

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution
References


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