[go: up one dir, main page]

0% found this document useful (0 votes)
77 views10 pages

Accounting Error Canceled Invoice

The document details a service request (SR 4-0000091783) regarding a canceled invoice with unprocessed accounting status, causing period close exceptions. Oracle support has provided a series of steps to resolve the issue, including creating specific profile options and running necessary jobs. The customer is required to follow the outlined action plan to address the technical issue effectively.

Uploaded by

Gurpreet Seehra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
77 views10 pages

Accounting Error Canceled Invoice

The document details a service request (SR 4-0000091783) regarding a canceled invoice with unprocessed accounting status, causing period close exceptions. Oracle support has provided a series of steps to resolve the issue, including creating specific profile options and running necessary jobs. The customer is required to follow the outlined action plan to address the technical issue effectively.

Uploaded by

Gurpreet Seehra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 10

11/12/24, 9:21 AM Service Request Details

My Oracle Cloud Support Account (3) 

Invoice canceled but …


Activity Details
4-0000091783

Add your message

    
    

Add Files Cancel Send

Newest to Oldest  All Messages 

 Message from Oracle


Nov 12, 2024 3:44 AM

EMAIL Alert sent:


Dear Customer,
Service Request SR 4-0000091783
has been updated and requires
your attention.
SR Issue Type: Technical
Issue
SR Status: Customer
Working
SR Product: Oracle
Fusion Subledger
Accounting Cloud
Service

https://support.oracle.com/support/?SR=4-0000091783&page=sptemplate&sptemplate=sr-activities 1/10
11/12/24, 9:21 AM Service Request Details

Please click the SR link to review


and update it as needed at your
earliest convenience.

 Message from Oracle


Nov 12, 2024 3:39 AM

Hi,
I have updated the action plan,
please follow below action plan -:
1. Create profile option with code
and name as AP_SHBYIV_ENABLE
Navigate to: Setup and
Maintenance -> Manage Profile
Options -> New ->
(a) Create Profile Option as:
- Profile Option Code:
AP_SHBYIV_ENABLE
- Profile Display Name:
AP_SHBYIV_ENABLE
- Application: Payables
- Module: Invoices
- Description: Self-Healing Profile
- Start Date: 01-01-2022
Set Profile Option Levels for all
profile options:
User level: Enable and Updateable
Save and close.
B. Set the profile option values
Navigate to:Setup and
Maintenance -> Manage
Administrator Profile Values
(a)Search for Profile Option Code:
AP_SHBYIV_ENABLE
Set Profile Values at:
* Profile Level = User
* Username = Select User name
from LOV only (user who will
Validate the invoice)
* Profile Value = Y
Save and close.

3. Create profile option with code


and name as
https://support.oracle.com/support/?SR=4-0000091783&page=sptemplate&sptemplate=sr-activities 2/10
11/12/24, 9:21 AM Service Request Details

AP_SHBYIV_MARK_UNACCT_INVO
ICE_EVENTS2_NU (similarly you
created the above profile option)
and Set profile option value as
invoice_id : 443084 for User
4. Login with same user and Run
Invoice Validation ESS Job by
passing Invoice
Number :VGR1245920-1 as input
parameter.
5. Run the create accounting ESS
job to complete the fix. (Please do
not perform post to ledger
operation from UI).

Note -: I have changed the profile


option from
AP_SHBYIV_MARK_UNACCT_PAY
MENT_EVENTS2_NU to
AP_SHBYIV_MARK_UNACCT_INVO
ICE_EVENTS2_NU. Please disable
AP_SHBYIV_MARK_UNACCT_PAY
MENT_EVENTS2_NU and create
AP_SHBYIV_MARK_UNACCT_INV
OICE_EVENTS2_NU

Best Regards,
Shivam

GS gurpreet.seehra@acer.com
Nov 11, 2024 5:34 PM

Hi Team,

We did the steps recommended


but still have the error. The output
files are attached,

CC

cmos-file-
management_ww@oracle.com
Nov 11, 2024 5:33 PM

https://support.oracle.com/support/?SR=4-0000091783&page=sptemplate&sptemplate=sr-activities 3/10
11/12/24, 9:21 AM Service Request Details

File 13478832.log has been


received and submitted for post
processing. Your Support Agent
will be notified once compliance
has been verified.

CC

cmos-file-
management_ww@oracle.com
Nov 11, 2024 5:32 PM

File outputDocument__6_.pdf has


been received and submitted for
post processing. Your Support
Agent will be notified once
compliance has been verified.

 Message from Oracle


Nov 11, 2024 3:38 PM

EMAIL Alert sent:


Dear Customer,
Service Request SR 4-0000091783
has been updated and requires
your attention.
SR Issue Type: Technical
Issue
SR Status: Solution
Offered
SR Product: Oracle
Fusion Subledger
Accounting Cloud
Service
Please click the SR link to review
and update it as needed at your
earliest convenience.

呂 Message from Oracle - Solution


Nov 11, 2024 3:33 PM

Hi,

https://support.oracle.com/support/?SR=4-0000091783&page=sptemplate&sptemplate=sr-activities 4/10
11/12/24, 9:21 AM Service Request Details

Good Day!!
If Invoice is in Cancelled Status and
Accounting status is
'Unaccounted', please follow below
steps to mark the accounting
status to Accounted without
generating accounting events, as
there is no point of generating net
0 entries for a cancelled invoice -:

1. Create profile option with code


and name as AP_SHBYIV_ENABLE
Navigate to: Setup and
Maintenance -> Manage Profile
Options -> New ->
(a) Create Profile Option as:
- Profile Option Code:
AP_SHBYIV_ENABLE
- Profile Display Name:
AP_SHBYIV_ENABLE
- Application: Payables
- Module: Invoices
- Description: Self-Healing Profile
- Start Date: 01-01-2022
Set Profile Option Levels for all
profile options:
User level: Enable and Updateable
Save and close.
B. Set the profile option values
Navigate to:Setup and
Maintenance -> Manage
Administrator Profile Values
(a)Search for Profile Option Code:
AP_SHBYIV_ENABLE
Set Profile Values at:
* Profile Level = User
* Username = Select User name
from LOV only (user who will
Validate the invoice)
* Profile Value = Y

Save and close.

3. Create profile option with code


and name as
AP_SHBYIV_MARK_UNACCT_PAY

https://support.oracle.com/support/?SR=4-0000091783&page=sptemplate&sptemplate=sr-activities 5/10
11/12/24, 9:21 AM Service Request Details

MENT_EVENTS2_NU (similarly you


created the above profile option)
and Set profile option value as
invoice_id : 443084 for User
4. Login with same user and Run
Invoice Validation ESS Job by
passing Invoice
Number :VGR1245920-1 as input
parameter.
5. Run the create accounting ESS
job to complete the fix. (Please do
not perform post to ledger
operation from UI).

Best Regards,
Shivam


Message from Oracle - Issue
Clarification
Nov 11, 2024 3:31 PM

Invoice canceled but accounting is


unprocessed and causes period
close exceptions.
Invoice Num : VGR1245920-1

 Message from Oracle


Nov 11, 2024 3:29 PM

Dear Customer,
My name is Shivam, and I am a
support engineer working for the
Fusion AP Support Team.
Your Service Request has been
assigned to me.
I will contact you by updating this
SR.
You can reach me by updating the
Service Request within My Oracle
Support
My working hours are from 7.00
AM - 3.30 PM IST (UTC/GMT +
5:30) and I will be helping you only
https://support.oracle.com/support/?SR=4-0000091783&page=sptemplate&sptemplate=sr-activities 6/10
11/12/24, 9:21 AM Service Request Details

during those hours.


If you post an update after at the
end of my working hours it will be
reviewed the next day when I come
back to my working hours.
Any calls outside of my working
hours will be answered by
someone on our HUB. If you need
to work this SR outside of my
working hours, send us a note to
request to be moved to an
engineer that works during the
hours that you need.
Thank You,
Global Customer Services

GS gurpreet.seehra@acer.com
Nov 11, 2024 2:39 PM

Question: Which accounting area


are you encountering the issue?
Answer: Create Accounting

Redirect to Interview:
IF125580_FIN_AP_SLAAP_SLAAPA
CCTG_OIA
Question: What is the type of issue
you are trying to address?
Answer: Errors
Review the following document
related to the issue:

Fusion AP: Consolidated Note for


Create Accounting Errors Due To
Balancing Segment Value (BSV)
Assignment / Balancing Issues

If the above solution does not


resolve the issue, follow the
steps detailed in the document
below:

SRDC - Data Collection for Fusion


Payables Create Accounting

Proceed with the next step.


Question: What accounting
process in generating the error?
Answer: Create Accounting Process
(Ess job)
https://support.oracle.com/support/?SR=4-0000091783&page=sptemplate&sptemplate=sr-activities 7/10
11/12/24, 9:21 AM Service Request Details

Question: What is the error?


Answer: Error: The segment value
COMPANY in the account is not
assigned to the ledger/This
subledger journal entry is not
balanced by balancing segments
Redirect to Interview:
IF122790_FIN_AP_APTRX_APTRXA
CCTG_ANALYZER_OIA
Question: Do you have a sample
invoice or payment which is in
issue?
Answer: Yes
INSTRUCTIONS:
The information collected on this
screen will be used by an
automated process to help
expedite the resolution of this
issue.

DO:
Enter ONE SUPPLIER
NAME or SUPPLIER
NUMBER and ONE
INVOICE NUMBER. .
Enter the SUPPLIER
NAME or SUPPLIER
NUMBER and INVOICE
NUMBER exactly as
they appear in the
application.

DO NOT:
Enter problem
description or
additional information
in these fields
Add any additional text
or explanation. The
automated process
expects ONE SUPPLIER
NAME or SUPPLIER
NUMBER and ONE
INVOICE NUMBER in
the respective fields
below.
https://support.oracle.com/support/?SR=4-0000091783&page=sptemplate&sptemplate=sr-activities 8/10
11/12/24, 9:21 AM Service Request Details

If the problem is for a payment,


please enter the SUPPLIER NAME
or SUPPLIER NUMBER and
INVOICE NUMBER for only ONE of
the invoices paid on that payment.

Good Examples:
Supplier field: (Supplier
Name Example)
ABC Supplier
Supplier field: (Supplier
Number Example)
9852
Invoice Number field:
123456

Bad Examples:
Supplier field:
My supplier is ABC
supplier.....This does not
contain just the supplier
name
All Suppliers..... If the
issue is for all suppliers,
please enter one
example supplier name
for the automated
process to analyze
Invoice Number field:
Invoice # 123456..... This
does not have just the
invoice number
123456, 987654..... This
is more than one invoice
number
Refer to the attached
list..... The automated
process is currently not
able to reference data in
attached documents or
the problem
description. Please
enter an invoice number
https://support.oracle.com/support/?SR=4-0000091783&page=sptemplate&sptemplate=sr-activities 9/10
11/12/24, 9:21 AM Service Request Details

for the automated


process to analyze

Tip: If you know the Supplier


Number, enter that instead of
Supplier Name. Supplier Number is
normally shorter and less prone to
user error when entering.
Question: Enter the Supplier Name
OR Supplier Number
Answer: 60000916
Question: Enter the Invoice
Number
Answer: VGR1245920-1

© 2024 Oracle Terms of Use Privacy

https://support.oracle.com/support/?SR=4-0000091783&page=sptemplate&sptemplate=sr-activities 10/10

You might also like