Solution: Query the Purchase Order--> Click on shipments button--> Click on distribution Button --> Click on More Tab
Now update Rate date and Rate and save it and try to approve it.
Issue: Excise Invoice No & Excise Invoice date is not shown in Receipt India Localization window.
Solution: User forgot update the Descriptive Flexfield in Receipt window. Ask to correct(Cancel) the receipt and ask him to enter Receipt Localized(Re-enter Receipt) again. Then the issue is resolved.
Issue: Purchase Order(PO) Status is showing" Pre-Approved".
Solution: The Following SQL Script will change PO Status from
"Pre-Approved" to "Incomplete".
update po_line_locations_all
set closed_code='',
closed_date='',
CLOSED_FLAG='N',
Qty_Rcv_Exception_Code='NONE'
where po_header_id in( ) -------Enter PO Header ID
and org_id= ; ------- Enter Org ID
update po_lines_all
set closed_code='',
closed_date='',
CLOSED_FLAG='N'
where po_header_id in( ) -------Enter PO Header ID
and org_id= ; ------- Enter Org ID
update po_headers_all
set closed_code='',
closed_date='' ,
WF_ITEM_TYPE = NULL,
APPROVED_DATE='',
APPROVED_FLAG='',
Authorization_Status='INCOMPLETE'
where po_header_id in() -------Enter PO Header ID
and org_id= ; ------- Enter Org ID
Issue: Unable to enter in Requisition Form, You are not setup as an Employee. To access this form you need to be an employee note is shown.
Solution: You need to update the following form for the above error.
1. Human Resources -> People -> Enter and Maintain
Provide all mandatory details in People form.
Select Person Types as Employee and Assign Supervisor and Save it.
Note: Need to Assign this employee to User.2. If you do not have Oracle HRMS add the employee and buyer in Purchasing Super User --> Setup -->employee or buyer from same navigation.
Now, Try to Open the Form and you can enter the Requisition.
Issue: where receipt Header number was generated but later, the receipt number could not be found in system anywhere from front-end.
Solution: Period was not opened, for that particular warehouse.
Now, Try to Open the Form and you can enter the Requisition.
Issue: where receipt Header number was generated but later, the receipt number could not be found in system anywhere from front-end.
Solution: Period was not opened, for that particular warehouse.
That was actually a great blog. Your blog was consisted of such interesting and valid points that my knowledge is upgraded. Thanks for sharing. Here is a referred link same as yours oracle fusion scm training.
ReplyDeleteThanks for sharing this blog. The content is beneficial and useful. Very informative post. Visit here to learn more about Data Mining companies and Data analytics Companies.
ReplyDelete"Thanks for compiling these common Purchasing Module issues and their solutions! The step-by-step instructions, especially for resolving PO status and missing currency rates, are incredibly practical and easy to follow. Great resource for PhozellPay users!"
ReplyDelete