Best Of
Re: Script see who added a responsibility or removed end date of responsibility to user
Oops, in the query
ug.last_updated_by
should be
ug.last_update_date
Apologies for that, was typing along and wrote the wrong thing.
Thanks,
J
Re: Script see who added a responsibility or removed end date of responsibility to user
Hi Linda,
This query should work. It will prompt for the user name and the responsibility name Be aware that it can only show who last updated it. So if the responsibility has been taken away again, you will see the person who took it away.
select u.user_name, t.responsibility_name, ug.start_date access_began, ug.end_date access_ends
, ug.last_updated_by access_change_date, uc.user_name access_updated_by
from apps.fnd_user_resp_groups_all ug, apps.fnd_responsibility_tl t
, apps.fnd_user u, apps.fnd_responsibility r, apps.fnd_user uc
where nvl(ug.end_date,sysdate+1) > sysdate -- user has the responsibility as of today
and nvl(r.end_date,sysdate+1) > sysdate -- responsibility itself is not end-dated as of today
and nvl(u.end_date,sysdate+1) > sysdate -- user is not end-dated as of today
and ug.responsibility_id = t.responsibility_id
and ug.responsibility_application_id = t.application_id
and t.responsibility_id = r.responsibility_id
and t.application_id = r.application_id
and ug.user_id = u.user_id
and uc.user_id = ug.last_updated_by
and u.user_name = '&USER_NAME'
and t.responsibility_name = '&RESPONSIBILITY'
If this works, please check Yes where it asks if this answers the question.
Thanks,
J
Re: AR WorkCenter - Regular Deposit Results
Thank you so much for your kind and prompt response, Pere; I will definitely add this on the Ideas lab.
Have an excellent day!
Maty
Re: Why Can't PO matched Invoice Distribution charge account be updated, Once the AP posted to GL and th
Hi @User_5RRJX ,
Please refer
R12: Invoice and Invoice Distribution Adjustment Charts - Explains what Fields can be Adjusted on an Invoice and when the System Prevents Update (Doc ID 1300685.1)
Thank You,
Anees
Re: AR WorkCenter - Regular Deposit Results
Hello @FIN_USER_7 ,
I hope all is well with you over there ;o)
Thanks for your latest post in the PeopleSoft Financial Management Community!!
Having reviewed your comments, I am assuming that you are talking about the below Entered Date column:
Note that the Regular Deposit within the Links > Payments section from Fluid Receivables WorkCenter is basically pointing to the Regular Deposit search page under the below navigation path:
- Accounts Receivable > Payments > Online Payments > Regular Deposit
The Entered Date column has been listed in the search results for many releases now. Adding the Accounting Date, while a valid point, would be an Enhancement Request. I would suggest you raise this same post into the Receivables Ideas Lab site, so it can be considered by the Strategy and Development teams for future FSCM 9.2 PUM Images.
The Search Record behind the Regular Deposit page within the Component PAYMENT_ENTRY is based on DEPOSIT_NP_VW (Deposits - Not Posted). You will see the fields within this View include ENTRY_DT. If you wish to have the Accounting Date, you would need to customize this View to include/list ACCOUNTING_DT field as well.
I hope that the information provided has clarified all your doubts. Should you have additional related questions, do not hesitate letting us know. On the contrary, if all your queries, and doubts have been successfully addressed, please make sure to mark 'YES' on the 'Did this answer the question? Yes-No' link. This will enable other Community Users to quickly identify the solution suggested, and see that this post has been successfully
answered.
Have an excellent day!
Pere Taulé
AR WorkCenter - Regular Deposit Results
When querying the AR Regular Deposits link of the Links> Online Payments section of the WorkCenter, the results include Entered Date. Would it be more beneficial to have Accounting Date instead, or have that field added to the delivered functionality?
Re: BOE not showing while creating Receipt when clicking on Receipt Line Application?
Hi @P.Priyanka.S.Singh-Oracle ,
Issue is resolved now. We have completed the receipts.
Thank you all for the inputs.
Re: Item will not load to the control board as a cycle count.
Hi Abhilash,
Is this specific to this item or you are not able to generate cycle count tasks in WCB no matter the item?
If this is a general issue, please validate the below :
- Do you have a cycle count standard task type defined and enabled?
- Are resources assigned to the task?
If you have the above setup in place, i suggest opening a service request to look deeper into the cycle count task generation issue.
For correcting the stock (initial topic of the thread), you also have the other 2 options
Regards,
Ionut
Re: Item will not load to the control board as a cycle count.
Hi Abhilash,
What do you need help with? Have you encountered any issue with the cycle count adjustment?
As a general note, there are 3 main options to correct the inventory :
- Cycle Count Adjustment
- Miscellaneous Issue/Receipt
- If you have discrepancy between on hand and historical material transactions, a standard datafix is described in this note : Current Onhand Quantity and Total Transactions History Quantity Mismatch Diagnosis (Doc ID 279205.1)
Regards,
Ionut