Best Of
Re: Supplier Split Percentage - Mass Upload Tool
Hello Jayashree,
As the P43211 Enter Change form has the item number in the header, it is not a ready candidate for bulk entry, such as from import from Excel. I do not find an interoperability utility for P43211. This would likely best be met with a custom object to populate the F43211 or V43211A. Perhaps another client has a ready solution or third party code.
Regards,
Jeff
Re: Oracle BIP- Unifier report question- Default parameters
I'm not sure how you built the data model for your custom report, but if you used an internal data model, then you'll need the project_id column in the main data view. At report runtime, Unifier will filter the results of the main data view to only return rows where project_id matches the project id of the shell you're running the report from.
If you used a custom report with external data model, then there's a predefined Unifier parameter (uuu_p_context_project_id - see https://docs.oracle.com/cd/G18097_01/English/admin/admin_general/10282207.htm#subhead_predefinedunifierparameters28) that gets passed from Unifier to BI Publisher at runtime to accomplish the same thing.
To summarize, Unifier should only output results based on the shell you're running the custom report from. If you wanted to bypass that - you could (like getting all shells, or getting just the child shells) in the data model.
Need a document link to RFQ to BPA or Contract creation
Need a document link to RFQ to BPA or Contract creation
Re: Safety Stock Calculation Possibility
Hi @Aji NS ,
What you are expecting cannot be acheived.
Safety stock is calculated for each individual planning bucket based on the forward days you have specified.
You may calculate the safety stock as per your business need and enter the same in EBS.
Alternatively, you can write your customizations in data collections hook.
Best Regards,
Mohan Balaji
Re: AP Invoice Auto-Round addition at Line Level.
Hi @User_5FBLU,
Invoice Type 'Miscellaneous' is usually used in OFI for tax lines.
It might be due to customization,
try to re-test in Core Code Only (Invoice workbench > help > diagnostic > personalize > core code only)
See, if still there is an different in both OU's validation
Thank You,
Anees
Re: Input Service Distribution
Hi,
You may check the following note:
Need To Understand The Functionality For (Input Service Distribution) ISD Under GST (Doc ID 2287567.1)
Thanks and regards,
Anca
Re: There are blocks in v$nonlogged_block, but NONLOGGED_START_TIME is empty
Just a quick sanity check - when you say "it did not work", what did you do and what actually happened?
e.g. a cut and paste
SQL> select scn_to_timestamp(12670475000000) from dual;
select scn_to_timestamp(12670475000000) from dual
*
ERROR at line 1:
ORA-08181: specified number is not a valid system change number
ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1
This is the result I got in SQL*Plus when using a value smaller than the smallest SCN recorded in smon_scn_time. Does this emulate your "did not work"?
Regards
Jonathan Lewis