Oracle ERP : Issue Resolution : ORA-29280: invalid directory object

Subject: When we are bursting or creating a .csv file using PLSQL procedure and try to send it on FTP directory or try to open the file from the FTP directory path we are getting the below error message.

Error:

ORA-29280: invalid directory object

Solution:

Oracle suggests using the directory path which is defined under utl_file_dir. the application allows accessing the file from the FTP server.

Use the below query to get UTL FILE Directory path

select * from  V$PARAMETER where NAME like '%utl_file_dir%'

Set path: /s01/oracle/DEV/db/19.3.0/temp/DEV  (at a time run concurrent request)

After setting the suggested path run the concurrent request. The file was generated successfully.

Oracle Fusion: How to Create Inventory Sub-Inventory Transfer Transaction

Subject: Business required to move on-hand stock from one sub inventory to another sub-inventory for that we need to create a sub-inventory transfer.

--Item Details--

Item Code: 04081006.1

Organization: DHY

Sub-Inventory1: C1-R2-150-A-G05

Sub-Inventory2: C2-R2-170-A-G09

Let me check the Item stock before creating the transaction against both sub-inventory.

Navigation: Oracle Home Page > Supply Chain Execution > Inventory Management

Click on the right-side panel Task Button > Show Task "Inventory" > Manage Item Quantities.

Sub-Inventory1: G05
Locator: C1-R2-150-A-G05

QTY: 11

Sub-Inventory2: G09

Locator: C2-R2-170-A-G09 

QTY: 8

Let's create the sub-inventory transfer from G05 to G09

Navigation: Oracle Home Page > Supply Chain Execution > Inventory Management > Select Task > Show Task "Inventory" > Create Subinventory Transfer.

Enter all the required details.

Date: It must be within the open inventory accounting period.

Type: Subinventory Transfer

Item: 04081006.1

--Source--

Sub-Inventory: G05
Locator: C1-R2-150-A-G05

--Destination--

Sub-Inventory: G09

Locator: C2-R2-170-A-G09 

Qty: 1

Reason: Stock Pick

After entering all the details click on Submit button. 

Now let's check on hand in both sub-inventory locators.

Click on the right-side panel Task Button > Show Task "Inventory" > Manage Item Quantities.

Sub-Inventory1: G05
Locator: C1-R2-150-A-G05

QTY: 10

Sub-Inventory2: G09

Locator: C2-R2-170-A-G09 

QTY: 9

Sun-inventory transfer transaction completed successfully. 

Oracle Fusion: How to create Miscellaneous Transaction to add item on-hand stock

Subject: We need to create onhand for items using Oracle Fusion Miscellaneous Transaction Screen.

Let me check the Item stock before creating the transaction.

--Item Details--

Item Code: 341-01-0018

Organization: JV2

Navigation: Oracle Home Page > Supply Chain Execution > Inventory Management

Click on the right-side panel Task Button > Show Task "Inventory" > ManageItem Quantities.

Search with Item Code and Organization.

We can see that Item having Onhand Quantity 100.

Let's Increase the onhand Quantity using Miscellaneous Transaction.

Navigation: Oracle Home Page > Supply Chain Execution > Inventory Management > Select Task > Show Task "Inventory" > Create Miscellaneous Transaction

Entered highlighted all Details. Must take care date within Open Inventory Accounting Period

Type: Miscellaneous Receipts

Account: Inventory Material Account

Use Current Item Cost: Yes

After entering all these details, click on edit details.

We must be required to enter the serial numbers for serialized Items. 

After entering the serial number click on Ok.

Now Click on Submit.

Miscellaneous Transaction Created successfully.

Let's Check the Onhnad for the same Item again.

Navigation: Oracle Home Page > Supply Chain Execution > Inventory Management

Click on Task Button > Show Task "Inventory" > ManageItem Quantities.

Search with Item Code and Organization.

We can see that Item having an Onhand Quantity of 250.

Onhand created successfully.