Best Of

Re: Query for PTAEO Combinations

To expand on what J has provided, this will include the award information also.

select Distinct gaa.award_number, pp.segment1 project_number, pt.task_number, peia.expenditure_type, hou.name Organization
from pa_expenditure_items_all peia, pa_expenditures_all pe, hr_all_organization_units hou, pa_projects_all pp, pa_tasks pt
, gms_award_distributions gad
, gms_awards_all gaa
where peia.project_id = pp.project_id
and peia.task_id = pt.task_id
and hou.organization_id = nvl(override_to_organization_id, incurred_by_organization_id)
and peia.expenditure_id = pe.expenditure_id
and peia.expenditure_item_id = gad.expenditure_item_id
and gad.award_id = gaa.award_id
order by award_number, pp.segment1, pt.task_number;

Regards,
Shane

Shane Horne-Oracle

1

Re: Travel & Expenses - New expense type created, mapping updated, getting as Invalid Exp Type error .

hi,

Thanks for the clarification .This is supply chain management forum,we will move your question to Expense forum .

thanks,

Phanindra

Phanindra-Oracle

1

Re: Unable to view other Business Units

Hi,

This community is for EBS applications only. Please review the following note:

Customer Creation not restricted by user's set access (Doc ID 2782515.1)

If that doesn't resolve the issue, please post it to the Fusion experts under the following link which is for Fusion applications:
https://community.oracle.com/customerconnect/

Best Regards,
John

John Nieman-Oracle

1

Re: Do I need to keep any files after an update?

IMHO Package Pruner job will cleanup only packages in /opt/assure1/distrib/packages/ directory, not in the installation depot (/opt/install in this case).
Anyway, it is safe to clean up the installation depot completely. Packages are needed only during adding Role or Package,so if you don't plan to add any soon, you can completely remove the files and unzip it when needed.

TomTSP

3

Re: For an ST/OT, Add Payable Freight Calculated by R4981 to Inventory Cost

Dear user8930,

I'm going to suggest that you create a service request in order for us to have a web conference to go over your process. This is too complex of an issue to troubleshoot on a community post. There can be many different factors involved that we would need to confirm with you that can only be done via a service request.

Thank you,

Michael

Michael Curley-Oracle

1

Re: The expenditure organization is not active - When entering expenditure entry 12.2.9

Hi,

Oracle Payables Supplier Invoices is reserved for transfers from Payables and is not available for use in the WebADI. You will need to user the third party source as you have tested.

Along with the previous information provided, there is a pretty comprehensive note for the troubleshooting the error 'The expenditure organization is not active.' (PA_EXP_ORG_NOT_ACTIVE).

Please review Error On Expenditure Entry: The Expenditure Organization Is Not Active (Doc ID 756313.1)

Thanks,
Shane

Shane Horne-Oracle

1

Re: JDE E1 compose page Not allowing selection of Prompt data selection and values as same task manager

Review E1: E1PAGE: Composite Page Batch Version Tile Type Missing "Data Selection and Values" Option (Doc ID 2777130.1).

Dorothy Ahfat-Oracle

1

Re: For an ST/OT, Add Payable Freight Calculated by R4981 to Inventory Cost

Dear user8930,

There is not any correlation between landed costs applied at the time of receipts and freight update. The freight update is used to calculate shipping costs (payable and billable). The landed costs are applied to the actual receipt line for the product. There is a processing option on the R4981 to update the item cost, but this is only for shipping costs (not landed costs) and is only used when using freight allocation at the item level.

Thank you,

Michael

Michael Curley-Oracle

1