[PO] RCV: Processing Mode

System Profile "RCV: Processing Mode" decides the processing mode for receiving transactions, it can be either in "Batch", "Immediate" or "On-line" modes.

It is reflected in RCV_TRANSACTIONS_INTERFACE.PROCESSING_MODE_CODE field.

[OM] Ctrl+Click and Shift+Click

At the Order Organizer form, we can perform multiple lines selection at the line level using hot key Ctrl+Click and Shift+Click.

This is useful if we need to perform the same Actions across all order lines. E.g. I wanted to release multiple order line holds all at one go. I click on the first row, move my mouse to the end row, press Shift+Click, all order lines will be selected with highlight color blue. Then, I proceed to Actions button to perform Release Holds action. This action will be applied to all selected order lines.

[SYS] PHASE_CODE and STATUS_CODE in FND_CONCURRENT_REQUESTS

It has been a bit confusing, hence i summarized the fields' values and meaning as follows:

PHASE_CODE
        P - Pending
        C - Completed
        R - Running

STATUS_CODE
        Q - Standby //Scheduled
        R - Running
        C - Normal
        D - Cancelled
        E - Error
        G - Warning
        I - Normal //Inactive

[WIP] Work Order is Canceled and Onhand Stock Not Released

Stock is reserved due to the allocation done during WIP Component Pick Release process. Even job is canceled, the allocation will not be released. Hence, the onhand is still not available for other transactions' use.

In order to increase the availability, we need to remove the job allocation.

Go to "Transact Move Orders" menu, go to "Pick Wave" tab, "Work Order" section, enter the job number, query the job. Cancel allocation at Tools->Cancel Allocations

[GL] Receiving Journal Transfer to GL by Journal Import

Found a good article on Receiving (Purchasing) Journal transfer to GL by Journal Import.

Related SQL:
SELECT *
  FROM apps.gl_interface
 WHERE user_je_source_name = 'Purchasing'
   AND user_je_category_name = 'Receiving'

In R11i for Inventory Destination Transactions, the Receiving Transaction Processor Debits and Credits the Receiving Account and Inventory AP Accrual Account respectively in GL_INTERFACE and RCV_RECEIVING_SUB_LEDGER. These Transactions in GL_INTERFACE are identified with User_je_source_name ='Purchasing' and user_je_category_name 'Receiving'. In RCV_RECEIVING_SUB_LEDGER these transactions are identified by column accrual_method_flag ='O'
In R11i for Period End Transactions ie Transactions with accrue_on_receipt_flag ='N' in PO_DISTRIBUTIONS_ALL, no accounting transactions are generated on receipt of goods. The Receipt_Accrual_Period-End program generates the Accounting Entries in GL_INTERFACE and RCV_RECEIVING_SUB_LEDGER simultaneously by Debiting Charge Account and Crediting Expense AP Accrual Account. In GL_INTERFACE the Transactions are identified by column names user_je_source_name='Purchasing' and user_je_category_name ='Acccrual'. In RCV_RECEIVING_SUB_LEDGER the Transactions are identified by column Accrual_Method_flag ='P'.

In R11i both On Line Transactions and Period End Transactions are moved from GL_INTERFACE  to GL_IMPORT_REFERENCES,GL_JE_HEADERS and GL_JE_LINES by JOURNAL IMPORT.

In R12 GL_INTEFACE TABLE is no longer directly used for Receiving Transactions.  The Receiving Transaction Processor only populates the RCV_RECEIVING_SUB_LEDGER with Inventory Destination Transactions. The Receipt_Accrual_Period-End program also only populates the RCV_RECEIVING_SUB_LEDGER with Expense Destination Period End Accruals.

Create Accounting-Receiving Concurrent program from Cost Mangement Responsibility transfers the journals in RCV_RECEIVING_SUB_LEDGER to SLA Tables.  Once the accounting entries are created in receiving subledger for the receiving transactions, Create Accounting process gets started depending on the profile option CST:Receiving Accounting option and the encumbrance set up.

On submitting this program, it spawns the Accounting program which will do the validations and picks the data from table rcv_receiving_sub_ledger and process it according to the accrual method set for the POs

Depending on the accrual method and the value for profile SLA:Disable journal import, this spawned program "Accounting program" inserts the data into gl_interface first and then calls the Journal import program and posting program and populates the accounting events in subledger table xla_ae_headers and entries in xla_ae_lines and xla_distribution_links.
If there is any problem with the Journal import, the data will get rolled back from gl_interface. Once the Journal import is completed, data will get populated in gl_import_references,gl_je_headers and gl_je_lines.

......

Refer to Metalink Note 827125.1 for details.

[OM] Cancel Order Does Not Appear on Shipping Transaction Form

Cancelled order does not have Pick-Up date attached. That's why when user enters Pick-Up date as parameters, no record shown.

[OM] Unable to Pick Release Internal Sales Order (ISO)

ISO was created from Internal Requisition (IR), order line status is "Awaiting Shipping", shipment line status is "Ready to Release", next step is "Pick Release". Performed Pick Release, shipment line status is not changed. As usual, no error shown in the log.

After investigation, found onhand no issue, inventory period is opened, what else could be the cause?

Ans: The ISO has tied to subinventory ABC, but the manual Pick Release is picked from subinventory DEF. So, change the "Pick From" subinventory to ABC, problem solved. Note: ISO subinventory is defaulted from IR subinventory.

[OM] Internal Requisition Approved, Internal Sales Order Created and Picked, Need to Cancel All, How?

Ans: First perform backorder for ISO, cancel the ISO, then cancel the IR. Do remember to move back the inventory from staging to picking.

[INV] Inventory Cycle Count

Step (1)
Create ABC Compile
ABC Codes->ABC Compiles
This will compile cycle count content. Result in number of items, total quantity and total value (qty x cost).

Compilation criteria: 15 different criterion available. Most commonly used is "Current on hand quantity".

Note: This will affect the material sequence.

Click "Compile" and "Compile ABC analysis" program get submitted. Compile Status will changed from "No" to "Complete" after it is done.

At the ABC Compile form, select the Compile Name, go Tool->View Compile, we can see the details of compiled items here.

Alternatively, we can see output of the "ABC descending value report" concurrent request. Note: View Compile from form level shows only items with cost whereas "ABC descending value report" shows all items in compile even it comes with zero cost.

Step (2)
Create Group and Assign Compile and Items to Group
ABC Codes->ABC Assignment Groups

Enter a new Group Name

Assign Compile - Choose Compile Name
Assign Group Classes - Assign ABC class to relevant Priority
Assign Items - Assign item by Sequence, Inventory Value, % of Items or % of Item Value. Click "Assign" button or Save.
"Define ABC assignments" program will be submitted.

Click on the "Update Item" button, we can see list of items that has been categorized by Classes.

If the list is complete, we are done with ABC Codes.

Notes: Item MUST have "Cycle Count Enable" flag checked. If not, item will not be listed in "Update ABC Item Assignments" form.

Step (3)
Define Cycle Count
Counting->Cycle Counting->Cycle Counts

Creat a new Cycle Count.

Initialize the Cycle Count by adding the previously created ABC Group to it. Save record.

"Initialize cycle count items" program will be submitted once we save the cycle count. ABC Initialization status will change to "Completed".

Step (4)
Execute Cycle Count (Assume manual scheduling in this case).

Click "Schedule" button at Cycle Count Summary form.

Enter the items that you decided to count, this is the important list because the later cycle count list is
base on this.

Go Tools->Generate Count Requests. "Generate cycle count requests" will be submitted.
Go Tools->Cycle Count Listing Report. "Cycle count listing" will be submitted.

Step (5)
Enter Count
Counting->Cycle Counts->Cycle Count Entries

Choose the Cycle Count name, query it. Enter the count quantity. (note that the line is by subinventory, locator and lot).

Step (6)
Approve Count
Counting->Cycle Counting->Approve Counts

After count was approved, inventory transaction type "Cycle Count Adjustment In" - increase quantity or "Cycle Count Adjustment Out"- decrease quantity will be transacted automatically.

[WIP] Missing Item Code in LOV

In order to build an assembly item in WIP, the "Pick Components" check box should NOT be checked (Order Management tab in Item form).

If it is checked, it will not appear in the Assembly LOV when user tried to create a WIP discrete job. It will also not appear in Routing LOV. Anyway, it will still appears in BOM LOV.

[INV] Interclass conversion between THB and EUR is not defined

After I performed ship confirm for a Internal Sales Order, Interface Trip Stop completed warning. And this error showned in the log, "Interclass conversion between THB and EUR is not defined". This error is also shown in the Transaction Open Interface errored record.

Solution:
Make sure the GL conversion rate is setup and the rate type used for IR-ISO is specified in these 2 profile option:

INV: Intercompany Currency Conversion
INV: Inter-Organization Currency Conversion

Also refer to Metalink note: 338402.1

[OM] Pick Release in Shipping Transactions Form

This is an alternate way to perform pick release at a place other than Release Sales Orders form.

Shipping->Transactions

Go "Action" LOV, choose "Launch Pick Release", click Go button.

[OM] HL Pick Slip SRS Report -> Completed Warning

After Pick Release action, pick slip report will get submitted, but it often completed warning.

How to know if actual picking taken place? Picking could be failed or success even the program completed warning. E.g. For printing issue, even it completed warning, but the stock has been picked.

From Requests list, click on the request, view Output. If there is records there, it was successfully picked. Another faster way, observe the request in the list, if the 4th and 5th parameters have value, it is successful.

[OM] No Delivery Detail Found

After Ship-Confirm action, shipping line status is Closed, Interface Trip Stop program completed Warning, with warning message "No Delivery Detail Found" in the log file.

Where to rectify this?

Ans: Go Inventory responsibility, Transactions->Transaction Open Interface, check for any errors in the shipping organization. Rectify from there.

[AR] Customer - Types & Address

Oracle has 2 customer types, Person or Organization.

 

Person is mainly use for retails business whereas Organization is used for company that has company as target customer.

 

Customer is differenciated by Party Number and Customer Number. If Customer Type is Person, Party Number refers to Person Number, if Customer Type is Organization, Party Number refers to Organization Number.

 

Party Number and Customer Number are cross OUs and organizations, this means the same customer just need to be defined once. In different OUs, the Party Number and Customer Number will be shared and it will be differenciated by Customer Address.

[INV] Wrong Item Code Used in IR, ISO had been Shipped, How?

Wrong Item Code, ISO been shipped, but receiving for IR is not done yet. Anyway quick way to fix?

First of all, there is no RMA and RTV functions available for IR-ISO, this is a very BIG design gap.

Workaround 1:
Receive the wrong Item Code. Create a reversal IR-ISO.

Workaround 2:
Miscellaneous Receipt back quantity to Shipping Organization, make sure Credit Account is correct. Final Close the IR.

[SYS] Trick - Maximise Form

Due to "bad" design of Oracle Form UI, the grid information in Oracle form will not maximise eventhough I maximised the form. 1 typical example is Material Transaction form.

 

There a trick to "force" the grid to grow bigger, and then fit to the maximised form.

 

First, maximise the form.

Then, move the mouse in between 2 fields until a double-headed arrow appears.

Double Click.

 

You will see this magic works.

[OM] Pick List Ship-To Address Not Get Updated

It is an address issue.

 

The Ship-to Address appears on the Pick List (for ISO) is retrieved from wsh_locations table. As for IR-ISO setup, ship-to-address comes from Customer address instead of Location address.

 

When we updates the customer address, hz_locations table get update. By right, both hz_locations table and wsh_locations table should be synchronized automatically. But, in my case, it was not. Business event "oracle.apps.ar.hz.Location.update" is enabled, everything else is fine. But the synchronize is not happening.

 

Logged a tar and Oracle came back with suggestion to run "Import Shipping Location" program in OM responsibility to synchronize the table. These was their reply (copied from some another article).

 

"...The 'Import Shipping locations' concurrent program imports all of the internal and external
locations from HR/HZ LOCATIONS tables into the WSH_LOCATIONS tables.

This program should be executed at least once when upgrading to 11.5.9. After the
upgrade, it should not be required to rerun this concurrent program since any
changes in the HR/HZ LOCATIONS tables are automatically synced up with WSH
tables.

There are a few exceptions when Import Shipping Locations concurrent program should be run. These exceptions would be only when any updates to a
Customer's information does not get reflected when creating a new sales order
or when you find any inconsistencies in Location records when interfaced from
HR to WSH Locations, such as an incorrect country code..."

 

Question is the auto-sync is not happening and Oracle can't give reason why.

 

End up I have to run "Import Shipping Location" program to solve the issue (and it took 3.5 hours to complete with the Start-Date value = sysdate-4).

[SYS] Java Cache Caused Internet Explorer Crashed

I was trying to launch the Oracle form (in Java applet), IE crashed. I tried on Firefox, it did not get launched at all. Restarted my system, problem still there.

 

Before I decided to call Helpdesk to examine my system, I found a trick that can save me a lot of time dealing with Helpdesk.

 

Checked "Control Panel", "JInitiator 1.3.1.29" (your version might be different), "Cache" tab. My total file size in JAR Cache folder has exceeded the limit. I have then removed all cache files in that folder, increased my size limit, and it works!!!

[SYS] Time Zone Conversion

I created a sale order, checked order header record history, the "Update Date" is differs from the last_update_time in oe_orders_headers_all, why?

Check the system profile values for Client Timezone and Enable Timezone Conversions, any time zone setup in these profiles will get reflected in the front-end display of time related records.

Note: Backend time is always consisitent.