Skip to content

Inventory Items Type

I’ve got this insight from Oracle Community. One of the authors informed about the kind of inventory item type in simple languange. So, this is it:

The terminology of items is rather confusing from a Purchasing/Inventory
point of view.

For easy understanding, these will be referred to as A , B and C,
A – Expense Items
B – Inventory Expense Items
C – Inventory Asset Items

A – These items have attributes checked

B – These terms have the following attributes checked
a – inventory item = YES
b – stockable
c – transactable
d – Inventory Asset Value = NO
e – Costing Enabled = No

C – These items have the following attributes checked
a – inventory item = YES
b – stockable.
c – transactable
d – Inventory Asset Value = YES
e – Costing Enabled = YES

Hope this helps.




PO Pre-Approved Status

Please find below, the situation where PO will go to Pre-approved status :
1. Pre–Approved document is one in which approvar approves the document but then forwards it to someone else for additional approval, then it goes in to pre approved status

2. Your organization uses encumbrance budgeting (reserves funds for documents), and the purchasing document is eligible for approval but funds have not yet been reserved for it.

Hence if you are using the encumbrance , the Period should be open. If the PO that is in Pre approved is an old PO and the corresponding GL / purchasing period is already closed .
So the issue could be due to the closing of the period for the each month in this case .

If it was working earlier, and if you are not sure of the changes, please Run the program “Fill employee Hierarchy Program” and once it’s completed successfully, you may reset the document to Incomplete status again using the below note

How To Reset a Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases ( Doc ID 390023.1 ) and submit again.

Before submitting the PO, please check if funds check is passing and able to reserve the document.
Once its done, please submit for approval and make sure that there a default hierarchy is populated while submitting for approval

Hope this clarifies!


Status PO Rejected but in View Action History is APPROVED, What should we do?

(SR 3-17235453221)

Problem Summary
Status PO Rejected but in View Action History is APPROVED, What should we do?

Problem Description
There are 2 PO with status REJECTED but, in View Action History result is APPROVED.

Analytical Files
File: Diagnostics__Apps_Check_060418.txt
File: POAPPANALYZER_Analyzer_PROD_2018-04-06_05_18.html
File: 316542.png;po_12_316542.html

Analyzer execution information
Analyzer Execution Details
Applications Release: 12.1.3
Analysis Mode: SINGLE
Is Cloud environment: N
Analyzer version: 200.15

Operating Unit: 81
Document Type: PO
Document Number: 316542
Release Number: NULL

Profile Options:
User Profile Option Name Profile Option Value Set At
===================================== =========================== ======
PO: MFG Organization ID ** Not Set At Any Level **
PO: Price Tolerance (%) for Catalog Updates ** Not Set At Any Level **
PO:Workflow Processing Mode ONLINE Site

POAPPANALYZER_Analyzer_PROD_2018-04-06_05_18.html shows the following details:
This PO has Authorization Status NULL and is not eligible for reset. Only documents with authorization_status ‘IN PROCESS’ or ‘PRE-APPROVED’ are eligible to be reset.

— Script Output —
File Name or Source:

Description :


06-APR-18 09:04:28 06-APR-18 09:05:00 APPROVE_PO_SUB_PROCESS / UNABLE_TO_APPROVE_DOC Approve PO Unable To Approve Document COMPLETE SEND_BACK_TO_PREPARER FELIX.PARLINDUNGAN 762235 CLOSED 06-APR-18 09:05:00 06-APR-18 09:05:00 APPROVE_PO_SUB_PROCESS / REJECT_PO Approve PO Reject The PO COMPLETE Y 06-APR-18 09:05:00 06-APR-18 09:05:00 APPROVE_PO_SUB_PROCESS / GET_NOTIFICATION_ATTRIBUTE Approve PO Get Preparer Notification Attribute COMPLETE ACTIVITY_PERFORMED 06-APR-18 09:05:00 06-APR-18 09:05:00 APPROVE_PO_SUB_PROCESS / PO_PO_REJECTED Approve PO PO Rejected COMPLETE #NULL BAYU.PUTRA 762238 OPEN 06-APR-18 09:05:00 06-APR-18 09:05:00 APPROVE_PO_SUB_PROCESS / PO_NEW_COMMUNICATION-1 Approve PO PO New Communication COMPLETE Y

WFStat: Notification Attributes

ONLINE_REPORT_TEXT Line 1 Schedule # 1: The Need-By Date and/or Promised Date does not fall within an open purchasing accounting period.


Set the profile option PO: Check open periods to N,

~ Ann

Profile Option “SLA: Enable Diagnostics” : How not to use it

Originally posted 23 December 2008 on

As diagnostics functionality tends to be very useful, most implementers when arriving at a site immediately enable all diagnostics. In case of profile option “SLA: Enable Diagnostics” this might cause more bad than good, and here is why:

First of all it’s important to understand the basic concept of SLA. When SLA creates accounting it doesn’t physically store all the data from the subledgers into the XLA tables. Instead SLA uses views to look directly at the subledger data it requires (you can see these views in the SLA Accounting Event Class Options window under the Transaction Objects tab).

But when profile option “SLA: Enable Diagnostics” is set to Yes, SLA will not only look at the subledger data through the abovementioned views, but it will also physically copy over all that data into an SLA diagnostics table (XLA_DIAG_SOURCES).

The reason why SLA does this is because you enabled SLA diagnostics, so SLA expects that you will want to run the Transaction Objects Diagnostics report. But in order for this report to be able to pick up data, SLA first needs to make the data available, therefore it copies over all the subledger data to the SLA tables so afterwards the Transaction Objects Diagnostics report can print the data for you.

This copy process happens during Create Accounting so when you run Create Accounting while the profile option is set to Yes you should also notice a decrease in the Accounting Program’s performance (because all the inserts into XLA_DIAG_SOURCES are being executed).

Correct order of events when diagnosing SLA:

1) Enable profile option “SLA: Enable Diagnostics”
2) Run “Create Accounting”
3) Disable profile option “SLA: Enable Diagnostics”
4) Run “Transaction Objects Diagnostics” report
5) Run “Purge Transaction Objects Diagnostics”

Keep the profile option away from so-called “overenthusiastic profile option switchers”. I’ve seen a case where the profile option was set to Yes at Site level meaning every single run of Create Accounting copied all source data from all subledgers to the XLA scheme eventually causing the database to run out of space. Although this was in a DEV instance without security policy it still proves that this (and in fact any) profile option should be handled with care – if you don’t know it then please don’t touch it.

When you do use the profile option then use it as it was intended to be used: run Create Accounting for a very small amount of data. It really doesn’t make any sense to try and diagnose a large volume of data because you will get lost in the Transaction Objects Diagnostics’ output file.

When you’re done diagnosing do not forget to switch the profile option back to No.

As soon as you’ve run your Transaction Objects Diagnostics report you can run Purge Transaction Objects Diagnostics request. This will purge the diagnostics data from XLA_DIAG_SOURCES. You can still continue looking at the data because that’s saved in the Transaction Objects Diagnostics’ output file.

taken from

Oracle Service Pack

There is nothing called service pack for Oracle EBS.
If you are running release 12.1.3
There is a patch level for each product or family of products in Oracle EBS
You can use the below query to identify the patch level of individual products:

select a.application_short_name, a.application_name, fpi.status, patch_level
from fnd_product_installations fpi, fnd_application_vl a
where fpi.application_id = a.application_id
and a.application_name like ‘%%’;



How To Use Source Line Transfer To Transfer Cost From One Asset Into Another Asset?


Oracle Assets – Version and later
Information in this document applies to any platform.


How to perform a source line transfer to transfer cost from one asset into another asset?


Perform the following steps:

1.  Query the “Transfer Out” asset in the Asset Workbench.  Navigate to Assets > Asset Workbench, query the asset number.
2.  Place the cursor in the record for the asset, then click the Source Lines button.
3.  In this form, check the line for the invoice, click the “Transfer To” button.
4.  In this form, do a blind query to find all the assets that this could be transferred to, or simply hit F11 to initiate the query.  Or enter query mode (f11), then key the desired “Transfer To” asset on the first line, then hit Ctrl+F11 to bring it back. Click Done to commit the Source Line Transfer to the asset.

Doc ID 1447559.1

This case just happened today, when 1 user was wrong Add new Invoice to an Asset Number. Lucky I have this document.



Re-Assign Buyer


To disable the function “Reassign To Buyer” from the Tools menu in Autocreate, please implement following steps.
I’ve already tested following steps in our internal instance and got the result as expected.

1. Navigate to Application Developer responsibility

2. Navigate to Application> Function

3. Query the function ‘PO_REASSIGN_BUYER’, e.g. F11> Enter PO_REASSIGN_BUYER> CTRL-F11

4. Go to Properties Tab

5. Select ‘Offline’ from Maintenance Mode Support LOV

6. Save changes

7. Check the result in Autocreate form

Eun Sil